/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 vote310 views1 answer
Mysql add to number
SQL
8 votes306 views1 answer
Oracle current date plus 1 month
SQL
0 vote283 views1 answer
Sql xampp gabungan nama awal dan akhir
SQL
-1 vote340 views1 answer
Difference berween database and data base management system
SQL
11 votes346 views2 answers
Import mysql dump command line windows
SQL
15 votes302 views6 answers
Laravel db transaction
SQL
0 vote273 views1 answer
Mysqli_real_connect(): (28000/1045): Access denied for user 'u0738423'@'www8.aname.net' (using password: YES)
SQL
0 vote322 views1 answer
Mysql workbench Error Code: 2013. Lost connection to MySQL server during query
SQL
0 vote281 views1 answer
Mysql procedure between two tables
SQL
0 vote297 views1 answer
Sql put two columns into one
SQL