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 create
Database:
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 the
structure 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)
Posts
3 comments:
Microsoft Dynamics AX training, do keep a few things in mind to get the maximum out of the course as well as the application.we teach Microsoft Dynamics AX training and class at Hyderabad.
Microsoft Dynamics AX training in Hyderabad
Microsoft Dynamics CRM training in Hyderabad
Microsoft Dynamics NAV training in Hyderabad
Arrowsol Training offers you a way to training materials, classroom training, E-Learning, certification exams, Microsoft Press Books, and more for Microsoft Dynamics.
Microsoft Dynamics online Training
Your Blog post are nice
Post a Comment