2020年4月27日

    1. INSERT INTO users (name,phone)VALUES('QT3,'13245564');
    2. INSERT INTO users (name,phone)VALUES('QT4,'13245565');
    3. INSERT INTO users VALUES(0,'QT5,'13245566','123456');
    4. INSERT INTO users (name,phone)
    5. VALUES
    6. ('QT6','13245567'),
    7. ('QT7','13245568')
    8. ;
    9. INSERT INTO users
    10. VALUES
    11. (0,'QT8','13245569,'123456'),
    12. (0,'QT9','132455610,'123456')
    13. ;
    15. INSERT INTO birds_body_shapes(body_id, body_shape)
    16. VALUES
    17. ('HMD','Hummingbird'),
    18. ('LLW','Long-Legged wader'),
    19. ('MHH','Marsh Hen'),
    20. ('PHB','Perching Bird'),
    21. ('PWB','Perching Water Bird')
    22. ;
    24. INSERT INTO birds_wing_shapes(wing_id,wing_shape)
    25. VALUES
    26. ('HMD','Broad'),
    27. ('LLW','Rounded'),
    28. ('MHH','Pointed'),
    29. ('PHB','Long'),
    30. ('PWB','Very Long')
    31. ;
    33. INSERT INTO users (name,phone)VALUES('QT3,'13245564');
    34. INSERT INTO users (name,phone)VALUES('QT4,'13245565');
    35. INSERT INTO users VALUES(0,'QT5,'13245566','123456');
    36. INSERT INTO users (name,phone)
    37. VALUES
    38. ('QT6','13245567'),
    39. ('QT7','13245568')
    40. ;
    41. INSERT INTO users
    42. VALUES
    43. (0,'QT8','13245569,'123456'),
    44. (0,'QT9','132455610,'123456')
    45. ;
    47. INSERT INTO birds_body_shapes(body_id, body_shape)
    48. VALUES
    49. ('HMD','Hummingbird'),
    50. ('LLW','Long-Legged wader'),
    51. ('MHH','Marsh Hen'),
    52. ('PHB','Perching Bird'),
    53. ('PWB','Perching Water Bird')
    54. ;
    56. INSERT INTO birds_wing_shapes(wing_id,wing_shape)
    57. VALUES
    58. ('HMD','Broad'),
    59. ('LLW','Rounded'),
    60. ('MHH','Pointed'),
    61. ('PHB','Long'),
    62. ('PWB','Very Long')
    63. ;
    65. INSERT INTO users (name,phone)VALUES('QT3,'13245564');
    66. INSERT INTO users (name,phone)VALUES('QT4,'13245565');
    67. INSERT INTO users VALUES(0,'QT5,'13245566','123456');
    68. INSERT INTO users (name,phone)
    69. VALUES
    70. ('QT6','13245567'),
    71. ('QT7','13245568')
    72. ;
    73. INSERT INTO users
    74. VALUES
    75. (0,'QT8','13245569,'123456'),
    76. (0,'QT9','132455610,'123456')
    77. ;
    79. INSERT INTO birds_body_shapes(body_id, body_shape)
    80. VALUES
    81. ('HMD','Hummingbird'),
    82. ('LLW','Long-Legged wader'),
    83. ('MHH','Marsh Hen'),
    84. ('PHB','Perching Bird'),
    85. ('PWB','Perching Water Bird')
    86. ;
    88. INSERT INTO birds_wing_shapes(wing_id,wing_shape)
    89. VALUES
    90. ('HMD','Broad'),
    91. ('LLW','Rounded'),
    92. ('MHH','Pointed'),
    93. ('PHB','Long'),
    94. ('PWB','Very Long')
    95. ;

    笔记：
    插入数据语法：
    INSERT INTO 表名[(字段1,字段2…)] VALUES(value…) [,(value…),…];
    插入单挑数据的基本方式：数据的基本单位都是按行来提示
    插入特点的字段：可以插入部分字段数据来添加一行，字段可以设置默认值，如果没有被插入则使用默认值；
    例如：INSERT INTO users(name,phone)VALUES(‘QT5’,’13245566’);
    NOT NULL指的是值不能为null，设置之后默认值还是null，那字段就必须被插入
    插入所有字段：
    INSERT INTO users VALUES(0,’QT6,’123456’);
    DEFAULT:直接使用数据库里的默认值
    一次插入多条数据
    指定字段

    INSERT INTO users (name,phone)
    VALUES
    (‘QT6’,’13245567’),
    (‘QT7’,’13245568’),
    …;
    所有字段
    INSERT INTO users
    VALUES
    (0,’QT8’,’13245569,’123456’),
    (0,’QT9’,’132455610,’123456’),
    …;
    明确插入：一次只能插入一条数据
    INSERT INTO 表名 SET 字段名1=值1[,字段名2=值2 …];
    INSERT INTO users SET name=’QT10’,phone=’132455611’;

    替换重复数据（擦汗如数据操作）

    支持多条数据插入
    在唯一键的字段下遇到重复值，则会删除数据表内原有的一行数据，再将新数据插入
    REPLACE INTO users(name,phone) VALUES(‘QT11’,’132455611’);