/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 votes276 views2 answers
Mysql alter column default
SQL
1 vote277 views3 answers
Sql select only time from datetime
SQL
0 vote267 views1 answer
Assign value to var in SQL
SQL
0 vote286 views4 answers
What is unique key in sql
SQL
22 votes278 views4 answers
Mysql reset auto increment id
SQL
0 vote310 views1 answer
Sql show founctions
SQL
0 vote276 views1 answer
SQL Query to delete all the tables in a database
SQL
4 votes276 views2 answers
Postgres update single column
SQL
0 vote287 views2 answers
.... ERROR! The server quit without updating PID file mysql centos
SQL
8 votes292 views2 answers
Oracle undo usage
SQL