Mysql Error Create Table 1064
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the error 1064 mysql 42000 create table workings and policies of this site About Us Learn more about
Error 1064 Mysql 42000 Create Database
Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions error 1064 (42000): you have an error in your sql syntax; Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other.Mysql Error 1064 42000
Join them; it only takes a minute: Sign up MySQL Create Table Error 1064 up vote 0 down vote favorite I am trying to create a table in MySQL but it doesn't want to play: create table traders( traderID INT(9) ZEROFILL NOT NULL AUTO_INCREMENT UNSIGNED, traderProfileName VARCHAR(64) NOT NULL, traderPassword CHAR(128) NOT NULL, traderFirstName VARCHAR(40) NOT NULL, traderSurname VARCHAR(40) create table mysql NOT NULL, traderContactPhone VARCHAR(14) NOT NULL, locationPostCode CHAR(4) NOT NULL, traderEmail VARCHAR(120) NOT NULL, traderBio VARCHAR(255) DEFAULT NULL, traderReviewRating DECIMAL(5,2) DEFAULT NULL, traderLastLogin DATETIME DEFAULT NULL, PRIMARY_KEY(traderID) ); And I am getting error: "ERROR 1064 (42000): 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 'UNSIGNED, traderProfileName VARCHAR(64) NOT NULL, traderPassword CHAR(128) NOT ' at line 2" Is this something simple as I am using incorrect parameters for the table settings? mysql database share|improve this question edited May 29 at 15:46 wogsland 2,84181235 asked Oct 14 '13 at 19:27 Jonlee 1614 also unsigned is not a valid mysql type. Read the manual ! You have an invalid type and a typo. –Lorenz Meyer Feb 3 '15 at 9:16 add a comment| 4 Answers 4 active oldest votes up vote 0 down vote Auto increment is an integer by default, no need to define unsigned. http://dev.mysql.com/doc/refman/5.0/en/example-auto-increment.html share|improve this answer answered Oct 14 '13 at 19:33 Tom Ron 7here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn
Mysql Create Table Example
more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up MySQL error 1064 creating table up vote 1 down vote favorite Trying to create a table with two foreign keys and keep getting this error: #1064 http://stackoverflow.com/questions/19367752/mysql-create-table-error-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 'idbed MEDIUMINT UNSIGNED NOT NULL, idnumber MEDIUMINT UNSIGNED NOT NULL,' at line 2 The table is: CREATE TABLE care( idbed MEDIUMINT UNSIGNED NOT NULL, idnumber MEDIUMINT UNSIGNED NOT NULL, PRIMARY KEY(idbed, idnumber), FOREIGN KEY(idbed) REFERENCES intensivecarebed(idbed) FOREIGN KEY(idnumber) REFERENCES employee(idnumber)); the other two tables are: CREATE TABLE Employee( first_name VARCHAR(30) NOT http://stackoverflow.com/questions/28067915/mysql-error-1064-creating-table NULL, last_name VARCHAR(30) NOT NULL, address VARCHAR(60) NOT NULL, salary FLOAT UNSIGNED NOT NULL, specialization VARCHAR(50) NOT NULL< clinic_name VARCHAR(50) NOT NULL, PRIMARY KEY(idnumber) ); CREATE TABLE intensivecarebed( idbed MEDIUMINT UNSIGNED NOT NULL, clinic_name VARCHAR(50) NOT NULL, tax_reg_number TINYINT(10) UNSIGNED NOT NULL, PRIMARY KEY(idbed) ); Anybody insights? mysql sql mysql-error-1064 share|improve this question edited Jan 21 '15 at 13:31 rtruszk 3,408132242 asked Jan 21 '15 at 13:02 Ioanna Otinanai 83 Ther is some syntax error in the following line: specialization VARCHAR(50) NOT NULL< < should be replaced by ',' in the first create After correcting this syntax error, i executed this sccript in my MySQL server it went ok... –ASNAOUI Ayoub Jan 21 '15 at 13:09 specialization VARCHAR(50) NOT NULL< one < which must be ,. Don't you need idnumber MEDIUMINT UNSIGNED NOT NULL, also in table Employee? –Jason Paddle Jan 21 '15 at 13:10 add a comment| 1 Answer 1 active oldest votes up vote 2 down vote accepted There are several errors in your code: You missed idnumber in Employee table. You missed coma between foreign keys. You had < instead of , You also have to create care table after creating other two tables because you are referring to these tables. Try this: CREATE TABLE Employee( idnumber MEDIUMINT UNSIGNED NOT NULL, first_name VARCHAR(30) NOT NULL, last_name VARCHAR(30) NOT NULL, addreslog in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of http://dba.stackexchange.com/questions/34076/creating-table-syntax-error-1064 this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database https://dev.mysql.com/doc/refman/5.5/en/create-table.html Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a create table minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top creating table syntax error 1064 up vote 2 down vote favorite I'm using workbench to create a table. This script is giving me a problem. It is saying that there is a syntax error new '). DROP TABLE error 1064 mysql IF EXISTS `waitronmain`.`managers` ; CREATE TABLE IF NOT EXISTS `waitronmain`.`managers` ( `manager_id` INT NOT NULL AUTO_INCREMENT , `name` VARCHAR(45) NOT NULL , `email` VARCHAR(45) NOT NULL , `password` VARCHAR(45) NOT NULL , `restaurant` VARCHAR(45) NOT NULL , `location` VARCHAR(45) NULL , PRIMARY KEY (`manager_id`) ) ENGINE = InnoDB; -- ----------------------------------------------------- -- Table `waitronmain`.`waiters` -- ----------------------------------------------------- DROP TABLE IF EXISTS `waitronmain`.`waiters` ; CREATE TABLE IF NOT EXISTS `waitronmain`.`waiters` ( `waiter_id` INT NOT NULL AUTO_INCREMENT , `name` VARCHAR(45) NOT NULL , `password` VARCHAR(45) NOT NULL , PRIMARY KEY (`waiter_id`) , INDEX `manager_id` () , CONSTRAINT `manager_id` FOREIGN KEY () REFERENCES `waitronmain`.`managers` () ON DELETE NO ACTION ON UPDATE NO ACTION) ENGINE = InnoDB; The line causing the problem is this: INDEX `manager_id` () , Any ideas? I'm at a loss, the code was generated from an ERD model I made within Workbench so I'm suprised it has a syntax error at all. I got this error code when executing: Error Code: 1064 You have an error in your SQL syntax mysql mysql-workbench share|improve this question edited Feb 4 '13 at 17:15 bluefeet♦ 6,06522255 asked Feb 4 '13 at 16:18 Javacadabra 12827 add a comment
Connectors More MySQL.com Downloads Developer Zone Section Menu: Documentation Home MySQL 5.5 Reference Manual Preface and Legal Notices General Information Installing and Upgrading MySQL Tutorial MySQL Programs MySQL Server Administration Security Backup and Recovery Optimization Language Structure Globalization Data Types Functions and Operators SQL Statement Syntax Data Definition Statements ALTER DATABASE Syntax ALTER EVENT Syntax ALTER FUNCTION Syntax ALTER LOGFILE GROUP Syntax ALTER PROCEDURE Syntax ALTER SERVER Syntax ALTER TABLE Syntax ALTER TABLE Partition Operations ALTER TABLE Online Operations in MySQL Cluster ALTER TABLE Examples ALTER TABLESPACE Syntax ALTER VIEW Syntax CREATE DATABASE Syntax CREATE EVENT Syntax CREATE FUNCTION Syntax CREATE INDEX Syntax CREATE LOGFILE GROUP Syntax CREATE PROCEDURE and CREATE FUNCTION Syntax CREATE SERVER Syntax CREATE TABLE Syntax CREATE TABLE ... LIKE Syntax CREATE TABLE ... SELECT Syntax Using FOREIGN KEY Constraints Silent Column Specification Changes CREATE TABLESPACE Syntax CREATE TRIGGER Syntax CREATE VIEW Syntax DROP DATABASE Syntax DROP EVENT Syntax DROP FUNCTION Syntax DROP INDEX Syntax DROP LOGFILE GROUP Syntax DROP PROCEDURE and DROP FUNCTION Syntax DROP SERVER Syntax DROP TABLE Syntax DROP TABLESPACE Syntax DROP TRIGGER Syntax DROP VIEW Syntax RENAME TABLE Syntax TRUNCATE TABLE Syntax Data Manipulation Statements CALL Syntax DELETE Syntax DO Syntax HANDLER Syntax INSERT Syntax INSERT ... SELECT Syntax INSERT DELAYED Syntax INSERT ... ON DUPLICATE KEY UPDATE Syntax LOAD DATA INFILE Syntax LOAD XML Syntax REPLACE Syntax SELECT Syntax SELECT ... INTO Syntax JOIN Syntax UNION Syntax Subquery Syntax The Subquery as Scalar Operand Comparisons Using Subqueries Subqueries with ANY, IN, or SOME Subqueries with ALL Row Subqueries Subqueries with EXISTS or NOT EXISTS Correlated Subqueries Subqueries in the FROM Clause Subquery Errors Optimizing Subqueries Rewriting Subqueries as Joins UPDATE Syntax Transactional