用户登录
用户注册

分享至

mariadb数据库示例

  • 作者: 内涵大神你米哥
  • 来源: 51数据库
  • 2020-10-03
[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)



  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();
软件
前端设计
程序设计
Java相关