Boa tarde João!
Eu fiz desta maneira mas não funcionou aparece o conteúdo do campo e não o conteúdo da variável:
CREATE TABLE sec_menu
(
Codigo
int(11) NOT NULL,
Descricao
varchar(50) DEFAULT NULL,
Link
varchar(100) DEFAULT NULL,
Sub_menu
int(11) DEFAULT NULL,
Ordem
int(11) DEFAULT NULL,
Icone
varchar(100) DEFAULT NULL,
Target
varchar(10) DEFAULT NULL,
Hint
varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO sec_menu
(Codigo
, Descricao
, Link
, Sub_menu
, Ordem
, Icone
, Target
, Hint
) VALUES
(1, ‘{lang_menu_security}’, ‘’, 0, 0, ‘’, ‘’, ‘’),
(2, ‘{lang_list_users}’, ‘sec_grid_sec_users’, 1, 1, NULL, NULL, NULL),
(3, ‘{lang_list_apps}’, ‘sec_grid_sec_apps’, 1, 2, NULL, NULL, NULL),
(4, ‘{lang_list_groups}’, ‘sec_grid_sec_groups’, 1, 3, NULL, NULL, NULL),
(5, ‘{lang_list_users_x_groups}’, ‘sec_grid_sec_users_groups’, 1, 4, NULL, NULL, NULL),
(6, ‘{lang_list_apps_x_groups}’, ‘sec_form_sec_groups_apps’, 1, 5, NULL, NULL, NULL),
(7, ‘{lang_list_sync_apps}’, ‘sec_sync_apps’, 1, 6, NULL, NULL, NULL),
(8, ‘{lang_logged_users}’, ‘sec_logged_users’, 1, 7, NULL, NULL, NULL),
(9, ‘{lang_social_login}’, ‘sec_link_social’, 1, 8, NULL, NULL, NULL),
(10, ‘{lang_2fa}’, ‘sec_add_2fa’, 1, 9, NULL, NULL, NULL),
(11, ‘{lang_settings}’, ‘sec_settings’, 1, 10, NULL, NULL, NULL),
(12, ‘{lang_change_pswd}’, ‘sec_change_pswd’, 1, 11, NULL, NULL, NULL),
(13, ‘{lang_log_title}’, ‘app_grid_log’, 1, 12, NULL, NULL, NULL),
(14, ‘{lang_exit}’, ‘’, 0, 13, NULL, NULL, NULL);