st set on MySQL 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
nd storing
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
one.
Any suggestion?
Thanks,
Luca
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
logs).
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]
sequence (similar to auto_increment). 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: ht
eed to insert a record before in such table to get the new id
and then insert 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]
port more than 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]
on *.*.
My 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 greatf
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) va
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 se
yments 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
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
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
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 PRO
ow I obtain the following error in /var/apache/error.log
DBI->connect(database=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
--
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, 20
3.28), but maybe
I'm just dumb? And of course the deadline is looming, etc.
What can I do? Please note that I will gladly accept a workaround, but
everything must be done inside a single MySQL query. (Which will later get
processed by a big, nasty PHP program which will do unwholesome things on
> 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
>
> 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
>
> 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:
htt
> 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,
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
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 and
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:
m
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
--
25 matches
Mail list logo
