MySQLMan Help


Tool bar     HOME

Insert

Insert a new record to the table specified. The insert form can be found by following the link "insert" in the tool bar or the table list. To insert a record into to that table, you simply put the values in the "VALUE" column and then press "GO" once the text fields are filled.

  • Using functions
    To use the functions in INSERT, you need to first choose the function you need from the select list in "Function" column. Then, enter the values for the functions in the column "Value".
  • For example to run
        INSERT INTO table_name
        SET Datetime = NOW(), PASSWORD('MyPass')

    Here is what you put in the form:
        

  • Insert null values
    In the config file, if you have insert_null (in %config) set to 1, then there will be an extra colunm at the end of the table called "Null". If a field is set to NULL, then there would be a checkbox for the field in the column; there will not be one otherwise. Check the checkbox and leave the "Value" input text box blank to insert a record with that field being null. If both a value is entered in "Value" and "Null" checkbox is checked for a field, then the value in "Value" will be taken and the check in the "Null" Checkbox will be ignored.
  • Escape character
    Values entered in "Value" will be escaped automatically by the script. I.e. you do not need to put a escape character (\) in before a single quote ('), etc.
  • Fields with type TIMESTAMP
    Fields with type TIMESTAMP is hidden by default. You can have these fields shown by setting show_timestamp_field to 1 in the config file (mysql.cfg).
Tool bar     HOME
Related topics: Table List