MySQL Database

How to Dump MySQL Tables Without Data

10 October , 2011 bill MySQL Database

Use the mysqldump command with the –no-data option:

More

0 how to, linux, mysql, tutorial, ubuntu,

How to Output a MySQL Query to CSV

9 September , 2011 bill MySQL Database

To output a MySQL query to a CSV file, the query needs to be altered.

More

0 csv, how to, mysql, server, tutorial,

How to Recover the MySQL root Password

31 August , 2011 bill MySQL Database

Introduction If the root password for MySQL has been forgotten, there is a way to reset it. The process involves stopping the MySQL server and starting it in safe mode.

More

0 how to, linux, mysql, server, tutorial,

How to Rename a MySQL Table

23 August , 2011 bill MySQL Database

To rename a MySQL table use RENAME TABLE with the old name then the new name after the TO keyword.

More

0 how to, linux, mysql, osx, server,

How to Delete a Field in a MySQL Table

27 July , 2011 bill MySQL Database

To delete a column in a MySQL database column, use the DROP COLUMN keywords with ALTER TABLE. Do not mistake deleting a field for deleting a record.

More

1 how to, linux, mysql, osx, server,

How to Rename a Field in a MySQL Table

27 July , 2011 bill MySQL Database

To change the name of a field in a MySQL database table use the CHANGE keyword with ALTER TABLE. You must also supply the field type again or you can change that too in the same line. Example: ALTER TABLE mytable CHANGE oldname newname VARCHAR(32);

More

0 how to, linux, mysql, osx, server,

Powered by WordPress. Designed by elogi.