mysql
ctllin
孤芳自赏
展开
-
mysql 查询库中所有表和表中所有字段
SELECT TABLE_NAME, column_name, column_comment, CHARACTER_MAXIMUM_LENGTH FROM information_schema.COLUMNS WHERE table_schema = 'wise_base_device' AND column_name = 'store_code';原创 2020-12-29 17:33:23 · 2099 阅读 · 0 评论 -
mysql 操作日志查询
show variables like'%general_log%'; #general_log ON #general_log_file /home/data/mysql/localhost.log set global general_log = ON; tailf /home/data/mysql/localhost.log原创 2021-08-17 10:22:48 · 275 阅读 · 0 评论 -
反转性别利用二进制
user表反转sex利用二进制updateuserset`sex`=(bin(`sex`)&1)+1;原创 2021-03-23 19:05:15 · 258 阅读 · 0 评论 -
mybatis批量插入-自动适配表名自动适配表字段
@Autowired private TbUserMapper tbUserMapper; @Override public boolean saveBatch(Collection<TbUser> entityList, int batchSize) { return tbUserMapper.insertBatch(entityList, BeanUtil.getTableClassBean(TbUser.class))>0?true:f...原创 2020-12-10 17:55:38 · 560 阅读 · 0 评论 -
mysql笔记
mysqldump -h127.0.0.1 -uroot -p wise_base_channel channel_category channel_category_copy100069 channel_category_itn channel_category_itn_copy channel_store_goods channel_store_goods_copy100069 channe...原创 2019-11-14 13:52:04 · 249 阅读 · 1 评论 -
DButils工具类可以用来获取数据库连接向数据库插入更新删除对象2
package com.ctl.util; import java.awt.Color; import java.awt.Font; import java.awt.Insets; import java.awt.event.MouseAdapter; import java.awt.event.MouseEvent; import java.io.*; import java.lang.ref原创 2014-08-07 22:32:10 · 3248 阅读 · 0 评论 -
mysql获取执行插入数据后的id
package com.test.javaSe01; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.State原创 2014-03-23 16:21:21 · 2266 阅读 · 0 评论 -
C#链接MySQL
//需要添加引用MySql.Data.dll using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.原创 2013-11-13 13:44:43 · 1053 阅读 · 0 评论 -
mysql 创建存储过程 java程序调用该存储过程
CREATE TABLE SCOTT.USERS_NING ( ID NUMBER, PWD NUMBER ); insert into users_ning values(1,1234); insert into users_ning values(123,1234); CREATE PROCEDURE login_ning(IN p_id int,IN p_pwd原创 2013-05-29 11:17:11 · 2150 阅读 · 0 评论 -
删除子父节点中的某个节点
import java.sql.Connection; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; public class deleteNoteMysql { public static void main(String args[]) throw原创 2013-02-23 10:49:37 · 1646 阅读 · 0 评论