- @echo off
- echo 南无七俱胝佛母大圣准提王菩萨 !!!
- echo 南无七俱胝佛母大圣准提王菩萨 !!!
- echo 南无七俱胝佛母大圣准提王菩萨 !!!
- echo 敬礼佛母!!!
- set "database=luqd"
- set "table=user"
- rem 创建数据表的字段(含括号的需加^):
- rem ************************************
- set "Column1=id"
- set "Column1_key=int"
- set "column2=userid"
- set "Column2_key=varchar^(20^)"
- ::set "column3=sex"
- ::set "Column3_key=varchar^(2^)"
- ::set "column4=age"
- ::set "Column4_key=int"
- ::set "column5=tel"
- ::set "Column5_key=int"
- ::set "column6=email"
- ::set "Column6_key=varchar^(30^)"
- ::set "column7=address"
- ::set "Column7_key=varchar^(100^)"
- ::set "column8=beizhu"
- ::set "Column8_key=varchar^(150^)"
- rem ***********************************
- set mysqlpath=D:\amp\mysql\bin
- mode con cols=95
- cd.>mysql.sql
- rem 先删除数据库%database%.
- ::echo drop database %database%; >>mysql.sql
- rem 后创建数据库%database%.
- echo create database %database%; >>mysql.sql
- echo use %database%; >>mysql.sql
- setlocal enabledelayedexpansion
- for %%j in (%Column1% %Column2% %Column3% %Column4% %Column5% %Column6% %Column7% %Column8%) do set columns=!columns!%%j,
- for %%k in (%Column1% %Column2% %Column3% %Column4% %Column5% %Column6% %Column7% %Column8%) do set end=%%k
- rem echo "%columns:~,-2%" & echo "%end%"
- rem 不创建数据表,直接插入记录到%table%表.
- ::goto :insert
- echo create table %table% ^(>>mysql.sql
- if "%Column1%" neq "" if "%Column1%" neq "%end%" ( echo %Column1% %Column1_key% ,>>"%~dp0mysql.sql"
- ) else echo %Column1% %Column1_key% >>"%~dp0mysql.sql"
- if "%Column2%" neq "" if "%Column2%" neq "%end%" ( echo %Column2% %Column2_key% ,>>"%~dp0mysql.sql"
- ) else echo %Column2% %Column2_key% >>"%~dp0mysql.sql"
- if "%Column3%" neq "" if "%Column3%" neq "%end%" ( echo %Column3% %Column3_key% ,>>"%~dp0mysql.sql"
- ) else echo %Column3% %Column3_key% >>"%~dp0mysql.sql"
- if "%Column4%" neq "" if "%Column4%" neq "%end%" ( echo %Column4% %Column4_key% ,>>"%~dp0mysql.sql"
- ) else echo %Column4% %Column4_key% >>"%~dp0mysql.sql"
- if "%Column5%" neq "" if "%Column5%" neq "%end%" ( echo %Column5% %Column5_key% ,>>"%~dp0mysql.sql"
- ) else echo %Column5% %Column5_key% >>"%~dp0mysql.sql"
- if "%Column6%" neq "" if "%Column6%" neq "%end%" ( echo %Column6% %Column6_key% ,>>"%~dp0mysql.sql"
- ) else echo %Column6% %Column6_key% >>"%~dp0mysql.sql"
- if "%Column7%" neq "" if "%Column7%" neq "%end%" ( echo %Column7% %Column7_key% ,>>"%~dp0mysql.sql"
- ) else echo %Column7% %Column7_key% >>"%~dp0mysql.sql"
- if "%Column8%" neq "" if "%Column8%" neq "%end%" ( echo %Column8% %Column8_key% ,>>"%~dp0mysql.sql"
- ) else echo %Column8% %Column8_key% >>"%~dp0mysql.sql"
- echo ^);>>mysql.sql
- :insert
- rem 向mysql中的%database%数据库%table%表各个字段中,插入100条记录. (在下面手动添加批量的默认数据)
- for /l %%i in (1,1,100) do (
- echo insert into %table% ^(%columns:~,-2%^) values ^(>>"%~dp0mysql.sql"
- rem ---------------------------------------------字段Column1:----------------------------------------------------------
- if "%Column1%" neq "" if "%Column1%" neq "%end%" ( echo %%i ,>>"%~dp0mysql.sql"
- ) else echo %%i >>"%~dp0mysql.sql"
- rem ---------------------------------------------字段Column2:---------------------------------------------------------
- if "%Column2%" neq "" if "%Column2%" neq "%end%" ( echo 'luqd%%i' ,>>"%~dp0mysql.sql"
- ) else echo 'luqd%%i' >>"%~dp0mysql.sql"
- rem ---------------------------------------------字段Column3:----------------------------------------------------------
- if "%Column3%" neq "" if "%Column3%" neq "%end%" ( echo '男' ,>>"%~dp0mysql.sql"
- ) else echo '男' >>"%~dp0mysql.sql"
- rem ---------------------------------------------字段Column4:----------------------------------------------------------
- if "%Column4%" neq "" if "%Column4%" neq "%end%" ( echo %%i ,>>"%~dp0mysql.sql"
- ) else echo %%i >>"%~dp0mysql.sql"
- rem ---------------------------------------------字段Column5:---------------------------------------------------------
- if "%Column5%" neq "" if "%Column5%" neq "%end%" ( echo 1886233512%%i ,>>"%~dp0mysql.sql"
- ) else echo 1886233512%%i >>"%~dp0mysql.sql"
- rem ---------------------------------------------字段Column6:----------------------------------------------------------
- if "%Column6%" neq "" if "%Column6%" neq "%end%" ( echo 'ptsdy@16%%i.com' ,>>"%~dp0mysql.sql"
- ) else echo 'ptsdy@16%%i.com' >>"%~dp0mysql.sql"
- rem ---------------------------------------------字段Column7:----------------------------------------------------------
- if "%Column7%" neq "" if "%Column7%" neq "%end%" ( echo '苏州市吴中区' ,>>"%~dp0mysql.sql"
- ) else echo '苏州市吴中区' >>"%~dp0mysql.sql"
- rem ---------------------------------------------字段Column8:----------------------------------------------------------
- if "%Column8%" neq "" if "%Column8%" neq "%end%" (echo 'Buzhu Mark' ,>>"%~dp0mysql.sql"
- ) else echo 'Buzhu Mark' >>"%~dp0mysql.sql"
- echo ^);>>"%~dp0mysql.sql"
- )
- ::mysql -h localhost -u root -p <mysql.sql //需要输入密码
- %mysqlpath%\mysql.exe -f -u root -p123456 -e "source %~dp0mysql.sql"
- rem 登录到mysql中.
- %mysqlpath%\mysql.exe -u root -p123456 %database% --execute="select * from %table%;"
- pause & exit
复制代码
|