Tables Archives

Table Diagnostics

Kailash Chander June 15, 2026 No Comments

Use Tools -> Table Diagnostics (Ctrl+Alt+T) to perform various Table Diagnostics operations. Analyze The Analyze Tables Wizard allows you to analyze and store the key distribution for the table. During the analysis…

Table Properties

Kailash Chander June 15, 2026 No Comments

To view the Advanced Properties of a table, select the table in the Object Browser and select Table -> More Table Operations -> View Table Properties from the popup menu. To define or to edit the Advanced Properties of a…

View Data

Kailash Chander June 15, 2026 No Comments

To quickly view data of a table select the table in the Object Browser and 1) select Open Data from the popup menu 2) click the DATA tab 3) or just press Enter.…

Pasting SQL for Table

Kailash Chander June 15, 2026 No Comments

INSERT statement With the menu item Table -> Paste SQL Statements -> INSERT INTO <tablename>…, SQLyog creates a template of a MySQL statement with INSERT clause for the table selected in…

Copy Table to different HOST

Kailash Chander June 15, 2026 No Comments

This feature can be used instead of the Database – Copy DB To Another Host/Database option when you need to copy a single table, but in fact you can use it for…

Looking up constraints for a value

Kailash Chander June 15, 2026 No Comments

When inserting/updating a value in a column on which a Foreign Key CONSTRAINT is defined SQLyog GRID and FORM view (in Table data) provide you with a facility to look…

Data Manipulation

Kailash Chander June 15, 2026 No Comments

To manually insert or update data in a MySQL Table, right click on the table in the Object Browser and select the Open Table or press F11. It is populated by a…

Import XML Data using LOAD LOCAL

Kailash Chander June 15, 2026 No Comments

To import data from a XML file into a MySQL table, select the table in Object Browser and select Table -> Import -> Import XML Data Using Load Local… or(Ctrl+Shift+X). Tables: The list of all…

Import CSV Data Using LOAD LOCAL

Kailash Chander June 15, 2026 No Comments

To import data from a CSV file into a MySQL table, select the table in Object Browser and select Table -> Import -> Import CSV Data Using Load Local… or(Ctrl+Shift+M). Tables: The list of…

Backup Table to (and restore from) SQL Dump (‘Batch Scripts’).

Kailash Chander June 15, 2026 No Comments

In the table menu/context menu you will find an option to backup a Table to (and restore from) a SQL Dump similar to what is possible with a database. Refer…

KB Category: Tables