Mysql 索引 和修改字段

看看

索引

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;