/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 vote305 views1 answer
Where in clause tsql
SQL
0 vote310 views1 answer
Get foreign table names mysql
SQL
4 votes379 views2 answers
Sql display today's date
SQL
0 vote336 views1 answer
Oracle current timestamp insert statement
SQL
0 vote292 views1 answer
Zsh: command not found: mysql mamp
SQL
0 vote324 views1 answer
Mysql join column order By and group By
SQL
0 vote319 views1 answer
Sql server query database space available
SQL
0 vote340 views1 answer
Find the names of sailors who have reserved a red boat, and list in the order of age
SQL
0 vote296 views1 answer
Selects all the columns from the sailors table
SQL
0 vote333 views1 answer
T sql dynamic top n query
SQL