Databases, as options for concentration of information, are vital, and even an insignificant project cannot do without them. How efficiently the structure is thought out, the tables are correctly designed, the connections are configured - the speed of data sampling / recording, the reliability of data storage, the guarantee of the impossibility of accidentally causing damage, the availability of rollback, the completeness of each transaction, and the success as a whole depend on it.
The database, first of all, is a conceptual idea, the presentation of information and the logic of its use in a specific task.
Simple Relationships = Effective Implementation
Relational ideas for organizing data are definitely not the best, but they have confidently held their position for many decades. As factories producing goods and essentials for consumer goods, they are certainly necessary.
, . , - . - - .
MySQL create table , . «» , , , .
,
: « » MySQL, - . , , .
create temporary table MySQL , , , .
- , . , .
create temporary table, MySQL . , . MySQL create table check, . - SQL .
:
, , , . «» - , : , .
MySQL, create table , .
code_back, owner_code session_code , . MySQL create table, key , : , , , , .
h_code, a_contents a_surprise. create table MySQL , , . , , . . , , a_contents : ;;e-mail, a_surprise - .
a_contents / a_surprise
, , , . create table MySQL - , , e-mail : (a_contents like '{$cUserName};{$cUserPass}%') or (a_contents like '%{$cUserPass};{$cUserName}').
: scTableExists('rm_cache') , , , , .
create table if not exists MySQL . . , .
MySQL, PHP, : , . , - , . MySQL create table . . create table MySQL, - .
- . , , MySQL . MySQL create table default- ( ) .
, , , , ( - ), " " - , , . create table SQL MySQL . «» SQL .
char varchar - ( , ), , .
, , - . MySQL "create table". MySQL : , , ... , .
, , , . " " - - .
, , . , ( ) MySQL .
«» , . , char varchar MySQL create table syntax, .
MySQL. Create table . , , , , , , php.ini, my.ini httpd.conf.
« » - « », - , . create table int MySQL : , , .
, , , . , create temporary table, MySQL . , , - .
create table if not exists MySQL : , / , .
- MySQL+
. MySQL create table . -, , , , : . .
, , .
, . MySQL, , MySQL+.
, , , , .
, , , .
MySQL, , , , .
Apache/MySQL/PHP
- , . PHP 7.0.13, MySQL 5.7.16, , Perl "" 4.1.1 PHP.
(, , ) Linux, FreeBSD, UBUNTU . , , AMP (Apache, MySQL, PHP). , .
MySQL , phpMyAdmin, . . - PHP, MySQL Apache. , .
, , , . , , , .
/
MySQL create table . : . : , . : , , .
, . / , , .
Create table if not exists, MySQL , : , .
«, » , « ».
Create table: MySQL
/ , .
/ / , - - , , .
MySQL , , , .
- . users cache_users. , - , (). , , / .
( ), , , . , , .
,
- . - , , - - . - - . - - .
, , AMP: Apache, PHP, MySQL. : , - , .
SQL - , , . . PHP - , , , . .
If you combine PHP and MySQL into a single whole, you get a tool with memory. The combination option gives the idea of object-oriented programming: the object described in the language is in a compact state in memory (in the database) for the time being unnecessary. When a need arises in him, he is restored to a full-fledged object and acts in accordance with his competence.