Open main menu

CDOT Wiki β

SRA840 Lab7

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

Milton

1. give and remove user rights

1.1 Give privileges:

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

1.2 Remove privileges:

mysql> flush privileges;

2. create a table

mysql> create table table_name (name char(20));

3. insert a few records into the table you created

mysql> insert into table_name values('milton');

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

mysql> select name from table_name;

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

mysql> update mxx set name='john' where name='milton';

6. delete records from the table you created