I cannot execute MySQL query

Asked By Maxene Tomas 0 points N/A Posted on - 03/23/2012

While creating a table for emails in mysql database it shows the following error: "#1064 – You have an error in your SQL syntax"

the following code I tried:

'
'
—
— Table structure for table `coming_soon_emails`
—

CREATE TABLE `coming_soon_emails` (
  `email` varchar(64) collate utf8_unicode_ci NOT NULL,
  `ts` timestamp NOT NULL default CURRENT_TIMESTAMP,
  PRIMARY KEY  (`email`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

• Status: Open
• Question Views: 974
• Answer Count: 3
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MySQL Server

Best Answer by Manthew Gard

Go To Solution

Best Answer

Best Answer

Answered By Manthew Gard 0 points N/A #114813

I cannot execute MySQL query

 

Mysql is always a sensitive element for web development. So you must have attractive attention to the job when you use this language. Most of the time, you may face the problem about syntax error such as comma, invited comma and others. Beside you may avoid the coding system to make database and table because of an accurate result. If you make a table on MySQL manually, you can save your time and get exclusive result. Just follow the command manually to make a table:

Go to mysql and take a name of database >> Next write your table name and row amount >> specially choose some option for every field. Your table is ready for use.

About Manthew Gard

Questions
1

Answers
12

Best Answers
4

• Vote Up 0 Vote Down

• Posted on - 03/24/2012
• Question Category: MySQL Server

Answered By mmsayeed 0 points N/A #114814

I cannot execute MySQL query

Drop these lines:

'

'
—
— Table structure for table `coming_soon_emails`
—

And try the following:

CREATE TABLE `coming_soon_emails` (

  `email` varchar(64) collate utf8_unicode_ci NOT NULL,

  `ts` timestamp NOT NULL default CURRENT_TIMESTAMP,

  PRIMARY KEY  (`email`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

Your table will be created. Thanks.

About mmsayeed

Questions
0

Answers
1

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 03/24/2012
• Question Category: MySQL Server

Answered By Maxene Tomas 0 points N/A #114815

I cannot execute MySQL query

yes it is really sensitive. all should be right in entry to avoid any error. I tried to follow the images and thanks to you no error occured on my second try. Thanks a lot Manthew..>–<

About Maxene Tomas

Questions
9

Answers
5

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 04/10/2012
• Question Category: MySQL Server