suggestion for disk configuration

2008-01-24 Thread Luca Ferrari
). Any suggestion or link? Thanks, Luca -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

encrypt - password

2008-01-20 Thread Luca Ferrari
? Thanks, Luca -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

pam and crypt using mysql

2007-11-06 Thread Luca Ferrari
password thru the encrypt function. Anyone that can provide me a reason why I'm not able to use the password function? Does it depends on some module I'm missing (with regard to mysql) or to a misconfigured linux server? Thanks, Luca -- MySQL General Mailing List For list archives: http

Re: Migration from Oracle to MySQL

2007-07-27 Thread Luca Ferrari
only jdbc-4 driver (of course the 4 is the best). Luca -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

sequences and auto_increment

2007-01-02 Thread Luca Ferrari
). In MySQL there're no sequences, or better, there's only an auto_increment action on an int field. How can I obtain the same effect of the concatenation of a sequence and a string? Thanks, Luca -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: sequences and auto_increment

2007-01-02 Thread Luca Ferrari
in my competenza table. This would require a transaction and will result even more complex than the above, I guess. Any other idea? Thanks, Luca -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: deadlocks on concurrent INSERTS

2006-12-06 Thread Ben de Luca
What does a `show innodb status show`? On 07/12/2006, at 2:44 AM, James Neff wrote: Greetings, I've got 6 Java client applications (running on 6 different PC's, including one of them on the database server) reading data from a flat file and inserting data into a table on my database:

Re: triggers? when they execute and locking

2005-12-05 Thread Ben De Luca
to diagnose this weird behavior? Ben De Luca wrote: Im am trying to implement a task running system with mysql and Im coming across a few problems with what I am trying to do. Simply I am trying to insert a list of tasks into the DB for various computers to run, I want to track when they ran

triggers? when they execute and locking

2005-12-04 Thread Ben De Luca
Im am trying to implement a task running system with mysql and Im coming across a few problems with what I am trying to do. Simply I am trying to insert a list of tasks into the DB for various computers to run, I want to track when they ran and where they ran. I also have to limit some of

Security Flaw

2005-03-11 Thread Luca Ercoli
question is this: is possible that an user own at least one of those privileges on *.* (for example GRANT CREATE TEMPORARY TABLES ON *.* TO 'test'@'%';): - REFERENCES - CREATE TEMPORARY TABLES - GRANT OPTION - CREATE - SELECT would be greatfull to get some help, Luca Ercoli -- MySQL General Mailing

MySQL 4.0.13 and JDBC

2003-06-18 Thread Luca
server? Or there's a new JDBC for version 4.x? Thanks Luca -- Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/ _ Naviga www.numeroverdeweb.it -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

SQL question - no CREATE VIEW in mysql

2003-02-24 Thread Luca Pizzinato
Hi People. SQL problem: given a table where each column is a number, let's say that I wish to create a second table where columns are the sum of specific columns of the first, i.e.: col_1 + col_2 + col_3 + col_4 col_1 of second table col_5 + col_6 + col_7 + col_8 col_2 of

is it a bug?

2003-01-04 Thread Luca Burlizzi
hello, I have a problem in mysql 4.0.7 this piece of code worked until version 4.0.4 SELECT @ID:=''; SELECT @ID:=CONCAT(@ID,',',MAX(ID)) FROM WF_Users GROUP BY GUID; SELECT @ID; the result was: ,1,2,.,n. but today doesn't works anymore now the result is .n where n is the last max(id) value

Help, upgrade problems!

2002-07-31 Thread Luca Bonci
=dbname;host.domain.it:) failed: Can't connect to MySQL server on 'host.domain.it' (111) at /usr/lib/cgi-bin/querydb.cgi line 89 Thanks in advance for any help! Luca - Before posting, please check: http://www.mysql.com

One slow connection make mysql slow

2002-05-07 Thread Luca Vertua
time but sending results to me may take 30 seconds. The problem is that mysql locks the table up to the end of the data sending process so other local client can't work. Is this a bug? Are there a logical explanation? Thanks for your help Luca mysql, sql

Re: One slow connection make mysql slow

2002-05-07 Thread Luca Vertua
Ok, I'm agree with you, someone know how to avoid this? Why mysql does not retrive data in the buffer before send them on network? My query is about 400 Kbyte. Luca - Original Message - From: Gelu [EMAIL PROTECTED] To: Luca Vertua [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, May

One slow connection make mysql slow

2002-05-06 Thread Luca Vertua
time but sending results to me may take 30 seconds. The problem is that mysql locks the table up to the end of the data sending process so other local client can't work. Is this a bug? Are there a logical explanation? Thanks for your help Luca

Mysql and Sun reference implementation J2EE

2002-03-08 Thread Luca Dozio Tiscali
Hi, I'm trying Mysql with various Java application Server. I've started with Sun Refernce implementation. What are the params to set in resourse config file? and what type of jdbc drivers can i use? Thank. Luca - Before

Strange problem

2002-02-05 Thread Luca Biffi
LEFT JOIN t_payment_lang ON t_payments.pay_key = t_payment_lang.pyl_pay_id WHERE t_payment_lang.pyl_lang_id = 1 AND t_payments.pay_enabled 0; or if I drop the column pay_fixed_comm column from table t_payments. I don't understand why ! Thanks for any advice. Luca

Re: Encode function

2001-10-29 Thread Luca Vertua
Luca Vertua [EMAIL PROTECTED] 8volante srl soluzioni_internet Via Cernaia 7 25034 - Orzinuovi - Bs Tel.: 030/9444003 Fax: 02/700430453 www.8volante.com - Original Message - From: [EMAIL PROTECTED] To: Luca Vertua [EMAIL PROTECTED] Sent: Monday, October 29, 2001 6:06 PM Subject: Re

Help! MySQL variables laugh at me

2001-06-04 Thread Luca Accomazzi
by a big, nasty PHP program which will do unwholesome things on it and which I can not touch). Thanks in advance. Luca Accomazzi - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

FW: Help! MySQL variables laugh at me

2001-06-04 Thread Luca Accomazzi
I have only had a quick look over this and already have a question for the simple example you've provided. How are you determining the last value entered before entering the new value? The only way I see you of effectively accomplishing this is through the use of a datetime column. Or am

Re: Help! MySQL variables laugh at me

2001-06-04 Thread Luca Accomazzi
I have only had a quick look over this and already have a question for the simple example you've provided. How are you determining the last value entered before entering the new value? The only way I see you of effectively accomplishing this is through the use of a datetime column. Or am

Re: emergency help

2001-06-04 Thread Luca Accomazzi
Last Saturday when I rebooted Red Hat Linux, mysql database server didn't come back any more. Try typing this on the command line: safe_mysqld Then tell us what happens. :-) L.A. - Before posting, please check:

Re: emergency help

2001-06-04 Thread Luca Accomazzi
I got the message: [root@mothra /tmp]# safe_mysqld [1] 3922 [root@mothra /tmp]# Starting mysqld daemon with databases from /usr/local/var mysqld daemon ended Are your databases in there? If you do a ll /usr/local/var Do you see a directory for each database of yours, with the