Re: alternate in mysql

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 joh...@pixelated.netwrote: Yeah.. I think i misunderstood

mysql_real_escape_string()

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']);

AW: mysql_real_escape_string()

-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 it

AW: AW: mysql_real_escape_string()

-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

Re: How to optimize a slow query?

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

Prevent execution of queries without a WHERE clause

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

RE: Prevent execution of queries without a WHERE clause

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

Queue / FIFO in MySQL?

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 Worker(s):

Re: Queue / FIFO in MySQL?

On Mon, Sep 7, 2009 at 8:18 PM, Allen Fowlerallen.fow...@yahoo.com 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

Re: Queue / FIFO in MySQL?

On Mon, Sep 7, 2009 at 8:18 PM, Allen Fowlerallen.fow...@yahoo.com 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

Re: Queue / FIFO in MySQL?

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