Change Null Values in a Table to the Previous Value
[]
['Create table If Not Exists CoffeeShop (id int, drink varchar(20))', 'Truncate table CoffeeShop', "insert into CoffeeShop (id, drink) values ('9', 'Rum and Coke')", "insert into CoffeeShop (id, drink) values ('6', NULL)", "insert into CoffeeShop (id, drink) values ('7', NULL)", "insert into CoffeeShop (id, drink) values ('3', 'St Germain Spritz')", "insert into CoffeeShop (id, drink) values ('1', 'Orange Margarita')", "insert into CoffeeShop (id, drink) values ('2', NULL)"]
{"mysql": ["Create table If Not Exists CoffeeShop (id int, drink varchar(20))"], "mssql": ["Create table CoffeeShop (id int, drink varchar(20))"], "oraclesql": ["Create table CoffeeShop (id int, drink varchar(20))"], "database": true, "name": "change_null_values", "pythondata": ["CoffeeShop = pd.DataFrame([], columns=['id', 'drink']).astype({'id':'Int64', 'drink':'object'})"], "postgresql": ["Create table If Not Exists CoffeeShop (id int, drink varchar(20))"], "database_schema": {"CoffeeShop": {"id": "INT", "drink": "VARCHAR(20)"}}}
{"mysql": ["MySQL", "<p><code>MySQL 8.0</code>.</p>"], "mssql": ["MS SQL Server", "<p><code>mssql server 2019</code>.</p>"], "oraclesql": ["Oracle", "<p><code>Oracle Sql 11.2</code>.</p>"], "pythondata": ["Pandas", "<p>Python 3.10 with Pandas 2.2.2 and NumPy 1.26.4</p>"], "postgresql": ["PostgreSQL", "<p>PostgreSQL 16</p>"]}
['Database']