05 2021 档案

phpmyadmin创建mysql的存储过程
摘要：DELIMITER $$ CREATE PROCEDURE `sp_insert_test_users`(IN `para_count` INT) BEGIN DECLARE p_username varchar(50); DECLARE p_countryCallingCode varchar(1 阅读全文
posted @ 2021-05-05 23:06 jshaibozhong 阅读(153) 评论(0) 推荐(0)
mysql中字符查询与替换
摘要：select * from tablename where column like "%str%" 查询表中的某列里包含某str的行 update ear_bbs_threads_content set content = replace(content, substring(content, lo 阅读全文
posted @ 2021-05-05 12:38 jshaibozhong 阅读(763) 评论(0) 推荐(0)