Platform: Windows 10
I'm pretty sure this is a bug in the IDE since the code works fine in my execution window.
Code: Select all
SELECT COUNT(DISTINCT(ilm.FROM)) FROM import_linkedin_messages ilm WHERE DIRECTION = 'OUTGOING';
The errors are:
Unexpected symbol 'ilm' and Unexpeted symbol ')'.
Renaming the Columns solves the problem:
Code: Select all
SELECT COUNT(DISTINCT(ilm.ic_FROM)) FROM import_linkedin_messages ilm WHERE ic_DIRECTION = 'OUTGOING';
Code: Select all
SET NAMES 'utf8mb4';
--
-- Set default database
--
USE empowercrm_main;
--
-- Create table `import_linkedin_messages`
--
CREATE TABLE import_linkedin_messages (
ID int NOT NULL AUTO_INCREMENT,
`FROM` varchar(100) DEFAULT NULL,
`TO` text DEFAULT NULL,
DATE datetime DEFAULT NULL,
SUBJECT varchar(150) DEFAULT NULL,
CONTENT text DEFAULT NULL,
DIRECTION varchar(50) DEFAULT NULL,
FOLDER varchar(50) DEFAULT NULL,
PRIMARY KEY (ID)
)
ENGINE = INNODB,
CHARACTER SET utf8mb4,
COLLATE utf8mb4_unicode_ci;