Difference between revisions of "SRA840 Lab7"
Milton.paiva (talk | contribs) (→Milton) |
Milton.paiva (talk | contribs) (→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''; | ||
| − | |||
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 17: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
