/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 votes399 views2 answers
Mysql on duplicate key update get value from values
SQL
12 votes363 views6 answers
Select distinct
SQL
0 vote356 views1 answer
Convert polygon to text in mysql
SQL
0 vote346 views1 answer
A network or instance-specific error sql server
SQL
0 vote335 views1 answer
How much table store postgres
SQL
5 votes372 views1 answer
Oracle add time to date
SQL
5 votes384 views1 answer
Sql integer to serial
SQL
11 votes342 views2 answers
Safe mode off mysql
SQL
0 vote337 views1 answer
Eliminar ultimo carcacter mysql
SQL
0 vote341 views1 answer
Sql server split string and insert into table select
SQL