RE: [PHP] mysql problem- I know it isn't strictly php
| From: | Jay Blanchard | Date: | Tue, 19 Jul 2005 12:43:01 +0000 |
| Subject: | RE: [PHP] mysql problem- I know it isn't strictly php | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-218956@lists.php.net to get a copy of this message | ||
[snip]
1064 - 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
'DEFAULT CHARSET=latin1 AUTO_INCREMENT=303' at line 18
and this is what the manual says (not very helpful)
a.. Error: 1064 SQLSTATE: 42000 (ER_PARSE_ERROR)
Message: %s near '%s' at line %d
Any help will be appreciated.
[/snip]
There is nothing PHP here, but you knew that when you pressed send.
Really there are a lot of MySQL gurus on this list. There are a lot more
on mysql@lists.mysql.com
You're problem is likely related to the version of MySQL that you are
running, perhaps it doesn't support CHARSET definitions.