Results 1 to 15 of 15

Thread: MySQL .

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered User 's Avatar
    Join Date: Feb:2006
    Location:
    Posts: 653

    MySQL .

    , MySQL ,

    C:\Documents and Settings\All Users\Application Data\MySQL\MySQL Server 5.1\data, customer, - client.frm db.opt.

    , , Connection String-a - DSN=Customer;SERVER=Localhost;UID=root;P WD=123;DATABASE=customer;PORT=3306

    .exe customer - client.frm db.opt, , - C:\Documents and Settings\All Users\Application Data\MySQL\MySQL Server 5.1\data, .

  2. #2
    White awesomeness z0ne's Avatar
    Join Date: Feb:2002
    Location: o
    Posts: 13,331
    SQL PHPMyAdmin ?

  3. #3
    Registered User tedych's Avatar
    Join Date: Nov:2003
    Location:
    Posts: 17,654
    , \data .
    Connection string-a mysql localhost, , MySQL . .
    mysql , user . root, \data , .

    , phpmyadmin - , !
    , - . - .

  4. #4
    Registered User 's Avatar
    Join Date: Feb:2006
    Location:
    Posts: 653
    , - , , , . .

  5. #5
    . worm4's Avatar
    Join Date: Jul:2005
    Location: Varna
    Posts: 20,295
    o MyIASM, InoDB .

    Each MyISAM table is stored on disk in three files. The files have names that begin with the table name and have an extension to indicate the file type. An .frm file stores the table format. The data file has an .MYD (MYData) extension. The index file has an .MYI (MYIndex) extension.

    The InnoDB storage engine maintains its own buffer pool for caching data and indexes in main memory. InnoDB stores its tables and indexes in a tablespace, which may consist of several files (or raw disk partitions). This is different from, for example, MyISAM tables where each table is stored using separate files.

    .MYD InoDB. mysqladmin.

    .. . MySQL. PostgreSQL.


    ...

    @tedych ... , , . , , postgre, .
    mysql4.01 "". 5 , , 4.01
    Last edited by worm4; 16th March 2009 at 19:05.
    "Arbeit macht frei" -
    - . , :..,,--?!
    OgiDogi: , , ..,

  6. #6
    Registered User tedych's Avatar
    Join Date: Nov:2003
    Location:
    Posts: 17,654
    Quote Originally Posted by worm4 View Post
    o MyIASM, InoDB .

    .MYD InoDB. mysqladmin.

    .. . MySQL. PostgreSQL.
    ...
    mysql .
    , , mysql.
    , .
    MS SQL , , - - mysql

    innodb , , command line , .

  7. #7
    Registered User 's Avatar
    Join Date: Jul:2003
    Location:
    Posts: 23,490
    Quote Originally Posted by worm4 View Post
    .. . MySQL. PostgreSQL.
    Oracle
    !

  8. #8
    Registered User 's Avatar
    Join Date: Feb:2006
    Location:
    Posts: 653
    . sql , . , . Solution-a , , .
    Access- mySQL, , Query Browser-a. .

  9. #9
    . worm4's Avatar
    Join Date: Jul:2005
    Location: Varna
    Posts: 20,295
    Oracle => !
    .
    /
    Postgre . , ' ... "" , . . 4.0... 5 , . , 5 150 000 ( , ) . .
    , .

    ,
    "Arbeit macht frei" -
    - . , :..,,--?!
    OgiDogi: , , ..,

  10. #10
    دارس وعامل Siemens's Avatar
    Join Date: Jul:2003
    Location:
    Posts: 1,576
    3.2 5-8 JOIN- ( 10-50 . ) ( ). ( ) 0.2 . - 20 ...
    .. MySQL (innodb *), .

    * - , 4.1 - , .

  11. #11
    Registered User tedych's Avatar
    Join Date: Nov:2003
    Location:
    Posts: 17,654
    MySQL , , 9 . .. , .
    , , MS SQL/Oracle .
    2 ms sql 50- coldfusion/php.

    Siemens, . , , , ms sql .
    - , .

  12. #12
    Registered User 's Avatar
    Join Date: Jul:2003
    Location:
    Posts: 23,490
    Quote Originally Posted by tedych View Post
    MySQL , , 9 . .. , .
    9 . .
    100 . . .
    20-30 , , BLOB .


    ROLLBACK ...


    ,
    !

  13. #13
    Registered User tedych's Avatar
    Join Date: Nov:2003
    Location:
    Posts: 17,654
    9 , .
    . . 9 . - .
    , , - spy , .
    , 9 .
    ?

  14. #14
    Bombera's Avatar
    Join Date: Jul:2001
    Location: 4EVA
    Posts: 13,833
    - " " . , , .

    -(, ?) , 5, ( ) - SUPER, , 5.0.31.
    EVGA X299 FTW K|i9-7960X@4.7|4x8 Patriot Viper Steel 4000|GTX 1660 Ti|970 EVO 1 TB|Seasonic Focus GX-1000|Xigmatek Elysium|
    Rampage IV Extreme BE|E5-1680v2@4.7|4x4 HyperX 1866|Cougar Aqua 240|GTX 1050 Ti|970 EVO 1/4 TB|CM 850 SilentPro|HAF-X|

  15. #15
    Registered User
    Join Date: Oct:2003
    Location:
    Posts: 4,852
    Postgre. , MySQL . Postgre 7-8 . 8.3, . , .
    Core i7 6950X watercooled|RVE|4x RX VEGA|4x4GB GEIL DRAGON DDR4-3333CL16|Corsair AX1600i|SSD 850 EVO 250GB|WD1001FALS|HP LP2475w|Creative X-Fi Titanium Pro|Luxeon 5.1WH|Logitech G500|Lian Li A70B

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Copyright © 1999-2011 . .
iskamPC.com | mobility.BG | Bloody's Techblog | | 3D Vision Blog |