Open main menu

CDOT Wiki β

Changes

SRA840 Lab7

90 bytes added, 16:35, 11 April 2009
Milton
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