These are chat archives for FreeCodeCamp/HelpJavaScript

9th
Jun 2018
Tiago Correia
@tiagocorreiaalmeida
Jun 09 2018 18:45
@JLuboff around?
/*Please add ; after each select statement*/
CREATE PROCEDURE securityBreach()
BEGIN
    SELECT * FROM users WHERE attribute REGEXP CONCAT('.*%.*',users.first_name,'_',users.last_name,'-*.*.%')
END
any idea what im missing?
ERROR 1064 (42000) at line 36: 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 'END' at line 4
Stephen James
@sjames1958gm
Jun 09 2018 18:52
do you need an ; after the select?
Right before the END
Tiago Correia
@tiagocorreiaalmeida
Jun 09 2018 19:03
yeah indeed
im sleeping, thanks @sjames1958gm :D
Christopher McCormack
@cmccormack
Jun 09 2018 19:06
@sjames1958gm the hero we don't deserve :D
Tiago Correia
@tiagocorreiaalmeida
Jun 09 2018 19:30
but the one we need :D
Stephen James
@sjames1958gm
Jun 09 2018 20:01
lol - well the comment before CREATE was helpful
Christopher McCormack
@cmccormack
Jun 09 2018 20:29
@sjames1958gm HAH
Tiago Correia
@tiagocorreiaalmeida
Jun 09 2018 21:09
Crap ahah