import console;
import mysql.client;
console.log("正在连接数据库服务器...");
thread.invoke( function()
while(! thread.get("db4free.net:end")){
io.stdout.write(">");sleep(100);
}
)
var dbMysql,err = mysql.client(
server = "db4free.net"; //数据库服务器,可省略默认为localhost
uid = "aardio";//用户名,可省略默认为root
pwd = "aardio.com";
);
thread.set("db4free.net:end",true)
console.clearScreen ();
if(!dbMysql){
console.log("连接数据库失败",err);
console.pause();
return;
}
//选择数据库
dbMysql.selectDb("aardio")
//执行SQL语句,注意mysql表名、字段名可包含于反引号内(用键盘左上角ESC下方的按键内)
dbMysql.exec("CREATE TABLE IF NOT EXISTS `library` (
`name` varchar(100) NOT NULL, `auditing` tinyint(1) DEFAULT '0',`bytes` BLOB,PRIMARY KEY (`name`),UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT charset=utf-8;");
var dbTable,err = dbMysql.listTables()
for tbl in dbTable.each(){
console.log("发现数据表:",tbl);
}
//执行SQL语句,使用命名参数
console.log(
dbMysql.exec("INSERT `library` VALUES('测试',@num,@str)",{
num = 123;
str = "测试:'这是字符串!'命名参数可以自动处理字符串转义";
} )
)
//查询数据并返回记录集
var result = dbMysql.query("SELECT * FROM `library`");
for name,auditing,bytes in result.each(){
console.log( name,auditing,bytes ); //逐行输出所有记录
}
//移除数据库
dbMysql.exec("DROP TABLE IF EXISTS `library`");
console.pause();
[root@test01 10.19.166.166 ~ ]
# mysqladmin -u root -p create testdb1
enter password: // 此处填写mariadb数据库的密码
[root@test01 10.19.166.166 ~ ]
# mysql
mariadb [(none)]> show databases;
+--------------------+
| database |
+--------------------+
| hellodb |
| information_schema |
| mydb |
| mysql |
| performance_schema |
| test |
| testdb |
| testdb1 |<---创建的好的库 +--------------------+="" 1.2:登录mariadb库创建="" mariadb="" [(none)]=""> create database testdb2;
query ok, 1 row affected (0.00 sec)
mariadb [(none)]> show databases;
+--------------------+
| database |
+--------------------+
| hellodb |
| information_schema |
| mydb |
| mysql |
| performance_schema |
| test |
| testdb |
| testdb1 |
| testdb2 |<---创建好的库 +--------------------+="" (2)mariadb删除数据库="" 2.1:使用mysqladmin删除数据库="" [root@test01="" 10.19.166.166="" ~="" ]="" #="" mysqladmin="" -u="" root="" -p="" drop="" testdb1="" enter="" password:="" 输入数据库密码="" 执行完上面的删除命令后,会出现一个提示框,提示是否确认删除此数据库="" dropping="" the="" database="" is="" potentially="" a="" very="" bad="" thing="" to="" do.="" any="" data="" stored="" in="" the="" database="" will="" be="" destroyed.="" do="" you="" really="" want="" to="" drop="" the="" ‘testdb1‘="" database="" [y/n]="" y="" 删除="" database="" "testdb1"="" dropped="" 登录查看="" mariadb="" [(none)]=""> show databases; //确认testdb1已被删除
+--------------------+
| database |
+--------------------+
| hellodb |
| information_schema |
| mydb |
| mysql |
| performance_schema |
| test |
| testdb |
| testdb2 |
+--------------------+
2.2:登录mariadb库删除
mariadb [(none)]> drop database testdb2;
query ok, 0 rows affected (0.00 sec)
mariadb [(none)]> show databases; //确认testdb2已被删除
+--------------------+
| database |
+--------------------+
| hellodb |
| information_schema |
| mydb |
| mysql |
| performance_schema |
| test |
| testdb |
+--------------------+
(3)mariadb选择数据库,查看选择库下面的所有表
mariadb [(none)]> show databases; //查看所有库
+--------------------+
| database |
+--------------------+
| hellodb |
| information_schema |
| mydb |
| mysql |
| performance_schema |
| test |
| testdb |
+--------------------+
7 rows in set (0.00 sec)
mariadb [(none)]> use mydb //选择mydb数据库
database changed
mariadb [mydb]> show tables; //查看mydb数据库下面所有表信息
+----------------+
| tables_in_mydb |
+----------------+
| ssc |
| t1 |
| tb2 |
| tb4 |
| tb5 |
+----------------+
5 rows in set (0.00 sec)---创建好的库>---创建的好的库>
用户登录
还没有账号?立即注册
用户注册
投稿取消
文章分类: |
|
还能输入300字
上传中....