1.数据库:
表引擎InnoDB,支持外键。
2.SQL左/右连接查询:
SELECT t1.id, t1.name, t1.groupid, t2.name FROM t_user t1 LEFT JOIN t_group t2 ON t1.groupid = t2.id;
如果还要添加查询条件的话,用WHERE:
SELECT t1.id, t1.name, t1.groupid, t2.name FROM t_user t1 LEFT JOIN t_group t2 ON t1.groupid = t2.id WHERE t1.id=1;
3.一个input可以上传多个文件:
<input type="file" multiple="true" />
4.允许其他机器访问本机数据库:
use mysql;
update user set Host='%' where User='root';
5.rsa方式进行ssh连接
(1) 用命令ssh-keygen -t rsa生成密钥对
(2) 将生成的id_rsa.pub拷贝到授权主机文件夹~.ssh/下
(3) 将id_rsa.pub重命名为authorized_keys2