Insert records in a table is part of everyday life of any developer, because it is important to know the respective command of this function in the database in which they are working. Currently in the development of Web applications, it is common to find the Firebird DBMS as standard and so we will explain below how to write records in tables stored in it.

Using INSERT can insert records in a table in Firebird as shown in the syntax and example below:

INSERT INTO [Table] ([Fields])

VALUES ([Values])


INSERT INTO product (Name, Price)

VALUES (‘DVD Player’, ‘2000’)

In the example shown above insert a record into product table values ​​passing as the name of the product and its price.

The Firebird also provides the insertion from a query, as shown in the example below.

INSERT INTO product (Name, Price)

SELECT Name, Price FROM product_2

From a products query in the table product_2 will be inserted a mass data in the products table, but remember that the table data must be compatible with exactly the same type so there is no error in the execution of the command.


More and more Firebird has gained space in development environments, especially those that use PHP as default language development. Better understand this scenario and know the advantages of PHP with Firebird in our official site.

By ,

September 17, 2013


You might also like…

5 reasons you can’t miss a Black Friday Scriptcase!

This November we bring you the biggest and most important discounts of the year! And do you know wh...

Taking a look at Scriptcase version 9.7

After the big Scriptcase 9.7 presentation event, we have a new version of Scriptcase for download, ...

October Newsletter

Follow the latest news for the month of October! Webinars, blog posts, videos, and more. WEB...

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 Learn more about our Privacy Police.