"Everybody is a genius. But if you judge a fish by its ability to climb a tree, it will live its whole life believing that it is stupid." – Albert Einstein

CREATE TABLE query in mysql


CREATE TABLE `tableName` (
`column1` varchar(100) DEFAULT ”,
`column2` varchar(100) NOT NULL DEFAULT ”,
`column3` longtext,
.
.
PRIMARY KEY (`column1`)
)
ENGINE=InnoDB
DEFAULT CHARSET=latin1
COMMENT=’comment here’

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s