看看
索引
show index from first_page_record;// 查看first_page_record 表所有 索引
CREATE INDEX itvaccount_index ON first_page_record (itvaccount);//给表first_page_record 列itvaccount添加索引itvaccount_index
ALTER table first_page_record ADD INDEX indexName(addtime);//给first_page_record;//给表first_page_record 列addtime添加索引indexName
ALTER table tb_leftlist_ral_content ADD INDEX contentId_index(contentid)
IPTV
alter table active_comit_click drop primary key;
alter table active_comit_click ADD ID decimal;
alter table first_page_record add add6 varchar(10) comment '测试添加字段'; //mysql给表添加字段并注释
desc first_page_record; //查看表first_page_record 字段
select COLUMN_NAME,DATA_TYPE,COLUMN_KEY,CHARACTER_MAXIMUM_LENGTH,CHARACTER_OCTET_LENGTH,IS_NULLABLE,COLLATION_NAME,COLUMN_COMMENT
from information_schema.columns where TABLE_SCHEMA = 'IPTV' and TABLE_NAME = 'first_page_record' //查询表结构及注释
alter table t_user_info modify phoneNum varchar(11) default null;//修改字段为varchar
select * from active_record A order by addtime desc limit 0,20\G;
mysqldump -u root -p gzyl_hjy>/root/usr/hjy_lwb.sql;
mysqldump -uroot -p IPTV video_record where 1=1
andSTR_TO_DATE(addtime,'%Y-%m-%d')>= STR_TO_DATE('2018-11-04','%Y-%m-%d')
and STR_TO_DATE(addtime,'%Y-%m-%d')<= STR_TO_DATE('2019-03-04','%Y-%m-%d') > dump.sql;
source /root/usr/hjy_lwb.sql
desc /root/usr/hjy_lwb.sql
create database TGDM
重命名表名
RENAME TABLE tb_userinfo TO tb_userInfo;