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 Using The MySQL Control Panel The MySQL feature inside your Control Panel is where you manage your database, including desiging tables, adding, deleting, and updating records, all from within your web browser. When you first click on the MySQL feature, you will be asked to provide a name for your database and a password, you can use the same username and password that you use for your Control Panel if you so desire. Once the database is created, and you return to this feature inside your Control Panel it will then become the Welcome page for your database. A tree view is on the left. The name of your database and the version of MySQL are displayed to the right of the tree. The Tree The top entry in the tree, Home, will return you to the Welcome page. Beneath that is your database name and a square with a plus or minus sign in it. Clicking the square will show and hide the names of the tables in the database in the tree. Clicking on the database name in the tree will display the main database management page. Clicking on one of the tables names in the tree will display the properties of that table. The Main Database Management Page This page displays a list of all the tables in your database and the number of records in each. You can also execute an SQL statement, perform advanced queries, dump the database, and create new tables. The List of Tables Next to each table name are links to various actions you can perform on a table.
Any SQL statement can be executed on your database by typing it into the textbox labled Run SQL query/queries on database and pressing the Go button. For help with SQL statements ??? Query by example Advanced queries can be built and executed using a graphical interface. View dump (schema) of database Dumping of the database displays the structure and or data contained in the database. 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. See also View dump (schema) of table. Create a new table Create a new table by typing in the name of the table and the number of fields to be in the table and pressing the Go button. You will be shown a page which will allow you to set up the datatype and attributes of each field. |