happy cat image

everdevel

coding

login
NotificationX
  • Currently, only notices of comments are displayed.
  • no comment or please login

MySQL command

kinds

command

creating database

CREATE DATABASE database name;

view database list

SHOW DATABASES;

Select database to work with

USE database name;

creating table

CREATE TABLE table name;

View all fields in the table

desc or describe table name

Add data to the table

INSERT INTO table name VALUES(data, data, data)

View all data in the table

SELECT * FROM table name;





Frequently Used Commands

kinds

command

meaning

Database commands

create

Creation of database

drop

Deletion of the database

use

Database selection

Table command

create

Create Table

desc or describe

Table structure

alter

Change field in table

rename

Rename Table

drop

Drop table

Data manipulation instruction

insert

Record input

select

record search

update

Record changes

delete

Delete record

Database backup and restore

mysqldump

Database backup

mysql

Database restore


Thank you for visiting. If you have any inquiry or explanation of mistakes, please use the comments below.


    
    

Back to the course

ALL COMMENTS 0

Sort by