create table test( id int(10) not null AUTO_INCREMENT,name varchar(3), PRIMARY KEY(id), UNIQUE KEY uqe_name(name) ) engine=innodb charset=utf8;
INSERT INTOtest(id,name) VALUES (1, 'aa'), (2, 'bb'), (3, 'cc');
非聚集索引,索引和记录是分开存放的
| #!/bin/sh | |
| # | |
| # This script should be run via curl: | |
| # sh -c "$(curl -fsSL https://raw.githubusercontent.com/ohmyzsh/ohmyzsh/master/tools/install.sh)" | |
| # or wget: | |
| # sh -c "$(wget -qO- https://raw.githubusercontent.com/ohmyzsh/ohmyzsh/master/tools/install.sh)" | |
| # | |
| # As an alternative, you can first download the install script and run it afterwards: | |
| # wget https://raw.githubusercontent.com/ohmyzsh/ohmyzsh/master/tools/install.sh | |
| # sh install.sh |
| #!/bin/bash | |
| set -u | |
| # First check if the OS is Linux. | |
| if [[ "$(uname)" = "Linux" ]]; then | |
| HOMEBREW_ON_LINUX=1 | |
| fi | |
| # On macOS, this script installs to /usr/local only. | |
| # On Linux, it installs to /home/linuxbrew/.linuxbrew if you have sudo access |
<script type="text/javascript">
const a = {a:1}
console.log(a)
console.log("===================")
const b = Object.create(null,{
a: {
writable:true,
configurable:true,
value: 2
<script>
var obj = {
"name": "hello"
}
function test(a,b,c) {
console.log(this.name)
console.log(a,b,c)
}
test.call(obj,1,2,3)
download from this url:https://golang.org/dl/
go version
ll /usr/local/go
vim ~/.bash_profile
| #nginx的gzip模块需要zlib库,rewrite模块需要pcre库,ssl模块需要openssl库,查看程序是否已安装: | |
| rpm -q pcre | |
| rpm -q openssl | |
| rpm -q zlib | |
| rpm -q nginx | |
| #!/usr/bin/env bash | |
| #创建用户和组 | |
| echo "======创建用户和组======" | |
| /usr/sbin/groupadd -f www |