• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

SQL - Not able to get result with INSERT query


Excel Ninja

I am trying to write an INSERT query in my database.
Query is as below.

insert into mydatabase (Sr, Region, Name, MyDate, Amount) values (21, North, Sachin, 22-Oct-2018, 5000)
However when I run this query, only first and last column of the table are updated.
Rest of the tables are not updated. Can anyone please help me in this.