Home > Database > Mysql Tutorial > 05-mysql的基本使用_MySQL

05-mysql的基本使用_MySQL

WBOY
Release: 2016-06-01 13:07:03
Original
993 people have browsed it

1.查看数据库,表
show databases;
show tables;

2.使用某一个数据库
use mysql;

3.创建数据库,表
create database  test;
create table test_student(user_ID int);

4.查看表中的内容
select * from test_student;

5.删除数据库,表
drop database test;
drop table test_student;

source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template