mysql list,
after my upgrade to 5.1.36 I hit this odd little problem:
I have an application which does roughly this:
CREATE TEMP TABLE new LIKE old;
populate 'new'.
do some stuff
TRUNCATE new;
populate again
This has always worked fine, but after the upgrade it failed because the
user does not
mysql list,
this weekend I upgraded my 5.0.51 installation to 5.1.36, which seems to
have gone without a hitch - except the following weird messages:
> Failed to ALTER DATABASE `#mysql50#.protected` UPGRADE DATA DIRECTORY
> NAME
> Error: Table 'mysql.event' doesn't exist
> Failed to ALTER DATABAS
Please check out http://q4m.31tools.com/*. *It is a message queue storage
engine with sql interface. Havent used it in a production setup though we
did some tests.
--
Thanks
Alex
http://alexlurthu.wordpress.com
On Mon, Sep 7, 2009 at 8:18 PM, Allen Fowler wrote:
> Note: In this scheme the worker winds up with all "new" records generated
> since the last worker claimed any. Not sure how else to guarantee atomicity.
> I would prefer "only n records per request". Ideas?
SELECT...FOR UPDATE followed by one
On Mon, Sep 7, 2009 at 8:18 PM, Allen Fowler wrote:
> Hello,
>
> I need to create a system where records are generated by a "producer" process
> and processed by several "worker" processes.
>
> I was thinking about something like:
>
> Producer:
> 1) Producer INSERTs new records with "state" = "new
Hello,
I need to create a system where records are generated by a "producer" process
and processed by several "worker" processes.
I was thinking about something like:
Producer:
1) Producer INSERTs new records with "state" = "new" & "worker" = "null"
2) Producer sleeps and loops back to step #1
Add the option 'safe-updates' to the mysql section of your 'my.cnf' / 'my.ini'
file and restart the mysqld service.
[mysql]
Safe-updates
Regards
John Daisley
Mobile +44(0)7812 451238
Email j...@butterflysystems.co.uk
Certified MySQL 5 Database Administrator (CMDBA)
Certified MySQL 5 Developer
Hi all,
I vaguely recall finding mention a MySQL command or start-up option that
blocked any update or delete query that didn't have a WHERE component,
to prevent statements accidentally affecting too many rows (like those
of a certain absent-minded web developer who might work for the same
compan
Hi Mike,
Thanks for you help!
Best,
Jia
mos wrote:
Jia,
The code you sent seems to be able to get the job done.
You could try something simpler by executing 2 sql statements instead
of using one. Something like:
create table rmpdata1
select ri.*, mv.* from RItime as ri left join MVti
>-Ursprüngliche Nachricht-
>Von: AndrewJames [mailto:andrewhu...@gmail.com]
>Gesendet: Montag, 7. September 2009 13:37
>An: Skoric, Majk
>Betreff: Re: AW: mysql_real_escape_string()
Dont forget to put the list in!
>hmmm, my mysql_real... function call is below my db connection, so there
>-Ursprüngliche Nachricht-
>Von: AndrewJames [mailto:andrewhu...@gmail.com]
>Gesendet: Montag, 7. September 2009 11:39
>An: mysql@lists.mysql.com
>Betreff: mysql_real_escape_string()
>
>Hey guys,
>
>whenever i try to perform this function on my $variables before using them
>in sql queries
Hey guys,
whenever i try to perform this function on my $variables before using them
in sql queries it deletes them and returns my variable as nothing, ''.
this is how i am using it.
my login.php form
$username = check_input($_POST['username']);
$password = check_input($_POST['password']);
m
Hi All,
Thanks a lot for all your help.
I was able to do it using "sed" os command.
I spooled the data from db into a file and used the sed command on it.
thanks once again.
regards
anandkl
On Fri, Aug 21, 2009 at 9:07 PM, Johnny Withers wrote:
> Yeah.. I think i misunderstood what he is trying
13 matches
Mail list logo
