[MySQL Tutorial]: Basic Queries (Select, Update, Delete, Insert)

preview_player
Показать описание
In this video I discuss the basic MySQL queries, including select, update, delete and insert. The goal is to show the basic syntax of the query and thus none of them are highly complicated.

If you have any questions or comments please leave me a comment or send a message and I will get back to you as soon as possible!
  1. PartiallyDeveloped
  2. mysql
  3. tutorial
  4. howto
  5. basic
  6. help
Рекомендации по теме
MySQL: How to 0:05:01

MySQL: How to SELECT data from a TABLE

SQL SELECT Tutorial 0:08:56

SQL SELECT Tutorial |¦| SQL Tutorial |¦| SQL for Beginners

MySQL: SUBQUERIES 0:06:46

MySQL: SUBQUERIES

Learn Basic SQL 0:17:40

Learn Basic SQL in 15 Minutes | Business Intelligence For Beginners | SQL Tutorial For Beginners 1/3

MySQL - The 0:17:17

MySQL - The Basics // Learn SQL in 23 Easy Steps

MySQL Tutorial for 0:08:21

MySQL Tutorial for Beginners 8 - Using SELECT Statement to Query Data In MySQL

MySQL Workbench Tutorial 0:17:49

MySQL Workbench Tutorial

MySQL: How to 0:08:10

MySQL: How to create a TABLE

Case - When 0:03:53

Case - When - Then - Else - End | MYSQL | Tutorial video by Rajdeep Da | Part - III

SQL Tutorial for 0:44:57

SQL Tutorial for Beginners

MySQL Full Course 3:00:00

MySQL Full Course for free 🐬

SQL Tutorial for 3:10:19

SQL Tutorial for Beginners [Full Course]

MySQL: JOINS are 0:05:04

MySQL: JOINS are easy (INNER, LEFT, RIGHT)

Learn SQL In 0:56:24

Learn SQL In 60 Minutes

MySQL VIEWS are 0:06:03

MySQL VIEWS are awesome

Introduction to Queries 0:10:09

Introduction to Queries with MySQL Workbench & Sakila Sample Database

DBeaver Tutorial - 0:15:50

DBeaver Tutorial - How to Use DBeaver (SQL Editor)

SQL Basics for 0:27:51

SQL Basics for Beginners | Learn SQL | SQL Tutorial for Beginners | Edureka

MySQL UNIONS are 0:04:14

MySQL UNIONS are easy

Complete SQL Query 0:37:24

Complete SQL Query in One Video | SQL Tutorial for Beginners| Complete MYSQL Query in One Video 2023

Python MySQL Tutorial 0:13:10

Python MySQL Tutorial - Setup & Basic Queries (w/ MySQL Connector)

SQL Tutorial - 4:20:39

SQL Tutorial - Full Database Course for Beginners

SQL - Complete 3:16:14

SQL - Complete Course in 3 Hours | SQL One Shot using MySQL

Functions in MySQL 0:03:45

Functions in MySQL are easy

Комментарии
Автор

Thanks a lot for uploading this video ! A clear description of how PHP and MySQL together work, is given here

teja-tfhx
Автор

Good Video. Explaining the values as well.

davidsmith-wsbz
Автор

It's a very good tutorial for beginner who want to lean MySQL, thank you.

felixleung
Автор

Thank you for this. I was getting syntax errors because I had replaced all back-ticks with regular single quotes because these latter were more visible to me. I was being done in by back-ticks!! LOL.
Thanks again!

gugsah
Автор

Thanks! for taking the time to make the video, it really helped me out.

johnzoidberg
Автор

@chimamiresatoh It can be done with a single query.

The basic syntax is as follows:
INSERT INTO `table_name` (`columns`, `here`) VALUES('1', '2'), ('1', '2')

So in your case:
INSERT INTO `table_name` (`Name`, `Job`) VALUES('Name1', 'Job1'), ('Name2', 'Job2')

Hope this helped!

PartiallyDeveloped
Автор

How would I go about populating a table with several values, but ignoring certain columns?
For instance, allowing the ID field to auto-increment, but inserting several values into `Name` and several into `Job`?

Can I do that with a single query?

chimamiresatoh
Автор

@gugsah It's a very common error especially for beginner programmers!

Glad to hear this was helpful! Happy coding!

PartiallyDeveloped
Автор

How can insert a column in mysql database's table. Pls let me explain it. Thnx

leonardoddm