; -- without ticks
ERROR 1064: You have an error in your SQL syntax near '94' at line 1
mysql select * from `94`; -- with ticks
that works. however, how do I make it so mysqldump can build the
create statement correctly for these tables?
Augey Mikus
I seem to have answered my own question :-)
The answer is that you have to use -Q or --quote-names in mysqldump
Cheers!
Augey Mikus
Augey Mikus wrote:
I am attempting to migrate a MySQL driven web application that, in my
opinion, was designed by a stupid monkey. The php web frontend
that there should be a way to set a limit. I didnt see one.
Augey
Dicky Wahyu Purnomo wrote:
On Tue, 14 May 2002 18:49:48 -0400
Augey Mikus [EMAIL PROTECTED] wrote:
what are the host-bin.001 002 003 etc.. files in the mysql_dir/var
directory? On my system they range in size from bytes to gigs
what are the host-bin.001 002 003 etc.. files in the mysql_dir/var
directory? On my system they range in size from bytes to gigs. What
are they and can they be cleaned?
Augey
-
Before posting, please check:
what is the simplest way to delete duplicate occurences of a specific
field in mysql?
thanks,
augey
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the
what i meant is deleting duplicate occurences of records of a certain
field. ...sorry...
Paul DuBois wrote:
At 17:16 -0400 5/10/02, Augey Mikus wrote:
what is the simplest way to delete duplicate occurences of a specific
field in mysql?
thanks,
augey
Your question is a bit
when running
select count(distinct value) from table;
on a table with more than 19 million records i got the error:
got error 27 from table handler (or something like that)
i looked up the error in mysql perror which gave me file too large
does this have to do with my file size in linux or a
is there a way for me to do it in a mysql delete statement? just out of
curiosity, for instance, if i wanted to add duplicates later for
whatever reason.
Paul DuBois wrote:
At 17:54 -0400 5/10/02, Augey Mikus wrote:
what i meant is deleting duplicate occurences of records of a certain
thanks :-)
Paul DuBois wrote:
At 18:00 -0400 5/10/02, Augey Mikus wrote:
is there a way for me to do it in a mysql delete statement? just out
of curiosity, for instance, if i wanted to add duplicates later for
whatever reason.
Okay, let's suppose you have 3947 instances of abc
so i suppose an automatic delete of every duplicate record is out of the
question :-)
Paul DuBois wrote:
At 18:00 -0400 5/10/02, Augey Mikus wrote:
is there a way for me to do it in a mysql delete statement? just out
of curiosity, for instance, if i wanted to add duplicates later
I suppose the i could always remove the unique constraint once the alter
statement has removed the duplicates.
ok
Paul DuBois wrote:
At 18:13 -0400 5/10/02, Augey Mikus wrote:
so i suppose an automatic delete of every duplicate record is out of
the question :-)
Sounds like you're
I have checked my file size in my data dir and can't find any files
close to 2GB even looking in subdirs.
Does this mean that my problem is most likely corruption or could it
still be file too large.
Augey
Augey Mikus wrote:
when running
select count(distinct value) from table
I have two tables. One table, which (to protect the innocent :-)) we'll
call MainTable, has a list of names with user info like address, etc..
and an auto-incrementing unique id for each. The other, which we'll
call MapTable, is simply a key mapping table with ids from MainTable
that just
Augey Mikus wrote:
I have two tables. One table, which (to protect the innocent :-))
we'll call MainTable, has a list of names with user info like address,
etc.. and an auto-incrementing unique id for each. The other, which
we'll call MapTable, is simply a key mapping table with ids
14 matches
Mail list logo