In SSMS in the Object Explorer, right click on the database right-click and pick "Tasks" and then "Generate Scripts". This will allow you to generate scripts for a single or all tables, and one of the options is "Script Data"
--by zhuyj 显示&select ‘\&s’ from dual; --注意必须要加引号 --by zhuyjcreate or replace function fun_export_data( v_tablename in varchar2, v_condition in varchar2 )return varchar2 is/*by zhuyj 20171130*/ cursor cur(v_tablename varchar2) is select column_name
CREATE TABLE IF NOT EXISTS `pihealth`.`warning_events` ( `wid` INT NOT NULL AUTO_INCREMENT, `wtime` DATETIME NOT NULL, `wip` VARCHAR(20) NOT NULL, `wtype` INT(5) NOT NULL, `wdetails` VARCHAR(255) NULL, PRIMARY KEY (`wid`), UNIQUE INDEX `wid_UNIQUE` (