140
List all records of table
SELECT * FROM table_name;
Inserting multiple records
INSERT INTO eg_user (EmailId, Pword, DateOfBirth, Gender)
VALUES ('
[email protected]', MD5('1'), '1979-10-19', 'Male'),
('
[email protected]',MD5('a'), '1980-5-12', 'Female'),
('
[email protected]',MD5('ab'), '1972-6-10', 'Male'),
('
[email protected]',MD5('AB'), '1989-12-12', 'Female');
Modifying the record
UPDATE eg_user SET DateOfBirth='1980-12-8', uStatus='Active'
WHERE Id=1;
Deleting the record
DELETE FROM eg_user WHERE Id=5;
TRUNCATE TABLE tbl_name;
Example :
Create emp table
CREATE TABLE eg_emp(
Id SMALLINT(5) UNSIGNED PRIMARY KEY
AUTO_INCREMENT,
Name VARCHAR(30) NOT NULL,
Salary DECIMAL(10,2) NOT NULL,
Location VARCHAR(50) NOT NULL) AUTO_INCREMENT=101;
Inserting Records
INSERT INTO eg_emp (Name, Salary, Location) VALUES
('Mr.A',5000, 'Hyd'),('Mr. B', 4500, 'Mumbai'), ('Ms. C', 6000,'Delhi'),
('Mr. D', 7000, 'Delhi'),('Mr. B', 5000, 'Hyd'),('Ms. E', 3000, 'Hyd');