Experienced Senior Software Engineer with a demonstrated history of working in the information technology and services industry. Skilled in .Net Software Development, MSSQL, Oracle Database, C#, PHP, Google Cloud Platform and Microsoft Azure. Strong engineering professional with a Bachelor’s Degree focused in Artificial Intelligence from Universiti Teknologi MARA Malaysia. Currently work as Lead Solution Architect and Director of new startup IT company named Aurora Cloud Works Sdn. Bhd.

SQL, list all column in table

To write the INSERT statement that required you to write all the field is stress work for developer.. Here is the SQL command to return all column from a table that we can direct copy and past into our insert statement.

SELECT column_name + ‘,’
FROM information_schema.columns
WHERE table_name = ‘users’