Error 1064 shown with MySQL

Asked By david unaiponn 10 points N/A Posted on - 10/15/2013

Hello,

I am doing a research on MySQL and the error messages but concerning this particular error below I did not see much information. I would like some experts here to tell me all I need to know about the error from MySQL shown below.

Thanks.

An error has occurred

Query failed ALTER TABLE leads modify colum website Null::MySQL 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 NULL at line 1

• Status: Open
• Question Views: 857
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS SQL Server

Answered By Salazar Chaidez -10 points N/A #176747

Error 1064 shown with MySQL

The following error has been occurring in you system because you are repeating a common syntax error again and again.The scripting that you are following is not correct as You have not provided semicolon at the end to terminate your statement. The error clearly states this deficiency.

The correct syntax of using the command is "ENGINE = MYISAM CHARACTER SET latin1 COLLATE latin1_bin;"

About Salazar Chaidez

Questions
0

Answers
53

Best Answers
5

• Vote Up 0 Vote Down

• Posted on - 10/28/2013
• Question Category: MS SQL Server