Question: MySQL 5.6 Command Line Client ERROR 1864 (428e0): You have an error in your SQL syntax; check the manual that corresp mysql> select from emp;
MySQL 5.6 Command Line Client ERROR 1864 (428e0): You have an error in your SQL syntax; check the manual that corresp mysql> select from emp; empno | ename l Job l Mgr I Hredate Sal I Comm | deptno | 1 Smith anager NULL 2e08-10-1e ee:00:ee 2345.91 200 3 Allen S MARTIN Manager NULL 2010-01-20 e0:ee:00 4345.9600 I 12015-10-1e e0:00:0 1800 180 NULL I 2013-11-20 ee : ee : ee 1 2345.9 | 2300 180 I 12014-01-10 00:00:0e 4 | 2013-11-20 :00:ee l 2745.9 | 1 2014-81-18 80:00:00 2 2013-11-20 00:00:00 1 2014-01-10 00:00:00 SALESMAN 260 280 I 2787 320 230 280 I 8 I KING 9 I JAMES 1 I BLAKE 11 CLARK 12 I MILLER 13 I Ali CLERK SALESMAN | NULL | 2013-11-20 e0:00:00 1 | 2013-05-10 00:00:0 2300 280 SALESMAN | 1 | 2012-e9-20 80:80:0 2800 | 290 3587 290 3800 340 1 2013-05-1e 00:80:80 2 2014-89-28 00:80:00 10 | 2013-5-10 e0:e0:0 4 | 2016-09-20 00:00:80 1 | 2013-07-10 00:00:00 10 | 2015-04-20 80:00:00 1 | 2813-05-18 00:00:00 2012-09-20 00:00:00 ANALYST ANALYST 17 | Zhangsan I Manager 2350 450 I 18 | Lisi 19 I Wangfang 3880 390 ANALYST Manager 21 | Chengdong | SALESMAN | 18 | 2013-05-10 00:80:00 380 340 22 | Hewang ANALYST 4 I 2016-89-28 08:00:00 3887 | 290 I 22 rows in set (e.18 sec) mysql> select*fron dept; sumsalary | persons 1 I Research | New York 2 I Office 4 I Factory Iowa rows in set (0.03 sec) ype here to search
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
