Re: UPDATE and INSERT in one

conditional update/insert? Take a look at REPLACE: http://dev.mysql.com/doc/refman/5.0/en/replace.html -- David Precious http://blog.preshweb.co.uk/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Help please: SELECT in binlog?

e binlog which does. Cheers Dave P -- David Precious http://blog.preshweb.co.uk/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: How to present query time through perl

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Thursday 04 March 2004 08:58, Jonas Lindén wrote: > Hello list, I am trying to find a way to retrive the time a certain > select statement took for debug purposes. If I execute a select > statement in the mysql console I get the time that select sta

Re: Subtracting date fields

LECT ID, (TO_DAYS(firstdate) - TO_DAYS(postdate)) AS diff FROM calendar Cheers David P - -- David Precious [EMAIL PROTECTED] http://www.preshweb.co.uk Early to rise and early to bed makes a man healthy and socially dead All emails PGP signed - PGP key at: http://www.preshweb.co.uk

Re: insert into x select * from x doesn't work

Hi > In mysql 4.1 (and since mysql 4.0.14 or something like that) I > believe it's documented that an insert into X select * from X should > work. IIRC, the table you're INSERTing into cannot be the same table you SELECT from - you're trying to take records from the table 'foo' and insert the

Re: the logic of full text search

. It is with this reasoning that such rows have been assigned a low semantic value in this particular dataset. -- end quote -- Hope that helps! David P -- David Precious http://www.preshweb.co.uk/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To uns

Re: the logic of full text search

g a fulltext search on? IME it tends to work better with plenty of rows to work with. HTH! David P -- David Precious http://www.preshweb.co.uk/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: PhpMyadmin

u really should try a little harder to find the answer yourself first before posting to a list about it. HTH David P -- David Precious http://www.preshweb.co.uk/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL error code 1064

t > statement works ok directly on the MySQL server. It would appear that the application is generating the INSERT statement incorrectly. HTH! David Precious http://www.preshweb.co.uk/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL 3.23.51 Reference Manual needed

> I am looking for the Reference Manual for MySQL 3.23.51 (or the latest of > the prior ones). Can anyone help me? You should find the manuals etc at: http://www.mysql.com/documentation/index.html HTH! David P -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql T

Re: varchar restriction

Andrew, > ok ok I get it what you are saying if I change a tables attributes from > varchar on one table it wont chnage another tables varchars attributes AND > WHY THE F**K WOULD I EXPECT IT TO!, > > what I am asking is it necessary to make chnages to the other table. The answer to your questio

Re: mysqldump suddenly returns error 1064 [sorted]

for your help Victoria, you've saved me from tearing out a considerable amount of hair! Cheers David P -- David Precious [EMAIL PROTECTED] http://www.preshweb.co.uk A mind is a terrible thing to ... er ... h Now playing: Oasis - Whatever (Live, Knebworth) -- MySQL General Mai

mysqldump suddenly returns error 1064

ne 1 when using LOCK TABLES Just for info: MySQL v3.23.51 on Slackware Linux 9.0 (on a high-performance dual-Xeon server). Anyone got any ideas what could be causing this to happen? Many thanks David P -- David Precious [EMAIL PROTECTED] http://www.preshweb.co.uk A clear conscience is us