Solving query problem: How to get all the results from the Customers table and replace the null values ​​in the Status and Fax columns with empty strings?
P粉726234648
P粉726234648 2024-04-01 15:06:14
0
1
442

I am very confused about this question. The problem is that I know I can use the COALESCE function, but how? Because there are two columns here, State and Fax.

P粉726234648
P粉726234648

reply all(1)
P粉262073176

You can use if null

select id,ifnull(state, '') as state ,ifnull(fax, '') as fax from customer
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!