/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

2 votes325 views1 answer
When matched in sql server
SQL
2 votes340 views3 answers
Sql server: how to concatenate column data using comma
SQL
3 votes303 views1 answer
Sql multiple column index
SQL
3 votes322 views2 answers
Sql asc
SQL
16 votes378 views1 answer
Mysql mediumint max value
SQL
0 vote307 views1 answer
Mysql local password denied
SQL
4 votes325 views4 answers
Pl sql output
SQL
0 vote314 views1 answer
Bus source and destination equal to destination and source of another by sql query
SQL
6 votes348 views3 answers
Rename column ORACLE
SQL
8 votes317 views1 answer
Oracle search source code
SQL