mysql 新增欄位資料

insert into tables(id,name,age)values(2,'sunsun',28);
(注意文字型態用'   '包起來，'  '是enter左邊鍵)

查table 欄位內容

use database;
select * from tablesname;

mysql 新增 table

CREATE TABLE mytable(id INTEGER, name TEXT, age INTEGER);

修改學務系統 姓名欄位

UPDATE `sfs3`.`teacher_post_view` SET `name` = '馬大大' WHERE CONVERT(`teacher_post_view`.`teach_id` USING utf8) = 'yspXXX' LIMIT 1;

CentOS 7 修改主機名稱

修改主機名稱

1.hostnamectl set-hostname [NAME]

查看目前的主機名稱

2.hostnamectl

下個指令之後，就不用再去修改 network 設定了

3.sudo hostnamectl set-hostname [NAME]

開啟 short_open_tag

sed -i 's/short_open_tag = Off/short_open_tag = On/' /etc/php.ini

yum lock 的問題

1.找出 PackageKit

#ps aux | grep PackageKit

>root 9809 1.8 4.5 944132 177120 ? SN 17:28 0:21 /usr/bin/python /usr/share/PackageKit/helpers/yum/yumBackend.py get-updates none

>root 10723 0.0 0.0 112656 968 pts/2 S+ 17:47 0:00 grep --color=auto PackageKit

#kill -9 9809

假如仍

Existing lock /var/run/yum.pid: another copy is running as pid 9809.
Another app is currently holding the yum lock; waiting for it to exit...
Another app is currently holding the yum lock; waiting for it to exit...
Another app is currently holding the yum lock; waiting for it to exit...

^C

Exiting on user cancel.

一般程序執行時候，lock file 會放在 /var/lock/subsys/ 目錄，但此處沒有 yum 或 python 或 PackageKit

[root@localhost ~]# ls /var/lock/subsys/
abrt-ccpp auditd crond local network rpc.statd
abrtd autofs cups lvm2-monitor NetworkManager rsyslog
acpid blk-availability haldaemon messagebus postfix sshd
atd certmonger ip6tables netfs rpcbind udev-post
[root@localhost ~]#

從剛剛的訊息
Existing lock /var/run/yum.pid: another copy is running as pid 9809.
yum 的 lock file 是 /var/run/yum.pid，用 rm -fr 指令刪除

[root@localhost ~]# rm -fr /var/run/yum.pid

OK

centos 7 rsync

1.yum install rsync








systemctl enable rsyncd.service (安裝)


systemctl start rsyncd.service(啟動)

查看centos目前作業系統類型版本

1.cat /etc/*-release
2.uname -a

crontab -e 命令找不到

yum -y install vixie-cron crontabs

cp 指令相關

1.如果要複製一個目錄, 只需要加上'-r' 的參數就行了

CentOS 7 － firewalld 設定

1.firewalld目錄

/etc/firewalld/：使用者自訂的資料


/usr/lib/firewalld/：firewalld預設的資料，請勿更動。

2.

啟動

# service firewalld start

停止

# service firewalld stop

重新啟動

# service firewalld restart

重讀設定

# firewall-cmd --reload

查看狀態

# service firewalld status

或

# firewall-cmd --state

3.

查看zone

# firewall-cmd --get-default-zone

(預設)

# firewall-cmd --get-active-zones

(運作中)

查看此zone所開的服務

# firewall-cmd --zone=public --list-all

4.

在public zone新增80TCP的服務

# firewall-cmd --zone=public --add-port=80/tcp

移除在public zone上80埠的所有服務 tcp/udp

# firewall-cmd --zone=public --remove-port=80


# firewall-cmd --zone=public --add-source=163.17.40.0/24(指定來源)

# firewall-cmd --zone=public --remove-source=163.17.40.0/24

close centos7 selinux

# vi /etc/sysconfig/selinux

(find)SELINUX=enforcing

(change into)SELINUX=disabled

# reboot

centos 7 change dns seeting (when Couldn't resolve host 'mirrorlist.centos.org')

1. use   nmcli
2.# nmcli con mod enoXXXXX ipv4.dns “168.95.1.1”
3# nmcli con up enoXXXX

OR