mysql中用命令行复制表结构的方法主要有一下几种: 1.只复制表结构到新表 CREATE TABLE 新表 SELECT * FROM 旧表 WHERE 1=2;或 CREATE TABLE 新表 LIKE 旧表 ; 注意上面两种方式,前一种方式是不会复制时的主键类型和自增方式是不会复制过去的,而    Read More
posted @ 2019-12-26 14:33
xiaotian_小天
Views(544)
Comments(0)
Diggs(0)
        
            
        
        
        
package com.hxkr.util; import net.sourceforge.pinyin4j.PinyinHelper; import net.sourceforge.pinyin4j.format.HanyuPinyinCaseType; import net.sourceforge.pinyin4j.format.HanyuPinyinOutputFormat; import     Read More
posted @ 2019-12-26 14:32
xiaotian_小天
Views(312)
Comments(0)
Diggs(0)
        
            
        
        
        
mysql 遍历查询所有父级: SELECT T1._id groupID FROM ( SELECT @r AS _id, (SELECT @r := fbh FROM business_group WHERE bh = _id) AS fbh, @l := @l + 1 AS lvl FROM     Read More
posted @ 2019-12-26 14:30
xiaotian_小天
Views(5001)
Comments(0)
Diggs(0)
        
 
                    
                
 
 浙公网安备 33010602011771号
浙公网安备 33010602011771号