SQL Tutorial - 10: Creating Tables from Other Tables

[@sumeetsapla]

i m not able to create table table from other table in microsoft SQL server help me out it is giving the error:incorrect syntax near select

[@AditiBhondwe]

Great video !!! You've really explained the topic in detail!

[@bashar786]

Hi Madhur, I have tried doing this exact word for word in SQL server 2012, getting following message 'Incorrect syntax near the keyword 'select'.' from what I read on the internet some SQL commands are no supported in different DBMS such as SQL server is this true? also the DESC command does not work in SQL server 2012

[@BabbanTantrik]

I enjoyed the way of explanation. Thank you very much Sir.

[@osabhieferguson8562]

Nice and straight to the point

[@imly9863]

Hi, Madhur, I tried to use same syntax but not working the error showing at 'select' and also DESC not working

[@kaushikjammy7236]

Great tutorials man.....but are these set of tutorials enough to gain sufficient knowledge in SQL?

[@krishnakishoreg4695]

Hi Madhur,, I quick question here .. When we create copy of columns, will its properties also be copied . I observed that "id" is primary key in employee table and it is not in emp_info table .. One more question, I see apart from id column others are showing yes for null. What does that mean Thanks krishna

[@joefyneface4525]

+Krishnakishore G I noticed the primary id did not copy as well. I wonder if when creating tables from tables, you have to specify which column you want to be the primary key for the newly created table.

[@joefyneface4525]

+Krishnakishore G In regards to your second question, The yes for NULL means that for those fields, such as name, you do not need to put in a value for every row. The id field, since it is a primary key, cannot not be NULL, so it must have a value for every row (or record). In addition to not being NULL, the primary key field must also be unique, so no value can be the same in the field.

[@raghubarua]

Madhur, Thanks for the nice tutorials.. Can we also have some advance level tuts for comparision of different DBMS flavors to widen the knowledge.

[@subbudgreat]

Hi Madhur, I have a query, for the employee table the primary key constraint is present, but when we are creating a new table form emp_info and importing the columns id, name we are not getting the primary key constraint for id in the new table emp_info, is there a reason why this is not coming?

[@aanaysingh1]

can i create a view using other tables too?

[@surgiokilla1011]

Good video. I like and subscribe!

[@definetly_indefinet]

Now i wont fail my exam!

[@vivekgupta5041]

This video was very helpful !!!

[@thelegitimatenoob1]

I had fun being the 49,101th person watching this

[@IslamReazul]

49,101st :)

[@yanirazelaya5378]

Very good tutorials. Thanks

[@unknwn_usr3077]

Describe table is not working...

[@vibhamahanth2439]

try DESC *table name* ;

[@venkatareddykummitha5863]

Nice.. easy to learn

[@aanandingle4963]

Who's watching this vid in 20222????

[@Herecomesher]

Please mysql app installed is different from the one on the video, where can I find sql development. Thank you

[@akshayathale]

Hi, Why we are getting "int(11)" in the result when running DESC employyee, even we have not specify any limit. Akshay

[@nexxtentertainment3949]

that's the maximum number of digits allocated to integers by default, unless stated otherwise

[@ashrafmohamed3921]

great tutorial, thank you very much

[@asfandkhan8295]

i m using sql 12..they give me error when i execute this query.. error is incorect syntex near kwyword AS

[@monikasuman9377]

Done sir 👍🏽

[@shwethagowda543]

Hi, After executing queries, i am not getting outputs.

[@bethanyhospital835]

can we do inner join?

[@abdullahsultan3244]

Thank you Madhur ... :)

[@sireeshareddy8046]

Can you provide real time interview questions in SQL

[@DhanshriBorse-wi8kj]

cab u share latest vdos

[@bellasun3820]

thx~ however, hope you could provide the code and tables.

[@rameshsomsolay159]

The best class

[@virgilproductions]

Very good! Thank you!

[@cemolos7656]

Thanks dude!

[@McGavel1]

Very cool, thanks!

[@0fficialfirdos891]

Done sir

[@vasugoel8216]

brother can you send me the link to download that software

[@hossamalaaal-deen7173]

mysql workbench

[@philemonbabu3273]

Sir....may I know The website name.......!!!!!!!!!!

[@roshansharma5143]

copy table does not work.

[@maheshsadhu1339]

Tq u

[@monaduttasangita7054]

sir why your tutorial name is bad that you have specified clearly to us!!!!!!!!!???????

[@abhishekdas5286]

i hv subscribd

[@ghansham4067]

👍👍

[@chandughai7978]

👍

[@monikasuman9377]

👍🏽👍🏽

[@deekshapayasi170]

Why is your channel name "bad tutorials" ? U mad or what

[@sumitkumar-xf4mv]

please speak a little bit slow

[@jasveersuman9346]

👍👍