Enter records (insert into-select)
A record is a row in the table that contains the data itself. Each record has one data for each column (field). Our "users" table consists of 2 fields, "name" and "password". When entering the data for each record, the quantity and order of the fields must be taken into account. The basic and general syntax is as follows: insert into TABLENAME (FIELDNAME1, ..., FIELDNAMEn)values (FIELD VALUE1, ..., FIELD VALUEn); We use "insert into", then the name of the table, we detail the names of the fields between parentheses and separated by commas and after the "values" clause we place the values for each field, also between parentheses and separated by commas. In the following example a record is added to the "users" table, in the "name" field "Mariano" will be stored and "clown" will be stored in the "password" field: insert into users (name, password) values ('Mariano', 'c