Skip to main content

Featured

Dhadi Game - An Indian War game

Hi Friends, Today i will introduce an indian traditional board game to android user I am very interested in playing dhadi game with my friends. Now that interest  becomes as an android game Here these are the playing instructions to the dhadi game Dhadi is a traditional indian game with two players.It runs with mind power between 2 players.You can play against your friends Features: Auto Move Suggestions Interesting Graphic View to game Time taken by two players will be shown individually Total movements shows Intresting background sounds and music music and sound on/off feature No permissions are needed to this app. Download the best Dhadi for Android now! https://play.google.com/store/apps/details?id=in.mjtech.daddy

creating Federated mysql table with username password and host

Usage of character as like these @ is not suggested in passwords and a similar discussion on this issue is available here.

You can work-around the above limitation by using CREATE SERVER statement as shown in the example below:

CREATE SERVER federatedTablelink
FOREIGN DATA WRAPPER mysql
OPTIONS (USER 'USERNAME', HOST 'Host_IP', DATABASE 'DB_NAME',
PORT '3306',Password 'PASSWORD');
Once the server Link is created using the step above, you can use the following to create table that uses this connection:

[sourcecode]
CREATE TABLE test (
id INT(20) NOT NULL AUTO_INCREMENT,
name VARCHAR(32) NOT NULL DEFAULT '',
PRIMARY KEY (id),
INDEX name (name),
INDEX other_key (other)
)
ENGINE=FEDERATED
DEFAULT CHARSET=latin1
CONNECTION='federatedTablelink/test';
[/sourcecode]
MySQL documentation that refers to similar topics are as follows:

https://dev.mysql.com/doc/refman/5.6/en/federated-usagenotes.html

https://dev.mysql.com/doc/refman/5.1/en/federated-create.html

Comments

Popular Posts