Following is a list of some of mysql specific commands that I frequently use. You should be connected to mysql server through the command-line to execute the commands.
>show databases;
Display the list of databases hosted by the mysql server
>use db;
Selects the database to be working on.
>desc table;
Describes the metadata of the table;
>show tables;
Display tables of the selected database
>source test.sql;
execute an SQL script file
Hiç yorum yok:
Yorum Gönder