pollsetup.sql

来自「php源码 php源码参考」· SQL 代码 · 共 22 行

create database poll;

use poll;

create table poll_results (
			     candidate varchar(30),
			     num_votes int
);

insert into poll_results values 
  ('John Smith', 0),
  ('Mary Jones', 0),
  ('Fred Bloggs', 0)
; 

grant all privileges
on poll.*			
to poll@localhost 
identified by 'poll';