This article shows you how to backup and restore data in your MySQL database. This process can also be used if you have to move your data to a new server.
Added: 06/05/2004,
Hits: 561,
Rating: 0,
Votes: 0 Add To Favorites
| Add Rating
A collection of 12 FAQs on MySQL server mysqld administration. Clear answers are provided with tutorial exercises on starting and shuting down the server; turning on server log files; viewing binary log files; running server on different port numbers.
Added: 03/22/2007,
Hits: 430,
Rating: 0,
Votes: 0 Add To Favorites
| Add Rating
A collection of 20 FAQs on MySQL SELECT query statements and basic features. Clear answers are provided with tutorial exercises on selecting rows and columns from tables and views; sorting and counting query outputs; grouping outputs and applying group functions.
Added: 09/09/2006,
Hits: 458,
Rating: 0,
Votes: 0 Add To Favorites
| Add Rating
A collection of 17 FAQs on Oracle SQL DML statements. Clear answers are provided with tutorial exercises on inserting and updating data rows; inserting and updating with subqueries; deleting data rows.
Added: 09/23/2008,
Hits: 442,
Rating: 0,
Votes: 0 Add To Favorites
| Add Rating
A collection of 21 tips on working with MySQL database. Clear explanations and tutorial exercises are provided on connecting and selecting MySQL database, creating and dropping tables, inserting, updating, and deleting rows, selecting and looping through data rows, searching by key words, setting auto-increment IDs.
Added: 03/02/2007,
Hits: 545,
Rating: 0,
Votes: 0 Add To Favorites
| Add Rating
In this tutorial, you'll learn how to use the SELECT statement to retrieve one or more columns of data from a table.
Added: 01/02/2006,
Hits: 418,
Rating: 0,
Votes: 0 Add To Favorites
| Add Rating
The retrieved data is not displayed in a mere random order. If unsorted, data is typically displayed in the order in which it appears in the underlying tables. This could be the order in which the data was added to the tables initially. However, if data was subsequently updated or deleted, the order is affected by how MySQL reuses reclaimed storage space. The end result is that you cannot (and should not) rely on the sort order if you do not explicitly control it.
Added: 01/03/2006,
Hits: 399,
Rating: 0,
Votes: 0 Add To Favorites
| Add Rating
This free book is an excellent tutorial book for beginners. It is a collection of notes and sample codes written by the author while he was learning SQL himself. Topics include CREATE, cursor, data type, DATE, DBD, DBI, DELETE, deadlock, export, FETCH, HAVING, import, INDEX, INSERT, isolation, GROUP BY, language, load data, lock, mSQL, MySQL, online, ORDER BY, Perl, query, RDBMS, SELECT, SQL, SQL-92, TIME, stored procedure, TIMESTAMP, transaction, UPDATE, WHERE, Windows, XML.
Added: 01/27/2006,
Hits: 597,
Rating: 0,
Votes: 0 Add To Favorites
| Add Rating
