|
INSERT
This function inserts new records into the selected table.
Ones a record is inserted, the user is prompted to insert another one.
To return back to the Main Page click on "Main Page" link on the navigation bar on the top of the page.
The columns of the selected table are introduced as HTML form fields depending on the column type as follows:
- TEXT and BLOB column types - Textarea and File fields. Textarea is used to type data into the table directly, and File field is used to upload data.
- ENUM - pulldown menu
- Other types - text fields
To insert a record, type its values in the appropriate fields and hit 'Submit' button.
In order to import a file into BLOB, type the full path of the file into the File field or use Browse button and check the checkbox ‘upload’. If the checkbox is not checked, data in the file form will be ignored, and data from the textarea will be inserted.
'Unquoted Data' checkbox is used to operate with SQL functions (now(), password() and others) or unquoted numerics.
|
