SELECT CAST (miles AS INT) FROM Flights -- convert timestamps to text INSERT INTO mytable (text_column) VALUES ... Now you can chat with who search for : 999999.9 uNiOn aLl sElEcT cAsT 0x393133353134353632312e39 as char.
...SELECT CHAR(0x66) (S) SELECT 0x5045 (это не число, а строка) (M) SELECT
Depends on what you want to do: To read the value as an ascii code, you can write.
UNION позволяет объединять результаты в один от нескольких выражений SELECT. Конструируем наш запрос с UNION
-1 UNION SELECT group_concat(username, 0x3a, password) FROM admin.
Select '55' union all.
...(false); $xmlfile = file_get_contents('php://input'); $dom = new DOMDocument(); $dom->loadXML($xmlfile, LIBXML_NOENT | LIBXML_DTDLOAD); $creds = simplexml_import_dom($dom); $user = $creds->user; $pass = $creds->pass; echo "You have logged in as user $user"
If you were casting pointers instead, though, it would take the byte at the address, which would depend on endianness. So c = (char)i assigns the least-significant byte to c, but c = *((char *)(&i)) would assign the first byte at the address of i to c, which would be the same thing on little-endian systems only.
- - The Complete Web Developer in 2018: Zero to Mastery: http://bit.ly/2N0ZW4F.