Unnecessary whitespace found SQL-L039
Style
Minor
a month ago
—
6 months old
Unexpected whitespace before statement terminator ';'
37 KEY `account_id` (`account_id`),
38 KEY `parent_txn_id` (`parent_txn_id`),
39 KEY `txn_id` (`txn_id`)
40) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='All PayPal transactions that go through the IPN handler.' AUTO_INCREMENT=1 ;Unexpected whitespace before statement terminator ';'
6 `delete_date` datetime DEFAULT NULL,
7 PRIMARY KEY (`id`),
8 KEY `account_id` (`account_id`)
9) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;Unexpected whitespace before statement terminator ';'
3 `name` varchar(32) NOT NULL,
4 `display` int(1) NOT NULL DEFAULT '1',
5 PRIMARY KEY (`cat_id`)
6) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ; 7
8INSERT INTO `cp_servicedeskcat` (`cat_id`, `name`, `display`) VALUES
9(1, 'Technical Support', 1),Unexpected whitespace before statement terminator ';'
8 `ip` varchar(15) NOT NULL DEFAULT '0',
9 `isstaff` int(1) NOT NULL DEFAULT '0',
10 PRIMARY KEY (`action_id`)
11) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;Unexpected whitespace before statement terminator ';'
15 `curemail` text NOT NULL,
16 `lastreply` varchar(24) NOT NULL DEFAULT '0',
17 PRIMARY KEY (`ticket_id`)
18) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1000 ;
Description
Whitespace should be limited to a single space unless while indenting or preceding a comment.
Bad practice
SELECT
a, b
FROM foo
Recommended
SELECT
a, b
FROM foo