PDA

View Full Version : damn mysql


GregT
October 28th, 2002, 01:18
this stupid piece of ---- is making me mad now :mad:
it keeps saying that



INSERT INTO yupadog.bb1_smilies VALUES (1, 'images/angry.gif', ':angry:', '')
INSERT INTO yupadog.bb1_smilies VALUES (2, 'images/baby.gif', ':trenz:', '')
INSERT INTO yupadog.bb1_smilies VALUES (3, 'images/meow.gif', ':meow:', '')
INSERT INTO yupadog.bb1_smilies VALUES (4, 'images/forkfork.gif', ':forkfork:', '')
INSERT INTO yupadog.bb1_smilies VALUES (5, 'images/puke1.gif', ':puke1:', '')
INSERT INTO yupadog.bb1_smilies VALUES (6, 'images/puke2.gif', ':puke2:', '')
INSERT INTO yupadog.bb1_smilies VALUES (7, 'images/duckboob.gif', ':duckboob:', '')
INSERT INTO yupadog.bb1_smilies VALUES (8, 'images/google.gif', ':google:', '')
INSERT INTO yupadog.bb1_smilies VALUES (9, 'images/penguin.gif', ':papa:', '')
INSERT INTO yupadog.bb1_smilies VALUES (10, 'images/bug.gif', ':jakie:', '')
INSERT INTO yupadog.bb1_smilies VALUES (11, 'images/ducky.gif', ':ducky:', '')
INSERT INTO yupadog.bb1_smilies VALUES (12, 'images/lol.gif', ':LOL:', '')
INSERT INTO yupadog.bb1_smilies VALUES (13, 'images/biggrin.gif', ':D', '')
INSERT INTO yupadog.bb1_smilies VALUES (14, 'images/blush.gif', ':blush:', '')
INSERT INTO yupadog.bb1_smilies VALUES (15, 'images/confused.gif', ':?', '')
INSERT INTO yupadog.bb1_smilies VALUES (16, 'images/cool.gif', '8)', '')
INSERT INTO yupadog.bb1_smilies VALUES (17, 'images/cool2.gif', ':cool2:', '')
INSERT INTO yupadog.bb1_smilies VALUES (18, 'images/cry.gif', ':cry:', '')
INSERT INTO yupadog.bb1_smilies VALUES (19, 'images/cry2.gif', ':cry2:', '')
INSERT INTO yupadog.bb1_smilies VALUES (20, 'images/eek.gif', ':eek:', '')
INSERT INTO yupadog.bb1_smilies VALUES (21, 'images/eek2.gif', ':eek2:', '')
INSERT INTO yupadog.bb1_smilies VALUES (22, 'images/godfather.gif', ':godfather:', '')
INSERT INTO yupadog.bb1_smilies VALUES (23, 'images/lmao.gif', ':LMAO:', '')
INSERT INTO yupadog.bb1_smilies VALUES (24, 'images/rolleyes.gif', ':rolleyes:', '')
INSERT INTO yupadog.bb1_smilies VALUES (25, 'images/sad.gif', ':(', '')
INSERT INTO yupadog.bb1_smilies VALUES (26, 'images/sad2.gif', ':sad2:', '')
INSERT INTO yupadog.bb1_smilies VALUES (27, 'images/fisheye.gif', ':fisheye:', '')
INSERT INTO yupadog.bb1_smilies VALUES (28, 'images/smile.gif', ':)', '')
INSERT INTO yupadog.bb1_smilies VALUES (29, 'images/tongue.gif', ':P', '')
INSERT INTO yupadog.bb1_smilies VALUES (30, 'images/wink.gif', ';)', '')
INSERT INTO yupadog.bb1_smilies VALUES (31, 'images/wtongue.gif', ';P', '')
INSERT INTO yupadog.bb1_smilies VALUES (32, 'images/bluemad.gif', ':madblue:', '')
INSERT INTO yupadog.bb1_smilies VALUES (33, 'images/maggie.gif', ':oldthing:', '')
INSERT INTO yupadog.bb1_smilies VALUES (34, 'images/rotfl.gif', ':ROTFL:', '')
INSERT INTO yupadog.bb1_smilies VALUES (35, 'images/badtongue.gif', ':redtongue:', '')
INSERT INTO yupadog.bb1_smilies VALUES (36, 'images/redface.gif', ':redface:', '')
INSERT INTO yupadog.bb1_smilies VALUES (37, 'images/moo.gif', ':moo:', '')
INSERT INTO yupadog.bb1_smilies VALUES (38, 'images/pig.gif', ':pig:', '')
INSERT INTO yupadog.bb1_smilies VALUES (39, 'images/banana.gif', ':banana:', '')
INSERT INTO yupadog.bb1_smilies VALUES (40, 'images/inlove.gif', ':love:', '')
INSERT INTO yupadog.bb1_smilies VALUES (41, 'images/cake.gif', ':cake:', '')
INSERT INTO yupadog.bb1_smilies VALUES (41, 'images/clown.gif', ':clown:', '')
INSERT INTO yupadog.bb1_smilies VALUES (43, 'images/king.gif', ':king:', '')
INSERT INTO yupadog.bb1_smilies VALUES (44, 'images/whip.gif', ':whip:', '')
INSERT INTO yupadog.bb1_smilies VALUES (45, 'images/smash.gif', ':smash:', '')
INSERT INTO yupadog.bb1_smilies VALUES (46, 'images/yawn.gif', ':yawn:', '')
INSERT INTO yupadog.bb1_smilies VALUES (47, 'images/devious.gif', ':devious:', '')
INSERT INTO yupadog.bb1_smilies VALUES (48, 'images/suprised.gif', ':suprised:', '')
INSERT INTO yupadog.bb1_smilies VALUES (49, 'images/music.gif', ':music:', '')
INSERT INTO yupadog.bb1_smilies VALUES (50, 'images/freak.gif', ':freak:', '')
INSERT INTO yupadog.bb1_smilies VALUES (51, 'images/monkey.gif', ':monkey:', '')
INSERT INTO yupadog.bb1_smilies VALUES (52, 'images/smooch.gif', ':smooch:', '')
INSERT INTO yupadog.bb1_smilies VALUES (53, 'images/dog.gif', ':doggy:', '')
INSERT INTO yupadog.bb1_smilies VALUES (54, 'images/bomb.gif', ':catbomb:', '')





# Error: You have an error in your SQL syntax near 'INSERT INTO yupadog.bb1_smilies VALUES (2, 'images/baby.gif', ':trenz:', '') INS' at line 1

whats wrong ? is it mysql or how i type my tables ? i do it manually from mysqlfront and it uses the same coding. what the heck is wrong ?
ProQ
October 28th, 2002, 01:33
you forgot the semicolon at the end of each line( ; )
GregT
October 28th, 2002, 01:44
Originally posted by ProQ
you forgot the semicolon at the end of each line( ; )

still doesnt work :(



INSERT INTO yupadog.bb1_smilies VALUES (1, 'images/angry.gif', ':angry:', '');
INSERT INTO yupadog.bb1_smilies VALUES (2, 'images/baby.gif', ':trenz:', '');
INSERT INTO yupadog.bb1_smilies VALUES (3, 'images/meow.gif', ':meow:', '');
INSERT INTO yupadog.bb1_smilies VALUES (4, 'images/forkfork.gif', ':forkfork:', '');
INSERT INTO yupadog.bb1_smilies VALUES (5, 'images/puke1.gif', ':puke1:', '');
INSERT INTO yupadog.bb1_smilies VALUES (6, 'images/puke2.gif', ':puke2:', '');
INSERT INTO yupadog.bb1_smilies VALUES (7, 'images/duckboob.gif', ':duckboob:', '');
INSERT INTO yupadog.bb1_smilies VALUES (8, 'images/google.gif', ':google:', '');
INSERT INTO yupadog.bb1_smilies VALUES (9, 'images/penguin.gif', ':papa:', '');
INSERT INTO yupadog.bb1_smilies VALUES (10, 'images/bug.gif', ':jakie:', '');
INSERT INTO yupadog.bb1_smilies VALUES (11, 'images/ducky.gif', ':ducky:', '');
INSERT INTO yupadog.bb1_smilies VALUES (12, 'images/lol.gif', ':LOL:', '');
INSERT INTO yupadog.bb1_smilies VALUES (13, 'images/biggrin.gif', ':D', '');
INSERT INTO yupadog.bb1_smilies VALUES (14, 'images/blush.gif', ':blush:', '');
INSERT INTO yupadog.bb1_smilies VALUES (15, 'images/confused.gif', ':?', '');
INSERT INTO yupadog.bb1_smilies VALUES (16, 'images/cool.gif', '8)', '');
INSERT INTO yupadog.bb1_smilies VALUES (17, 'images/cool2.gif', ':cool2:', '');
INSERT INTO yupadog.bb1_smilies VALUES (18, 'images/cry.gif', ':cry:', '');
INSERT INTO yupadog.bb1_smilies VALUES (19, 'images/cry2.gif', ':cry2:', '');
INSERT INTO yupadog.bb1_smilies VALUES (20, 'images/eek.gif', ':eek:', '');
INSERT INTO yupadog.bb1_smilies VALUES (21, 'images/eek2.gif', ':eek2:', '');
INSERT INTO yupadog.bb1_smilies VALUES (22, 'images/godfather.gif', ':godfather:', '');
INSERT INTO yupadog.bb1_smilies VALUES (23, 'images/lmao.gif', ':LMAO:', '');
INSERT INTO yupadog.bb1_smilies VALUES (24, 'images/rolleyes.gif', ':rolleyes:', '');
INSERT INTO yupadog.bb1_smilies VALUES (25, 'images/sad.gif', ':(', '');
INSERT INTO yupadog.bb1_smilies VALUES (26, 'images/sad2.gif', ':sad2:', '');
INSERT INTO yupadog.bb1_smilies VALUES (27, 'images/fisheye.gif', ':fisheye:', '');
INSERT INTO yupadog.bb1_smilies VALUES (28, 'images/smile.gif', ':)', '');
INSERT INTO yupadog.bb1_smilies VALUES (29, 'images/tongue.gif', ':P', '');
INSERT INTO yupadog.bb1_smilies VALUES (30, 'images/wink.gif', ';)', '');
INSERT INTO yupadog.bb1_smilies VALUES (31, 'images/wtongue.gif', ';P', '');
INSERT INTO yupadog.bb1_smilies VALUES (32, 'images/bluemad.gif', ':madblue:', '');
INSERT INTO yupadog.bb1_smilies VALUES (33, 'images/maggie.gif', ':oldthing:', '');
INSERT INTO yupadog.bb1_smilies VALUES (34, 'images/rotfl.gif', ':ROTFL:', '');
INSERT INTO yupadog.bb1_smilies VALUES (35, 'images/badtongue.gif', ':redtongue:', '');
INSERT INTO yupadog.bb1_smilies VALUES (36, 'images/redface.gif', ':redface:', '');
INSERT INTO yupadog.bb1_smilies VALUES (37, 'images/moo.gif', ':moo:', '');
INSERT INTO yupadog.bb1_smilies VALUES (38, 'images/pig.gif', ':pig:', '');
INSERT INTO yupadog.bb1_smilies VALUES (39, 'images/banana.gif', ':banana:', '');
INSERT INTO yupadog.bb1_smilies VALUES (40, 'images/inlove.gif', ':love:', '');
INSERT INTO yupadog.bb1_smilies VALUES (41, 'images/cake.gif', ':cake:', '');
INSERT INTO yupadog.bb1_smilies VALUES (41, 'images/clown.gif', ':clown:', '');
INSERT INTO yupadog.bb1_smilies VALUES (43, 'images/king.gif', ':king:', '');
INSERT INTO yupadog.bb1_smilies VALUES (44, 'images/whip.gif', ':whip:', '');
INSERT INTO yupadog.bb1_smilies VALUES (45, 'images/smash.gif', ':smash:', '');
INSERT INTO yupadog.bb1_smilies VALUES (46, 'images/yawn.gif', ':yawn:', '');
INSERT INTO yupadog.bb1_smilies VALUES (47, 'images/devious.gif', ':devious:', '');
INSERT INTO yupadog.bb1_smilies VALUES (48, 'images/suprised.gif', ':suprised:', '');
INSERT INTO yupadog.bb1_smilies VALUES (49, 'images/music.gif', ':music:', '');
INSERT INTO yupadog.bb1_smilies VALUES (50, 'images/freak.gif', ':freak:', '');
INSERT INTO yupadog.bb1_smilies VALUES (51, 'images/monkey.gif', ':monkey:', '');
INSERT INTO yupadog.bb1_smilies VALUES (52, 'images/smooch.gif', ':smooch:', '');
INSERT INTO yupadog.bb1_smilies VALUES (53, 'images/dog.gif', ':doggy:', '');
INSERT INTO yupadog.bb1_smilies VALUES (54, 'images/bomb.gif', ':catbomb:', '');
acidmist_mike
October 28th, 2002, 02:48
What is the new error message now?

How / where are you running the commands?
GregT
October 28th, 2002, 03:07
Originally posted by acidmist_mike
What is the new error message now?

How / where are you running the commands?

weird it worked this time :nervous: