Difference between revisions of "SRA840 Lab7"

From CDOT Wiki
Jump to: navigation, search
(Milton)
(Milton)
Line 4: Line 4:
  
 
1.1 Give privileges:
 
1.1 Give privileges:
  grant all on wordpress.* to wordpress@localhost identified by 'password';
+
  mysql> grant all on wordpress.* to wordpress@localhost identified by 'password';
  
 
1.2 Remove privileges:
 
1.2 Remove privileges:
  flush privileges;
+
  mysql> flush privileges;
  
 
2. create a table
 
2. create a table
  
  create table ''table_name'' (name char(20));
+
  mysql> create table ''table_name'' (name char(20));
  
 
3. insert a few records into the table you created
 
3. insert a few records into the table you created
  
  insert into ''table_name'' values('milton');
+
  mysql> insert into ''table_name'' values('milton');
  
 
4. select some of the records in the table you created
 
4. select some of the records in the table you created
  
  select name from ''table_name'';
+
  mysql> select name from ''table_name'';
  
 
5. change some of the records into the table you created
 
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
 
6. delete records from the table you created

Revision as of 17:35, 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 mxx set name='john' where name='milton';

6. delete records from the table you created