- 論壇徽章:
- 0
|
去data目錄看了一眼~ actor_info 只有frm文件
[root@localhost sakila]# ls actor_info.*
actor_info.frm
去主庫(kù)上查看該表:
mysql> select * from actor_info limit 1\G;
*************************** 1. row ***************************
actor_id: 1
first_name: PENELOPE
last_name: GUINESS
film_info: Animation: ANACONDA CONFESSIONS; Children: LANGUAGE COWBOY; Classics: COLOR PHILADELPHIA, WESTWARD SEABISCUIT; Comedy: VERTIGO NORTHWEST; Documentary: ACADEMY DINOSAUR; Family: KING EVOLUTION, SPLASH GUMP; Foreign: MULHOLLAND BEAST; Games: BULWORTH COMMANDMENTS, HUMAN GRAFFITI; Horror: ELEPHANT TROJAN, LADY STAGE, RULES HUMAN; Music: WIZAR
mysql> show create table actor_info;
發(fā)現(xiàn)它是個(gè)視圖~~
那我就不能在叢庫(kù)上執(zhí)行 load data from master 來(lái)倒數(shù)據(jù)了? 視圖不能通過(guò)這種方式導(dǎo)入? |
|