Best unofficial Apache Server developers community
Username
Forgot password?
Sign in with Twitter account
Sign in with Facebook account

MySQL create table

⇧
0
⇩
60 views

After reading the tutorials and examples on creating tables, I'm trying to create my own. But, the error this code gives me doesn't tell me what is wrong.

Can someone help?

CREATE TABLE feedback
(id INT NOT NULL AUTO_INCREMENT CREATE PRIMARY KEY,
email VARCHAR(80),
brand VARCHAR(30),
model VARCHAR(30),
desc VARCHAR(255),
date TIMESTAMP(8));
mysql
asked April 13, 2011 10:05 am CDT
SquireCD
posted via StackOverflow

3 Answers

⇧
3
⇩
 

You're doing the primary key declaration wrong, I believe. Leave off the word "create" and it should work.

answered April 13, 2011 10:23 am CDT
eykanal
⇧
2
⇩
 

desc VARCHAR(255),

"desc" is a reserved keyword, It might the problem, use something else and try

Hope it helps

answered April 13, 2011 10:23 am CDT
nr4bt
⇧
0
⇩
 
 
CREATE TABLE  `feedback` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
`email` VARCHAR(80),
`brand` VARCHAR(30),
`model` VARCHAR(30),
`descr` VARCHAR(255),
`date` TIMESTAMP
)
answered April 13, 2011 10:23 am CDT
Marco

Your answer

Join with account you already have

Sign in with Twitter account
Sign in with Facebook account
Sign in with Google Friend Connect

Preview
Similar questions
Can I change the datatype for the "Create Table" field in the Show Create Table function in MySQL?
January 10, 2011
Create table from select then alter table by adding an auto increment column in mysql
January 11, 2011
Mysql create table based on another table including indexes
January 25, 2011
MySQL create table containing values from a column in another table.
January 28, 2011
Create a enum table and access it from other table in mysql
March 21, 2011
How to create index in two table mysql?
January 13, 2011
Can't create foreign key on mysql table
March 23, 2011
MySQL - Aren't these privileges enough to create a table?
January 3, 2011
MySQL table create taking way too long
February 11, 2011
Mysql how to create optimum query for these table
February 11, 2011
Mysql create a table character sets
January 25, 2011
Convert Simple T-SQL DDL to MySQL DDL (Create Table)
January 6, 2011
Foreign Key Error on MySQL CREATE TABLE statement (err: 150)
March 18, 2011
Mysql proxy to check create table statement
February 22, 2011
How to create mysql table with many hasMany association in CakePHP?
January 18, 2011
Is there a mysql equivalent of show create table in postgres???
February 6, 2011
Help to creating a formula on mysql to create another column on another table
March 6, 2011
Create MySQL View from Lookup Table and Actual Data
March 9, 2011
Using MySQL, I'm attempting to create a table in a db, and then insert into, but am getting a 'syntax' error
January 13, 2011
MySQL table joins, nested select statements, or create a view?
February 17, 2011
How to fetch column names from 'MySQL Create Table' Query string?
April 8, 2011
Mysql, how to create table and automatically track users who add or delete rows/tables
February 11, 2011
Create new table from two tables with multiple columns in first table replaced by columns in second table
April 10, 2011
Should I create a Mysql table using a MEMORY (HEAP) engine or MyISAM engine?
April 11, 2011
PHP / MySQL - Create array of distinct values, query db table for data associated with those values, and loop for each
January 25, 2011
Mysql statement to create user and table private to that user only
April 11, 2011
Create this table using my sql
February 1, 2011
Cannot rake db:create:all -- Couldn't create database for {"encoding"=>"utf8", "username"=>"root", "adapter"=>"mysql" ...
April 6, 2011
Create table in hbase
February 22, 2011
I need to create a SQLite table...
February 17, 2011