Skip navigation links

Browse

Ask the Librarian

Note the above only searches this section, for site searches use the overall search function. Help: Searching, Tag Searching

The MySQL Librarian collects the best of the web when it comes to MySQL! If you have something to add to the Librarian, please do so. Help us keep it current and relevant to the MySQL Community!

Browser Tools

  • Bookmarklet: Add to Librarian
    Drag link above to your browser (Firefox/Safari) toolbar to add URLs to the MySQL Librarian from anywhere.

Profile

Top Voted (Last Month)

  1. Does MySQL support Julian Dates? Vote!
Showing entries 1 to 3

Tags Filter: Technical (reset)

Articles
Add to Favourites +1 Vote Up -0Vote Down
posted by kedar vaijanaupurkar on Thu 11 Feb 2010 11:12 UTC
Tags:
(edit) Technical, mysql, shell script
This shell script will be grabbing the tables you want and pass it to splitted.sql It’s capable to understand regular expressions as I’ve added sed -r option. Also MyDumpSplitter can split the dump in to individual table dumps.

Report link

Articles
Add to Favourites +1 Vote Up -0Vote Down
posted by kedar vaijanaupurkar on Mon 08 Feb 2010 12:06 UTC
Tags:
(edit) Technical, mysql, stored procedure
Stored procedure to add-remove prefix by rename table

Report link

Articles
Add to Favourites +2 Vote Up -0Vote Down
posted by kedar vaijanaupurkar on Thu 14 Jan 2010 14:08 UTC
Tags:
(edit) Technical, mysql, load data, csv
Loading csv or delimited data files to MySQL database is a very common task frequently questioned about and almost everytime LOAD DATA INFILE come into rescue. In this article we will try to understand some of the very common scenarios for loading data into MySQL Database.

Report link

Showing entries 1 to 3