Scripts bible for MySql

Be the Sun of your solar system.

Summary

Show create scripts

show create table table_name;

To show all records vertically (and more human-readable)

To add a postfix \G in each query, e.g.

select * from table1 limit 1 \G;

The output will look like below, easier for developer to check and see.

–HTH–