MySQL

How to show MySQL table details?

Submitted by Richard on Wed, 10/14/2009 - 06:17

Issue this command in your MySQL prompt to show table column detail.

desc user;

or

describe user;

The display would be as follows:  full story »

How display database tables in MySQL?

Submitted by Richard on Wed, 10/14/2009 - 06:13

Switch to a database you want to use using this command:

mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed

Once you have selected the database, just type this command to show all the tables inside it.

mysql> show tables;

The database tables are shown below.  full story »

How to delete MySQL database?

Submitted by Richard on Wed, 10/14/2009 - 06:09

To delete MySQL database, just simply type this command inside MySQL terminal.

mysql> drop database test_db;
Query OK, 0 rows affected (0.07 sec)

How to create MySQL database using mysqladmin command?

Submitted by Richard on Wed, 10/14/2009 - 06:04

To create MySQL database using mysqladmin command, type this command in your terminal.

mysqladmin create database_name

How to create MySQL database?

Submitted by Richard on Wed, 10/14/2009 - 06:01

Login to your MySQL database server

mysql -u root -p

and type this command:

mysql> create database test_db;
Query OK, 1 row affected (0.00 sec)

To check your newly created database, type this command:

mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| test |
| test_db |
+--------------------+
4 rows in set (0.00 sec)