There are a lot of database management tools on the internet, however DbSchema it’s clearly a unique tool for database management.I'm using DbSchema to manipulate mysql database.
When I try to create table according to this instructions it says "syntax error" every time I try it. Does anyone know what might be a problem. I use MySQL v5.1
Nice tutorial for people who have never seen RDBMS and if you get a chance maybe you could explain MySQL more:
1. Why you have to create/select a DB
2. Different data types (INT, VARCHAR, CHAR etc.)
3. Why you use comma in create, insert etc.
4. When to use apostrophe
5. Include also the update and delete of table values
6. Syntax etc.
Those are important things (basics) to learn in the beginning in my opinion. Later it gets more complicated. Other than that you've posted a descent tutorial.
gr8t video 4 beginnrs.....:)
naveen99977 4 weeks ago
Great video , thanks a lot man :)
skyrider1991 2 months ago
This has been flagged as spam show
There are a lot of database management tools on the internet, however DbSchema it’s clearly a unique tool for database management.I'm using DbSchema to manipulate mysql database.
mitzanubv 2 months ago
nice one..
siddharthjhumat 2 months ago
gud one thnks mate nice and simple
rukshaz1 2 months ago
Ur Nthstd?
HRSSRHAlFx 3 months ago
EfX is'nt
HRSSRHAlFx 3 months ago
or U Re starting Gpl x
HRSSRHAlFx 3 months ago
Man why SFx? you want only srh and xxl
HRSSRHAlFx 3 months ago
tanks!! this was very usesfull for me!! can u upload how to connect whit c# whit Visual Studio!! plzzzz!!
CAAL1991 8 months ago
thanks....
antosriyantha 8 months ago
how do you get to this point
accohen1 10 months ago
Short and sweet!
amrith007 1 year ago
Good Video thanks...
rcee14 1 year ago
thanks dude...
thiyagi 1 year ago
Wrong site!!
FranklyLate 1 year ago
Can you prove that Hobbits do not exist?
I have a book and film which hinsts that they do.
Answer Sir!
Or have your own argument which you deploy on Hitchens fall to your feet.
FranklyLate 1 year ago
good! I used it now!
Samantha7BROWN 1 year ago
man, you helped me a lot!
linuxnaveia 1 year ago
some voice would be good too
carbidutz 1 year ago
@carbidutz
reminds me my first MySQL videos, with no sound :) but he's better, using annotions. I've used notepad chat all around :)
sismancocuk 1 year ago
thank u that was very helpful for beginners like me
al7arbi1 1 year ago
where can i download mysql ?Is mysql free ?
anazays66 1 year ago
thank you very very much!
tolskie31 1 year ago
Maybe you have an error in your syntax. all are rigth here
MrMbakus 1 year ago
When I try to create table according to this instructions it says "syntax error" every time I try it. Does anyone know what might be a problem. I use MySQL v5.1
discovery1983 1 year ago
How do you rehash the MySQL database??
lofhy 1 year ago
thank you soooo much...I was searching for this...Thanks
sanjika1 1 year ago
I think the video is perfect for a beginner who is already on the 'mysql>' prompt and wants to start off with some simple basics..
AbbuMisbah 1 year ago
seems like I'm beinfg prevented of making another post...
smithy2402 2 years ago
How do you get to the MySQL prompt?
gigman7 2 years ago
You have to navigate the directories until you get to the mysql prompt...
Depends on what folder mysql is stored on your computer...
smithy2402 2 years ago
I know where the folder is. How do I get the prompt?
gigman7 2 years ago
1/2...
Depends on if where the folder is...
If you have downloaded just mysql then its most probably in the c:\mysql directory
If you have WAMP then the directory path to mysql will be different...
I'll assume you you have it in c:\mysql directory...and that you also know how to open up the command prompt...
Check my next post....
smithy2402 2 years ago
Comment removed
gigman7 2 years ago
This video was PERFECT for my understanding
Chubigans 2 years ago
Thanks this was really helpful!! It was a bit diffiuct to see the text eg. ( or < also a voice over would be helpful but it was stll great.
Thanks
collafulbutterfly 2 years ago
This has been flagged as spam show
If you want to insert more then one values, just separate the different values with comma in one insert :)
evelin6315 2 years ago
Comment removed
evelin6315 2 years ago
Isn't there a GUI version? This looks archaic, having to type all that out each time you want to add/delete something...
QuantumAnomaly 2 years ago
Command line is much quicker than GUI. If you know what you want, you just type out the query and finish with it.
zenpher 2 years ago
There is, and I am currently learning to do the command inputs, in which I keep on making mistakes, having to type in the \c to start over.
ironfalcon100 2 years ago
I can't hear anything.
gigman7 2 years ago
Nice tutorial for people who have never seen RDBMS and if you get a chance maybe you could explain MySQL more:
1. Why you have to create/select a DB
2. Different data types (INT, VARCHAR, CHAR etc.)
3. Why you use comma in create, insert etc.
4. When to use apostrophe
5. Include also the update and delete of table values
6. Syntax etc.
Those are important things (basics) to learn in the beginning in my opinion. Later it gets more complicated. Other than that you've posted a descent tutorial.
BMuris 2 years ago
muhaha text kommi post:)
wunderfan 3 years ago
Omg you are the greatest person i have ever met ty !!!!
st0ne2thedge 3 years ago
voice would have been nice, but i still give 5 stars because it was easy to follow
schecter420 3 years ago
Awesome dude, i love this kind of tutorial as "stevebasset" said makes it clear for beginners to understand. Keep up the good work!
dinmamma164 3 years ago
At last something nice and easy I can understand! Thanks for that.
stevebasset 3 years ago