You could start a transaction before running your queries and then rollback after running them. Note that to do this you'll require InnoDB or XtraDb tables (won't work on MyISAM).

0 792 posted 11 years ago by satie83

MySQL Pivot table Schedule

You have a schedule table (period, day, subject, room) with a primary key period,day to avoid duplicate bookings. You wish to display the schedule as periods, subjects and rooms in rows, and days of the week in columns.

mysql
table

0 662 posted 11 years ago by cahyadsn

MySQL Age in Years for Given Birthdate

Given a birthdate in @dob, here are two simple formulae for age in years : (the second formulae is for age in years to two decimal places, ignoring day of month)

mysql

0 510 posted 11 years ago by cahyadsn

MySQL MySQL Select duplicates

Instead of the standard return of duplicates, this will actually show the rows that are duplicated, making it easier to see the data

mysql

0 556 posted 11 years ago by TheNullByte

MySQL mysql create modify default timestamp

add created datetime and modified timestamp columns to table

mysql

0 487 posted 11 years ago by navblue

MySQL Copy an SQL Table

Create a new table from the details of another table then insert the table contents

copy
mysql

0 557 posted 11 years ago by imbraz

MySQL Users Sharing between multiple Joomla 2.5.x sites

xxxx1... are tables from master site xxxx2... are tables from client site

joomla
mysql

0 517 posted 12 years ago by A973C

MySQL Replace a text in SQL Server Table Column

If you have a Table which has a Column of type char or varchar or even text, and you want to change a portion of text in it for example a path. In this case you need to change the same text with new one in every records.

replace
text

0 799 posted 12 years ago by klovera

MySQL UPDATE table using JOINS

Update an empty name column in default_comments

mysql

0 477 posted 12 years ago by jgomez

MySQL Find and Replace MySQL column with substring

Example: There is a table, 'user', with a column, 'clear', containing values such as: `clear -------- \'animal\' \'pass'\ ` and we would like to retrieve 'animal' and 'pass' ( without the pre & post \' )

mysql

0 781 posted 12 years ago by jgomez

MySQL Wordpress Display Recent Authors of Posts

Select wp_users and wp_posts to retrieve data from both tables in order to display post title, post date, author name with gravatar (gravatar isn't listed in this code) Note: probably not idea solution, but it's one of many fixes

0 658 posted 12 years ago by ninacess

MySQL Languages table

Most popular languages on the web table (in order of popularity). Handy for auto complete fields and such.

mysql
table

0 1197 posted 12 years ago by Synnoid

MySQL Convert textual dates of the form '[d]d-[m]m-yyyy' to actual dates

Converts textual dates like '1-3-1954' and '01-02-1963' to respectively '1954-3-1' and '1963-02-01'. MySQL is smart enough to understand the values without leading zeros when inserting into a DATE field.

date

0 606 posted 12 years ago by jpkunst

MySQL MYSQL search and replace

mysql

0 666 posted 12 years ago by irishsk

MySQL MySQL Data Pull to Localhost

<h1>What it does</h1> <p>This snippet is used to pull data from one server to another. I primarily use it to get the latest data from our production to our development environments. The first part of the command is where the data is pulling from a...

data
mysql

1 763 posted 12 years ago by nedf23

MySQL Update database fields with search replace word

Used to update a database field using search replace.

0 633 posted 12 years ago by carouselcreative

MySQL US & CANADA Cities Database

3 2286 posted 12 years ago by frederichoule

MySQL Average discount in magento 1.4.1

0 522 posted 12 years ago by simsevu

MySQL wordpress - MYSQL - Assign all articles from one author to another

0 783 posted 12 years ago by krembo99

MySQL Change MySQL user password

mysql

0 629 posted 12 years ago by athome

MySQL Create user & grant privilege

0 698 posted 12 years ago by athome

MySQL CMS Made Simple Query for Pages Containing \'#\'

Get all page names and ids from the DB of pages with content containing '#'

mysql

0 595 posted 12 years ago by nielsenrc

MySQL \"Hoja de ruta\" para acciones bÃ¡sicas MySQL.

Instrucciones Mysql para crear un nuevo usuario (aÃ±adiendo valores a campos existentes en una BBDD existente) y una nueva BBDD con una tabla con cuatro campos a la que tenga acceso el usuario creado.