mysql> CREATE TABLE client (
-> client_id int(11) NOT NULL, 
-> client_first_name varchar(20) NOT NULL,
-> client_last_name varchar(40) NOT NULL,
-> client_gender char(1) NOT NULL,
-> client_year_of_birth int(4) NOT NULL, 
-> client_marital_status varchar(20) default NULL,
-> client_street_address varchar(40) NOT NULL,
-> client_postal_code varchar(10) NOT NULL,
-> client_city varchar(30) NOT NULL,
-> client_state_province varchar(40) NOT NULL
-> client_phone_number varchar(25) NOT NULL, t NULL,
-> client_household_income bigint(30) default NULL,
-> client_country varchar(40) default NULL,
-> broker_id int(11) NOT NULL) ENGINE=FEDERATED 
-> COMMENT = 
-> 'mysql://myuser:passueryword@192.164.3.2:3306/gim/client'; 
Query OK, 0 rows affected (0.20 sec)

mysql> select count(*) from client;
+----------+
| count(*) |
+----------+
| 5600 |
+----------+ 
1 row in set (0.50 sec)