How to insert records in the table?

Once the structure of the table is ready, now we can insert records to the table.

To insert the records, you have to use the SQL statement, INSERT INTO with following Syntax

Syntax

INSERT INTO tablename VALUES(value1, value2, value3…);

Remember that,

üWhile passing string and date kind of data, enclose that data in single quote

üDefault date format of MySQL is yyyy-mm-dd

Example

USE demodb;

INSERT INTO book VALUES(101, 'Data Analytics for Beginners','Rohit Kumar',400);

INSERT INTO book VALUES(102, 'Data Analytics for Professional','Sanjay Sharma',500);

INSERT INTO book VALUES(103, 'Business Analytics for All','Neeraj Verma',500);

INSERT INTO book VALUES(104, 'SQL Programming','Dr B P Sharma',700);

INSERT INTO book VALUES(105, 'Python Programming','Dr B P Sharma',900);

 

INSERT INTO student VALUES(1234,'Harish Kumar','harish@gmail.com','9899999999',89000);

INSERT INTO student VALUES(1235,'Kapil Sharma','kapil@yahoo.co.in','9888888888',45000);

INSERT INTO student VALUES(1236,'Nitin Verma','nitin@hotmail.com','9877777777',90000);

INSERT INTO student VALUES(1237,'Ritesh Khanna','ritesh@gmail.com','9866666666',32000);

INSERT INTO student VALUES(1238,'Tarun Kumar','tarun@outlook.com','9855555555',56000);

 

INSERT INTO IssueBooks VALUES(101,1234,'2023-11-12');

INSERT INTO IssueBooks VALUES(102,1235,'2023-11-16');

INSERT INTO IssueBooks VALUES(103,1236,'2023-11-20');

Comments

Post a Comment

Popular posts from this blog

What SQL can do?

SQL can  perform various database operations like ·          Create and remove of database ·          Create, alter and remove the tables ·          Insert, update, delete and retrieve the records ·          Controlling the user access ·          Managing transactions during insertion, updation and deletion of records
Read more

What are different data types to manage data in the columns or fields?

Every column or field related to some entity has to manage a kind of data known as data type. In general, data can be of three types ·          Numeric type Data ·          String type Data ·          Date type Data Different RDBMS software provides different keywords to define the data type e.g. MySQL provides data types such as ·          INT for integer data numeric data e.g. Book Number ·          FLOAT for floating type numeric data e.g. Price ·          VARCHAR for variable length strings e.g. Name, Email ·          CHAR for fixed length strings e.g. Pin Code, Mobile Number ·          DATE for managing dates e.g. Date of Birth Remember that, ...
Read more

What is SQL?

Image
Structured Query Language (SQL) is the standard language for storing, manipulating and retrieving data in databases using special software known as Relational Database Management Systems (RDBMS). There are many RDBMS softwares available to store and manage the structured data. Some of the RDBMS softwares are MySQL, MariaDB, Oracle Database, Microsoft SQL Server, PostgreSQL, SQLite etc. SQL is case insensitive language. SQL became a standard of the American National Standards Institute (ANSI) in 1986 and of the International Organization for Standardization (ISO) in 1987
Read more