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 |