On 1/5/2011 13:31, James Dekker wrote:
Because some sequence tables contain one to many cardinality and MySQL tables
can only have one auto_increment column...
Is there a way to do what I am trying to do (obtain max sequence id, set it to
its corresponding table, and then increment by one) in
Because some sequence tables contain one to many cardinality and MySQL tables
can only have one auto_increment column...
Is there a way to do what I am trying to do (obtain max sequence id, set it to
its corresponding table, and then increment by one) in a stored function?
Happy programming,
J
On 1/4/2011 23:23, James Dekker wrote:
Peter,
Thanks for the response!
Unfortunately, that worked but a new error arose:
check the manual that corresponds to your MySQL server version for the right
syntax to use near 'ID = (select max(CONVERT(id_field, signed)) from
my_table_t)' at line 1
I
Hey,
happy new year and I do have a question what might be the best way to
migrate some different databases to a new central server.
The question came up as I wanted to put our web CMS database on our
newer master/slave mysql installation.
We run red hat el 4 and 5 right now, so the source db is
http://dev.mysql.com/doc/refman/5.1/en/events.html
On 01/05/2011 12:21 PM, Machiel Richards wrote:
HI
How do I use the mysql event scheduler?
I have not used this as yet so not sure how to use it.
Regards
Machiel
-Original Message-
*From*: petya mailto:petya%20%3cpe...@petya.org.hu%
HI
How do I use the mysql event scheduler?
I have not used this as yet so not sure how to use it.
Regards
Machiel
-Original Message-
From: petya
To: Machiel Richards , mysql@lists.mysql.com
Subject: Re: Stored procedure
Date: Wed, 05 Jan 2011 12:15:59 +0100
Hi,
Use the
Hi,
Use the mysql event scheduler instead of cron, the bash script is quite
pointless, and call your stored procedure with now() - interval 1 day
parameter.
Peter
On 01/05/2011 11:00 AM, Machiel Richards wrote:
Good day all
I am hoping that someone can assist me here.
Good day all
I am hoping that someone can assist me here.
As per a client requirement, I am writing a
script/stored procedure combination in order to do the following:
- Script to be run within a cron once a day
according to a set schedule.
Usually this is caused by DNS-based authentication, where the
reverse-DNS lookups are hanging for one reason or another.
If you can, switch to IP-based authentication and use --skip-name-resolve.
/ Carsten
On 05.01.2011 08:26, Yogesh Kore wrote:
Hi,
What is unauthenticated user seen in mysql
