Hi win.a,
I tried with another user the problem still persists. I am getting same
error for another user as well.
--
Regards,
Manasi Save
On Tue, 7 Sep 2010 11:41:35 0800, win.a wrote:
use another user and dump the data ,eg the root .
mysqldump -uroot -p --al-databases
: Wed, September 8, 2010 3:57:40 PM
Subject: Re: mysqldump error 1064 for database Use command
Hi win.a,
I tried with another user the problem still persists. I am getting same
error for another user as well.
--
Regards,
Manasi Save
On Tue, 7 Sep 2010 11:41:35 0800, win.a wrote:
use another
On 06/09/2010 6:54 a, Manasi Save wrote:
Dear Nitin,
I have newly installed mysql on this server.
mysql Select version();
+-+
| version() |
+-+
| 5.1.22-rc-Debian_2~ppa5-log |
+-+
Earlier I use to run the same
No it does not. But when I dump database name mydb it does. but not
the database with name 1.
--
Regards,
Manasi Save
On Mon, 06 Sep 2010 09:23:21 0200, Jangita wrote:
On 06/09/2010 6:54 a, Manasi Save wrote:
Dear Nitin,
I have newly installed mysql on this server.
mysql
...@artificialmachines.comTo: "mysql@lists.mysql.com"
mysql@lists.mysql.comSent: Sat, September 4, 2010 12:06:27 PMSubject: mysqldump
error 1064 for database Use commandHi All,I
have 10 mysql databases all the tables use MyIsAm mysql storage engine.Database names are 1,2,3,4,...10.When I use mysqldu
Hi All,
I have 10 mysql databases all the tables use MyIsAm mysql storage
engine.
Database names are 1,2,3,4,...10.
When I use mysqldump command with --all-databases option. This gives me
following error:
mysqldump -u myuser -p --all-databases AllNew_Databases_20100904.sql
ERROR MESSAGE :-
(of database in your case).
Hope that helps.
Regards,
Nitin
From: Manasi Save manasi.s...@artificialmachines.com
To: mysql@lists.mysql.com mysql@lists.mysql.com
Sent: Sat, September 4, 2010 12:06:27 PM
Subject: mysqldump error 1064 for database Use command
Hi
I am receiving this error:
ERROR 1064: You have an error in your SQL syntax. Check the manual that
corresponds to you MySQL server version for the right syntax to use near '16
varchar(255) NOT NULL default 'Not applicable', 17a varch
I have version 4.0.16 and have a dump file that I'm
Hi Brad,
2010/6/8 Brad Scott outlawsco...@hotmail.com:
[...]
Any line beginning with just a number (ie 9, 10, 16) causes a failure. What
am I missing?
you should add backticks ( ` ) at both ends of the column name, e.g.
`7c` varchar(255) NOT NULL default '',
I think your export should have
Brad Scott skrev:
Any line beginning with just a number (ie 9, 10, 16) causes a failure. What am
I missing?
backticks. Use `9`, `10`, etc.
Having column names that begin with numbers is a really bad design
decision. 9a123 (unquoted, of course) will work, as you've noticed,
but e.g.
');
ERROR 1064 (42000): 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 'UPDATE `tblTransaction` SET `TYPE` = 'Manual' WHERE
(`ORDERID` = '694215576aac60' at line 1
If anybody has any ideas, please let me know
` =
'694215576aac60f10c9eebe4a5a39d0f');
ERROR 1064 (42000): 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 'UPDATE `tblTransaction` SET `TYPE` = 'Manual' WHERE
(`ORDERID` = '694215576aac60' at line 1
If anybody has any ideas
Hello !
I'm a beginner with mysql. I just installed the phpMyAdmin
2.9.1.1-Debian-1 / mysql 14.12 Distrib 5.0.30 for a soft (koha), but I
have an error when I try to install the base :
Creating the MySQL database for Koha...
0
ERROR 1064 (42000) at line 772: You have an error in your SQL
Hi !
I'm a beginner with mysql. I just installed the phpMyAdmin
2.9.1.1-Debian-1 / mysql 14.12 Distrib 5.0.30 for a soft (koha), but I
have an error when I try to install the base :
Creating the MySQL database for Koha...
0
ERROR 1064 (42000) at line 772: You have an error in your SQL syntax
I dumped a database from a 4.0 mysql and am attempting to move it to a
server running 4.1 - using the command line:
$ mysql -u root -pmypassword empty4.1db 4.0dump.sql
The result:
ERROR 1064 (42000) at line 2: You have an error in your SQL syntax; check
the manual that corresponds to your MySQL
words.
Carlos
On 9/26/06, Curious George [EMAIL PROTECTED] wrote:
I dumped a database from a 4.0 mysql and am attempting to move it to a
server running 4.1 - using the command line:
$ mysql -u root -pmypassword empty4.1db 4.0dump.sql
The result:
ERROR 1064 (42000) at line 2: You have an error
)|
as well as renaming it from |b| to |c|:
ALTER TABLE t2 MODIFY a TINYINT NOT NULL, CHANGE b c CHAR(20);
for changing the name of a column, right? So, why doesn't the below work?
mysql ALTER TABLE actors CHANGE director_id actor_id;
I get this,
ERROR 1064 (42000): You have an error in your SQL
At 0:09 +1000 8/6/06, Mark Sargent wrote:
ALTER TABLE t2 MODIFY a TINYINT NOT NULL, CHANGE b c CHAR(20);
for changing the name of a column, right? So, why doesn't the below work?
mysql ALTER TABLE actors CHANGE director_id actor_id;
I'm no great expert myself, but off the top of my head,
|b| from |CHAR(10)| to |CHAR(20)|
as well as renaming it from |b| to |c|:
ALTER TABLE t2 MODIFY a TINYINT NOT NULL, CHANGE b c CHAR(20);
for changing the name of a column, right? So, why doesn't the below work?
mysql ALTER TABLE actors CHANGE director_id actor_id;
I get this,
ERROR 1064
: ERROR 1064 (42000): You have an error in your SQL syntax;
Hi All,
gee I really hate bugging you all for this. I looked at this page,
http://dev.mysql.com/doc/refman/5.0/en/alter-table.html
which has this,
To change column |a| from |INTEGER| to |TINYINT NOT NULL| (leaving the name
the same
At 15:19 +0100 7/6/06, Rob Desbois wrote:
With the CHANGE clause of ALTER TABLE statement, you must provide
the column definition, so something like this is what you need:
ALTER TABLE actors CHANGE director_id actor_id MEDIUMINT UNSIGNED NOT NULL;
or whatever your original definition is.
:[EMAIL PROTECTED]
Enviado el: Miércoles, 15 de Marzo de 2006 07:22 p.m.
Para: mysql@lists.mysql.com
Asunto: Error 1064: update .select nested.
Dear Sir,
MySQL-4.1.12 on RedHat Linux EL4:
mysql update TABLE1 set FIELD1=(select FIELD2 from TABLE2 where
mysql COLUMN2=
'[EMAIL PROTECTED
07:22 p.m.
Para: mysql@lists.mysql.com
Asunto: Error 1064: update .select nested.
Dear Sir,
MySQL-4.1.12 on RedHat Linux EL4:
mysql update TABLE1 set FIELD1=(select FIELD2 from TABLE2 where
mysql COLUMN2=
'[EMAIL PROTECTED]') where COLUMN1='[EMAIL PROTECTED]';
ERROR 1064
, 2006 10:51 PM
Subject: RE: Error 1064: update .select nested.
AAAUUUGGGHHH!!! You used the dreaded comma separated list !!! ;-)
A more explicit way to write the same thing posted by Sr. Cruz...
update TABLE1 a
INNER JOIN TABLE2 b
on a.id = b.other_id
set a.FIELD1=b.FIELD2
WHERE
Dear Sir,
MySQL-4.1.12 on RedHat Linux EL4:
mysql update TABLE1 set FIELD1=(select FIELD2 from TABLE2 where COLUMN2=
'[EMAIL PROTECTED]') where COLUMN1='[EMAIL PROTECTED]';
ERROR 1064: You have an error in your SQL syntax. Check the manual that corresp
onds to your MySQL server version
Sorry I should have said. I get error 1064 whenever I am working with an
integer or real column. char's are fine.
Kerry
Can someone help me.
I was running v4.1 and just upgraded the version to v5.0.
Most of my tables are MyISAM with some InnoDb. Most
Hello.
FOREIGN KEY (A_areaNum) REFERENCES Area(areaNum),
Put Area in backticks ('`'). See:
http://dev.mysql.com/doc/refman/5.0/en/legal-names.html
Nabegh Al-Thalji wrote:
When I execute the following query
CREATE TABLE Sponsor (
sNum INTEGER UNSIGNED NOT NULL,
sAdrBlock
When I execute the following query
CREATE TABLE Sponsor (
sNum INTEGER UNSIGNED NOT NULL,
sAdrBlock CHAR(2),
sCivil_ID CHAR(12),
sDateOfBirth DATE,
sDrvLicenseExp DATE,
sDrvLicenseNum CHAR(9),
sGender ENUM('M','F'),
sName VARCHAR(20),
sStatus VARCHAR(20),
sTelephone CHAR(7),
A_areaNum INTEGER
Hi,
You are using a reserved function name AREA (polygon function) as a
fieldname. Simply change the field's name or try using quotes around
it...
Detlev
[...]
FOREIGN KEY (A_areaNum) REFERENCES Area(areaNum),
[...]
Any ideas?
--
MySQL General Mailing List
For list archives:
.
The following caused the same error of:
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 'select max(length(testName)) from test)' at line 1
select testName from test where length(testName) = (select
max
.
The following caused the same error of:
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 'select max(length(testName)) from test)' at line 1
select testName from test where length(testName) = (select
max
Hello list.
I'm new to MySQL but so far I like it a lot. I have it running on
WinNT4 w/SP6a and I use MySQL Admin.
I'm having trouble running an application from a third party, this
application launches but whenever I try a query, I get a message that
says Type mismatch for field field
.
In my database I have three tables that I am having problems with and each
one has the same error.
Here is the 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
'-5, 5' at line 1
Good Morning.
I am new to the list and new to Mysql.
I am in the process of running a website and I need a little newbie help.
In my database I have three tables that I am having problems with and each
one has the same error.
Here is the error.
1064 - You have an error in your SQL syntax
I created the dump file from my current DB to make adjustments and also migrate to
Innodb tables. In the process I have tried to add some ENUM types in select table.
Obviously, I am doing something wrong as each one give me a syntax error 1064 when I
try to source in the text file. I've read
to make adjustments and also migrate to Innodb tables. In the process I have tried to add some ENUM types in select table. Obviously, I am doing something wrong as each one give me a syntax error 1064 when I try to source in the text file. I've read the manual and do not see where my error is. Can
Hi,
I am comparable new to mySQL, so sorry if I might bother you with a
newby Problem:
When I connect to the database via phpMyAdmin or via the mySQL Command
Line Tool as root I have problems creating a view (root has all
privelegs, and the pure select statement works fine in the line before):
Klaus Neudecker [EMAIL PROTECTED] wrote:
Hi,
I am comparable new to mySQL, so sorry if I might bother you with a
newby Problem:
When I connect to the database via phpMyAdmin or via the mySQL Command
Line Tool as root I have problems creating a view (root has all
privelegs, and the pure
;
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 'LIKE students' at line 1
mysql CREATE TABLE students2 (LIKE students);
ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds
TABLE students2 LIKE students;
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 'LIKE students' at line 1
mysql CREATE TABLE students2 (LIKE students);
ERROR 1064: You have an error in your SQL
I am converting an Access95 DB to mySQL. The interface will remain in Access95. I
encountered a problem with one of the existing queries. The code for the query is:
SELECT DISTINCTROW ManualChecksPrinted.AccountNum, ManualChecksPrinted.CheckNumber,
ManualChecksPrinted.AccountID,
Hill, Keith wrote:
I am converting an Access95 DB to mySQL. The interface will remain in Access95. I encountered a problem with one of the existing queries. The code for the query is:
SELECT DISTINCTROW ManualChecksPrinted.AccountNum, ManualChecksPrinted.CheckNumber,
Hello,
i´m using the 3.23.57 version and i´ve declared a native function, but when
i call it (SELECT GETUPDATE(1);) i
get this line
ERROR 1064: You have an error in you SQL syntax near '(1)' at line 1;
I think i´ve followed all the steps right:
1)added the line in lex.h
{GETUPDATE
Hi!
On Sep 08, Gustavo Castro wrote:
Hello,
i?m using the 3.23.57 version and i?ve declared a native function, but when
i call it (SELECT GETUPDATE(1);) i
get this line
ERROR 1064: You have an error in you SQL syntax near '(1)' at line 1;
I think i?ve followed all the steps right
modifications.
- Original Message -
From: Sergei Golubchik [EMAIL PROTECTED]
To: Gustavo Castro [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; Fortuno, Adam [EMAIL PROTECTED]
Sent: Monday, September 08, 2003 10:30 PM
Subject: Re: Error 1064 in native function (?)
Hi!
On Sep 08, Gustavo Castro
with little
modifications.
- Original Message -
From: Sergei Golubchik [EMAIL PROTECTED]
To: Gustavo Castro [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; Fortuno, Adam [EMAIL PROTECTED]
Sent: Monday, September 08, 2003 10:30 PM
Subject: Re: Error 1064 in native function (?)
Hi!
On Sep 08
be wrong ?
Yours sincerely
Morten Gulbrandsen
-Ursprüngliche Nachricht-
Von: Victoria Reznichenko [mailto:[EMAIL PROTECTED]
Gesendet: Donnerstag, 7. August 2003 13:54
An: [EMAIL PROTECTED]
Betreff: Re: mutual declarations produce Error 1064
Morten Gulbrandsen [EMAIL PROTECTED] wrote
Morten Gulbrandsen [EMAIL PROTECTED] wrote:
USE company;
# SHOW INNODB STATUS;
DROP TABLE IF EXISTS DEPARTMENT;
CREATE TABLE DEPARTMENT
(
DNAME VARCHAR(15) NOT NULL,
DNUMBER INT NOT NULL,
MGRSSN CHAR(9) NOT NULL,
MGRSTARTDATE
),
FOREIGN KEY (SUPERSSN)
REFERENCES EMPLOYEE(SSN),
INDEX (DNO, DNUMBER),
FOREIGN KEY (DNO)
REFERENCES DEPARTMENT(DNUMBER) # this is declared in department
)TYPE = INNODB;
===
ERROR 1064 at line 9: You have an error in your SQL syntax. Check the
manual th
at corresponds to your MySQL
) REFERENCES EMPLOYEE(SSN)
- ON DELETE SET NULL
- ON UPDATE CASCADE;
ERROR 1064: You have an error in your SQL syntax. Check the manual that
corresp
onds to your MySQL server version for the right syntax to use near
'FOREIGN KEY
(SUPERSSN) REFERENCES EMPLOYEE(SSN)
ON DELETE SET
mysql
Cc: 'Victoria Reznichenko'; [EMAIL PROTECTED]
Betreff: Re: mutual declarations produce Error 1064
Morten,
In your extremely long mail, I think I managed to find your question and
removed all other stuff.
On Wed, Aug 13, 2003 at 03:18:26PM +0200, Morten Gulbrandsen wrote:
mysql
mysql # from now
NULL
- ON UPDATE CASCADE;
ERROR 1064: You have an error in your SQL syntax. Check the manual that
corresp
onds to your MySQL server version for the right syntax to use near
'FOREIGN KEY
(SUPERSSN) REFERENCES EMPLOYEE(SSN)
ON DELETE SET
mysql
mysql ALTER TABLE EMPLOYEE
- FOREIGN KEY (DNO
[mailto:[EMAIL PROTECTED]
Gesendet: Donnerstag, 7. August 2003 13:54
An: [EMAIL PROTECTED]
Betreff: Re: mutual declarations produce Error 1064
Morten Gulbrandsen [EMAIL PROTECTED] wrote:
USE company;
# SHOW INNODB STATUS;
DROP TABLE IF EXISTS DEPARTMENT;
CREATE TABLE DEPARTMENT
(
DNAME
Morten Gulbrandsen [EMAIL PROTECTED] wrote:
I think something is wrong with my administration,
Basically I get these messages,
ERROR 1005 at line 9: Can't create table '.\company\department.frm'
(errno: 150)
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password:
YES)
being written out by mysqldump, and nothing on the
server has changed which I would expect to cause this - MySQL hasn't been
reconfigured or upgraded or anything.
The error I'm seeing is:
mysqldump: Got error: 1064: You have an error in your SQL syntax
near '404 READ /*!32311 LOCAL
snip
mysqldump: Got error: 1064: You have an error in your SQL syntax
near '404 READ /*!32311 LOCAL */' at line 1 when using LOCK TABLES
Anyone got any ideas what could be causing this to happen?
snip
Table name :) It consists only of digits. Use -Q option of mysqldump.
Aaahh! I
on the
server has changed which I would expect to cause this - MySQL hasn't been
reconfigured or upgraded or anything.
The error I'm seeing is:
mysqldump: Got error: 1064: You have an error in your SQL syntax
near '404 READ /*!32311 LOCAL */' at line 1 when using LOCK TABLES
Just for info:
MySQL
,state,zipcode)
Error: 1064 - You have an error in your SQL syntax near 'name,name,street
address,city,state,zipcode)' at line 1
when I attempt to LOAD DATA INFILE the tab delimited field ascii file.
=
Field Type Null Default
TERMINATED BY '\r' (manufacture name,name,street
address,city,state,zipcode)
Error: 1064 - You have an error in your SQL syntax near 'name,name,street
address,city,state,zipcode)' at line 1
You have field names with spaces in them; you will have to escape them
with backtics:
BY '\t' LINES
okay - mysql build is killing me here ..
when I run mysql_install_db, gives me the following error
ERROR 1064 : use mysql; INVALID SYNTAX
I cannot get mysqld to start - it keeps saying
ERROR: 1064 syntax error near '' at line 1
what is goign on here
- Original Message -
From: David Angela Ehmer [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, January 04, 2003 11:00 PM
Subject: mysqldump ERROR 1064
Hi
I am having problems generating the mysqldump file. I have tried a range
of
options and carefully studied several
Hi
I am having problems generating the mysqldump file. I have tried a range of
options and carefully studied several tutorials I have on using this
command. Each time I get the following errror.
ERROR 1064 you have an error in your SQL syntax near 'mysqldump -u root -p
adrienne netno_db
On Sun, 2003-01-05 at 00:00, David Angela Ehmer wrote:
Hi
I am having problems generating the mysqldump file. I have tried a range of
options and carefully studied several tutorials I have on using this
command. Each time I get the following errror.
ERROR 1064 you have an error in your
and get the following message :
[papabaer@hanna papabaer]$ mysql samp_db -u root -p create_member.sql
Enter password:
ERROR 1064 at line 1: You have an error in your SQL syntax near '{
last_name VARCHAR(20) NOT NULL,
first_name VARCHAR(20) NOT NULL,
suffix VAR' at line 2
now I
interests VARCHAR(255) NULL
hp }
hp then I tried :
hp mysql samp_db -u root -p create_member.sql
hp and get the following message :
hp [papabaer@hanna papabaer]$ mysql samp_db -u root -p create_member.sql
hp Enter password:
hp ERROR 1064 at line 1: You have an error in your SQL syntax near
Gene Gurevich wrote:
Hi all:
I'm trying to import the tables from the dump file
via
mysqldump testdb exp
That should be:
mysql testdb exp
and it complaints about the command in the export
file:
DROP TABLE IF EXISTS db;
CREATE TABLE db (
Host char(60) NOT NULL default
That's what I used :
mysql testdb exp. Sorry about the typo
Gene
--- Gerald Clark [EMAIL PROTECTED]
wrote:
Gene Gurevich wrote:
Hi all:
I'm trying to import the tables from the dump file
via
mysqldump testdb exp
That should be:
mysql testdb exp
and it
MySQL doen not yet support nested queries.
Jawad Khan wrote:
server version 3.23.35
-Original Message-
From:Khan, Jawad [COLE:6S34:EXCH]
Sent:Thursday, June 28, 2001 1:13 PM
To: '[EMAIL PROTECTED]'
Subject: I get SYNTAX ERROR 1064 with mySQL 3.2.3 when
Hope you can find the problem in the following SQL command:
delete from alarms where raiseTime = ( select MIN(raiseTime) from alarms)
limit 1 ;
raiseTime is of type BIGINT.
server version 3.23.35
-Original Message-
From: Khan, Jawad [COLE:6S34:EXCH]
Sent: Thursday, June 28, 2001 1:13 PM
To: '[EMAIL PROTECTED]'
Subject: I get SYNTAX ERROR 1064 with mySQL 3.2.3 when using delete
as shown
Hope you can find the problem
On 28-Jun-01 Jawad Khan wrote:
Hope you can find the problem in the following SQL command:
delete from alarms where raiseTime = ( select MIN(raiseTime) from alarms)
limit 1 ;
That is a sub-select, currently unsupported in MySQL.
try :
delete from alarms order by raiseTime limit 1;
error:
./mysql -uroot -einsert into user(Host,User,Password)
values('localhost','guestbook',password('guestbook') mysql
ERROR 1064 at line 1: You have an error in your SQL syntax near
'user(Host,User,Password)
values('localhost','guestbook',password('guestbook')' at line 1
I also tried
72 matches
Mail list logo