! - . . , , . , , , (, ) . !







Visage Role Play - . /adminka , ! http://visage-rp.ru
VK: vk.com/sergey68

76890 - 1000,46860 - 500, 300
** V.I.P --> **

: MySQL

1 4 4

  1. #1

      Alex_Bardakov

    :
    :18.02.2015
    :127.0.0.1
    :592
    :113 [+/-] 

    MySQL

    . MySQL

    MySQL SQL, MySQL, MySQL. SHOW, USE CREATE.
    .
    SHOW
    MySql


    . :
    PHP :
    SHOW DATABASES
    , , mysql test ( ), MySQL :
    PHP :
    +----------+|Database|+----------+| mysql    || test     |+----------+ 
    :
    PHP :
    SHOW TABLES
    :
    PHP :
    +-----------------+|Tablesin mysql |+-----------------+| test            || mysql           |+-----------------+ 
    : , , , .
    CREATE

    . , mysql test. , , ( ). :
    PHP :
    CREATE DATABASE staff 
    , SHOW DATABASES :
    PHP :
    +----------+|Database|+----------+| mysql    || test     || staff    |+----------+ 
    USE

    , . USE . :
    PHP :
    USE staff 
    , (. ), .
    SQL

    SQL.

    :
    PHP :
    SELECT FROM mysql
    , mysql, .
    : SQL- , MySQL SQL . , MySQL-, .
    , SELECT . :
    PHP :
    SELECT <FROM <>[WHERE <>][ORDER BY <>]; 
    , ; * (), , .
    WHERE , () (). ORDER BY .
    , . staff . , .
    PHP :
    SELECT nameprojectworks_sinceFROM staffWHEREname >'' ANDworks_since '1998-04-26'

    MySQL name, project works_since. , . , , 26- 1998- . :
    PHP :
    +----------+--------------+-------------+| name     project      works_since |+----------+--------------+-------------+|Fred|Secret data  |1997-01-01||Jonathan|Blue apples  |1997-06-01|+----------+--------------+-------------+ 
    :
    PHP :
    SELECT project FROM staff ORDER BY project;
    +-------------+| 
    project     |+-------------+|Blue apples ||Blue apples ||Cornichons||Secret data ||Secret data ||Secret data |+-------------+ 
    , , () project, . DISTINCT:
    PHP :
    SELECT DISTINCT project FROM staff ORDER BY project;
    +-------------+| 
    project     |+-------------+|Blue apples ||Cornichons||Secret data |+-------------+ 
    SQL . COUNT, SUM, MAX, MIN AVG:
    COUNT ;
    SUM ;
    MAX ;
    MIN ;
    AVG .
    . .
    PHP :
    SELECT COUNT (projectFROM staff;SELECT MAX (projects_doneFROM staff;SELECT AVG (project_doneFROM staff 
    , , , .
    SQL ( Perl , ).
    LIKE, _ ( ) % ( ). . , Jo:
    PHP :
    SELECT name FROM staffWHERE name LIKE 'Jo%n';
    +----------+| 
    name     |+----------+|Jonathan||John|+----------+ 
    MySQL REGEXP , Perl (. Perl).
    PHP :
    SELECT nameproject FROM staffWHERE project REGEXP "[bB]"
    , b .
    , . , , .
    , , , staff.project, , . () . stuff x, projects y.
    PHP :
    SELECT x.namex.projectx.descriptionFROM staff xprojects xWHEREx.project x.project_name
    staff projects, , .
    PHP :
    +----------+-------------+------------------------------+| name     project     description                  |+----------+-------------+------------------------------||Jonathan|Blue apples |Worldwide apple distribution ||Fred|Secret data |Secret data                  ||John|Secret data |Secret data                  |+----------+-------------+------------------------------+ 
    :
    PHP :
    SELECT DISTINCT y.project_namey.descriptionCOUNT(x.name), FROM staff xprojects yWHEREy.project_name x.project ANDy.project_name >'Secret data' ANDy.project_name LIKE "Wo__d%"ORDER BYproject_name
    PHP :
    +--------------+--------------------------+-------------+| project_name description              COUNT(name)|+--------------+--------------------------+-------------+|Blue apples  |Worldwide apple delivery |3|+--------------+--------------------------+-------------+ 
    , , , Wo, , d , project_name.


    , . INSERT, DELETE UPDATE .
    INSERT . :
    PHP :
    INSERT INTO staff VALUES ("Robert","1980-05-07","2000-04-26","$100","Secret data"); 
    . , , SELECT NULL , , .
    PHP :
    INSERT INTO staff(namedate_of_birthVALUES ("Jack","1977-07-29");SELECT FROM staffWHERE name ="Jack"
    PHP :
    +------+---------------+-------------+---------+---------+| name date_of_birth works_since project sallary |+------+---------------+-------------+---------+---------+|Jack|1997-07-29NULL        NULL    NULL    |+------+---------------+-------------+---------+---------+ 
    DELETE. () , , . , , SELECT, .
    PHP :
    DELETE FROM staffWHEREname ="Jack"
    UPDATE. , , ( ) , , .
    PHP :
    UPDATE staffSETworks_since ="2000-04-26"sallary ="$200"project ="Secret data"WHEREname ="Jack"
    , , .
    SQL, MySQL, Web. SQL MySQL.
    , ANSI SQL 92: MySQL , .
    Alex_Bardakov; 24.03.2018 14:44.
    PHP :
    |||||||||VK https://vk.com/l_alex_bardakov_l
    |||||SKYPE Alex_Bardakov15
    ||||||eMAil Alex_bardakov15@list.ru 
  2. #2

      ShTorm

    :
    :14.06.2011
    :
    :1,054
    :181 [+/-] 
    .

    [ STAR WARS : MOVIE BATTLES 2 ]
    [ JOIN US ]
    [ Wonderful''' ]

  3. #3

      Alex_Bardakov

    :
    :18.02.2015
    :127.0.0.1
    :592
    :113 [+/-] 

    .
    UPD.
    PHP :
    |||||||||VK https://vk.com/l_alex_bardakov_l
    |||||SKYPE Alex_Bardakov15
    ||||||eMAil Alex_bardakov15@list.ru 
  4. #4

      HenryFum

    :
    :02.02.2019
    :Sri Lanka
    :2
    :0 [+/-] 

    MySQL



    DC_CMD
    sscanf
    Mysql








    PHP :

, : 38

------------------, 100, 200, , , , ., , , , , , , , , mysql, , , , , , , , php, project

(, , , , , ), , .
!
samp-rp advanvce pawn s0beit cs 1.6 0.3x World of Tanks samp-rp, samp-rp, - PAWNO SA-MP IV-MP MTA cleo s0beit sobeit sa-mp sa-mp pawno pawno pawno iv-mp iv-mp iv-mp godfather SAMP gta 4 4 GTA 4 GTA 4 GTA 4 SAMP SAMP Pen1 LS Pen1 Fugitive The Godfather rp roleplay samp-rp sa-mp sa-mp pawno gta-iv gta-v gta-sa gta-3 gta-III gta-4 gta-5 gta-vc mta mta-dm mta-race mta-sa pawno info ru pawno pawno gta-iv gta-iv gta-v gta-v gta-iv keygen gta sa gta 4 multiplayer gta san adnreas multiplayer sa-mp forum sa-mp pawno sa-mp pawno sa-mp gta-sa pawno pawno errors sa-mp 0.3c SA-MP 0.3d 4 GTA 4 GTA 4 GTA 4 SAMP SAMP Pen1 LS Pen1 Fugitive The Godfather SAMP hack rat android instagram twitter ddos root linux ubuntu mac android advance arizona 4g