CREATE TABLE counties( idint (11) NOT NULL auto_increment, countytinytext NOT NULL, PRIMARY KEY ( id)) TYPE = MyISAM;
counties
id
county
-- INSERT INTO `counties` VALUES (1, 'Alachua County');
I saw several patterns here. People use `` to surround field names and use '' for surrounding values. It's true?
Or the main reason for this is that then we can put the code in a text file and import it into the database.
Thank you
, [`] , . , / , SQL (..: from, where)
['] .
[']
`` MySQL afaik; , , SQL . table.column schema.table.column , - , .
table.column , dtd .
'' - ββ , MySQL . ( '1'. , MySQL- .)
''
'1'
Backticks , , . , . , , , - select, , . ( ) , .
select
Source: https://habr.com/ru/post/1755653/More articles:Running uninstaller from code - c #How do I get NHibernate to connect? - c #unrecognized escape sequence - c #Where can I get the latest information about aio on Linux 2.6.x - linuxMinimizing string literal strings? - javascriptphp mb_convert_case () save words in uppercase - stringFinding the roots of a function adjacent to imaginary numbers - mathHow can I catch jQTouch animation completion? - jqueryHow to get the last but not empty line in a txt file - c ++NetLogo - What is the 1 unit of distance measurement in NetLogo? - netlogoAll Articles