https://www.youtube.com/watch?v=Ix9NGwyChIY
Sunday, 5 July 2020
Saturday, 4 July 2020
邋遢姑娘
https://www.xiami.com/song/1775701048
随欲飘飘然
你住的天地一定自由自在
噢 邋遢姑娘 我意中人
噢 邋遢姑娘 我心上人
弄的我心一跳又跳再跳停不下来
一颗心赤祼祼的跳出身体你要不要我这自恋颓废的浪子
为你由空入色
再添烦恼
天下之大那有像你这样的芳草
噢 邋遢姑娘 我真是爱死你
赤祼祼真你 深深打动了我
在眉来眼去之间
心变的更乱双脚茫茫然 脑袋痴痴想
邋遢与颓废结合有没有美感
噢 邋遢姑娘 我意中人
噢 邋遢姑娘 我心上人
弄的我心一跳又跳再跳停不下来
一颗心赤祼祼的跳出身体你要不要我这自恋颓废的浪子
为你由空入色
再添烦恼
天下之大那有像你这样的芳草
噢 邋遢姑娘 我真是爱死你
生来就邋遢没有人是这样
何况是大家闺秀美丽的姑娘万物你了了然随欲飘飘然
你住的天地一定自由自在
噢 邋遢姑娘 我意中人
噢 邋遢姑娘 我心上人
弄的我心一跳又跳再跳停不下来
一颗心赤祼祼的跳出身体你要不要我这自恋颓废的浪子
为你由空入色
再添烦恼
天下之大那有像你这样的芳草
噢 邋遢姑娘 我真是爱死你
赤祼祼真你 深深打动了我
在眉来眼去之间
心变的更乱双脚茫茫然 脑袋痴痴想
邋遢与颓废结合有没有美感
噢 邋遢姑娘 我意中人
噢 邋遢姑娘 我心上人
弄的我心一跳又跳再跳停不下来
一颗心赤祼祼的跳出身体你要不要我这自恋颓废的浪子
为你由空入色
再添烦恼
天下之大那有像你这样的芳草
噢 邋遢姑娘 我真是爱死你
Thursday, 2 July 2020
Wednesday, 1 July 2020
Sunday, 31 May 2020
Friday, 29 May 2020
Wednesday, 15 April 2020
Using PHP to Backup MySQL Databases
http://www.php-mysql-tutorial.com/wikis/mysql-tutorials/using-php-to-backup-mysql-databases.aspx
There are at least three ways to backup your MySQL Database :
To backup your MySQL database using phpMyAdmin click on the "export" link on phpMyAdmin main page. Choose the database you wish to backup, check the appropriate SQL options and enter the name for the backup file.
- Execute a database backup query from PHP file.
- Run mysqldump using system() function.
- Use phpMyAdmin to do the backup.
Execute a database backup query from PHP fileBelow is an example of using SELECT INTO OUTFILE query for creating table backup :
<?php
To restore the backup you just need to run LOAD DATA INFILE query like this
: include 'config.php'; include 'opendb.php'; $tableName = 'mypet'; $backupFile = 'backup/mypet.sql'; $query = "SELECT * INTO OUTFILE '$backupFile' FROM $tableName"; $result = mysql_query($query); include 'closedb.php'; ?>
<?php
It's a good idea to name the backup file as tablename.sql
so you'll know from which table the backup file isinclude 'config.php'; include 'opendb.php'; $tableName = 'mypet'; $backupFile = 'mypet.sql'; $query = "LOAD DATA INFILE 'backupFile' INTO TABLE $tableName"; $result = mysql_query($query); include 'closedb.php'; ?> |
Run mysqldump using system() functionThe system() function is used to execute an external program. Because MySQL already have built in tool for creating MySQL database backup (mysqldump) let's use it from our PHP script
<?php
include 'config.php'; include 'opendb.php'; $backupFile = $dbname . date("Y-m-d-H-i-s") . '.gz'; $command = "mysqldump --opt -h $dbhost -u $dbuser -p $dbpass $dbname | gzip > $backupFile"; system($command); include 'closedb.php'; ?> |
Use phpMyAdmin to do the backup
This option as you may guessed doesn't involve any programming on your part. However I think i mention it anyway so you know more options to backup your database.To backup your MySQL database using phpMyAdmin click on the "export" link on phpMyAdmin main page. Choose the database you wish to backup, check the appropriate SQL options and enter the name for the backup file.
<style type="text/css">
.style1
{
width: 615px;
}
.style2
{
text-align: right;
width: 85px;
}
</style>
Monday, 6 April 2020
MySQL的JOIN用法
https://www.jianshu.com/p/600b99a8bc7f
下面一张图很好解释了笛卡尔积:
数据库中的JOIN称为连接,连接的主要作用是根据两个或多个表中的列之间的关系,获取存在于不同表中的数据。连接分为三类:内连接、外连接、全连接。另外还有
CROSS JOIN(笛卡尔积),个人认为如果要理解MySQL中JOIN的各种连接,只需要理解笛卡尔积就足够了。1 笛卡尔积
笛卡尔乘积是指在数学中,两个集合X和Y的笛卡尓积(Cartesian product),又称直积,表示为X × Y,第一个对象是X的成员而第二个对象是Y的所有可能有序对的其中一个成员。
下面一张图很好解释了笛卡尔积:
Subscribe to:
Posts (Atom)
zomok E-commerce system plan. Choose your online ordering system. No-risk 30 day free trial. Then USD 9/month. No credit card required.
zomok E-commerce system plan. Choose your online ordering system. No-risk 30 day free trial. Then USD 9/month. No credit card required. h...
-
DePauhGarden BabaCuisineBatuKawan ShunkaBatuKawan YenBatuKawan PanPanBatuKawan CheongfatttzeCafeMangga Iramadining AkkasCurryHouse Restauran...





