[RESOLVED] Weird query problem

ClarkF1

Okay, I have a .sql file generated by phpmyadmin containing about 300 INSERT queries of the form:

INSERT INTO tracks( played, artist, title, user, updated )
VALUES ( 1154386861, 'The Beatles', 'Hey Jude', 'ClarkF1', 0 ) ;

Now, when I tried to import the file using PHPmyadmin I got the error:

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

So I wrote a short script to loop through the contents of the file line by line removing any special characters etc using trim on each line.

That produced the same error.

However, copying the file contents into the sql entry field in phpmyadmin worked perfectly.

Can anyone see any problem in the query that would prevent it being parsed by the phpmyadmin import function?

jinrongye

check the table tracks's default charset is same as of the old table

bogu

Encapsulate your fields name between this character (`) dont know its name ... 😛

INSERT INTO tracks ( `played`, `artist`, `title`, `user`, `updated` )
VALUES ( 1154386861, 'The Beatles', 'Hey Jude', 'ClarkF1', 0 )

OR u can write your insert like this:

INSERT INTO tracks SET 
`played` = 1154386861, 
`artist` = 'The Beatles', 
`title` = 'Hey Jude', 
`user` = 'ClarkF1', 
`updated`= 0

TobyRT

the ` marks I believe are called 'backticks'

bogu

TobyRT wrote:
the ` marks I believe are called 'backticks'

THX 😃

ClarkF1

I copied the structure over and tried again, this time the other way round and phpmyadmin wouldn't accept it through the sql entry option or by looping through but worked using the import feature.

It's completely and totally confusing..........I'm using xampp on windows.

The databases are utf-8 encoded and all special characters are escaped in other entries.

I'm going to mark this as resolved because I have managed to get what I wanted done.