Red Hat NETSCAPE MANAGEMENT SYSTEM 6.0 - COMMAND-LINE Uživatelský manuál stáhnout pdf (Strana 25)

DROP TABLE table_name;

DROP DATABASE db_name;

SHOW COLUMNS FROM table_name;

select * from users;

select * from systems;

select * from changes;

select * from users order by user_first_name;

select * from users order by user_first_name desc;

select * from users order by user_last_name;

select * from users order by user_last_name desc;

select * from users where user_last_name = 'Westbrook';

select * from users where user_last_name != 'Westbrook';

select * from users where user_first_name = 'Matt';

select * from users where user_first_name != 'Matt';

select * from users where user_first_name like 'B%';

select * from users where user_first_name like 'M%';

select * from users where user_first_name like '%r';

UPDATE table_name SET column1_name=’new_value’ where

column_name=’current_value’;

UPDATE systems SET system_name='IISMBS' WHERE

system_name='jax-vst1';

Change password:

set password for change_user@localhost=password('password');

Delete specific row(s) in a table:

delete from table_name where column_name=criteria;

Delete all rows in a table:

delete from table_name;

truncate table_name;

1 2 ... 20 21 22 23 24 25 26 27 28 29 30 ... 59 60

Žádné komentáře

Red Hat NETSCAPE MANAGEMENT SYSTEM 6.0 - COMMAND-LINE Uživatelský manuál Strana 25