Open main menu

CDOT Wiki β

SRA840 Lab7

Revision as of 17:30, 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

insert into table_name values('milton');

4. select some of the records in the table you created

select name from table_name;

5. change some of the records into the table you created


6. delete records from the table you created