Search
 
SCRIPT & CODE EXAMPLE
 

SQL

mysql list databases

SHOW DATABASES;
Comment

how to list mysql databases

mysql -e 'show databases;'
Comment

view databases in mysql

mysql> SHOW DATABASES;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| pets               |
| sys                |
+--------------------+
5 rows in set (0.00 sec)
Comment
PREVIOUS NEXT
Code Example
Sql :: kill session inactive oracle 
Sql :: encrypt password postgresql 
Sql :: check if has alpha characters sql 
Sql :: if null mysql 
Sql :: rename table sql server 
Sql :: What is dialect for Postgres 
Sql :: How can I tell how many Cores SQL Server is actually using? 
Sql :: oracle sql drop column if exists 
Sql :: mysql check if lowercase 
Sql :: print integer and string in SQL 
Sql :: mysql select default if null 
Sql :: creating postgresSQL database using the the shell 
Sql :: change mariadb to mysql xampp 
Sql :: mysql like case sensitive 
Sql :: sql if empty then 
Sql :: get last 50 rows sql 
Sql :: mysql stored procedure vs function 
Sql :: sql inner join with where clause 
Sql :: MYSQLI_ASYNC 
Sql :: postgres update with if condition query 
Sql :: mariadb date equals to current_date plus days 
Sql :: mysql select distinct date from timestamp 
Sql :: postgres update single column 
Sql :: sqlite3 turn off case sensitive 
Sql :: oracle nvl 
Sql :: run sql script from command line 
Sql :: get sum sqlite android 
Sql :: sql left 
Sql :: alter table query sql server change column 
Sql :: mysql disable logging 
ADD CONTENT
Topic
Content
Source link
Name
8+4 =