Difference between revisions of "SRA840 Lab7"

From CDOT Wiki
Jump to: navigation, search
(Milton)
(Milton)
Line 15: Line 15:
 
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');
  
 +
4. select some of the records in the table you created
 +
 +
select name from ''table_name'';
  
4. select some of the records in the table you created
 
 
5. change some of the records into the table you created
 
5. change some of the records into the table you created
 +
 +
 +
 
6. delete records from the table you created
 
6. delete records from the table you created

Revision as of 16:30, 11 April 2009

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