What is the correct syntax to insert a new row into a table named users with columns id, name, email?

Question

What is the correct syntax to insert a new row into a table named   users   with columns  id ,  name ,  email ?

Accepted Answer

INSERT INTO users (id, name, email)  
 VALUES (1, 'John Doe', ' john.doe@example.com ');

Answer

INSERT INTO (id, name, email)  
 VALUES (1, 'John Doe', ' john.doe@example.com ');

Answer

INSERT INTO users  
 SET id=1, name='John Doe', email=' john.doe@example.com ';

Answer

INSERT INTO table users (id, name, email)  
 VALUES (1, 'John Doe', ' john.doe@example.com ');

Crowdly