Showing posts with label mysql how to. Show all posts
Showing posts with label mysql how to. Show all posts

MySQL - INSERT INTO

"users" table:

user_id user_name

INSERT INTO users (user_id, user_name) 
VALUES("1", "Jimmy McNulty");
Result:

user_id user_name
1 Jimmy McNulty

MySQL - SELECT

"users" table:

user_id name
1 John Doe
2 Jimmy McNulty

SELECT name FROM users;

Result:

name
John Doe
Jimmy McNulty