View Single Post
  #7  
Old 10-02-2006, 01:24 AM
Angelox
AX Classic Developer
 
Join Date: May 2006
Location: filler
Posts: 2,049
Default

Quote:
Originally Posted by Worktruck
Okay, then let me make myself clearier I've tried every variation that I could think of putting that line in the data table putting it in exactly like you say:
INSERT INTO accounts VALUES (1, 'Admin', '', 0, 'mini', 250, , 0, 0, 0, 0, '192.168.0.22')

I get:
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 ' 0, 0, 0, 0, 192.168.0.22)' at line 1 1064

Which is the same error I get every time I've entered this line into the query browser.
Tell you lean how to move around better in MySql, I suggest you download and use "MySQL Query Browser" from the MySql site;
http://dev.mysql.com/downloads/gui-tools/5.0.html
MySQL Query Browser will give you a "visual" on all this and you'll be able to see better what you are doing, right or wrong. Also, if you install this, take notice of the bottom right-hand corner where there is a great help and info on what to do

Also, this one helps a lot ; MySQL Administrator 1.2 for back ups, setting privs., etc
Reply With Quote