‘ ‘ – Eduguru

CONCAT() Function – MySQL

May 13, 2020 by eduguru

CONCAT() Function – MySQL MySQL has the CONCAT() function, which allows you to concatenate two or more strings. The function actually allows for one or more arguments, but its main use is to concatenate two or more strings. CONCAT (string1, string2,…) Arguments string1 First string to be joined. string2 Second string to be joined. Up … Read more

vicidial / extras / MySQL_AST_CREATE_tables.sql

October 10, 2013 by eduguru

CREATE TABLE phones ( extension VARCHAR(100), dialplan_number VARCHAR(20), voicemail_id VARCHAR(10), phone_ip VARCHAR(15), computer_ip VARCHAR(15), server_ip VARCHAR(15), login VARCHAR(15), pass VARCHAR(10), status VARCHAR(10), active ENUM(‘Y’,’N’), phone_type VARCHAR(50), fullname VARCHAR(50), company VARCHAR(10), picture VARCHAR(19), messages INT(4), old_messages INT(4), protocol ENUM(‘SIP’,’Zap’,’IAX2′,’EXTERNAL’) default ‘SIP’, local_gmt VARCHAR(6) default ‘-5.00’, ASTmgrUSERNAME VARCHAR(20) default ‘cron’, ASTmgrSECRET VARCHAR(20) default ‘1234’, login_user VARCHAR(20), login_pass … Read more