Hi,
I have a query which works fine for me in my 4.1 environment, but when
moved to the 5.0.18 environment, it fails with the result below:
mysql SELECT r.uid, u.username, u.image_type, count(id) AS antal,
s.timestamp FROM recruits_uid r, users u, users u2 LEFT JOIN sessions s
ON
Ariel,
You can try this:
mysqlselect stri from prueba order by stri+0 desc;
Leo Huang
2006/2/17, Ariel Sánchez Mora [EMAIL PROTECTED]:
mysql describe prueba;
+---+-+--+-+-+---+
| Field | Type| Null | Key | Default | Extra |
leo huang wrote:
Ariel,
You can try this:
mysqlselect stri from prueba order by stri+0 desc;
Leo Huang
Or just make the column an INT instead of a CHAR, if you want a natural
number order. Sorting is performed differently between characters and
integers - as is obviously shown in the
2006/2/20, Eric Persson [EMAIL PROTECTED]:
Hi,
I have a query which works fine for me in my 4.1 environment, but when
moved to the 5.0.18 environment, it fails with the result below:
mysql SELECT r.uid, u.username, u.image_type, count(id) AS antal,
s.timestamp FROM recruits_uid r, users u,
Hi
i ahve one table table_1 and columns like col_1,col_2,col_3
col_1 col_2 col_3
1 aa aaa
2 bb
Now i want to update my table table_1 SET col_3 as bbb where max of col_1
I wrote this below Query but it shows error how to write
UPDATE table_1
SET col_3 = 'bbb'
On Monday 20 February 2006 03:27, Veerabhadrarao Narra wrote:
Hi
i ahve one table table_1 and columns like col_1,col_2,col_3
col_1 col_2 col_3
1 aa aaa
2 bb
Now i want to update my table table_1 SET col_3 as bbb where max of col_1
I wrote this below
I wrote this below Query but it shows error how to write
UPDATE table_1
SET col_3 = 'bbb'
WHERE col_1 = (SELECT max(col_1) FROM table_1)
See the docs for Update at
http://dev.mysql.com/doc/refman/5.0/en/update.html. You cannot refer to
the update table in a subquery.
PB
-
Well, it says the host.frm file has the wrong information.
Have you tried mysql_fix_permissions? Or starting the server with
--skip-grant-tables? It's possible the table itself is corrupt.
You could also try backing up the data you have and running
mysql_install_db to re-create the hosts file.
mysqldump takes a table or database and dumps it -- current schema,
current data. You won't get alter tables.
What you want is something that will show all the alter statements.
You can run something like this on unix:
tail -f binlog* | grep ALTER alter.sql
and then the alter.sql text file
Why not also put a wildcard for 192.168.% ? That's what we've done.
-Sheeri
On 2/17/06, Ryan Stille [EMAIL PROTECTED] wrote:
did u start mysql with --skip-name-resolve ???
Kishore Jalleda
Kim Christensen wrote:
On 2/16/06, Ryan Stille [EMAIL PROTECTED] wrote:
Nope.
Well, have you
Drop the keys and references, change it, and then re-create the keys
and references.
http://dev.mysql.com/doc/refman/5.0/en/innodb-foreign-key-constraints.html
(a SHOW CREATE TABLE will show you the constraints including foreign
keys -- copy those, so you can create them later. Then you can use
Perhaps you were using CAST() incorrectly? What was your attempt?
my test table:
show create table ultimas_repuestas;
+---+-+
| Table | Create Table
That's odd. My mysql.sock is chmod 777, which happened automatically.
Check the startup script. Is it calling mysqld_safe? Are you using
the regular startup script that came with mysql, or have you mucked
with it?
Make sure when you chmod that the file is still a socket. Shouldn't
be a
Concurrent inserts (there also may be concurrent reads going on) are
intermittently causing:
java.sql.SQLException: Lock wait timeout exceeded; try
restarting transaction
I noticed that adding innodb_table_locks=0 in my.ini fixes the problem.
Looking through the manual however, this
I also had problems converting latin1 to utf-8. For whatever reason,
accents and stuff did not convert.
The solution was not to convert to utf-8. If you create your tables
with the character set of latin1, you should be fine (that's what we
did).
After all, you are already upgrading -- why
Hi Sheeri, you are correct in both the MySQL tips and in your suggestion that I
should include my test when I think something doesn't work ;) Thanks a lot!
I realize now that when I've sent a thank you note, I have only sent it to the
responder instead of all the list; my problem was sorted
Sheeri,
Thanks very much for the reply. However, that is not what I'm looking for. I
don't want the
tables that *have been* altered. I want CREATE TABLE statements output in the
ALTER TABLE
format for re-creation on another system (clean or otherwise).
Regards,
Michael
-- Original
Thank you for your reply, but I'm afraid it doesn't help :(
The new setup we are moving to is utf-8 only (Apache, mysql). Making some of
the data latin1 and some of it utf-8 will complicate things, we want to move
away from different character encodings, which is why we are using unicode in
Robert,
please post SHOW INNODB STATUS\G during such lock wait, so that we see what
lock it is waiting for.
Best regards,
Heikki
Oracle Corp./Innobase Oy
InnoDB - transactions, row level locking, and foreign keys for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs
Ok, I will do that during my next test run. But in the meantime, when I
did it previously, it was oddly enough waiting for a table lock on the
table that I was inserting into.
R.
-Original Message-
From: Heikki Tuuri [mailto:[EMAIL PROTECTED]
Sent: Monday, February 20, 2006 1:18 PM
To:
Robert,
maybe it was waiting on the AUTO-INC lock of the table? InnoDB must lock the
auto-inc counter, otherwise the MySQL replication would not work. That is a
limitation imposed by the MySQL architecture, not by InnoDB. InnoDB itself
never needs table locks.
Best regards,
Heikki
Oracle
On 19/02/2006 10:57 p.m., Kevin Burton wrote:
I was talking to a friend tonight about how they use NBD to run a single
system image in memory.
NBD (Network Block Device) allows one Linux box to export a block device
and for you to mount it on another filesystem. For the memory
component
I just upgraded from 3.23 to 5.0. There server seems to be working just
fine with all of my PHP and perl scripts. However, the mysql client is
giving me problems. It starts up okay and I can do everything, but when
I do an up arrow on the keyboard to get previous commands the second up
arrow
I try to create a cron in Linux (Debian Sarge) and the content for this cron is
a mysql database backup. I read documentation about mysqldump command and use,
but I forgot something because it not works for me. I put this in bash:
# mysqldump --opt -c -C dp /var/tmp_save/dproject.sql
But when I
I've got some import scripts that are giving me trouble.
Some MOFOs keep changing the format of the data they give us, and
sometimes I loose half the records. When this happens, I change the line
terminator from \r\n to \n ... or from \n to \r\n.
It's starting to get to me. Is there any
Roberts
How many concurreent inserts you've done?
What MySQL version you use?
Concurrent inserts (there also may be concurrent reads going on) are
intermittently causing:
java.sql.SQLException: Lock wait timeout exceeded; try
restarting transaction
I noticed that adding
I'm doing about 200,000 inserts, collecting them into batches of 500,
and queuing them into a thread pool with 6 threads.
R.
-Original Message-
From: Ady Wicaksono [mailto:[EMAIL PROTECTED]
Sent: Monday, February 20, 2006 8:36 PM
To: Robert DiFalco
Cc: mysql@lists.mysql.com
Subject:
Make sure you don't have dynamic-width rows. Use char instead of varchar.
On 2/17/06, Eamon Daly [EMAIL PROTECTED] wrote:
Hi, all. I have a machine with lots of memory, and I'm
trying to avoid the disk entirely for some of our larger
reports. I was under the impression that CREATE TEMPORARY
See
http://bugs.mysql.com/bug.php?id=15868
Make sure you don't hit this bug too :)
I'm doing about 200,000 inserts, collecting them into batches of 500,
and queuing them into a thread pool with 6 threads.
R.
-Original Message-
From: Ady Wicaksono [mailto:[EMAIL PROTECTED]
Sent:
29 matches
Mail list logo