数据库常用sql语句积累

组合一个新表

select  p.*,(select value from as_info where key  = 'v51_products')  as v51_products from AP_PORTAL p

---

 表改名

rename test to test_new;

 

---