Search
 
SCRIPT & CODE EXAMPLE
 

SQL

mariadb case switch

mysql> SELECT CASE  WHEN 2>3 THEN 'this is true' ELSE 'this is false' END; 
+-------------------------------------------------------------+
| CASE  WHEN 2>3 THEN 'this is true' ELSE 'this is false' END |
+-------------------------------------------------------------+
| this is false                                               | 
+-------------------------------------------------------------+
Comment

PREVIOUS NEXT
Code Example
Sql :: sql insert data 
Sql :: how to get last inserted id in sql server c# 
Sql :: sql arithmetic operators 
Sql :: how to delete user sql server 
Sql :: set column width in sqlplus 
Sql :: sql group by 
Sql :: sqlite modify row 
Sql :: mysqldump 1 table only 
Sql :: multiple left join mysql 
Sql :: what is cursor in sql server with example 
Sql :: mysql dump 
Sql :: mysql filter by date mount 
Sql :: sql 2 way of select unique 
Sql :: count sql 
Sql :: pl sql auto increment 
Sql :: having clause in sql 
Sql :: sql highest salary by location 
Sql :: back up stored procedures mysql 
Sql :: hidden error sql codeigniter 3 
Sql :: SQL DATEDIFF(date_part, start_date, end_date) 
Sql :: date datatype in livesql 
Sql :: compress sql file database ubuntu 
Sql :: create temp table sql 
Sql :: bigquery information_schema schema all columns 
Sql :: homebrew mysql service not starting 
Sql :: insert or update cassandra 
Sql :: truncate table sql server foreign key 
Sql :: postgresql create table add unique constraints 
Sql :: inserted row count tsql 
Sql :: oracle list partitions 
ADD CONTENT
Topic
Content
Source link
Name
9+5 =