Skip to content

Instantly share code, notes, and snippets.

@boina-n

boina-n/gist:a413549622d364c415edb9e62bf11c26

Created December 28, 2018 16:13
Show Gist options
  • Save boina-n/a413549622d364c415edb9e62bf11c26 to your computer and use it in GitHub Desktop.
Save boina-n/a413549622d364c415edb9e62bf11c26 to your computer and use it in GitHub Desktop.
Download ZIP
because i suck in mysql ... How to create a simple mysql DB with records
Raw
gistfile1.txt
create database boina-n_db01;
show databases;
use boina-n_db01;
create table mytable01 (name varchar(20), sex CHAR(1), birth DATE);
SHOW TABLES;
inset into mytable01 value ('boina-n','M','1989-12-22')
select * from mytable01;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment