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!!
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.
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 ?
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
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
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??
Anyone know how to insert Array into database ?? Something like maybe INSERT INTO TableName (column 1,column2) VALUES ('Arrayone','Arraytwo') To fill the rows
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
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⁷
"what the hell just happened" .. story of my life LOL
Thanks so much. Very helpful!!
Thanks for watching!
This tutorial is very helpful to me it really brings success to my coding journey thank
Thank You for your video, I am taking SQL Database Class right now!
Happy b'day man!!! lmaoo what a coincidence
thanks i got the job even though i was from mech background
love u bro
Thank you so much .....
your video today is also helpfull.
Thanks man! You're a great teacher
Thnx for this wonderful video man , it was really helpful... 💜
Thanks sir tomorrow is my practical
Thank you so much...it was really informative and convenient video.
Thanks buddy,your videos helping me alot..
Thankyou so much Sir sql commands smjh ni aa ri thi ab 5 me se ek aa gyi😂😂
This video is very good
Thank you!
Can we instert more than 1 person information in the same table by using the format ??
Waaala.this was apiece of cake for me.Easy to understand for beginners
Thanks man, this video helped a lot!
Very interesting tutorials. Thank you.
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
Thank you a lot sir .Bless your soul 😊
Thanks for watching!
What mySQL statement can we use to insert a selected row in a JFrametable into a mySQL database table?
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 ?
Excellent tutorial.
Liked it and subscribe to your channel.
which version are u using, looks so easy on that
Thank you, you are amazing..!!!!!!!!!!
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
Great tutorial thanks a lot man.
very informative video bro
Thanks sir for providing this !!!
3:52 why "name" is appearing in blue and rest of the column names are normal?
what scripts will i use for inserting in many tables ? is that possible ?
Happy Birthday 🎉
Thank you!
Hello I just added new column in my table and showing null .how can I insert
values to my new added column
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?
Great explanation comparing to others
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
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??
Awesome tutorial !!
Sir, thanks for the tutorial! However, I hope the values u typed aren't the real one's...(privacy problems😂)
We have the same birthday bruh😂😂 ✨✨
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
in which platform u use this sql
Hey Madhur tomorrow ur having ur Birthday ;)
HAPPY BDAY ! :D
Can you please tell me why the "name" column is blue but other columns like id , dob are not blue in 12 tutorial?????
Columns not allowed here error are come
how to solve problem?
Happy bday
y are u using semi-colon for date-time datatype .may i know sir?
In our computer what do u need to download
thank u sooo much sir
really helpful 👌
Which s/w u used
Shouldn't we mention the name within double quote???
Happy birthday Madhur
Which app do you use??
SQL> create table emp ;
create table emp
*
ERROR at line 1:
ORA-00906: missing left parenthesis
SQL> create table emp (eno number(7),ename varchar(40),sal number(30)) ;
Table created.
SQL> select * from emp;
no rows selected
SQL> insert into emp values(1;'amma','10000');
insert into emp values(1;'amma','10000')
*
ERROR at line 1:
ORA-00911: invalid character
SQL> insert into emp values(1;'amma',10000);
insert into emp values(1;'amma',10000)
*
ERROR at line 1:
ORA-00911: invalid character
SQL> insert into emp values(1,'amma',10000);
1 row created.
SQL> insert into emp values(2,'nanna',20000);
1 row created.
SQL> insert into emp values(3,'anna',30000);
1 row created.
SQL> insert into emp values(4,'akka',40000);
1 row created.
SQL> insert into emp values(5,' middle akka',50000);
1 row created.
SQL> insert into emp values(6,' chinna akka',60000);
1 row created.
SQL> insert into emp values(7,' my self vikky',70000);
1 row created.
SQL> select * from emp;
ENO ENAME SAL
---------- ---------------------------------------- ----------
1 amma 10000
2 nanna 20000
3 anna 30000
4 akka 40000
5 middle akka 50000
6 chinna akka 60000
7 my self vikky 70000
7 rows selected.
SQL> update emp values sal='1000000' where eno=1;
update emp values sal='1000000' where eno=1
*
ERROR at line 1:
ORA-00971: missing SET keyword
SQL> create table emp ;
create table emp
*
ERROR at line 1:
ORA-00906: missing left parenthesis
SQL> create table emp (eno number(7),ename varchar(40),sal number(30)) ;
Table created.
SQL> select * from emp;
no rows selected
SQL> insert into emp values(1;'amma','10000');
insert into emp values(1;'amma','10000')
*
ERROR at line 1:
ORA-00911: invalid character
SQL> insert into emp values(1;'amma',10000);
insert into emp values(1;'amma',10000)
*
ERROR at line 1:
ORA-00911: invalid character
SQL> insert into emp values(1,'amma',10000);
1 row created.
SQL> insert into emp values(2,'nanna',20000);
1 row created.
SQL> insert into emp values(3,'anna',30000);
1 row created.
SQL> insert into emp values(4,'akka',40000);
1 row created.
SQL> insert into emp values(5,' middle akka',50000);
1 row created.
SQL> insert into emp values(6,' chinna akka',60000);
1 row created.
SQL> insert into emp values(7,' my self vikky',70000);
1 row created.
SQL> select * from emp;
ENO ENAME SAL
---------- ---------------------------------------- ----------
1 amma 10000
2 nanna 20000
3 anna 30000
4 akka 40000
5 middle akka 50000
6 chinna akka 60000
7 my self vikky 70000
7 rows selected.
SQL> update emp values sal='1000000' where eno=1;
update emp values sal='1000000' where eno=1
*
ERROR at line 1:
ORA-00971: missing SET keyword
Anyone know how to insert Array into database ?? Something like maybe
INSERT INTO TableName (column 1,column2) VALUES
('Arrayone','Arraytwo')
To fill the rows
please help me to download the version of sql database you are using please
Hello sir result grid not shown
..what can i do
happy birthday in 3 days :)
Where is the tutorial series sir from 1 to end
Happy Birthday
Thank you!
tq so much sir
Why you named your Chanel the bad tutorial🤔
Thanks a lot bro
advance and sequencial sql tutorial
Awesome, thanks!
Is this MySQL?
Tq sir ❤
what data type is to be used is email id also contain numbers with characters..
id = int, email = varchar
Thanks man..
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
How can we insert multiple values in table??
we should use insert query as many times we want to insert data
thanks my dear
Thank you.
Table create hogaya ha lakin data insert nii horaha
If DESC doesn't work, then use sp_help
thank u so muchhh
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
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
nice explan
thank you
can u make more videos plsezz
brother how to give phone number details into table plz tell me how to give phone number
Tq bro
This very helpful for me tq u
Hi, How can I download MySQL Workbench?
yes i like it
This accent is so fucking funny hauhauhhau
Amazing treaning
tanks
2024??
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);
how i can name it as "the bad tutorials" ? LOL
You have not single sign of teaching 😅
which software are you using???
Happy bday