Sorry for the bad end of lines in the first message!
I am trying to set up MySQL on a GNU/Linux box with this script:cd
/home/qsys
gzip -cd /home/qsys/mysql-5.1.32.tar.gz | tar xf -
mv /home/qsys/mysql-5.1.32 /home/qsys/mysql-5.1.32.source
cd /home/qsys/mysql-5.1.32.source
./configure --pref
I am trying to set up MySQL on a GNU/Linux box with this script:cd /home/qsys
gzip -cd /home/qsys/mysql-5.1.32.tar.gz | tar xf -
mv /home/qsys/mysql-5.1.32 /home/qsys/mysql-5.1.32.source
cd /home/qsys/mysql-5.1.32.source
./configure --prefix=/home/qsys/mysql-5.1.32 \
--with-unix-socket
Hi,
I run a Perl program on a test run of about 4 hours and my database
connection expired/broke down.
Here is the error I got :
DBI connect('project','root',...) failed: Can't connect to local MySQL
server through socket '/var/lib/mysql/mysql.sock' (2) at
/usr/local/lib/perl5/site_perl/5.10
Well, I think an update after insert is the only way. Other than
perpopulating another table with possibe crc values then usinga join:
Select id from testtable
Inner join crctable on testtable.id=crctable.id
Where crctable.crcval='xxx'
Just be sure to index the crcval column.
On Sunday, Ma
Hello Mauricio,
Mauricio Tellez wrote:
Hi, I'm trying to debug a stored procedure. This SP has a few queries and
also call another SP. I'm starting mysql with the --log=my_queries.log but I
found that mysql only log the "call my_sp(param1, param2)" but don't log any
query inside my_sp neither lo
At 09:40 AM 4/30/2009, you wrote:
I see MySQL 5.4 is
out. http://www.mysql.com/news-and-events/generate-article.php?id=1602
Sun claims there are speed improvements for Innodb and ClusterDb
tables, but is there any reason to upgrade if I'm only using MyISAM tables?
Also I didn't see a Windows
Andy Shellam wrote:
My thoughts exactly!
This article might help:
http://dev.mysql.com/tech-resources/articles/mysql-54.html
It worries me though that 5.1 went through a large number of alpha
releases, then a set of beta releases before the GA release came out.
It looks like they've thrown
I'm so sorry for the mistake...
I mean:
I think it is to slow when I make a SELECT later in this form:
I don't think its possible to do what you want in a single statement. Since
LAST_INSERT_ID() is set to the last insert id of the connection... and the
row you are inserting doesn't exist.. wel
Hi Johnny,
I need the CRC32 for a unique URL-ID...
I think it isn't to slow when I make a SELECT later in this form:
Rows in Table: 825,984
Search for id: 2532552 (CRC32: 46316330)
SELECT id FROM `testtable` WHERE id = "2532552"
0.0005 sec.
SELECT id FROM `testtable` WHERE CRC32(id) = "46316
Dominik Klein wrote:
Hi.
I have a question regarding mysql replication and mysqldump.
I have a master (A). All my clients insert/update/delete only to this
master. Then I have a Slave (B). This slave only replicates the master.
There are no other processes changing/inserting data into the Slave
I don't think its possible to do what you want in a single statement. Since
LAST_INSERT_ID() is set to the last insert id of the connection... and the
row you are inserting doesn't exist.. well.. until you create it, it will
always either be zero or the record BEFORE your next insert, ie:
INSERT I
Hello,
I have a questions and I hope, that is possible in MySQL.
I have the following short Table.
CREATE TABLE IF NOT EXISTS `testtable` (
`id` bigint(20) unsigned NOT NULL auto_increment,
`id-crc` bigint(20) unsigned NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id-crc` (`id-crc`)
) ENGIN
12 matches
Mail list logo
