Hi All!
> Unable to insert [
> insert into match (league_id,round_id,team_id_1,team_id_2) VALUES ('1','3','2','3')
> ]: You have an error in your SQL syntax near 'match
>(league_id,round_id,team_id_1,team_id_2) VALUES ('1','3','2','3')' at line 1.
(Yes, I see the reserved word comments.)
Debug clue, when the syntax is obviously correct but still fails. Write a
small.file and use mysql -p db < small.file, where small.file looks like
this:
insert
into
match
(league_id,
round_id,
team_id_1,
team_id_2)
VALUES (
'1',
'3',
'2',
'3')
The 'at line' often makes more sense when there're 'more lines' instead of
just the one. :)
Or of course that can be done from the command line too but it's easier
with a more 'fixed' file line number reference.
Have a :) day!
jb
ob-word-filter: database table sql
--
jim barchuk
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
