hours trying to do this because the info given by my teacher says to use VALUE before the select sentence, now I tried without it and it worked perfectly, I am frustrated by the faults in my info but also thankful you helped me fix it, finally.
Just brilliant and very clear explanation... thank you very much sir and I just hit the subscribe button and the bell icon... you added me as a new subscriber !!!!!!!!!!!
hi @Simplified do you have a video for how to populate new tables from 2 tables 1 new table that regroups some of the 2 tables column ( exemple table clients , table invoices populating Clients invoices) regrouping all invoice from each clients)?
It's pulling data from source table to an empty table. Actually is it simpler to create a new table with new column names? If the table is not empty, I want to add a column to pull data from any table's column, I don't want those data to be after the origin null value, how to make it happen?
in the previous slide you had us delete emp_info, but in this video you have that table present. You should have had us re-create that table so we can stay in sync with you. Maybe you were just testing us to have us create it again.
Sir what if i only want to get specific data from two different table like for example in table one i only want to pull the column1 and column and the same time in table two i want to pull column 1, column3 and columnn 5 and insert it to table three.
Is it possible to use this INSERT command to add a computed column from table 1 (source) to destination? My syntex (shown below) works for calculating running total however, it doesn't work if i try to use same query to insert running total to new table; select t_date, amount, sum(amount) over (order by t_date) as balance from bank order by t_date; If i add one additional line as your video "INSERT INTO new_tb (t_date, amount, balance), the balance column in new_tb is still zero. Any input would be highly appreciated.
Can this method be used like a draft table scenario? So, the insert query copies the data over to the live table with the first table taking the data as the 'draft table'?
Sir thanx for your video tutorial. I stay in India where comprehensive books on ms access is not available. I have a simple question, Suppose I have two tables A and B with ID being the relationship key between the two tables. Suppose I update or insert new data in Table A. How that data could automatically be updated in table B. Thanx and Regards, Satyaban, India
good day sir, is it possible to insert data from one table to another with different number of fields? but i only want to insert the specific data i want to put in.pls reply
insert INTO employee(en_cust_id) SELECT id FROM customer where name = 'avi' Error Code: 1364. Field 'emp_id' doesn't have a default value can anybody tell me why i am getting this error? en_cust_id -->fk of employee table 'emp_id'--> pk of employee table 'id'-->is pk of customer table
Save my week. Now I need to do that in Node.js Thanks
Good explanation 👏🏼. Please what will be the syntax INSERT Query to copy only 15 minutes data from one table into another table?
hours trying to do this because the info given by my teacher says to use VALUE before the select sentence, now I tried without it and it worked perfectly, I am frustrated by the faults in my info but also thankful you helped me fix it, finally.
This is really fun! Great vid.
thank you so much. You have saved me from a lot of stress.
tooooo excellent
great thanks
Thanks, this is easy to copy from one file to other. (For having backup)
very very thanks full before this video i did not know about this
tq so much u r video helped me a lot
You're a hero bro !
It save my life thnku soo mch
Great!!!
thanks a lot!!!!
it's working on me..
i make my website project and you help me a lot..
Nice video it's very helpful to me thanks
nice vidio It 's very helpful for me
Amazing work my brother!
Thanks dude, it gave me an idea. Great!
+romy lloyd cruz
are u don this??
Just brilliant and very clear explanation... thank you very much sir and I just hit the subscribe button and the bell icon... you added me as a new subscriber !!!!!!!!!!!
Thank you so much for this tuto. It's helpful...
Very nice tutorials.Your all tutorials are enough to learn for sql???
Very good tutorial.
How do i copy a particular column values from one table to a column in an empty table?
Good work, good work!
this is so f-ing helpful thank you so much!
Thank you sir.
How did you make the emp_info table? In which video? Because when I make it, it shows yes under null value infront of integer. Please help?
hi @Simplified do you have a video for how to populate new tables from 2 tables 1 new table that regroups some of the 2 tables column ( exemple table clients , table invoices populating Clients invoices)
regrouping all invoice from each clients)?
Thank you for preparing this kind of video.....!!!!!
It's pulling data from source table to an empty table. Actually is it simpler to create a new table with new column names? If the table is not empty, I want to add a column to pull data from any table's column, I don't want those data to be after the origin null value, how to make it happen?
Please make a video on ‘how to data migrate from one table to another Table by using store procedure in oracle.
What if i don't know the columns present in the other table but I want all the data to place into another table? can you tell me the command
in the previous slide you had us delete emp_info, but in this video you have that table present. You should have had us re-create that table so we can stay in sync with you. Maybe you were just testing us to have us create it again.
Sir what if i only want to get specific data from two different table like for example in table one i only want to pull the column1 and column and the same time in table two i want to pull column 1, column3 and columnn 5 and insert it to table three.
Thanks Sir ❤
good video.Thanks
Thanks Bro
Is it possible to use this INSERT command to add a computed column from table 1 (source) to destination? My syntex (shown below) works for calculating running total however, it doesn't work if i try to use same query to insert running total to new table;
select t_date, amount,
sum(amount) over (order by t_date) as balance
from bank
order by t_date;
If i add one additional line as your video "INSERT INTO new_tb (t_date, amount, balance), the balance column in new_tb is still zero.
Any input would be highly appreciated.
I'm using Access2013 the SQL you provided at 1:05 did not work.
THANK YOU SO MUCH!
Wil it move data or it copies from one table to another
Sir, your tutorials are so nice .... Actually I was listening your shell script tutorial ................
In this tutorial what IDE your using ?
can we the move the data of different table structure in same database
How do i get the SQL object browser so i can practice?
can you make a tutorial to insert data from a table to another table but ignoring the duplicates. thanks
Is the data insert in another table remains in table from which it is inserted
sir how about two table are not in the same database?
Can this method be used like a draft table scenario?
So, the insert query copies the data over to the live table with the first table taking the data as the 'draft table'?
Hi. Where could I find that SQL files?
this is good example, but how to sync local database to server database using sp or trigger without any program
how to load data from one table to multiple table using stored procedure???????????
how make it in access?
THANKYOU SO MACH
sir I want to copy data from one table to another only if a condition satifies...how to do that? please reply
how we insert record in table from two different table by using mysql
I Want insert data into two Table in SQL ? Are you help me?
I have a question sir what if i have a 5 records into tb1 and i want to insert only one row into tb2
Use the WHERE clause with PRIMARY KEY.
Nice thx.
Sir thanx for your video tutorial. I stay in India where comprehensive books on ms access is not available. I have a simple question, Suppose I have two tables A and B with ID being the relationship key between the two tables. Suppose I update or insert new data in Table A. How that data could automatically be updated in table B. Thanx and Regards, Satyaban, India
Go for triggers concept
thank you!
How to Insert Into Table from table another without duplication in sql؟
Mai v JB value insert kr ri to ek row do Baar aa Ra don't know why😑
SUPER
can I use this sql code in c#?
tks Madhur ! But, I wanna Inserting Data Into a Table From Another Table and add a column in new table :) Can you give me a solution ? :) tks
I have the same question :)
thanks
Nice.. thank you.
how to use this in php? please help me :(. realy need your help
Hi Sir. I have a problem. I want to insert first the data to my recycle_bin table before I delete it. how can I do that? thank you Sir and Godbless
good day sir, is it possible to insert data from one table to another with different number of fields? but i only want to insert the specific data i want to put in.pls reply
use where condition
Bhai apki wja sa paper acha hugya 😂
how do I insert telephone number in a table?
how to avoid duplicates record while inserting data into a table
insert INTO employee(en_cust_id) SELECT id FROM customer where name = 'avi'
Error Code: 1364. Field 'emp_id' doesn't have a default value
can anybody tell me why i am getting this error?
en_cust_id -->fk of employee table
'emp_id'--> pk of employee table
'id'-->is pk of customer table
im getting continously left parenthesis error
This NICE
0 rows created
its not work dude ??
in tutorial 11 we dropped emp_info, when was it added back since this tutorial refers to it?
before he started the tutorial , he added again just to not waste time .
hello friend one question :
how to width a column in mysql workbench
answer please :D
@Suresh MySQL
Thank you!
Wil it move data or it copies from one table to another
thank you!