Error in Slide

Discussion in 'Big Data and Analytics' started by _4128, Jan 24, 2017.

  1. _4128

    _4128 Member
    Alumni

    Joined:
    Jan 9, 2017
    Messages:
    4
    Likes Received:
    0
    Please check the attachment where the insert statement has an error. It would be good to provide the right syntax to improve the quality of the material
     

    Attached Files:

    #1
  2. DeshDeep Singh

    DeshDeep Singh Well-Known Member
    Simplilearn Support Alumni

    Joined:
    Sep 22, 2015
    Messages:
    932
    Likes Received:
    62

    HI ,

    You can insert new data into table by two ways.

    1. load the data of a file into table using load command.

      LOAD DATA [LOCAL] INPATH 'filepath' [OVERWRITE] INTO TABLE tablename.

    2. you can insert new data into table by using select query.

      INSERT INTO table tablename1 select columnlist FROM secondtable;
     
    #2

Share This Page