《MYSQL數(shù)據(jù)庫如何用word vb宏來生成sql》要點：
本文介紹了MYSQL數(shù)據(jù)庫如何用word vb宏來生成sql，希望對您有用。如果有疑問，可以聯(lián)系我們。
昨天BOSS下了個命令讓我用word宏的方式來快速生成sql,這樣在我們建表的時候就不用在一條一條元數(shù)據(jù)的輸入.從而提高效率節(jié)約成本：MYSQL數(shù)據(jù)庫
接到命令后就開始著手來做,一邊上網(wǎng)搜相關的現(xiàn)成的材料,一邊看vb宏的視頻教程.終于讓我寫出了這個程序,雖說有點兒小吧,可是感覺挺好的.MYSQL數(shù)據(jù)庫
這里的vb宏要針對固定的數(shù)據(jù)庫數(shù)據(jù)字典表格進行的.
由于代碼太長就不拿出來了,這里是word中的表格式和vb運行后的結果如下：
MYSQL數(shù)據(jù)庫
|
文件名稱MYSQL數(shù)據(jù)庫 |
T_TestMYSQL數(shù)據(jù)庫 |
中文描述MYSQL數(shù)據(jù)庫 |
用戶信息表MYSQL數(shù)據(jù)庫 |
||||||
|
序MYSQL數(shù)據(jù)庫 號MYSQL數(shù)據(jù)庫 |
字段名MYSQL數(shù)據(jù)庫 |
中文說明MYSQL數(shù)據(jù)庫 |
數(shù)據(jù)類型MYSQL數(shù)據(jù)庫 |
長度MYSQL數(shù)據(jù)庫 |
缺省MYSQL數(shù)據(jù)庫 |
允許MYSQL數(shù)據(jù)庫 空值MYSQL數(shù)據(jù)庫 |
主鍵MYSQL數(shù)據(jù)庫 |
||
|
1MYSQL數(shù)據(jù)庫 |
useridMYSQL數(shù)據(jù)庫 |
主鍵IDMYSQL數(shù)據(jù)庫 |
IntegerMYSQL數(shù)據(jù)庫 |
10MYSQL數(shù)據(jù)庫 |
?MYSQL數(shù)據(jù)庫 |
?MYSQL數(shù)據(jù)庫 |
√MYSQL數(shù)據(jù)庫 |
||
|
2MYSQL數(shù)據(jù)庫 |
usernameMYSQL數(shù)據(jù)庫 |
用戶名MYSQL數(shù)據(jù)庫 |
VarcharMYSQL數(shù)據(jù)庫 |
50MYSQL數(shù)據(jù)庫 |
ChenMYSQL數(shù)據(jù)庫 |
?MYSQL數(shù)據(jù)庫 |
?MYSQL數(shù)據(jù)庫 |
||
|
3MYSQL數(shù)據(jù)庫 |
passwordMYSQL數(shù)據(jù)庫 |
密碼MYSQL數(shù)據(jù)庫 |
VarcharMYSQL數(shù)據(jù)庫 |
30MYSQL數(shù)據(jù)庫 |
我的MYSQL數(shù)據(jù)庫 |
?MYSQL數(shù)據(jù)庫 |
?MYSQL數(shù)據(jù)庫 |
||
|
4MYSQL數(shù)據(jù)庫 |
telephoneMYSQL數(shù)據(jù)庫 |
用戶電話MYSQL數(shù)據(jù)庫 |
VarcharMYSQL數(shù)據(jù)庫 |
20MYSQL數(shù)據(jù)庫 |
112323MYSQL數(shù)據(jù)庫 |
?MYSQL數(shù)據(jù)庫 |
?MYSQL數(shù)據(jù)庫 |
||
|
5MYSQL數(shù)據(jù)庫 |
AddressMYSQL數(shù)據(jù)庫 |
用戶地址MYSQL數(shù)據(jù)庫 |
VarcharMYSQL數(shù)據(jù)庫 |
50MYSQL數(shù)據(jù)庫 |
sssMYSQL數(shù)據(jù)庫 |
√MYSQL數(shù)據(jù)庫 |
?MYSQL數(shù)據(jù)庫 |
||
|
6MYSQL數(shù)據(jù)庫 |
DiscriptionMYSQL數(shù)據(jù)庫 |
用戶介紹MYSQL數(shù)據(jù)庫 |
VarcharMYSQL數(shù)據(jù)庫 |
200MYSQL數(shù)據(jù)庫 |
sssssMYSQL數(shù)據(jù)庫 |
√MYSQL數(shù)據(jù)庫 |
?MYSQL數(shù)據(jù)庫 |
||
|
8MYSQL數(shù)據(jù)庫 |
jjjjjjMYSQL數(shù)據(jù)庫 |
試試看MYSQL數(shù)據(jù)庫 |
varcharMYSQL數(shù)據(jù)庫 |
122MYSQL數(shù)據(jù)庫 |
333MYSQL數(shù)據(jù)庫 |
?MYSQL數(shù)據(jù)庫 |
?MYSQL數(shù)據(jù)庫 |
||
|
7MYSQL數(shù)據(jù)庫 |
hhhhMYSQL數(shù)據(jù)庫 |
試試看撒MYSQL數(shù)據(jù)庫 |
VarcharMYSQL數(shù)據(jù)庫 |
23MYSQL數(shù)據(jù)庫 |
111MYSQL數(shù)據(jù)庫 |
?MYSQL數(shù)據(jù)庫 |
?MYSQL數(shù)據(jù)庫 |
||
|
?MYSQL數(shù)據(jù)庫 |
?MYSQL數(shù)據(jù)庫 |
?MYSQL數(shù)據(jù)庫 |
?MYSQL數(shù)據(jù)庫 |
?MYSQL數(shù)據(jù)庫 |
?MYSQL數(shù)據(jù)庫 |
?MYSQL數(shù)據(jù)庫 |
?MYSQL數(shù)據(jù)庫 |
||
|
?MYSQL數(shù)據(jù)庫 |
?MYSQL數(shù)據(jù)庫 |
?MYSQL數(shù)據(jù)庫 |
?MYSQL數(shù)據(jù)庫 |
?MYSQL數(shù)據(jù)庫 |
?MYSQL數(shù)據(jù)庫 |
?MYSQL數(shù)據(jù)庫 |
?MYSQL數(shù)據(jù)庫 |
||
轉載請注明本頁網(wǎng)址：
http://www.snjht.com/jiaocheng/1624.html
