单表更新teledb=# update teledb_serial set nickname = 'random value' where id = 2; UPDATE 1 teledb=# select * from teledb_serial; id | nickname ----+--------------- 1 | hello teledb 2 | random value (2 rows)null 条件的表达方法。
单条件查询teledb=# select * from teledb_pg where id =1; id | nickname ----+------------ 1 | teledb 1 | hello,pgxc (2 rows)多条件andteledb=# select * from teledb_pg where id =1 and nickname like '%h%' ; id | nickname ----+------------ 1 | hello,pgxc (1 row)多条件
单表更新teledb=# update teledb_serial set nickname = 'random value' where id = 2; UPDATE 1 teledb=# select * from teledb_serial; id | nickname ----+--------------- 1 | hello teledb 2 | random value (2 rows)null 条件的表达方法。
单条件查询 teledb=# select * from teledb_pg where id =1; id | nickname ----+------------ 1 | teledb 1 | hello,pgxc (2 rows) 多条件and teledb=# select * from teledb_pg where id =1 and nickname like '%h%' ; id | nickname ----+------------ 1 | hello,pgxc (1 row
单条件查询teledb=# select * from teledb_pg where id =1; id | nickname ----+------------ 1 | teledb 1 | hello,pgxc (2 rows)多条件andteledb=# select * from teledb_pg where id =1 and nickname like '%h%' ; id | nickname ----+------------ 1 | hello,pgxc (1 row)多条件
单表更新teledb=# update teledb_serial set nickname = 'random value' where id = 2; UPDATE 1 teledb=# select * from teledb_serial; id | nickname ----+--------------- 1 | hello teledb 2 | random value (2 rows)null 条件的表达方法。