SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
create table t(id int, source varchar(255)); insert into t values(1, 'telegram'); insert into t values(2, 'viber'); insert into t values(3, 'whatsapp'); create table t_telegram(id int, token varchar(255), field_id int); insert into t_telegram values(1, 'telegram_token', 1); create table t_viber(id int, token varchar(255), field_id int); insert into t_viber values(1, 'viber_token', 1); create table t_whatsapp(id int, token varchar(255), field_id int); insert into t_whatsapp values(1, 'viber_token', 1); drop function if exists `getToken`; DELIMITER $$ CREATE function getToken( social varchar(255), field_id int ) BEGIN DECLARE stmt VARCHAR(255); SET @selectQuery = concat('SELECT token FROM ', 't_', social,' as t where field_id = ? ORDER BY dateT DESC LIMIT 1'); SET @field_id = field_id; PREPARE stmt FROM @selectQuery; EXECUTE stmt using @field_id; DEALLOCATE PREPARE stmt; END$$ DELIMITER ; select getToken('viber', 1) from t;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear