CTLLIN的专栏

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';

show variables like'%general_log%';#general_log ON#general_log_file /home/data/mysql/localhost.logset global general_log = ON;tailf /home/data/mysql/localhost.log

user表反转sex利用二进制updateuserset`sex`=(bin(`sex`)&1)+1;

@Autowired private TbUserMapper tbUserMapper; @Override public boolean saveBatch(Collection<TbUser> entityList, int batchSize) { return tbUserMapper.insertBatch(entityList, BeanUtil.getTableClassBean(TbUser.class))>0?true:f...

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...

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

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

//需要添加引用MySql.Data.dllusing System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Windows.

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

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