SoftTestingStudying的专栏

mysql存储过程的创建，删除，调用及其他常用命令mysql 5.0存储过程学习总结一.创建存储过程1.基本语法：create procedure sp_name()begin………end2.参数传递二.调用存储过程1.基本语法：call sp_name()注意：存储过程名称后面必须加括号，哪怕该存储过程没有参数传递三.删除存储过程1.基本语法：drop procedure

select to_timestamp(time/1000),time,apname from test_user limit 2;select to_timestamp(time/1000) from test_user where to_char(to_timestamp(time/1000),YYYYMMDD)=20110621 limit 5; select to_time

create procedure bb_test_updatedb()begindeclare test_i int default 0; declare test_char varchar(255) default test;InsertDB: while(test_iset test_char= convert(test_i,char);update bb_test_ssid SET

declare @strA varchar(100)declare @strB varchar(100)declare @i intdeclare @IsSame realselect @strA = abc,@strB = abd,@i = 1,@IsSame = 1while (@i begin if substring(@strA,@i,1) = substring(@strB,

new:DROP PROCEDURE IF EXISTS badboy.new_bb_test_user_InsertDB;CREATE PROCEDURE badboy.`new_bb_test_user_InsertDB`()begindeclare test

一、jsp连接Oracle8/8i/9i数据库（用thin模式）　　testoracle.jsp如下：　　　　　　　　　　　　String url="jdbc:oracle:thin:@localhost:1521:orcl";　　//orcl为你