mysql> source /home/mysqlscript;
ERROR 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'number(7),
name varchar2(20),
assigned_est_id number(7),
primar
mysql>

create table establishment
(id number(7),
name varchar2(20),
assigned_est_id number(7),
primary key(id),
foreign key (assigned_est_id) references establishment(id));

create table establishment
(id INT(7) NOT NULL, name VARCHAR(20),
assigned_est_id INT(7),FOREIGN KEY (assigned_est_id)
REFERENCES establishment(id),PRIMARY KEY(id));

create table establishment
(id NUMBER(7) NOT NULL,name VARCHAR2(20),
assigned_est_id NUMBER(7),FOREIGN KEY (assigned_est_id)
REFERENCES establishment(id),PRIMARY KEY(id));

select id, name, title
from k_emp
where id in (1,2,3);

select k_emp_id
from k_job_mtr
where k_dep_id=1;

select id, name, title
from k_emp
where id in
(select k_emp_id
from k_job_mtr
where k_dep_id=1);

mysql> source /home/1;
+----+------------------+------------------------+
| id | name             | title                  |
+----+------------------+------------------------+
|  1 | Vasily Fachester | Professor Dyady Vasya  |
|  2 | Arcady Hohtick   | Physician Dyadya Stepa |
|  3 | Vasya Hotdog     | Cleaner Tyotya Vasya   |
+----+------------------+------------------------+
3 rows in set (0.00 sec)

+----------+
| k_emp_id |
+----------+
|        1 |
|        2 |
|        3 |
+----------+
3 rows in set (0.00 sec)

ERROR 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'select k_emp_id
from k_job_mtr
where k_dep_id=1)' at line 4