/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

-1 vote145 views1 answer
Ms sql select datetime as date
SQL
2 votes118 views2 answers
Function in sql
SQL
0 vote160 views1 answer
Alter domain sql
SQL
0 vote150 views3 answers
Call to undefined function mysql_connect()
SQL
0 vote132 views1 answer
Pl sql turn off variable substitution
SQL
0 vote138 views1 answer
Mysql get date diff in months
SQL
0 vote161 views1 answer
Where to find pg_hba.conf in ubuntu
SQL
1 vote176 views1 answer
How-can-i-start-postgresql-server-on-mac-os-x
SQL
0 vote133 views1 answer
Mysql sum per week
SQL
0 vote140 views1 answer
Sqlserver now
SQL