Chapter 1 Account Overview Chapter 2 Getting Started Chapter 3 Control Panel Overview Chapter 4 FTP Instructions Chapter 5 SSH / Telnet Chapter 6 Email Software Setup Chapter 7 File Manager Chapter 8 Change Password Chapter 9 Mail Manager Chapter 10 Site Statistics Chapter 11 Mailing List Chapter 12 Microsoft FrontPage Chapter 13 Site Creation Tool Chapter 14 Counters Chapter 15 Protect Directories Chapter 16 Redirect URL Chapter 17 Search Engine Chapter 18 Formmail Chapter 19 PGP & PGP Mail Chapter 20 Mime Types Chapter 21 Anonymous FTP Chapter 22 Archive Manager Chapter 23 SSL (Secure Server) Chapter 24 MySQL Chapter 25 Shopping Cart Chapter 26 CGI-bin Chapter 27 Real Audio / Real Video |
|
Chapter 24 - MySQL
Overview |
MySQL Control Panel Feature |
Examples of SQL Statements |
Quick Actions Advanced Queries | Table Properties | Table Select | Perl SQL Delete Example Perl SQL Insert Example | Perl SQL Update Example | Perl While Loop Example View Dump Database Schema | Using MySQL With CGI Scripts References and Tutorials Table Properties The fields in the table are listed with their datatypes and attributes. The List of Fields Next to each field name are links to various actions you can perform on a field.
The primary fields and indexes are listed again below the list of all fields. Browse Display the records in the table 30 at a time. From the Browse page you can edit or delete a record. Select Build and execute a SELECT query on the table. Only those records which match the criteria you provide will be displayed. Insert Add a new record to the table. Various functions can be used to obtain the current time, generate random numbers, and more. Add New Fields To add one or more new fields to the table, select the number of fields to add and press the Go button next to the text Add new field:. Upload Data Insert textfiles into table allows you to load data into the table from a properly formatted text file on your local computer. Dump Table Properties View dump (schema) of table displays the structure and or data contained in the table. You can then save this information to a file on your local computer for archiving or to aide in the development of your database. The contents and format of the dump are based on the radio button and check box selections you make. Rename and Copy You can rename or copy a table as well. |