SIMPLE SQL DATABASE AND TABLE CREATION

[Ibbignerd]

How would you get to this point. Do you have a reference that explains how to set up what you did before you created the database? I want to do this on an actual server. not a localhost. Thanks and God Bless.

[thesouvikdk]

thx ..........................dear

[jaa546o]

Thanks for the good video. The mistakes add to a "real world" experience.

[XoRr0WBi7ch]

THANK U BRO 

[gregzyw123]

Thanks for the tutorial here. Made it alot easier to understand database creation. Kudos and probs bredda.

[kj91gorre]

i watch tutorial videos of SQL because our prof. is so boring and making it really boring and useless....

[liquidxblades]

Thanks a lot brother. Please upload some more tutorials/

[nannoo28]

You are my savior when it comes to SQL...I really needed this video to help get me on track...THANX...I got an A....

[rainbowcrak]

herbert the pervert

[guramika1]

you jackass, if you dont know what you'r talking about don't put up videos, or cut out the mistakes

[guramika1]

why do you have a 100 apps running at a time?

[Poohinc]

you sound sad :( like your wife just left you or something....

[chubbywank]

goddam your voice is so boring!

[Bioh4zardGaming]

ok so on the insert into what i am calling [Timeclock] i have a bad syntax somewhere....

insert into [TIMECLOCK] (name,date)

value('1','12/12/2012'

please help

-Kris

[billaking]

@Bioh4zardGaming values not value

[Bioh4zardGaming]

@Bioh4zardGaming ah got it thanks !!!

[ChidiAbba]

@Bioh4zardGaming : This should work

insert into [TIMECLOCK] ([name],[date])

values('1','12/12/2012')

[pcmatt2000]

HOW do we insert a lot of data from a text file?

is there a way to do that .. maybe a video??/ :)

[billaking]

@pcmatt2000 Put a GO after each insert line

[pcmatt2000]

HOW do we insert a lot of data from a text file?



[billaking]

@pcmatt2000 Put the GO keyword after each insert string

[thirumalamohan]

i having some .sql file.

i uploaded the this files to sql data base,but it showing one error,

"some tables are in mysql promt . plz change or execute in mysql"

plz give the commands for uploading the filesto mysql.

[billaking]

@thirumalamohan I am assuming by your statement above that you are using mysql as your database engine and your sql scripts are written in t-sql or a derivative of an sql language. There are some differences between them mysql uses ASCII sql, Microsoft uses T-SQL, Oracle has a similiar language. Send me your script and I will see what I can do to help lead you in the right direction. my email is palmpredeveloper@gmail.com

[varma690]

thank you so much for the video it is very clear

[billaking]

@varma690 You are very welcome.

[woofwoofbone]

I wonder if i can create a database of all my old records. Do you have to pay to store it on an sgl server?

[billaking]

@woofwoofbone Depends, if it is Microsoft Access, microsoft provides a free access to SQL converter. I use it all the time. Youtube will not allow me to put in urls - but Google - Microsoft Access to SQL Migration Tool and you will find it.

[stankanz07]

I'm a new student and using SQL Server 2008. When I click at dbo. SAMPLETABLE there don't have open table in the feature. What suggestion do you have to be able to open the table?

[MadStylezuk]

Hello DR William A King JR,

Do i need to Get Mysql Server to be able to make tables ect ?

Thank you in Advance

JT

[billaking]

@MadStylezuk MySQL and MS SQL Express are both free, depends on your preference. MySQL will work fine, but uses a different interface to interact with the tables, also it is closer to ANSI SQL than MS SQL which is the Microsoft way. MySQL is open source and is used on more servers than Microsoft's SQL.

[leeroyjenkins1234123]

i feel like i have played wow with some1 with the exact same voice. good video!

[ahmedsamy]

Thank you very much!

this video really helped me :)

[leggos]

Create a new table named ComputerSci of bookType CS with appropriate primary key and foreign key(s) containing the following columns:

bookCode, bookTitle, authorNumber, publisherCode, branchNumber, unitsOnHand

Data type of each column is same as in its parent table.

im having problems completing this query is anyone able to help me with how to create this TABLE On SQLite

[billaking]

@leggos SQLite comes in different flavors. I use it when creating mobile software for the Palm Pre and Pixie. There is a plug-in for SQLite for the firefox browser which will allow you to create and manage SQLite stuff. But, the SQL command structure for creating a table depends on the environment you are using to create the tables.

[eminemchu99]

Boring!

[billaking]

Check your database table truncation means that your data being inserted into one of your fields is longer than allowed. For example if State is set to nvarchar(2) and you are entering in 3 characters, you will generate this type of error. Whenever you see the word truncated, that should trigger you to think, OH SOMETHING IS LONGER THAN ALLOWED. Hope that helps

[billduke23]

Dr. King, great video. It has helped me a lot.  At 8:15 when you right click the dbo., you get a menu with open table option. My version does not have this. Do you know how I can get mine to do this? I have SQL Server 2008.

Thanks.

[mingceliu]

It is pleased to see the sql tutorials here, thanks very much for your work, you r so kind to dedicate knowledge for people. BTW, do you upload the whole tutorial of SQL Server 2008, or just a few parts, if you have time, please upload all content, or important parts, please Mr King, I am really enjoying your video. Thanks again.

[landlifter]

thank you so much for this vid. this'll be a great help, mr. king. just one question: are the requirements for installing it too big?

[billaking]

Sorry it took so long. I was on another project. No, the requirements are not too big. You can go to Microsoft's Web site and download the express version.

[NovacCky]

i had problem with SQL ,i'am first year in high scholl and we have sql on lessons

thanks for help

[billaking]

You are welcome. If you have additional questions let me know. I have a new phone the Palm Pre, I will answer pretty much in a matter of minutes if I am not in meetings