汇成软件 Create the world!!!

批量插入

一条insert语句批量插入多条记录

原创|浏览:138554|更新:2017-12-19 08:21

一条insert语句批量插入多条记录


常见的insert语句,向数据库中,一条语句只能插入一条数据:


insert into persons 


(id_p, lastname , firstName, city )


作者:admin 分类:php 浏览:616 评论:0

MYSQL当天日期

SELECT CURDATE()


当天日期


作者:admin 分类:mysql 浏览:532 评论:0

paypal开发


快捷生成js收款按钮

采用SDK录入数据库


关键:要把沙盒地址修改成正式地址


作者:admin 分类:PayPal 浏览:579 评论:0

js与jquery自动触发a链接的方法

自动触发a链接的方法如下:

1.

<body >
 <a  href="http://www.shengmake.net" ><span>Affiliate</span></a> 
</body>
<script src="jquery-3.6.0.min.js"></script>

<script type="text/javascript">
 $(document).ready(function() {
     setTimeout(function() {
  $("span").click();
    }, 1000);
  
 
 });
 
</script>
作者:admin 分类:前端技术 浏览:533 评论:0

php替换函数--数组写法

<?php 

$my_name='&&&&';

//echo  substr(xml_entities($my_name),0,135);
ECHO xml_entities($my_name);


function xml_entities($string) {
    return strtr(
        $string, 
        array(
            "<" => "",
            ">" => "",
            '"' => "",
            "'" => "",
            "&" => "",
            "|" => "",
            "-" => "",
            "–" => "",
            ":" => "",
            "Ⅱ" => "2",
            
        )
    );
}
 ?>
作者:admin 分类:php 浏览:606 评论:0

Can herpes be cured for Traditional Chinese medicin?

        Can herpes be cured,Traditional Chinese medicine can cure herpes. Traditional Chinese medicine mostly adopts the method of syndrome differentiation and treatment, and chooses the appropriate Chinese medicine according to the condition of the disease. If it is liver meridian fever, the patient's skin will feel burning and tingling, and the mouth will be bitter and the throat will be dry. At this time, you need to take some traditional Chinese medicines for clearing away heat and detoxification. You can take some Longdan Xiegan Decoction, mainly decoction of gentian grass, gardenia, mutong, rehmannia, chaihu and other medicines, which can help clear the liver. You can also take Xieqing Pills, decoction of Chinese angelica, chuanxiong, rhubarb, Qianghuo and other medicines, which can also alleviate the condition.

统计mysql字段值的长度

SELECT product_brand  FROM shop_product WHERE LENGTH(product_brand)>3;


作者:admin 分类:mysql 浏览:619 评论:0

mysql 选择字段第一个空格前的内容

 判断字符串(string)中是否包含另一个字符串(subStr)

locate(subStr,string) :函数返回subStr在string中出现的位置

实际运用

作者:admin 分类:mysql 浏览:824 评论:0

建议中国卖家放弃谷歌的GMC

原因有三

  1. 不信任中国人,认为中国的独立站都是骗人的

  2. 审核非常严格:99.9%的网站审核不通过

  3. 要符合谷歌的要求,网站基本上重新做一遍



作者:admin 分类:网站运营 浏览:552 评论:0