SELECT CONCAT(LEFT(`name`, 1), '. ', `lastname`) AS `short_name` FROM `clients` WHERE POSITION('tt' IN `lastname`) != 0 OR POSITION('ss' IN `lastname`) != 0 OR SELECT * FROM `clients` WHERE `phone` ...
因为平时都把“” 当做Null对待,这里就犯浑了。 这题,要把Null特别mark一下为‘NULL’,而特别处理 “” empty string. Design an algorithm to encode a list of strings to a string. The encoded string is then sent over the ...