Last answered:

22 May 2024

Posted on:

31 May 2023

0

Unable to load and execute employees data keep getting this error

  

Error
Static analysis:

5 errors were found during analysis.

 

Unexpected character. (near "" at position 2)
Unexpected character. (near "" at position 3)
Unexpected beginning of statement. (near "PK" at position 0)
Unexpected beginning of statement. (near "" at position 2)
Unexpected beginning of statement. (near "" at position 3)
 

SQL query: Copy

PK;

MySQL said:  

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'PK' at line 1

1 answers ( 0 marked as helpful)
Instructor
Posted on:

22 May 2024

0

Hi Allan!

Thanks for reaching out!


For the purposes of the courses, it's advisable to use MySQL, as it's a commonly taught relational database management system. The error message you provided indicates the use of MariaDB, which is similar to MySQL but has some differences, particularly in terms of syntax and features. So, for the course's consistency, it's recommended to use MySQL.
 

Hope this helps.
Best,
Martin

Submit an answer