friiks Posted February 20, 2006 Share Posted February 20, 2006 SolvedI just had to remove "->" these things ... :blushes: well.. admins can delete this .. This is more help for using phpmyadmin ... Im new with sql and ive only used it to install a forum wich anyone can do ... and now im trying to create a table with this code mysql> CREATE TABLE user ( -> ID INT PRIMARY KEY AUTO_INCREMENT, -> userid VARCHAR(100) UNIQUE NOT NULL, -> password CHAR(16) NOT NULL, -> fullname VARCHAR(100) NOT NULL, -> email VARCHAR(100) NOT NULL, -> notes TEXT); but it gives me an error like this There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problemERROR: Unknown Punctuation String @ 31STR: ->SQL: mysql> CREATE TABLE user ( -> ID INT PRIMARY KEY AUTO_INCREMENT, -> userid VARCHAR(100) UNIQUE NOT NULL, -> password CHAR(16) NOT NULL, -> fullname VARCHAR(100) NOT NULL, -> email VARCHAR(100) NOT NULL, -> notes TEXT)SQL query:mysql> CREATE TABLE user ( -> ID INT PRIMARY KEY AUTO_INCREMENT, -> userid VARCHAR(100) UNIQUE NOT NULL, -> password CHAR(16) NOT NULL, -> fullname VARCHAR(100) NOT NULL, -> email VARCHAR(100) NOT NULL, -> notes TEXT)MySQL said: Documentation#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 'mysql> CREATE TABLE user ( -> ID INT PRIMARY KEY AUTO_INCRE and Idont know how to fix that ... maybe im not using the code wright .. ? Have no clue really cuz im learning from a tutorial Link to comment Share on other sites More sharing options...
Skemcin Posted February 21, 2006 Share Posted February 21, 2006 good to see you found the problem and sorry no one was able to assist you. We rarely delete posts - each one is a resource to the other.I'm glad you were curtious enough to post your solution - thanks:) Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now