Assignment and homework help in MYSQL

MYSQL

MYSQL is an RDBMS (Relational Database Management System) which runs as a server thereby providing a multi user access to number of databases. The SQL phrase stands for Structured Query Language.

The MySQL development project has its source code available under the terms and conditions of GNU General Public License, and also under several proprietary agreements.

Free software open source projects which require a DBMS (data base management system) generally use this MySQL. Several paid editions are available for the commercial use. These editions also provide extra functionalities. Carious applications which use MySQL are: LAMP, Joomla, phpBB, TYPO3, Drupal etc.

MySQL is a database which is popularly used in almost all the web applications. It is also a central component of the web application software stack named LAMP – LAMP stands for: Linux, Apache, MySQL, PHP/Perl/Python.

MYSQL is also used on some of the most famous web sites on the internet like : YouTube, Wikipedia, Twitter, Facebook, Google etc.

MYSQL Syntax

1.      To Create a Database:

Mysql> Create database nikki;

Query OK, 1 row affected (0.00 sec)

 2.  To Delete a database:

Mysql> DROP database nikki;

Query OK, 1 row affected (0.00 sec)

3.   After creating a database, a user can create table for that particular database only if the database is in use. Thus to change the current database or in other words to start using the desired database –

following command is used:

 Mysql> use nikki;

Database Changed

 4.  To create a table in the database- create statement is used.

 CREATE TABLE student (

-> last_name varchar(20) not null,

-> first_name varchar(20) not null,

-> state varchar(10) not null,

-> city varchar(10) not null,

-> birth date not null default '0000-00-00',

-> );

Query OK, 1 row affected (0.00 sec)                                                                                                                                                                                            

5.      To see the tables which are present in the database named nikki- use SHOW statement.

Mysql>Show nikki;

+----------------+

| Tables_in_nikki |

+----------------+

| president |

+----------------+

1 row in set (0.00 sec)

 6.      To view the structure of the table DESCRIBE command is used.

 Mysql> Describe student;

 +------------+-------------+------+-----+------------+-------+---------------------------------+

| Field      | Type | Null | Key | Default | Extra | Privileges |

+------------+-------------+------+-----+------------+-------+---------------------------------+

| last_name | varchar(15) | | | | | select,insert,update,references |

| first_name | varchar(15) | | | | | select,insert,update,references |

| state | char(2)          | | | | | select,insert,update,references |

| city | varchar(20)       | | | | | select,insert,update,references |

| birth | date          | | | 0000-00-00| | select,insert,update,references |

+------------+-------------+------+-----+------------+-------+---------------------------------+

5 rows in set (0.00 sec)

 7.      To insert a row in the table Student, INSERT statement is used.

Mysql> INSERT INTO president values ('Singhal',

'Himadri',

'Delhi',

'Delhi',

'1987-02-11');

 8.      To retrieve the information from the table – Select command is used.

Mysql> select * from student;

 +-----------+----------+------+-------+-------------+

| last_name | first_name|state | city | birth       |

+-----------+----------+------+---------------------+

| Singhal   | Himadri   |Delhi | Delhi | 1987-02-11 |

+------------+---------+------+--------+------------+

1 row in set (0.00 sec)

 9.      To delete any selected data from the table:

 mysql> DELETE FROM student WHERE first_name="Himadri";

Query OK, 1 row affected (0.00 sec)

Online Homework help in MySQL

Tutors Kingdom is a place where each and every student can get answers to their doubts relating to various different languages such as MySQL etc. You can easily submit us you school, university or college level work to us. Our tutors ensure to provide you not only good solutions but also try their level best to make the assignment in way which could increase your knowledge and understanding. We have highly certified and qualified tutors, college professors etc in MySQL. Our tutors are ready to share their valuable experience with students for cheap prices.