/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 vote194 views1 answer
Alter table add column in SQL Server- NAYCode.com
SQL
0 vote283 views1 answer
Create dabase postgresql
SQL
11 votes203 views1 answer
Ddl materialized view
SQL
24 votes203 views5 answers
Sql server insert into select
SQL
104 votes1.1K views2 answers
Like in mysql
SQL
7 votes228 views6 answers
Mysql group concat
SQL
0 vote224 views1 answer
How to see the query of a view in mysql
SQL
2 votes219 views1 answer
Oracle apex who is connected
SQL
0 vote167 views2 answers
Spring properties file for db
SQL
1 vote294 views1 answer
Write an SQL query to print details of the Workers whose FIRST_NAME ends with ‘h’ and contains six alphabets.
SQL