본문 바로가기
2022/DB 데이터베이스

[DB] 221201 실습

by Or0i쿠 2022. 12. 4.

create user 'movie_user'@'%' identified by '1234';
grant all on movieDB.* to 'movie_user'@'%' with grant option;

drop database if exists movieDB;
create database if not exists movieB;

use movieDB;
create table if not exists movie(
id int not null auto_increment primary key,
title varbinary(20) not null,
genre varchar(20) null,
myear date null,
price int null,
photo varchar(50) null);