Open main menu

CDOT Wiki β

SRA840 Lab7

Revision as of 16:25, 11 April 2009 by Milton.paiva (talk | contribs) (Milton)

Milton

1. give and remove user rights

1.1 Give privileges:

grant all on wordpress.* to wordpress@localhost identified by 'password';

1.2 Remove privileges:

flush privileges;

2. create a table

create table table_name (name char(20));

3. insert a few records into the table you created


4. select some of the records in the table you created 5. change some of the records into the table you created 6. delete records from the table you created