qq_33304274的博客

创建RUNOOB数据库，并设定编码集为utf8CREATE DATABASE IF NOT EXISTS tp5 DEFAULT CHARSET utf8 COLLATE utf8_unicode_ci;创建表CREATE TABLE IF NOT EXISTS `test`( `id` INT UNSIGNED AUTO_INCREMENT, `title` VARCHAR(100) N...

vim bk_test_sql.sh简单备份：#!/bin/bashmysqldump -uroot -psheng ty_sos> /home/www/tysos/back_sql/ty_sos_$(date +%Y%m%d_%H%M%S).sqlchmod u+x bk_test_sql.sh 就表示对当前目录下的bk_test_sql.sh文件的所有者增加可执行权限。...

SELECT * FROM (SELECT * FROM posts ORDER BY dateline DESC) as testbiao GROUP BY tid ORDER BY dateline DESC LIMIT 10