/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 vote226 views1 answer
Sql insert query list of dictionaries
SQL
0 vote210 views1 answer
How to print out column name differently in mysql
SQL
0 vote211 views1 answer
How to find unique key in sql
SQL
1 vote200 views1 answer
Sequence item 6 expected str instance bytes found mysql workbench
SQL
1 vote213 views1 answer
Declare variables sql
SQL
1 vote219 views1 answer
Oracle sql create view
SQL
4 votes229 views3 answers
Mysql get column names from table
SQL
0 vote218 views2 answers
How to combine diff colmun value using group by postgres
SQL
0 vote214 views1 answer
Postpresql relation not found
SQL
1 vote214 views1 answer
Create table variable in sql stored procedure
SQL