WEBDEVELOPMENT Study Guide - Phpmyadmin, Xampp, Mysql

• School: National Institute of Technology - NIT Manipur
• Department: Design
• Course: WEBDEVELOPMENT

Document Summary

The sql show statement displays information contained in the database and its tables. This helpful tool lets you keep track of your database contents and remind yourself about the structure of your tables. For example, the show databases command lists the databases managed by the server. Throughout the tutorial we will be using the mysql engine and the. The easiest way to get mysql and phpmyadmin is to install free tools like xampp or wamp, which include all necessary installers. The show tables command is used to display all of the tables in the currently selected mysql database. For our example, we have created a database, my_database, with a table called customers. Show columns displays information about the columns in a given table. The following example displays the columns in our customers table: Show columns displays the following values for each table column: Extra: may contain any additional information that is available about a given column.