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 Thursday, August 23, 2018, 'Vinod Kumar' via Django users < django-users@googlegroups.com> wrote: > By default model have id column , so you have to put value of id. > > On Thu, Aug 23, 2018, 5:00 PM Vishak Raj <vishak.sha...@gmail.com> 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,%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: table webapp_information has 32 columns >> but 31 values were supplied >> >> I created the only 31 columns in models.py >> >> >> What to do.. thanks >> >> -- >> You received this message because you are subscribed to the Google Groups >> "Django users" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to django-users+unsubscr...@googlegroups.com. >> To post to this group, send email to django-users@googlegroups.com. >> Visit this group at https://groups.google.com/group/django-users. >> To view this discussion on the web visit https://groups.google.com/d/ >> msgid/django-users/10ad145e-5e0b-4d52-a8c9-54af6fa69fba% >> 40googlegroups.com >> <https://groups.google.com/d/msgid/django-users/10ad145e-5e0b-4d52-a8c9-54af6fa69fba%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> For more options, visit https://groups.google.com/d/optout. >> > > ************************************************************************ > > *This e-mail and all attachments are intended solely for use by the > intended recipient and may contain confidential / proprietary information > of KiwiTech, LLC, subject to important disclaimers and conditions including > restrictions on the use, disclosure, transfer or export of such > information.* *If you have received this message in error or are not the > named recipient(s), please immediately notify the sender at the telephone > number stated above or by reply e-mail and delete this e-mail from your > computer* > > -- > You received this message because you are subscribed to the Google Groups > "Django users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to django-users+unsubscr...@googlegroups.com. > To post to this group, send email to django-users@googlegroups.com. > Visit this group at https://groups.google.com/group/django-users. > To view this discussion on the web visit https://groups.google.com/d/ > msgid/django-users/CAJOHC1xufhygtCtBOjxZhUf26oonY > YLxaZeqv05QRJS%3DK%2BPOJQ%40mail.gmail.com > <https://groups.google.com/d/msgid/django-users/CAJOHC1xufhygtCtBOjxZhUf26oonYYLxaZeqv05QRJS%3DK%2BPOJQ%40mail.gmail.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > -- vishakraj -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscr...@googlegroups.com. To post to this group, send email to django-users@googlegroups.com. Visit this group at https://groups.google.com/group/django-users. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAFL71Cz5ZrAwDc2EgrXfX-QOLt-nL4tcM3fyMHGGRZQEjyrJJw%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.