Using WinMySQL Professional
Open MySQL® table
This menu, only available when connected to a database, opens a window with a list of tables contained in the current database. In this list, just click on the required table name. It enables the «Ok» button, then click on it. «Open MySQL® table» can be invoked too by the shortcut «Ctrl-O».
If you want to handle a big table only on the structure level (and not on the record level), you can click on the «Activate» button instead of the «Open» button. You'll be able to enter all managements and generators menus but not the record management menu.
During the opening procedure, WinMySQL Professional counts the number of records held by the table. If this number is greater than 6000, the data loading is stopped to ask for abortion or resuming.
When a table is opened, all its records are loaded in the output grid ; so, this grid becomes a table editor (see «Submenu Record>Insert record» section). The title bar then displays the active table, the active database and the target host.
If a table is «active», the additional enabled menus are (except if current database is «mysql») :
Table management>Load data from a delimited file
Tablemanagement>Load data from dBaseIII+
Table management>Structure info
Table management>Modify column
Table management>Delete column
Table management>Add primary key
Table management>Drop primary key
Table management>Make a column not null
Record>Delete/Update/Insert confirmation
Client generators>Web generators>HTML>Input form from current table structure
Client generators>Web generators>HTML>Page from output grid
Client generators>Web generators>PHP> «Select» script
Client generators>Web generators>PHP> «Insert» script
Client generators>Web generators>PHP> «Delete» script
Client generators>Web generators>PHP> «Update» script
Client generators>Wap generators>WML input deck
Client generators>Wap generators>PHP> «Select» script
Client generators>Wap generators>PHP> «Insert» script
Client generators>Wap generators>PHP> «Delete» script
Client generators>Wap generators>PHP> «Update» script
Client generators>WinMySQL baby apps for Windows®
Otherwise, to prevent MySQL® servers unrecoverable crash, if the current database is «mysql», the following menus stay disabled :
Table management>Modify column
Table management>Delete column
Table management>Drop primary key
Anyway, you shouldn't modify anything in the database «mysql» ; its structure is designed by TcX DatakonsultAB and an alteration cannot enhance anything.
If you want to handle records held by a big table, you may open a view instead of opening directly the table.
For further issues on views, please see : «File>Open view» and
«File>New view» sections.
Caution : Because of opposite menus forced enabled or disabled when the current database is «mysql» (example : «Table management>Add primary key» is enabled but «Table management>Drop primary key» is disabled), it may be impossible to correct with menus any improper modification. You will be forced to use the SQL command line editor to try to cancel what you have done. So, if you are not a confirmed user of MySQL®, you shouldn't use the «Table management» menu on the «mysql» database.
When you use the SQL command line editor with an active table, the output grid displays the query results, but the last opened table stays active and the «Record» menu becomes disabled : the ouput grid doesn't stay in table editor mode. To display back the active table content and to enable again the table editor mode and the «Record» menu , use the menu «Table management>Reload» (or «Ctrl-Z» shortcut. For further informations, see the «Submenu Table management>Reload» section).