Do you really have two single quotes before isbn10, or is that just the way it was pasted in?
Thyamine
2010-04-16 18:03:59
+1
A:
Dunno whether that was an artefact of the previous lack of indentation; I didn't remove any quotes in the code when I indented it.
Jonathan Leffler
2010-04-16 18:14:54
Thanks for the reply Thyamine and Jonathan and indenting my code. I don't understand how to paste code here. No, those double single quotes was copied and pasted from the mysqldump
01010011
2010-04-16 19:01:41
CORRECTION: the double single quote was from the error message
01010011
2010-04-16 19:17:19
+1
A:
Don't use single quotes around the column names. Single quotes means strings, you don't use strings for column names.
Try changing your script to this:
USE books;
INSERT INTO book (isbn10, isbn13, title, edition, author_f_name,
author_m_name, author_l_name, cond, price, genre)
VALUES ('0136061699', '978-0136061694',
'Software Engineering: Theory and Practice','4th Edition',
'Shari','Lawrence','Pfleeger','very good','50','Computing');
Lasse V. Karlsen
2010-04-16 19:27:10
@Lasse, thanks, you were right, it worked. One thing though, I got this message after I ran the query from the command line: Query OK, 1 row affected, 1 warning (0.00 sec). How do I display more info about this particular warning? I would like to fix this, whatever it might be.
01010011
2010-04-16 19:42:22
@Lasse, I figured it out, my title's size was set to char(20) while the title in my script had 41 characters and spaces. So I've changed char(20) to char(50)
01010011
2010-04-16 20:19:23