Cara menggunakan can mysql generate uuid?

The navigation bar allows you to switch the records quickly, insert, update or delete records. View data as a grid is most helpful for entering new records and editing old records in a table.

To add a record

1. Make sure that your cursor is situated in the first blank cell on the table, then enter the desired data. If you are adding the new record into an existing table, just simply click on an existing record and click the
   
   from the navigation bar or press CTRL+N to get a blank display for a record.
2. Watch the graphics symbol in the record selectors box just to the left of your record. It will change from the
   
   , which indicates that it is the current record, to
   
   , which indicates that you are editing this record.
3. Just simply move to another record to save the record or click the
   
   from the navigation bar.

To edit a record

1. Select the record that you wish to edit by clicking in the specific field you want to change.
2. Type in the new data for that field.
3. Just simply move to another record, the new data will overwrite the previous data or click the
   
   from the navigation bar.

Note: Close the table is another way to save the records.

To edit multiple cells with same data

1. Select a block of cells in the data grid.
2. Type in the new data.

Note: Changes will apply to multiple fields with compatible data type.

To delete a record

1. Select the record that you wish to delete.
2. Just simply right-click and select Delete Record or click the
   
   from the navigation bar.

Edit Records with Special Handling

To set Empty String for the cell, right-click the selected cell and select Set to Empty String.

To set Null value for the cell, right-click the selected cell and select Set to NULL.

To edit the text field record, just simply click Show Memo In Grid from the View menu.

Note: Available only for MySQL, Oracle, PostgreSQL and MariaDB.

Hint: To view/edit the text field record in an ease way, see Memo Editor.

To view images in the grid, just simply click Show Image In Grid from the View menu.

Note: Available only for MySQL, Oracle, PostgreSQL, SQL Server and MariaDB.

Hint: To view/edit the image in an ease way, see Image Editor.

To edit a Date/Time record, just simply click

Note: Available only for MySQL, Oracle, PostgreSQL, SQL Server and MariaDB.

To edit an Enum record, just simply choose the record from the drop-down list.

Note: Available only for MySQL, PostgreSQL and MariaDB.

To edit a Set record, just simply click

Note: Available only for MySQL and MariaDB.

To view BFile content, just simply enable Preview BFile under the View menu.

Note: Available only for Oracle.

To generate UUID/GUID, right-click the selected cell and select Generate UUID.

Note: Available only for PostgreSQL and SQL Server.

Edit Records with Foreign Key (Foreign Key Data Selection - Available only in Full Version)

Foreign Key Data Selection is a useful tool for letting you to get the available value from the reference table in an easy way. It allows you to show additional record(s) from the reference table and search for a particular record(s).

To include data to the record, just simply click

Just simply double-click to select the desired data.

Click

Enter a value into the edit box and click

Hint: To remove the filter results, right-click anywhere on the grid and select Show All.

Copy Data from Navicat

Data that being copied from Navicat goes into the windows clipboard with the fields delimited by tabs and the records delimited by carriage returns. It allows you to easily paste the clipboard contents into any application you want. Spreadsheet applications in general will notice the tab character between the fields and will neatly separate the clipboard data into rows and columns.

To select data using Keyboard Shortcuts

To select data using Mouse Actions

• Select the desired records by holding down the CTRL key while clicking on each row.
• Select a block of cells.

Note: After you have selected the desired records, just simply press CTRL+C or right-click and select the

Paste Data into Navicat

Data is copied into the clipboard will be arranged as below format:

• Data is arranged into rows and column.
• Rows and columns are delimited by carriage returns/tab respectively.
• Columns in the clipboard have the same sequence as the columns in the data grid you have selected.

When pasting data into Navicat, you can replace the contents of current records and append the clipboard data into the table. To replace the contents of current records in a table, you must select the cells in the data grid whose contents must be replaced by the data in the clipboard. Just simply press CTRL+V or right-click and select the

Copy Records as Insert/Update Statements

To copy records as Insert/Update statement, select the records and click Edit -> Copy As -> Insert Statement or Update Statement from the menu. Then, you can paste the statements in any editor.

Copy Field Name

To copy field names as tab separated values, select the columns/data and choose Edit -> Copy As -> Tab Separated Values (Field Name only) from the menu. If you want to copy data only or both field names and data, you can choose Tab Separated Values (Data only) or Tab Separated Values (Field Name and Data) respectively.

Save Data as a File

You can save the data in the table grid to a file. Simply right-click a cell and choose Save Data As. Enter the file name and file extension in the Save As dialog.

Kapan menggunakan UUID?

Kenapa harus menggunakan UUID?