After you enter data in the MySQL Workbench, you must click
the button in order to save the data
in your MySQL database. If you forget to click the
button your data will not be written
to the database and will be lost when you close the
Workbench.
You must enter data in the order of its dependencies.
Consider a database for a pizza restaurant. You must enter the
customer and employee data before you can
enter the order data because the order
data includes customer_keys and
employee_keys. In other words, the order
data is dependent on the customer and
employee data, so you must enter the
customer and employee data before entering
the order data.
You must enter dates in MySQL Workbench in this format:
yyyy-mm-dd, meaning
a four digit year
a dash
a two digit month number (01 is January)
a dash
a two digit day of the month
You must enter times in MySQL Workbench using 24 hour
format, also called military time. For example you must enter
8:00 AM as 8:00 and 2:00 PM as 14:00
You must enter Boolean values in MySQL Workbench as 0 and
1. 0 means FALSE and 1 means TRUE. When I enter FALSE or TRUE into
the Workbench datasheet, the Workbench always treats them as text
values and not Boolean values. I cannot find any way to enter the
words FALSE, false, F, f, TRUE, true, T, or t into the MySQL
Workbench and get the Workbench to write them to a BOOLEAN
cell.
To store a file into a BLOB cell, right click on the cell
and and click To
retrieve an object from a BLOB cell, right click on the cell and
click
If you want to enter a NULL in a
cell, you cannot simply type the word “NULL”. If you simply type
NULL, the Workbench will try to store the word NULL as a VARCHAR or
CHAR into the cell. If you want to enter a
NULL in a cell, right click on the cell
and click .