• 表内添加数据范例


    INSERT INTO shop VALUES('350','家乐福超市',200,'大连');

    #构造一些数据
    INSERT INTO shop VALUES('351','大润发超市',51,'大连');
    INSERT INTO shop VALUES('352','沃尔玛超市',143,'青岛');
    INSERT INTO shop VALUES('353','银座超市',52,'烟台');
    INSERT INTO shop VALUES('354','利群超市',65,'威海');
    INSERT INTO shop VALUES('355','家家乐超市',404,'北京');
    INSERT INTO shop VALUES('356','喜洋洋超市',3032,'济南');
    INSERT INTO shop VALUES('357','万象汇超市',87,'上海');
    INSERT INTO shop VALUES('358','银泰超市',378,'天津');
    INSERT INTO shop VALUES('256','万都汇超市',39,'天津');

    INSERT INTO goods VALUES('056','收音机',30.5);
    INSERT INTO goods VALUES('057','魅族手机',55.5);
    INSERT INTO goods VALUES('058','TCL电视',69);
    INSERT INTO goods VALUES('059','洗衣机',10);
    INSERT INTO goods VALUES('060','羽绒服',19.0);
    INSERT INTO goods VALUES('061','短裙',56.98);
    INSERT INTO goods VALUES('062','饮水机',24.98);
    INSERT INTO goods VALUES('063','笔记本',34);
    INSERT INTO goods VALUES('064','红米手机',79.9);
    INSERT INTO goods VALUES('065','荣耀手机',14.50);

  • 相关阅读:
    EMC研究院电面记
    被百度放了鸽子
    最长严格递增子序列算法
    括号配对问题
    RTP 协议
    C++ 纯虚函数, 记上一笔!
    一年又一年
    direct3d Colorkey 应用.
    CEGUI 中文输入与显示
    被遗忘的C,记录一笔
  • 原文地址:https://www.cnblogs.com/tiandlsd001/p/7927531.html
Copyright © 2020-2023  润新知