I've searching youtube vid since having trouble with SQL... and could not find proposed solution for creating table and populate them,... but i assure this is the one of best vid ever! helped me a lot Great teacher!!
Thanks for the information...but I have a one query suppose I have to delete data from serial no.of table not from I'd ,name etc.then what command should be used ?
hello.. suppose there are 10 columns into table and we insert values only into 8 fields thn error will generate.? insert into employee (1, 2 , 33, 33 ); this is done and there are 10 colmns in table employee thn error vl come or nt
Thanks a lot for the tutorial. how can i insert data into a particular column ....if there was a column called experience at that time how to insert the data??
i have a database class and the professor i have online sucks and dont teach anything now videos or anything.. is it possible to write the script on word and then copy and paste it into the sql
Anyone know how to insert Array into database ?? Something like maybe INSERT INTO TableName (column 1,column2) VALUES ('Arrayone','Arraytwo') To fill the rows
Sir, can u solve this problem ? PREMISE: An SQL table has 4 columns: product ,region ,province, price. The region column can be either National or provincial .If region is provincial then province is filled(e.g.Ontario),otherwise it's blank. Each product has one national price, but may have zero or one provincial price. If a product has no provincial price, the national price is used. For example, "kale" may have a provincial price of $5.99 in Ontario and a national price of $4.50, with no other prices. If a user wanted to find the price of kale in Quebec they would get $4.50. CHALLENGE: Create a method, with a name and signature, that finds the price of a particular product in a particular province. Add the logic in pseudo-code to the body of the method. Be sure to include input parameters, a return statement, and any validation or exception handling that you deem necessary. You can represent the data as an array of objects.
Sir jaise MySQL ke under insert into main sab daal diya mujhe show bhi kar raha hai but phir MySQL band kiya uske baad open toh same page khul gya so last main kiya tha par main uske aage aur entry daal raha hoon toh kyu error show ho raha hai sir please help me main aapko send bhi kar sakta hoon image jo main kiya hai
This is worst way of using INSERT statement in SQL Better way is as follow Insert into tablename set col1=val1, col2=val2, col3=val3; This insert is like update statement and it works 100% fine
exactly like you just did but with proper syntax: insert into table_name (name, class, mob.no) values('ram', '12th', 999999) ,('shayam', '10th', 100000);
After i heard his voice, i knew my search is finally over
Thanks man! You're a great teacher
Thank You for your video, I am taking SQL Database Class right now!
This tutorial is very helpful to me it really brings success to my coding journey thank
Thank you so much...it was really informative and convenient video.
Very interesting tutorials. Thank you.
Awesome tutorial !!
I've searching youtube vid since having trouble with SQL... and could not find proposed solution for creating table and populate them,...
but i assure this is the one of best vid ever! helped me a lot
Great teacher!!
1iiwoeoeow887⁷
Thanks man, this video helped a lot!
"what the hell just happened" .. story of my life LOL
Thanks so much. Very helpful!!
Thanks for watching!
Thnx for this wonderful video man , it was really helpful... 💜
What mySQL statement can we use to insert a selected row in a JFrametable into a mySQL database table?
Thanks buddy,your videos helping me alot..
Great explanation comparing to others
Excellent tutorial.
Liked it and subscribe to your channel.
Great tutorial thanks a lot man.
thanks i got the job even though i was from mech background
love u bro
Thankyou so much Sir sql commands smjh ni aa ri thi ab 5 me se ek aa gyi😂😂
Awesome, thanks!
HAPPY BDAY ! :D
Thank you so much .....
your video today is also helpfull.
Thanks for the information...but I have a one query suppose I have to delete data from serial no.of table not from I'd ,name etc.then what command should be used ?
Hello I just added new column in my table and showing null .how can I insert
values to my new added column
Thank you a lot sir .Bless your soul 😊
Thanks for watching!
Can we instert more than 1 person information in the same table by using the format ??
Thank you, you are amazing..!!!!!!!!!!
Thanks sir for providing this !!!
Happy b'day man!!! lmaoo what a coincidence
hello.. suppose there are 10 columns into table and we insert values only into 8 fields thn error will generate.?
insert into employee (1, 2 , 33, 33 );
this is done and there are 10 colmns in table employee thn error vl come or nt
very informative video bro
Thanks a lot for the tutorial.
how can i insert data into a particular column ....if there was a column called experience at that time how to insert the data??
what scripts will i use for inserting in many tables ? is that possible ?
Thanks sir tomorrow is my practical
Waaala.this was apiece of cake for me.Easy to understand for beginners
really helpful 👌
Hey Madhur tomorrow ur having ur Birthday ;)
which software are you using???
happy birthday in 3 days :)
the bad tutorials are really good XD
i have a database class and the professor i have online sucks and dont teach anything now videos or anything.. is it possible to write the script on word and then copy and paste it into the sql
thank u sooo much sir
y are u using semi-colon for date-time datatype .may i know sir?
I have two tables I want to insert values in second
Table with the help of first table so how can i. Please tell me sir
Can you please tell me why the "name" column is blue but other columns like id , dob are not blue in 12 tutorial?????
Anyone know how to insert Array into database ?? Something like maybe
INSERT INTO TableName (column 1,column2) VALUES
('Arrayone','Arraytwo')
To fill the rows
which version are u using, looks so easy on that
Happy Birthday
Sir, can u solve this problem
?
PREMISE: An SQL table has 4 columns: product ,region ,province, price. The region column can be either National or provincial .If region is provincial then province is filled(e.g.Ontario),otherwise it's blank. Each product has one national price, but may have zero or one provincial price. If a product has no provincial price, the national price is used. For example, "kale" may have a provincial price of $5.99 in Ontario and a national price of $4.50, with no other prices. If a user wanted to find the price of kale in Quebec they would get $4.50.
CHALLENGE: Create a method, with a name and signature, that finds the price of a particular product in a particular province. Add the logic in pseudo-code to the body of the method. Be sure to include input parameters, a return statement, and any validation or exception handling that you deem necessary. You can represent the data as an array of objects.
I can do
3:52 why "name" is appearing in blue and rest of the column names are normal?
Thanks a lot bro
Columns not allowed here error are come
how to solve problem?
thanks my dear
We have the same birthday bruh😂😂 ✨✨
Happy bday
Thank you!
I am not able to insert values in the columns.
It says column "id" of relation "employee" does not exist. Can you help me with it?
Thank you.
Happy birthday Madhur
Sir jaise MySQL ke under insert into main sab daal diya mujhe show bhi kar raha hai but phir MySQL band kiya uske baad open toh same page khul gya so last main kiya tha par main uske aage aur entry daal raha hoon toh kyu error show ho raha hai sir please help me main aapko send bhi kar sakta hoon image jo main kiya hai
Which app do you use??
Thanks man..
advance and sequencial sql tutorial
please help me to download the version of sql database you are using please
Happy Birthday 🎉
Thank you!
thank u so muchhh
nice explan
This video is very good
Thank you!
thank you
tq so much sir
in which platform u use this sql
Which s/w u used
How can we insert multiple values in table??
we should use insert query as many times we want to insert data
In our computer what do u need to download
yes i like it
Tq sir ❤
Where is the tutorial series sir from 1 to end
can u make more videos plsezz
Shouldn't we mention the name within double quote???
i am facing an issue there is no error but data is not inserting.. that only happens
if i use id as autoincriment. how can i fix this
tanks
Why you named your Chanel the bad tutorial🤔
Tq bro
This very helpful for me tq u
Is this MySQL?
If DESC doesn't work, then use sp_help
What the hell just happened 😂😂😂😂
🤣🤣🤣
@@producedbyshook ager aese har bar likhenge to ho gya kaam
@@prakhar9886 kya hogya be kyu chichiya rhe ho
Lmao I laughed at that when he said it and noticed your comment at the top!!! I subscribed
😂 I was about to comment that
what data type is to be used is email id also contain numbers with characters..
id = int, email = varchar
Amazing treaning
This accent is so fucking funny hauhauhhau
This is worst way of using INSERT statement in SQL
Better way is as follow
Insert into tablename set col1=val1, col2=val2, col3=val3;
This insert is like update statement and it works 100% fine
Hi, How can I download MySQL Workbench?
Table create hogaya ha lakin data insert nii horaha
brother how to give phone number details into table plz tell me how to give phone number
how i can name it as "the bad tutorials" ? LOL
You have not single sign of teaching 😅
Sir how can we insert multiple records by typing values of all fields, like
Name Class Mob.No
Ram 12th 999999
Shyam 10th 100000
exactly like you just did but with proper syntax:
insert into table_name (name, class, mob.no)
values('ram', '12th', 999999)
,('shayam', '10th', 100000);
Happy bday
thank you