sql to duplicate records with modified value

I have Postfix virtual mailboxes in MySQL table like below: I'd like to duplicate all records whilst MODIFYING two fields like so: current record has format like: user 'usern...@domain.tld' maildir 'domain.tld/usern...@domain.tld/' add new record that has: user 'username+s...@domain.tld' maildir

Freespace threshold be having to OPTIMIZE TABLE?

Hiya My query below, looks for tables with 10% freespace but also the space is greater than 100K. mysql> SHOW TABLE STATUS WHERE Data_free / Data_length > 0.1 AND Data_free > 102400 \G; *** 1. row *** Name: bayes_words Engin

[joke] SQL Injection License Plate Hopes to Foil Euro Traffic Cameras

http://gizmodo.com/5498412/sql-injection-license-plate-hopes-to-foil-euro-t raffic-cameras -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: High-level transaction isolation architecture of InnoDB

Hi Yang, On Mar 26, 2010, at 4:28 PM, Yang Zhang wrote: I've noticed that Innodb seems to exhibit true serializability for the serializable transaction isolation level. Does this mean it implements predicate locking? Kinda, but not exactly. In serializable, all reads will use shared locks

High-level transaction isolation architecture of InnoDB

I've noticed that Innodb seems to exhibit true serializability for the serializable transaction isolation level. Does this mean it implements predicate locking? Also out of curiosity, is it possible to set a snapshot isolation transaction isolation level (is Innodb implemented using MVCC)? Thanks i

Re: Birthday Calendar

Apparently not. Noel Butler wrote: does this list not have a dickhead filter? On Tue, 2010-03-23 at 15:17 +, Ganeswar Mishra wrote: Hi Please click on the link below and enter your birthday for me. I am creating a birthday calendar for myself. Don't worry, it'll take less than

Re: MySQL Slave is almost 1 day behind

Also, run "SHOW PROCESSLIST", to see what sql's are running on slave. This will give u any idea if any huge dml was run on master and its getting sync'd with slave. regards anandkl On Fri, Mar 26, 2010 at 8:25 PM, Jim Lyons wrote: > A few things to keep in mind: > > 1: the master may have seve

Re: MySQL Slave is almost 1 day behind

A few things to keep in mind: 1: the master may have several threads feeding into the binlog at a time, but a slave only executes in a single thread. Are you throwing more stuff at the slave in multiple mysql threads? 2: is there something else going on with the slave box? some big backup or gz

MySQL Slave is almost 1 day behind

Good day :) We've had our master/slave server running for a while now, and just yesterday, we started getting behind. Not entirely sure what happened, but it is getting further and furhter behind. (master server) mysql> show master status\G *** 1. row *

Re: Populating dataset

how would I know to automatically insert a missing date A common problem. Build a calendar table (http://www.artfulsoftware.com/infotree/queries.php?#95) PB - Tompkins Neil wrote: Hi, We have a table which contains the following sample of information 2010-03-20 2010-03-21 2010-03-22

mysql_free_result vs. mysqli_free_result

http://php.net/manual/en/function.mysql-free-result.php says memory is automatically freed at the end of script execution but http://kr.php.net/manual/en/mysqli-result.free.php says you should always call mysqli_free_result and does not mention automatic free. Is there any plan to support aut

Re: Populating dataset

Hi, We have a table which contains the following sample of information 2010-03-20 2010-03-21 2010-03-22 2010-03-23 2010-03-26 2010-03-27 2010-03-28 2010-03-30 As you can see, the dates listed are not constant e.g missing 2010-03-29 as a example. For our query like SELECT check_in_date FROM b