Database Management In MySQL?
Create a database in MySQL / MariaDB
-- Below commands can be used to create database
mysql> CREATE DATABASE QTEST;
Query OK, 1 row affected (0.00 sec)
mysql> create database qtest1 character set UTF8mb4 collate utf8mb4_bin;
Query OK, 1 row affected (0.00 sec)
-- View the create database statement used for creating db
mysql> SHOW CREATE DATABASE qtest1;
View database list
mysql> show databases;
mysql> select * from information_schema.schemata;
mysql> show databases like 'QTEST%';
No comments:
Post a Comment