- Find existing databases: show databases;
- Create a database: Create database [myDB]
- Select a database to use: Use [myDB]
- Show tables in current database: Show tables;
- Create a table: Create table student(id varchar(10), name varchar(50), age INT)
- Show details of a table: Describe [tablename]
- Show current user detial: Select current_user()
Last active
November 4, 2018 06:27
-
-
Save brijesh-deb/a52cdd80b490ee81b49fb1c2ec1c4430 to your computer and use it in GitHub Desktop.
#MySQL #HandsOn
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment