 |
|
 |
Home »
MySQL »
General Guides
::
ReportRelated Tutorials
 |
|
|
 MySQL / General Guides Use the command line mysqldump utility to dump all database contents to an external file. This utility should ideally be run before regular backups occur so the dumped file will be backed up properly. The command line mysqlhotcopy utility can be used to copy all data from a database (this one is not supported by all database engines). You can also use MySQL to dump all data to an external file using BACKUP TABLE or SELECT INTO OUTFILE. Both statements take the name of a system file to be created, and that file must not already exist or an error will be generated. Data can be restored using RESTORE TABLE. Site: www.brainbell.com
|
||
|
|
|
|
|
|
MySQL / General Guides What if you forget the name of a database or table, or what the structure of a given table is (for example, what its columns are called)? MySQL addresses this problem through several statements that provide information about the databases and tables it supports. Site: dev.mysql.com
|
||
|
|
|
|
|
|
MySQL / General Guides MySQL statements are executed when needed, as are stored procedures. But what if you wanted a statement (or statements) to be executed automatically when events occur? For example: Every time a customer is added to a database table, check that the phone number is formatted correctly and that the state abbreviation is in uppercase, Every time a product is ordered, subtract the ordered quantity from the number in stock, Whenever a row is deleted, save a copy in an archive table. Site: www.brainbell.com
|
||
|
|
|
|
|
|
MySQL / General Guides Creating the database is the easy part, but at this point it's empty, as SHOW TABLES tells you: Site: dev.mysql.com
|
||
|
|
|
|
|
 MySQL / General Guides This tutorial will show you how to get records in your table in database to show on your PHP files. This SQL statement has many options. Site: www.phpsimple.net
|
||
|
|
|
|
|
|
MySQL / General Guides This tutorial will show you how to create new table. |
||
|
|
|
|
|
|
MySQL / General Guides Before you can start creating tables you need to have a database.creates your database for you when setting up your permissions, you can begin using it. Otherwise, you need to create it yourself: Site: dev.mysql.com
|
||
|
|
|
|
|
|
MySQL / General Guides you'll learn how to take information stored in a database and display it on a Web page for all to see. So far you have installed and learned the basics of MySQL, a relational database engine, and PHP, a server-side scripting language. Now you'll see how to use these two new tools together to create a true database-driven Web site!. |
||
|
|
|
|
|
|
MySQL / General Guides This second installment covers an introduction to databases, logging on to MySQL, defining SQL, inserting data in a table, and modifying stored data. |
||
|
|
|
|
|
|
MySQL / General Guides In this tutorial, you will learn how to: Select data from a database; Filter data using Where clause; Sort data by Order; Use wildcards for smart search; Use aggregate functions; Insert data into a database; Update data in a database; Delete data from a database; Create, update and delete tables. Site: www.itechcollege.com
|
||
|
|
|
|
|
|
MySQL / General Guides The MySQL database is unique in that it offers multiple storage engines. The SQL parser and front end interfaces are separate from the storage engines. This lets you choose the low level table format that suits your application best. Site: www.hostlibrary.com
|
||
|
|
|
|
|
|
MySQL / Replication and Backup This tutorial describes how to set up database replication in MySQL. MySQL replication allows you to have an exact copy of a database from a master server on another server (slave), and all updates to the database on the master server are immediately replicated to the database on the slave server so that both databases are in sync. Site: www.howtoforge.com
|
||
|
|
|
|
|
 MySQL / General Guides Most of us have had problems with UTF-8 problems in PHP and MySQL. Here is how to modify your database and table to be UTF-8 compliant. Most of the time we do set the character set to utf8 but forget to set the collation set to utf8. Site: blogs.vinuthomas.com
|
||
|
|
|
|
|
|
MySQL / General Guides Once you know how to enter commands, you are ready to access a database. Site: dev.mysql.com
|
||
|
|
|
|
|
 MySQL / General Guides MySQL is a freely available open source Relational Database Management System [RDBMS], a database engine of sorts that uses Structured Query Language (SQL). SQL is the most popular language for adding, accessing, and processing data in a database, and is most noted for its rapid processing, proven reliability, and ease and flexibility of use. Site: www.siteground.com
|
||
|
|
Site Search
Categories
Adobe Fireworks
Adobe Flash
Adobe Illustrator
Adobe Image Ready
Adobe Photoshop
3D Studio Max
Cinema 4D
Maya 3D
Microsoft Excel
Microsoft PowerPoint
Microsoft Word
Microsoft Access
MySQL
C and C++ 
Python
Visual Basic
.htaccess
Adobe DreamWeaver
ASP
CGI & Perl
CSS
Java
JavaScript
Microsoft FrontPageAdvertisement
|
|