I'm not sure but you might try with sql_mode set to ANSI. Otherwise try the
dump
remotely from a Linux box.
Regards,
Nitin
From: Manasi Save
To: win.a
Cc: "mysql@lists.mysql.com"
Sent: Wed, September 8, 2010 3:57:40 PM
Subject: Re: mysql
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 >AllNew_Databa
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.
> >
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
: "mysql@lists.mysql.com"
Sent: 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 mysqldump
command with --all-databases opt
name (of database in your case).
Hope that helps.
Regards,
Nitin
From: Manasi Save
To: "mysql@lists.mysql.com"
Sent: Sat, September 4, 2010 12:06:27 PM
Subject: mysqldump error 1064 for database Use command
Hi All,
I have 10 mysql databases all
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
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. "
Hi Brad,
2010/6/8 Brad Scott :
[...]
> 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 been done with the opt
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 dum
7; WHERE (`ORDERID` =
'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` = '694
aac60f10c9eebe4a5a39d0f');
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
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 s
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 you
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: Yo
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 y
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.
Wo
bject: 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
nge column |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,
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, may
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
ng Tan Son'" <[EMAIL PROTECTED]>
Sent: Thursday, March 16, 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...
upd
ECTED]'
>
>
> Regards!
>
> -Mensaje original-
> De: Truong Tan Son [mailto:[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,
---
De: Truong Tan Son [mailto:[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
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 M
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 o
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,
> sAdr
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:
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 UNS
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)
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) = (s
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 , exp
eed 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; check the manual that
> corresponds to your MySQL server versio
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
e 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 the manual and do not s
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
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 t
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):
ts:
mysql> CREATE 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
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 synt
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, ManualChecksPrinted.A
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, ManualChecksPr
ction with little
modifications.
> - Original Message -
> From: "Sergei Golubchik" <[EMAIL PROTECTED]>
> To: "Gustavo Castro" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>; "Fortuno, Adam" <[EMAIL PROTECTED]>
> Sent: M
ith 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
Subj
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
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
{
4 rows in set (0.00 sec)
mysql>
mysql> # from now on the coding causes trouble
mysql>
mysql> ALTER TABLE EMPLOYEE
-> FOREIGN KEY (SUPERSSN) REFERENCES EMPLOYEE(SSN)
-> ON DELETE SET NULL
-> ON UPDATE CASCADE;
ERROR 1064: You have an error in your SQL syntax. Check t
van Engen [mailto:[EMAIL PROTECTED]
Gesendet: Mittwoch, 13. August 2003 15:36
An: Morten Gulbrandsen
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
YEE
> -> FOREIGN KEY (SUPERSSN) 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),
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
"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,
> MGRS
me what could 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"
the users I have created ?
I expect one user and one password for entering mysql,
And depending upon which database I'd like to use
I expect for each database I'd like to use, one second password,
This seems to be another topic,
When I write
mysql> grant all on company.* to '
"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 passw
> > 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?
> Table name :) It consists only of digits. Us
indicating that there's a problem with the SQL syntax -
> however, this is the SQL 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'
sqldump, 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 */' at li
FIELDS TERMINATED
> BY '\t' LINES 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
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
when I attempt to LOAD DATA INFILE the tab delimited field ascii file.
=
Field
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 goi
- 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
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.
>
> ERR
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 net
ip VARCHAR(10) NULL,
hp> phone VARCHAR(20) NULL,
hp> 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_me
mber.sql
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
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
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 N
Hi all:
I'm trying to import the tables from the dump file
via
mysqldump 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 '',
Db char(64) NOT NULL default '',
User char(16) NOT NULL default '',
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]'
&
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;
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
>
> Ho
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.
ql
after entering the previous lines fine, I get the following error:
./mysql -uroot -e"insert 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(Ho
73 matches
Mail list logo
