Some basic commands of MySql database

Some basic commans of MySql are given below

CREATE Command – is used to create a database/table.
SELECT Command – is used to retrieve data from the database.
DELETE Command – is used to delete data from the database.
INSERT Command – is used to insert data into a database.
UPDATE Command – is used to update the data in a table.
DROP Command – is used to delete or drop the database/table.

• Display one row:

mysql> SELECT *  FROM authors WHERE fieldname=value;

• Display one column:

mysql> SELECT fieldname FROM tablename;

• Count number of rows;

mysql> SELECT COUNT(*) FROM tablename;

• To delete a database:

 mysql> DROP database [database name];

• Delete data from table:

mysql> DELETE from tablename where fieldname=value;

• To delete a table:

 mysql> drop table [table name];

• Joining of two tables :

mysql> INSERT INTO table1(field1,field2,field3) SELECT field1,field2,field3 FROM table2;

• Update a table:

mysql> UPDATE tablename SET fieldname=”newvalue” where field=”originalvalue”;