COALESCE
Vadnica logo
search sentiment_satisfied
vadnica logo
x
HTML CSS JavaScript jQuery SQL PHP Laravel
HTML CSS JavaScript jQuery MySQL PHPStorm Database

MySQL SQL

SELECT DISTINCT WHERE AND OR NOT ORDER BY INSERT INTO NULL UPDATE DELETE LIMIT MAX MIN COUNT AVG SUM LIKE WILDCARDS IN BETWEEN AS INNER JOIN LEFT JOIN RIGHT JOIN CROSS JOIN SELF JOIN UNION GROUP BY HAVING EXISTS ANY ALL INSERT SELECT CASE IF NULL COALESCE Operaterji

MySQL Database

CREATE DATABASE DROP DATABASE CREATE TABLE DROP TABLE ALTER TABLE CONSTRAINTS NOT NULL UNIQUE PRIMARY KEY FOREIGN KEY CHECK DEFAULT CREATE INDEX AUTO-INCREMENT DATE CREATE VIEW FUNKCIJE DATA TYPE Združevalne funkcije XAMPP PHP Laravel

COALESCE

Funkcija COALESCE() vrne prvo ne ničelno vrednost v tabeli. Za primer bomo uporabili tabelo z imenom sadje.

id_sadja ime_sadja barva_sadja
1 Banane rumene
2 Jagode rdeče
3 Jabolka <NULL>
4 <NULL> modre
5 Kivi <NULL>
6 <NULL> <NULL> 
SELECT ime_sadja, barva_sadja, COALESCE(ime_sadja, 'prazno')
FROM sadje;
COALESCE
COALESCE

Hvala za obisk! Dodajam politiko zasebnosti.

© 2024 Vse pravice pridržane.

Donirajte preko PayPal ADMIN