Top "Mysql-error-1064" questions

Import large csv file using phpMyAdmin

I have a csv file, a big one, 30 000 rows. I've tried to import it using LOAD file etc.. from the …

mysql csv import phpmyadmin mysql-error-1064

cakephp query with conditions limit and order

I want to retrieve the last 3 registered users in cakephp using the field created in table Users. In my controller …

mysql cakephp mysql-error-1064

MySql calling stored function from within a stored procedure causing error

I'm getting a 1064 error when trying to call a stored function from within a stored procedure. It only happens on …

sql mysql stored-procedures mysql-error-1064 stored-functions

How to change the type of a column from varchar(30) to varcahar(100)?

I have a table that describes like this: mysql> describe easy_table; +---------------------+--------------+------+-----+---------+----------------+ | Field | …

mysql sql mysql-error-1064

Mysql making --secure-file-priv option to NULL

I am running MySQL in Ubuntu. I getting this error while running specific set of queries. The MySQL server is …

php mysql mysql-error-1064

what is the correct syntax for executing .sql script in MySQL command line?

I am confused. From references I have seen online, the command to execute a text file script is this: mysql&…

mysql mysql-error-1064 sql-scripts

Error creating table: You have an error in your SQL syntax near 'order( order_id INT UNSIGNED NOT NULL AUTO_INCREMENT, user_id ' at line 1

I am trying to create 2 tables in the same MySQL database with a PHP-script: table 'user' with primary key 'user_…

mysql sql database mysql-error-1064

How to deal with an apostrophe while writing into a MySQL database

I am getting this error: You have an error in your SQL syntax; check the manual that corresponds to your …

php mysql mysql-error-1064

How to fix MySQL CREATE FUNCTION query?

I want to add mysql function: CREATE FUNCTION `chf_get_translation`(translation_id INT, site_lang INT) RETURNS text CHARSET …

mysql mysql-error-1064 create-function

MySQL error - "You have an error in your SQL syntax"

The error message I got: You have an error in your SQL syntax; check the manual that corresponds to your …

php mysql syntax syntax-error mysql-error-1064