MySQL – Inserting data in MySQL tables

The INSERT SQL statement impregnates our table with data. Here is a general form of INSERT.

INSERT into table_name (column1, column2....)
values (value1, value2...);

where table_name is the name of the table into which we want to insert data; column1, column2 etc. are column names and value1, value2 etc. are values for the respective columns. This is quite simple, isn’t it?

Mysql – Deleting entries from tables

The SQL delete statement requires the table name and optional conditions.

DELETE from table_name [WHERE conditions];

NOTE: If you don’t specify any conditions ALL THE DATA IN THE TABLE WILL BE DELETED!!!

import-export MySQL database from a dump command line

set password for root :
mysqladmin -u root password newpassword ( if never set )

mysqldump -p -u user dbname > dbname.sql

mysql -p -u user -h DBSERVER dbname < dbname.sql

Category Archives: MySQL

MySQL – Inserting data in MySQL tables

Mysql – Deleting entries from tables

import-export MySQL database from a dump command line

Categories