Difference between revisions of "SRA840 Lab7"

From CDOT Wiki
Jump to: navigation, search
(Milton)
(Milton)
Line 26: Line 26:
  
 
6. delete records from the table you created
 
6. delete records from the table you created
 +
 +
mysql> delete from ''table_name'' where name='johndoe';

Revision as of 17:37, 11 April 2009

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 table_name set name='johndoe' where name='milton';

6. delete records from the table you created

mysql> delete from table_name where name='johndoe';