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 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