/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

5 votes122 views1 answer
Oracle asynchronous update
SQL
0 vote116 views1 answer
Oracle create package specification
SQL
1 vote117 views1 answer
Expression number 1 of select list is not in group by clause
SQL
1 vote128 views1 answer
How to ckeck that email is present in databse in mysqli
SQL
1 vote120 views1 answer
Oracle apex version view
SQL
1 vote117 views1 answer
Oracle sql create or replace view
SQL
0 vote126 views1 answer
Sql ignore
SQL
0 vote129 views1 answer
Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'updated_at' in 'field list'
SQL
0 vote121 views1 answer
Mysql update from n to 100
SQL
0 vote127 views1 answer
How to know if table in rigt or left in sql
SQL