![](https://img-blog.csdnimg.cn/20201014180756918.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
SQL
moshumu1
这个作者很懒,什么都没留下…
展开
-
import data from excel file to phpMyAdmin
1.将文件a.xls 另存为a.csv 2.记事本打开a.csv,再次另存为时选择右下角编码为utf8 3.phpMyAdmin 上原创 2021-06-14 23:53:33 · 107 阅读 · 0 评论 -
a simplest example of sql select used in excel vba
https://mp.weixin.qq.com/s/aI8lRAoANKQwZaRehCN7JA原创 2021-06-07 09:37:04 · 102 阅读 · 0 评论 -
(原创)phpAdmin ,mysql 汉字拼音首字查询 解析 2021-02-27
(原创)phpAdmin ,mysql 汉字拼音首字查询解析 最近想实现这个功能,网上查询很多文章都是如下这些代码。 BEGIN DECLARE V_RETURN VARCHAR(255); DECLARE V_FIRST_CHAR VARCHAR(2); SET V_FIRST_CHAR = UPPER(LEFT(PARAM,1)); SET V_RETURN = V_FIRST_CHAR; IF LENGTH( V_FIRST_CHAR) <> ..原创 2021-02-27 15:26:08 · 201 阅读 · 1 评论 -
Delete images from the ACCESS database,image as a filter
string sql = "DELETE* from picInfo where pic=@img"; DBHelper.OpenConnection();//DBHelper is a class with a method OpenConnection and a method Connection OleDbCommand comm = new OleDbCommand(sql, DB...原创 2020-02-04 10:16:05 · 128 阅读 · 0 评论