SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE students ( id INT PRIMARY KEY, name VARCHAR(50) ); SELECT ASCII('A'); SELECT ASCII('MOKSHGNA'); SELECT CHAR_LENGTH('HELLO'); SELECT CHAR_LENGTH('5'); SELECT CONCAT('Hello', 'World'); SELECT FORMAT(123456789,2); SELECT FORMAT(123456789,0); SELECT LOWER('HELLO'); SELECT LOWER('Hello World'); SELECT LOWER('HELLO'); SELECT LOWER('Hello World'); SELECT UPPER('hello'); SELECT UPPER('Hello World'); SELECT TRIM(' Hello World '); SELECT TRIM(BOTH 'X' FROM 'XXXHello WorldXXX') SELECT LTRIM(' Hello World'); SELECT LTRIM(' Leading spaces removed'); SELECT RTRIM('Hello World '); SELECT RTRIM('Trailing spaces removed '); mysql> SELECT REPLACE(Hello World World, MySQL); SELECT REPLACE('123-456-7190', '7', 'X'); SELECT SIGN(-10)