Create a table “alias”, and change table type

lavinbatra

New Member
I have a table called tb which is innodb - has over 1m rows. I want to do a fulltext search on the table, but I can't do that because its innodb.So, How do I create an "alias" of tb called tb2, meaning (a duplicate of the table, that updates automatically when the data of tb updates, but change the table type of tb2 to myisam )?So, that way I can do a fulltext search on tb2, find the ids and SELECT the ids from tb1
 
Back
Top