/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

1 vote162 views1 answer
Oracle sql pad left zeros
SQL
0 vote167 views1 answer
Sql track modification
SQL
0 vote142 views1 answer
Fast sql column count
SQL
14 votes149 views5 answers
Sql oracle limit
SQL
1 vote157 views2 answers
Begin transaction sql
SQL
0 vote156 views1 answer
Plpgsql if statement
SQL
8 votes142 views2 answers
Phpmyadmin default password
SQL
6 votes238 views2 answers
Database url postgres
SQL
9 votes139 views3 answers
Show table columns mysql command line
SQL
1 vote139 views1 answer
Mysql check string don't have number
SQL