PROGRAMMING
REMEMBERS
Login
☰
Php
97
Java
89
Python
53
Javascript
37
Git
22
Regex
27
Ubuntu
33
Mysql
27
Antipatterns
16
MLearning
10
Mysql
/
Administration
1
Select
9
Order by rand
Concat fields
Between
Regexp
If null
Union
Replace
Using syntax
Substring
2
Date
5
Get date
Format
Today
Month day
Parts
3
Administration
13
Foreign key
Foreign key disable
Innodb
Create database
Create table
Add column
Add index
Data type
Primary key
Errors
Indexes
Mysqldump
Table definition
/
Create database
➟
➟
Last update: 29-10-2021
1
2
3
Create
CREATE
DATABASE
[
IF
NOT
EXISTS
] mydb;
➥
Use (2/3)
Use
USE
DATABASE
mydb;
➥
Remove (3/3)
Remove
DROP
DATABASE
[
IF
EXISTS
] mydb;
➥
Questions
➟
Create table
Administration
Foreign key
Foreign key disable
Innodb
Create database
Create table
Add column
Add index
Data-type
Primary key
Errors
Indexes
Mysqldump
Table definition
A
B
C
D
E
F
🔔
0
???
How do you create a database?
CREATE DATABASE mydb
ADD DB mydb
???
How do you remove a database?
DROP DATABASE mydb
DELETE DATABASE mydb
1/2
⟲
➟
Main Reference
High Performance MySQL
amazon.com
↯
PROGRAMMING
»
MYSQL
»
ADMINISTRATION
»
CREATE DATABASE
User:
Login
|
Privacy Policy
|
Powered by:
minte9.com
CSS
bootstrap
|
highlight.php
Fair use
PROGRAMMING
Php
