How to check if the data is empty in a database?

Thread Rating:

Thread Modes

How to check if the data is empty in a database?

Larz60+
aetate et sapientia
Super Moderators

Posts: 11,887

Threads: 474

Joined: Sep 2016

Reputation: 452

Aug-19-2017, 03:58 PM

you can find all empty rows with '

SELECT channel FROM programs WHERE program_id is NULL;'

Messages In This Thread

RE: How to check if the data is empty in a database? - by Larz60+ - Aug-19-2017, 03:58 PM

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	Help with to check an Input list data with a data read from an external source	sacharyya	3	578	Mar-09-2024, 12:33 PM Last Post: Pedroski55
	how do you style data frame that has empty rows.	gsaray101	0	566	Sep-08-2023, 05:20 PM Last Post: gsaray101
	How to detect abnormal data in big database python	vanphuht91	5	1,228	Jun-27-2023, 11:22 PM Last Post: Skaperen
	Database that can compress a column, or all data, automatically?	Calab	3	1,296	May-22-2023, 03:25 AM Last Post: Calab
	[SOLVED] [sqilte3] Check if column not empty?	Winfried	5	1,223	Jan-28-2023, 12:53 PM Last Post: Winfried
	Basic SQL query using Py: Inserting or querying sqlite3 database not returning data	marlonbown	3	1,493	Nov-08-2022, 07:16 PM Last Post: marlonbown
	Showing an empty chart, then input data via function	kgall89	0	1,030	Jun-02-2022, 01:53 AM Last Post: kgall89
	I need help parsing through data and creating a database using beautiful soup	username369	1	1,758	Sep-22-2021, 08:45 PM Last Post: Larz60+
	SaltStack: MySQL returner save less data into Database table columns	xtc14	2	2,240	Jul-02-2021, 02:19 PM Last Post: xtc14
	Looping to read data in database	CEC68	1	1,777	Sep-24-2020, 08:54 PM Last Post: scidam

Users browsing this thread: 1 Guest(s)