Skip to content

Instantly share code, notes, and snippets.

@d-smith

d-smith/basic-ddl.sql

Last active February 19, 2016 19:43
Show Gist options
  • Save d-smith/4049dbe1856b40f73e53 to your computer and use it in GitHub Desktop.
Save d-smith/4049dbe1856b40f73e53 to your computer and use it in GitHub Desktop.
Download ZIP
mariadb basics
Raw
basic-ddl.sql
show databases;
create database roll;
create user rolluser identified by 'rollpw';
create table if not exists roll.sample (
name varchar(128) primary key,
value varchar(256)
)
grant select, update, insert, delete
on roll.sample
to rolluser;
/* login as rolluser */
use roll;
select count(*) from sample;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment