Please enable JavaScript.
Coggle requires JavaScript to display documents.
MySQL - Coggle Diagram
MySQL
function
-
LEFT (String , length)
MID (String , Position , Length)
RIGHT(String , Length)
SELECT LEFT(text , 2) FROM try
-
REPEAT(String, Number of Repeats)
REPLACE(String, Fromm, To)
REVERSE(String)
لعمل (UPDATE) للجدول
UPDATA try set test = REPEAT (test, 3 );
CONCAT(String,String,String)
CONCAT_WS(Separetot,String,String)
Select id, text , CONCAT_WS(',' , CONCAT(id,' '), text) As mytextwithid FROM 'try';
-