playing with dotnet core 31 - databases part 4 messing around with table row insert and delete

Channel:
Singapore Theo Ong Science and Engineering
Subscribers:
9,750
Published on ● Video Link: https://www.youtube.com/watch?v=tts8EBGkVBA


Duration: 16:22
21 views
0

(1) Always use backticks ````` for column names ONLY

(2) Create tables:

create table [tableName](
`column 1` int ,
`column 2` double,
...

primary key(`column 1`)
);

(3) Show columns from tables

show COLUMNS from table;
OR
show columns from table from database;

(4) insert data into tables

insert into tableName(
`column 1`,
`column 2`,
...)
values
(
"value for column 1",
"value for column 2",
...
);

(5) delete rows from table (example)

delete from tableName
where id = 1;

------------------ Useful Links ------------------------------------
use backticks for column names!
https://mariadb.com/kb/en/identifier-names/

To show the column names:
https://mariadb.com/kb/en/show-columns/

How to create table
https://www.mariadbtutorial.com/mariadb-basics/mariadb-create-table/

show columns in table
https://mariadb.com/kb/en/show-columns/

delete row from table
https://www.mariadbtutorial.com/mariadb-basics/mariadb-delete/

double data type syntax
https://mariadb.com/kb/en/double/

drop table
https://www.mariadbtutorial.com/mariadb-basics/mariadb-drop-table/


------------------ Video Sections --------------------------------
Chapters:
0:00 how to put column name with special characters and spaces using backticks
4:00 the number of decimal places in double is optional
4:30 testing if the data type string is valid... (it's not)
5:49 inserting data into the tables
7:06 show columns
7:50 inserting data into the table
8:49 disadvantage with using backticks
9:49 back to inserting of values
11:00 i forgot to give my id a value...
11:29 use backticks for table column names, inverted commas for table values
12:20 row of data successfully added!
13:06 deleting a row of data
15:50 dropping table and conclusionz




---------------------[Playlists and Relevant Github Repositories]----------------------------------------------

Fluid Mechanics and Git Repos:
https://www.youtube.com/playlist?list=PLhPfNw4V4_YSmdAXc6J0XOSQ1b27qsMGt
https://github.com/theodoreOnzGit/OpenFoam_heatTrf_YouTube

Petroleum Downstream Crash Course Playlist:
https://www.youtube.com/playlist?list=PLhPfNw4V4_YQ13CnhacUqEVk-tZlU4ISE

OpenFOAM for Windows 10 Beginner Playlist and some Git Repos
https://www.youtube.com/playlist?list=PLhPfNw4V4_YRhBU4IqSaToQ8_X543YQsZ
https://github.com/theodoreOnzGit/laminar_BL_OpenFOAM

OpenFOAM Intermediate Playlist and some Git Repos
https://www.youtube.com/playlist?list=PLhPfNw4V4_YSpWX6mSOlwWEOKVa6i_iuE
https://github.com/theodoreOnzGit/thin_pipeflow_snappyHexMesh

OpenFOAM Heat Transfer Playlist and GitHub Repo
https://www.youtube.com/playlist?list=PLhPfNw4V4_YR2Qa3Q9-AzNSF2J9Dc4_qT
https://github.com/theodoreOnzGit/OpenFoam_heatTrf_YouTube

Radiation Heat Transfer Learning Journal and Git Repos:
https://www.youtube.com/watch?v=uUzh9kh-WTo&list=PLhPfNw4V4_YRUUVUydQp-n6U-7uu1kJof
https://github.com/theodoreOnzGit/heatTransferTheory_YouTube

Convection Boundary Layer and git Repos:
https://www.youtube.com/playlist?list=PLhPfNw4V4_YR9pRBpp101Mkuds49vjQ63
https://github.com/theodoreOnzGit/heatTransferTheory_YouTube

Turbulence Modelling Playlist
https://www.youtube.com/watch?v=F_Rxv9uMM3g&list=PLhPfNw4V4_YSnbYkJIBQ1kRN06Mmxe2Be
https://github.com/theodoreOnzGit/turbulenceModelling

LabView Frequency Analysis and Fun (playlist and git repo)
https://www.youtube.com/playlist?list=PLhPfNw4V4_YQYE7XqTisMBkpm7gqNS_nl
https://github.com/theodoreOnzGit/Ted_labview_YouTube

Control Systems and Frequency Response
https://www.youtube.com/watch?v=qHY6y7JmB2U&list=PLhPfNw4V4_YRUuWnrtClovPKxU_gJOXH-
https://github.com/theodoreOnzGit/matlabFrequencyResponse.git

OpenFOAM C++
https://github.com/theodoreOnzGit/C-_YouTube_OpenFoam
https://www.youtube.com/playlist?list=PLhPfNw4V4_YT9OgqS7ZPlot_Ucxzc6pQJ

OpenFOAM Bash
https://github.com/theodoreOnzGit/Bash_OpenFOAM_YouTube
https://www.youtube.com/playlist?list=PLhPfNw4V4_YT5zjBhfj5Hj4r4D5eXilcU

Basic Samba
https://www.youtube.com/playlist?list=PLhPfNw4V4_YQuWJLufBUpNplitReZX0fB
https://github.com/theodoreOnzGit/sambaVideos

Manjaro Tips and Tricks
https://www.youtube.com/playlist?list=PLhPfNw4V4_YQuyXBfJxAvzHJTl0UiWx3h

lammps and Discrete Element Modelling (DEM)
https://www.youtube.com/playlist?list=PLhPfNw4V4_YTdRlnLiu2OUXeTf5ZNVQ9E

playing with dotnet core
https://www.youtube.com/playlist?list=PLhPfNw4V4_YQSTR8sqz0aRVzWlQBq3QUw
dotnet core github repo
https://github.com/theodoreOnzGit/dotnetCoreYoutube



Other Videos By Theo Ong Science and Engineering


2022-04-06playing with dotnet core 38 - dataStorage5 debugging the form and adding a repository interface
2022-04-06playing with dotnet core 37 - dataStorage4 adding forms for user input (and some bugs)
2022-04-05playing with dotnet core 36 - dataStorage3 injecting and testing a object with a list as singleton
2022-04-05playing with dotnet core 35 - dataStorage2 working with lists and preparing it as a singleton
2022-04-05playing with dotnet core 34 - dataStorage1 roadmap to learning asp dotnet core databases and entity
2022-04-05playing with dotnet core 33 - databases part 5 add user, drop user and grant privileges on mariadb
2022-03-31manjaro tricks - stream video from one pc to another using obs ndi
2022-03-31manjaro tricks - testing out vim nerdtree
2022-03-30manjaro tricks - add line numbering to vim
2022-03-28playing with dotnet core 32 - using dotnet cli to install remove and list packages in linux
2022-03-22playing with dotnet core 31 - databases part 4 messing around with table row insert and delete
2022-03-22playing with dotnet core 30 - databases part 3 messing around with table creation and deletion
2022-03-11playing with dotnet core 29 - databases part 2 create, delete and import databases
2022-03-11playing with dotnet core 28 - databases part 1 installing mariadb and navigating databases & tables
2022-03-11manjaro tricks - installing mariadb mysql and basic setup
2022-03-10playing with dotnet core 27 - transient vs scoped vs singleton part 2
2022-03-10playing with dotnet core 26 - transient vs scoped vs singleton part 1
2022-03-09playing with dotnet core 25 - power converter example with dependency injection and form validation
2022-03-09manjaro tricks - kde plasma 2022 start menu key not working
2022-03-08playing with dotnet core 24 - dependency injection part 5 common ways to do dependency injection
2022-03-07playing with dotnet core 23 - dependency injection part 4 using interfaces, inheritance and Construc


Tags:
Engineering
Math
Science
Thermodynamics
Fluid Mechanics
Chemical
Nuclear
Chemical Potential
Fugacity
Enthalpy
Internal Energy
Entropy
First Law
Second law
Gibbs Free Energy
Hemholtz free energy
heat capacity
constant volume
constant pressure
tutorial
petroleum
oil
refinery
downstream
crude
jet
gasoline
gasoil
diesel
computational fluid dynamics
CFD
OpenFoam
Open
Foam
Fluid mechanics
heat transfer
turbulence
conduction
convection
radiation
Linux
Mint
Ubuntu
Manjaro