Shulou(Shulou.com)06/01 Report--

This article mainly introduces how to achieve cross-library connection mysql, the things involved, learned from the theoretical knowledge, there are many books, literature for your reference, in terms of practical significance, accumulated years of practical experience can be shared with you.

FEDERATED storage engine needs to be enabled

SHOW VARIABLES LIKE'% plugin%'

If not, you need to download it now and put it in the folder.

And then

Install plugin FEDERATED soname 'ha_federated.so'

SHOW ENGINES

CREATE TABLE ggss (

Id int (11) NOT NULL AUTO_INCREMENT

Wfid varchar (10) DEFAULT''

Rectime timestamp NULL DEFAULT NULL

Power int (11) DEFAULT NULL

Maxpower int (11) DEFAULT NULL

Pw_ag int (11) DEFAULT NULL

PRIMARY KEY (id)

) ENGINE=FEDERATED DEFAULT CHARSET=utf8mb4 CONNECTION='mysql://gg:11111111@10.72.8.17:3307/base_db/ggss'

Read the above introduction on how to achieve cross-library connection mysql, I hope it can bring some help to everyone in practical application. Due to the limited space in this article, there will inevitably be deficiencies and areas that need to be supplemented. You can continue to pay attention to the industry information section and will update your industry news and knowledge regularly. If you need more professional answers, you can contact us on the official website for 24-hour pre-sales and after-sales to help you answer questions at any time.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.