To perform inserts records into tables in SQLite INSERT command is used, its syntax is similar to other DBMS such as Microsoft SQL Server, for example. Check it out below:

INSERT INTO [Table] ([Columns]) VALUES ([Values])

As a practical example we will perform the insertion of a record in the table cars storing information such brand, model, color and value.

INSERT INTO Cars (Brand, Model, Color, Price) VALUES (‘Peugeot’, ‘308’, ‘Red’, 62000)

INSERT INTO Cars VALUES (‘Peugeot’, ‘308’, ‘Red’, 62000)

Note that the columns in the first example are indicated, but the second does not. You have the option of performing the insert without specifying the columns, but for that you need to know them previously, including their order.

SQLite

SQLite can be a great option for web applications, wonder why? Then visit our official SQLite in PHP projects and find out.

By , The most efficient web development environment. Create your web solutions in a fast and innovative way, reducing the development time in up to 80%. Access http://scriptcase.net and learn more.

October 8, 2013

a

You might also like…

“Scriptcase is the best IDE we have used!” (SUITE TECHNOLOGY)

See how Suite Technology used Scriptcase to develop their projects. OVERVIEW Suite Technolog...

Exceptional Services Bestowed by Scriptcase Gets Recognized at GoodFirms

When it comes to Web hosting services Scriptcase is a choice. If you ask why? It’s becaus...

IaaS, PaaS and SaaS: understanding Cloud Computing types.

Cloud Computing is a factor that has been responsible for causing several important transformations...

You might also like…

Get new posts, resources, offers and more each week.

We will use the information you provide to update you about our Newsletter and Special Offers. You can unsubscribe any time you want by clinck in a link in the footer of any email you receive from us, or by contacting us at sales@scriptcase.net. Learn more about our Privacy Police.