Jan-03-2022, 02:22 AM
(This post was last modified: Jan-03-2022, 02:22 AM by BrandonKastning.
Edit Reason: forgot some important information
)
Python Obstacles | Kapap | Wiki Scraped Content [Column Nulling]
I am trying to learn how to null every row in an entire MariaDB 10.4.22 Database!
I will put the solution in Python format.
This is what I have tried so far; instead of nulling current values to null value, I ended up with new inserted null rows. The ID column with AUTO_INCREMENT enabled also did not continue from entry 99 (I copied the Tables from another to create 1 for each American Independent and Free State, USA Constitutionally Guaranteed and Protected Republic.) For some reason this attempt at nulling the entire column because AK has Boroughs rather than American Counties. Started the entries at 128, then another 129 and 130 on my last when I understood what just happened.
Questions:
Does anyone know the MariaDB Syntax to actually achieve what I am trying to accomplish?
Does anyone know why my ID's did not continue at 99?
Does anyone know the correct syntax to null value an entire column? Would ALTER be more appropriate perhaps?
Thank you everyone for this forum!
Best Regards,
Brandon
I am trying to learn how to null every row in an entire MariaDB 10.4.22 Database!
I will put the solution in Python format.
This is what I have tried so far; instead of nulling current values to null value, I ended up with new inserted null rows. The ID column with AUTO_INCREMENT enabled also did not continue from entry 99 (I copied the Tables from another to create 1 for each American Independent and Free State, USA Constitutionally Guaranteed and Protected Republic.) For some reason this attempt at nulling the entire column because AK has Boroughs rather than American Counties. Started the entries at 128, then another 129 and 130 on my last when I understood what just happened.
Questions:
Does anyone know the MariaDB Syntax to actually achieve what I am trying to accomplish?
Does anyone know why my ID's did not continue at 99?
Database changed MariaDB [Eggnest]> INSERT INTO WTPO_Dirty_Wiki_Counties_AK(american_county_name) values(NULL); Query OK, 1 row affected (0.098 sec) MariaDB [Eggnest]> INSERT INTO WTPO_Dirty_Wiki_Counties_AK(american_county_name) values(NULL); Query OK, 1 row affected (0.087 sec) MariaDB [Eggnest]> INSERT INTO WTPO_Dirty_Wiki_Counties_AK(american_county_name) values(NULL); Query OK, 1 row affected (0.086 sec) MariaDB [Eggnest]>
Does anyone know the correct syntax to null value an entire column? Would ALTER be more appropriate perhaps?
Thank you everyone for this forum!
Best Regards,
Brandon
“And one of the elders saith unto me, Weep not: behold, the Lion of the tribe of Juda, the Root of David, hath prevailed to open the book,...” - Revelation 5:5 (KJV)
“And oppress not the widow, nor the fatherless, the stranger, nor the poor; and ...” - Zechariah 7:10 (KJV)
#LetHISPeopleGo
“And oppress not the widow, nor the fatherless, the stranger, nor the poor; and ...” - Zechariah 7:10 (KJV)
#LetHISPeopleGo