Subscribe Now!

Enter your email address:

Wednesday, October 5, 2011

MySql


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)


 3. How to use the database?
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)

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

Post a Comment

Related Posts Plugin for WordPress, Blogger...