<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[PaperVeg的博客]]></title><description><![CDATA[]]></description><link>https://blog.csdn.net/PaperVeg</link><language>zh-cn</language><generator>https://blog.csdn.net/</generator><copyright><![CDATA[Copyright &copy; PaperVeg]]></copyright><item><title><![CDATA[Mysql 查询有库里有多少个表,多少个存储过程,多少个函数,多少个视图]]></title><link>https://blog.csdn.net/PaperVeg/article/details/105664017</link><guid>https://blog.csdn.net/PaperVeg/article/details/105664017</guid><author>PaperVeg</author><pubDate>Tue, 21 Apr 2020 18:07:04 +0800</pubDate><description><![CDATA[心情一般般,不想解释,自己看代码有注释
SELECT COUNT(*)  ttl, CONCAT(table_schema,"-Table") addr FROM information_schema.TABLES   
WHERE table_schema = '数据库名字' -- 查询多少个表
UNION 
SELECT COUNT(*)  ttl,  CONCAT(table_schema,...]]></description><category></category></item><item><title><![CDATA[css把控制单行字符长度过长显示省略号]]></title><link>https://blog.csdn.net/PaperVeg/article/details/95171301</link><guid>https://blog.csdn.net/PaperVeg/article/details/95171301</guid><author>PaperVeg</author><pubDate>Tue, 09 Jul 2019 10:20:44 +0800</pubDate><description><![CDATA[不想说话,直接看代码,有注释.

&lt;span style="width: 200px; overflow:hidden;text-overflow:ellipsis; white-space: nowrap;"&gt;
	testtesttesttesttesttesttesttesttesttesttesttesttest
&lt;/span&gt;
	&lt;!--主要是修改widt...]]></description><category></category></item><item><title><![CDATA[jq删除select标签的某些选项(option)或者使整个select不可用不可选]]></title><link>https://blog.csdn.net/PaperVeg/article/details/94393740</link><guid>https://blog.csdn.net/PaperVeg/article/details/94393740</guid><author>PaperVeg</author><pubDate>Mon, 01 Jul 2019 15:44:04 +0800</pubDate><description><![CDATA[心情hei差.自己看下面的代码和注释吧

		&lt;select id="stype" name="stype"&gt;
                  &lt;option value="1"&gt;test&lt;/option&gt;
                  &lt;option value="2"&gt;test2&lt;/option&gt;
            ...]]></description><category></category></item><item><title><![CDATA[MYSQL截取小数部分和获取小数位数,只查询带小数的数据,和substring_index函数用法,LENGTH函数用法]]></title><link>https://blog.csdn.net/PaperVeg/article/details/93617761</link><guid>https://blog.csdn.net/PaperVeg/article/details/93617761</guid><author>PaperVeg</author><pubDate>Tue, 25 Jun 2019 14:30:40 +0800</pubDate><description><![CDATA[心情不好不想多说,直接复制代码执行看效果或者看注释吧

		SELECT LENGTH(SUBSTRING_INDEX(1.123456,'.',-1)) ,SUBSTRING_INDEX(1.123456,'.',-1)     -- 1.123456为你要截取的原数值,SUBSTRING_INDEX函数和length函数请看下面的用法

substring_index() 函数为按照特殊字符...]]></description><category></category></item><item><title><![CDATA[MYSQL把某个字段特定值的数据置顶]]></title><link>https://blog.csdn.net/PaperVeg/article/details/91581811</link><guid>https://blog.csdn.net/PaperVeg/article/details/91581811</guid><author>PaperVeg</author><pubDate>Wed, 12 Jun 2019 18:05:04 +0800</pubDate><description><![CDATA[心情一般般,不想解释,自己看吧,有注释
请看下面的表,需要把sys_id为20数据置顶,使用下面的sql语句即可
![在这里插入图片描述](https://img-blog.csdnimg.cn/20190612180403588.png)

SELECT * FROM test WHERE id&gt;0 ORDER BY sys_id=20 DESC -- 可以在后面加更多的排序条件,例如加上...]]></description><category></category></item><item><title><![CDATA[c++创建文件句柄使图片的base64的数据流转为实际图片文件]]></title><link>https://blog.csdn.net/PaperVeg/article/details/90485462</link><guid>https://blog.csdn.net/PaperVeg/article/details/90485462</guid><author>PaperVeg</author><pubDate>Thu, 23 May 2019 18:10:14 +0800</pubDate><description><![CDATA[需要用到的主要的头文件
		#include &lt;stdio.h&gt;
		心情不错,不想解释,看代码,有注释

#include &lt;stdio.h&gt;
void test()
{
	char * buf_data;
	long buf_len;
	char root[384]="";//需要存放图片的文件夹路径

	//开启一个文件句柄
	FILE *fid =fopen(r...]]></description><category></category></item><item><title><![CDATA[html页面实现手写签名功能和一些参数设置]]></title><link>https://blog.csdn.net/PaperVeg/article/details/90449240</link><guid>https://blog.csdn.net/PaperVeg/article/details/90449240</guid><author>PaperVeg</author><pubDate>Wed, 22 May 2019 18:11:04 +0800</pubDate><description><![CDATA[需要用到的js : jSignature.min.js, jquery-3.0.0.min.js
心情不好,看底下例子代码,有注释

&lt;!DOCTYPE html&gt;
&lt;html lang="en"&gt;
&lt;head&gt;
    &lt;meta charset="UTF-8"&gt;
    &lt;title&gt;Document&lt;/title&gt;
  ...]]></description><category></category></item><item><title><![CDATA[js把html的代码转换成图片的base64 编码的数据流]]></title><link>https://blog.csdn.net/PaperVeg/article/details/89965619</link><guid>https://blog.csdn.net/PaperVeg/article/details/89965619</guid><author>PaperVeg</author><pubDate>Wed, 08 May 2019 18:13:16 +0800</pubDate><description><![CDATA[1.需要用到加载到的js
		html2canvas.min.js
		获取需要装换图片的dom对象,可以是一个table 或者div 或者整个body标签
		例子为用的是div
			代码如下

&lt;!DOCTYPE html&gt;
&lt;html lang="en"&gt;
&lt;head&gt;
    &lt;meta charset="UTF-8"&gt;
    &lt...]]></description><category></category></item><item><title><![CDATA[js给label赋值功能]]></title><link>https://blog.csdn.net/PaperVeg/article/details/89467453</link><guid>https://blog.csdn.net/PaperVeg/article/details/89467453</guid><author>PaperVeg</author><pubDate>Tue, 23 Apr 2019 10:30:14 +0800</pubDate><description><![CDATA[1.html 创建一个带有id的label标签
2.在需要的地方使用document.getElementById(‘test1’).innerHTML ="&lt;你需要赋值的内容&gt;" (例子上是一个按钮触发的赋值)
3.先看效果可以在W3chool 测试 http://www.w3school.com.cn/tiy/t.asp?f=html_script (把底下代码附上去提交即可)
&...]]></description><category></category></item></channel></rss>