/SQL/Provide hardcoded value in the mysql query

Provide hardcoded value in the mysql query

SELECT "" as Serial,
   "" as Object_ID,
   "" as ObjectDEsc,
   "" as Object_Num,
   "--(UNKNOWN -- )" as DropList
UNION
 SELECT CAST(p.Serial AS UNSIGNED INTEGER) as Serial, 
  p.Object_ID, 
  p.Part_ID, 
  st.Description AS ObjectDesc, 
  s.Object_Num, 
  concat(Serial,' (',st.Desc,' #',s.Object_Num,')') as DropList 
 FROM Parts p LEFT JOIN Objects s ON p.Object_ID = s.Object_ID 
 LEFT JOIN ObjectTypes st ON s.ObjectType_ID = st.ObjectType_ID

Source: stackoverflow.com

Similar codes

0 vote278 views1 answer
Varchar format not case sensitive sql
SQL
2 votes269 views1 answer
Query to find table size in oracle 12c
SQL
0 vote268 views1 answer
Truncate table sql server foreign key
SQL
-1 vote307 views1 answer
Mysql faster insert
SQL
1 vote285 views1 answer
Sql headers delphi
SQL
1 vote271 views1 answer
Real world example of nosql
SQL
0 vote259 views1 answer
Create domain sql
SQL
0 vote289 views1 answer
Insert overwrite table in mysql in nifi
SQL
0 vote319 views2 answers
ON DUPLICATE KEY UPDATE for postgres
SQL
10 votes265 views4 answers
Primary key sql
SQL