Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. Database & SysAdmin
  3. Database
  4. MySQL

MySQL

Scheduled Pinned Locked Moved Database
mysqltutorial
6 Posts 2 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • M Offline
    M Offline
    Member_14370046
    wrote on last edited by
    #1

    How to add a single data for multiple times using MySQL

    L 1 Reply Last reply
    0
    • M Member_14370046

      How to add a single data for multiple times using MySQL

      L Offline
      L Offline
      Lost User
      wrote on last edited by
      #2

      At a guess, by writing some code that runs in a loop. But if you want a proper answer you will need to provide more information about what you are trying to do.

      M 2 Replies Last reply
      0
      • L Lost User

        At a guess, by writing some code that runs in a loop. But if you want a proper answer you will need to provide more information about what you are trying to do.

        M Offline
        M Offline
        Member_14370046
        wrote on last edited by
        #3

        Actually, the concept is..."if i select january 2018 and enter some data that data should enter repeatedly from january to december 2018....if i select november 2018 and enter some data that data should enter repeatedly from november to december 2018..." Based on Month we selecting it should enter into database....Here i got the answer but i want query to insert....[Can't able to insert multiple data]. Here is my Query which i have in my code.... "INSERT INTO alem_meeting (meeting_date, meeting_start_time, meeting_end_time, meeting_type, meeting_manager_name, meeting_manager_email, meeting_client_name, meeting_client_contact, meeting_client_email, meeting_client_address1, meeting_client_address2, meeting_special_notes, meeting_status)VALUES ?"; Error which is showing there: "VALUES ?"

        L 1 Reply Last reply
        0
        • L Lost User

          At a guess, by writing some code that runs in a loop. But if you want a proper answer you will need to provide more information about what you are trying to do.

          M Offline
          M Offline
          Member_14370046
          wrote on last edited by
          #4

          Here i'm using NodeJs for server side

          L 1 Reply Last reply
          0
          • M Member_14370046

            Actually, the concept is..."if i select january 2018 and enter some data that data should enter repeatedly from january to december 2018....if i select november 2018 and enter some data that data should enter repeatedly from november to december 2018..." Based on Month we selecting it should enter into database....Here i got the answer but i want query to insert....[Can't able to insert multiple data]. Here is my Query which i have in my code.... "INSERT INTO alem_meeting (meeting_date, meeting_start_time, meeting_end_time, meeting_type, meeting_manager_name, meeting_manager_email, meeting_client_name, meeting_client_contact, meeting_client_email, meeting_client_address1, meeting_client_address2, meeting_special_notes, meeting_status)VALUES ?"; Error which is showing there: "VALUES ?"

            L Offline
            L Offline
            Lost User
            wrote on last edited by
            #5

            You have 13 column names but you only specify a single VALUE.

            1 Reply Last reply
            0
            • M Member_14370046

              Here i'm using NodeJs for server side

              L Offline
              L Offline
              Lost User
              wrote on last edited by
              #6

              SQL Tutorial[^]

              1 Reply Last reply
              0
              Reply
              • Reply as topic
              Log in to reply
              • Oldest to Newest
              • Newest to Oldest
              • Most Votes


              • Login

              • Don't have an account? Register

              • Login or register to search.
              • First post
                Last post
              0
              • Categories
              • Recent
              • Tags
              • Popular
              • World
              • Users
              • Groups