Examples for business, study, careers, love, and more...
Examples :: MYSQL Examples :: Example of Use Mysql statement

Example of Use Mysql statement:

USE db1;
SELECT COUNT(*) FROM mytable;

USE db2;
SELECT COUNT(*) FROM mytable;

USE db1;
SELECT author_name,editor_name FROM author,db2.editor
WHERE author.editor_id = db2.editor.editor_id;

CREATE DATABASE SomeWeirdName;
USE SomeWeirdName;
DROP SomeWeirdName;

Example of Mysql Use

USE db_name