Java技术

SELECT prp.app_no, CASE prp.app_no WHEN '111111' THEN 'aaaa' WHEN '2222' THEN 'bbbb' ELSE 'ccccc' END AS a_noFROM pa_r_pan prp

存储过程1.向表中添加数据的存储过程create or replace procedure gxs_add_2(g_id in number,g_name in varchar,g_sex in varchar,g_address in varchar) asbegin insert into gxs_stu_info (id,name,sex,address) values(g_id,g_name,g_sex,g_address);end gxs_add_2;...

启动MySQL：service mysqld start关闭MySQL：service mysqld stop重启MySQL：service mysqld restart查看服务状态：service mysqld status设置MySQL开机启动：chkconfig mysqld on

DELETE FROM customer WHERE id<>71