Re: Insert values in python manage.py shell using custom sql

2018-08-23 Thread Vishak Raj
Thank you.. I am new to django,. How can we say the data are in order to django and it asked the value for the id column.. How can it get the last id column.. Thanks in advance shanmu On Fri 24 Aug, 2018, 12:13 AM Aware Fun, wrote: > We dont need to give primary key it automatically define th

Re: Insert values in python manage.py shell using custom sql

2018-08-23 Thread Aware Fun
Primary key is a unique kye that differentiate you values like in order 1,2,3 like this or u can say that your values are are stored in order.In django when u create object and give values first it by default assign the primary key to 1. rahul On Thu, Aug 23, 2018, 11:20 PM Vishak Raj wrote:

Re: Insert values in python manage.py shell using custom sql

2018-08-23 Thread Aware Fun
We dont need to give primary key it automatically define the key. rahul On Thu, Aug 23, 2018, 11:20 PM Vishak Raj wrote: > Hello > > Thanks for replying.. > > I have a confusion > > In normal python shell, we import sqlite3 and insert values without giving > the Id or primary key.. > > Why we

Re: Insert values in python manage.py shell using custom sql

2018-08-23 Thread Vishak Raj
Hello Thanks for replying.. I have a confusion In normal python shell, we import sqlite3 and insert values without giving the Id or primary key.. Why we giving primary key in django.. Is it possible to insert values without primary key like we give in python shell.. Thanks in advance On Thur

Re: Insert values in python manage.py shell using custom sql

2018-08-23 Thread 'Vinod Kumar' via Django users
By default model have id column , so you have to put value of id. On Thu, Aug 23, 2018, 5:00 PM Vishak Raj wrote: > hello, > > i am inserting the values in the table using custome sql in django shell.. > > p.execute('INSERT INTO webapp_information > VALUES(%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s

Insert values in python manage.py shell using custom sql

2018-08-23 Thread Vishak Raj
hello, i am inserting the values in the table using custome sql in django shell.. p.execute('INSERT INTO webapp_information VALUES(%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)',i) i is the list of values it shows the error:OperationalError: tabl