12:03 AM
1.What is MySQL?
- MySQL is a database server
- MySQL is ideal for both small and large applications
- MySQL supports standard SQL
- MySQL compiles on a number of platforms
- MySQL is free to download and use
2.How to Create Database?
To createDatabase:
mysql> create database cegon;
Query OK, 1 row affected (0.00 sec)
To use the Database:
mysql> use cegon;
Database changed
4.How To view thestructure of the table:
mysql> describe student;
+--------+-------------+------+-----+---------+-------+
| Field |Type | Null | Key | Default |Extra |
+--------+-------------+------+-----+---------+-------+
| id |int(10) | NO | PRI | 0 | |
| name |varchar(20) | YES | | NULL | |
| gender | varchar(10) | YES | |NULL | |
+--------+-------------+------+-----+---------+-------+
3 rows in set (0.02 sec)
Posted in: MySql
0 comments:
Post a Comment