He would have figured that, if my example did not work the first time, showing an error, it would have if he removed the quotes. I'm only trying to help, no need to go off the deep end.bdlang wrote:No, table and column names SHOULD NOT be surrounded by quotes, please don't confuse the OP any more than necessary.iknownothing wrote: Should look more like this (may or may not need '' around variables in SQL statement):
[SOLVED] CREATE TABLE PROBLEM
Moderator: General Moderators
- iknownothing
- Forum Contributor
- Posts: 337
- Joined: Sun Dec 17, 2006 11:53 pm
- Location: Sunshine Coast, Australia
-
dream2rule
- Forum Contributor
- Posts: 109
- Joined: Wed Jun 13, 2007 5:07 am
bdlang wrote:To dream2rule I say this, since all posts thus far have apparently not given you the hint: you're formatting the CREATE TABLE statement as if it were something to display to the end user. Thus, SQL != HTML. Sure, it looks good when the user views the page (and you can copy and paste the output into phpMyAdmin), but MySQL does not understandCode: Select all
CREATE TABLE sometable (<br> ...
Yes bdlang, i had a problem with (non-breaking space)
MySQL does not understand " " but takes into account if an empty space is given.
Thanks all for replying. The problem seems to have been solved now.