Results 1 to 21 of 21

Thread: ALTER- MySQL

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered User genn's Avatar
    Join Date: Feb:2003
    Location:
    Posts: 1,215

    ALTER- MySQL

    ( PHP + MySQL InnoDB ), / . MySQL - ?
    :
    http://www.rndblog.com/don%E2%80%99t...py-and-rename/

    , - ?
    , ALTER- , 200 ... .

    .
    ( tbl_fields_def ) relation "" ( tbl_clients ), ( tbl_field_value ) , - . - , . / tbl_clients, tbl_fields_value. , , .

    , .

  2. #2
    Mire-x
    Join Date: Apr:2005
    Location: Sofia
    Posts: 763
    - , . - .

    , - . , MyISAM .
    (10b) || !(10b)

  3. #3
    Banned haste's Avatar
    Join Date: Mar:2006
    Location:
    Posts: 759
    " / /" .

    , " " . - , "" "" .

    "" , !

    : / / MySQL " ", storage engine (.. InnoDB). InnoDB, .

  4. #4
    Registered User genn's Avatar
    Join Date: Feb:2003
    Location:
    Posts: 1,215
    , .
    , , , - .


  5. #5
    ! vbTheKing's Avatar
    Join Date: Sep:2003
    Location:
    Posts: 4,138
    , , , - - . : > > . , , .
    , ALTER- 200 . .

    EDIT:>> , , ...
    ''? * *
    - !
    ...

  6. #6
    Registered User genn's Avatar
    Join Date: Feb:2003
    Location:
    Posts: 1,215
    :
    . . , , .
    ( ) ... . , skype, , ..
    / .
    .. / .
    ( "" ) reg. expression, .

    ). . .

  7. #7
    Undead user Oldman's Avatar
    Join Date: Oct:2003
    Location: outside
    Posts: 432
    Quote Originally Posted by genn View Post
    :
    . . , , .
    ( ) ... . , skype, , ..
    Entity-attribute-value model. RDBMS . .
    .

  8. #8
    Registered User tedych's Avatar
    Join Date: Nov:2003
    Location:
    Posts: 17,654
    . " " .
    , , . . 1-2 .

  9. #9
    Registered User genn's Avatar
    Join Date: Feb:2003
    Location:
    Posts: 1,215
    Quote Originally Posted by tedych View Post
    . " " .
    , , . . 1-2 .
    !
    - , . "", 1 ...
    .

    EAV ... ( )

    [edit]
    @vbTheKing: , . -

  10. #10
    ! vbTheKing's Avatar
    Join Date: Sep:2003
    Location:
    Posts: 4,138
    . .
    , , - ( : http://app.formassembly.com/form-builder3.4.2/?).
    ...

    - . , - int text, :
    1. ( / - ), form_id, name, creator , ( , ).
    2. , - field_id, form_id, field_type, field_name, is_required, validation_method .. .
    3. - record_id, form_id, timestamp, user_id, user_ip... , (user_id , ), ..
    4. integer - : record_id, field_id, value, int,
    5. text - : record_id, field_id, value, text,

    , 2, HTML. , 3, ID- int 4, record_id id 3. text 5 .. .

    -, - ... , .
    ''? * *
    - !
    ...

  11. #11
    Registered User tedych's Avatar
    Join Date: Nov:2003
    Location:
    Posts: 17,654
    " ", " , ..".
    - vbTheKing, "" , 1-2- , , N , .
    () - ID- tbl_clients. , - ...

  12. #12
    Registered User genn's Avatar
    Join Date: Feb:2003
    Location:
    Posts: 1,215
    Quote Originally Posted by tedych View Post
    " ", " , ..".
    - vbTheKing, "" , 1-2- , , N , .
    () - ID- tbl_clients. , - ...
    , , . ,

  13. #13
    Deleted User 4eRNoBiL's Avatar
    Join Date: Oct:2005
    Location:
    Posts: 739
    vbTheKing, 1 2 , 3,4,5 id- , .., - data (), , -? - . .
    Fujistu Lifebook E756 | Core i7-6500U / 400MHz-3.1GHz | 8 GB DDR4-2133 | Samsung PM871 / 256 GB SSD | 15" 1920x1080 | Manjaro Linux + kernel 4.19

  14. #14
    Registered User genn's Avatar
    Join Date: Feb:2003
    Location:
    Posts: 1,215
    EAV , .
    - , , ... EAV.
    , EAV - Magneto, drupal . open source , , , :
    , . "" . .
    MVC , , .

  15. #15
    ! vbTheKing's Avatar
    Join Date: Sep:2003
    Location:
    Posts: 4,138
    4eRNoBiL, . -, , 10 000 , " " . ?
    , 20-30 , 2-3. .
    genn, ( ), JOIN- , ALTER- .

    EAV Magento - , Magento ( , EAV), - ecommerce. , Magento -, opensource .
    ''? * *
    - !
    ...

  16. #16
    Deleted User 4eRNoBiL's Avatar
    Join Date: Oct:2005
    Location:
    Posts: 739
    ... ?
    , ? -. , - id- . , , JOIN -.
    . .
    .
    Fujistu Lifebook E756 | Core i7-6500U / 400MHz-3.1GHz | 8 GB DDR4-2133 | Samsung PM871 / 256 GB SSD | 15" 1920x1080 | Manjaro Linux + kernel 4.19

  17. #17

  18. #18
    Registered User
    Join Date: Jul:2005
    Location: Sofiq
    Posts: 2,798
    . serialize. , . , .

  19. #19
    ! vbTheKing's Avatar
    Join Date: Sep:2003
    Location:
    Posts: 4,138
    . ... - .
    ''? * *
    - !
    ...

  20. #20
    Registered User
    Join Date: Jul:2005
    Location: Sofiq
    Posts: 2,798
    , . , . , (user id, ...). , .

  21. #21
    Registered User genn's Avatar
    Join Date: Feb:2003
    Location:
    Posts: 1,215
    , , , .
    .
    , ,

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 |