I cannot execute MySQL query

Asked By 0 points N/A Posted on -
qa-featured

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;

SHARE
Best Answer by Manthew Gard
Best Answer
Best Answer
Answered By 0 points N/A #114813

I cannot execute MySQL query

qa-featured


 

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.

Answered By 0 points N/A #114814

I cannot execute MySQL query

qa-featured

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.

Answered By 0 points N/A #114815

I cannot execute MySQL query

qa-featured

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..>–<

Related Questions