Scriptcase Firebird INSERT Statement

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])

EXAMPLE:

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.