CGI & PHP Enhance your site with CGi, PHP and ASP scripts

  Subscribe via RSS

  Follow @XavierMedia

MySQL Simple Basics

May 22nd, 2010 by CGI & PHP.com


Beginning MySQL Shows you how to create,insert,update and delete databases/tables

Popularity: 2% [?]


Subscribe to new posts from this blog
You may also be interested in...
CGI Programming 101: Programming Perl for the World Wide Web, Second Edition
MySQL Crash Course
Genomic Perl: From Bioinformatics Basics to Working Code
MySQL Administrator's Guide
MySQL Starter Kit
The PHP Programming with MySQL

20 Responses to “MySQL Simple Basics”

  1. sanjika1 Says:

    thank you soooo much…I was searching for this…Thanks

  2. AbbuMisbah Says:

    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..

  3. smithy2402 Says:

    seems like I'm beinfg prevented of making another post…

  4. smithy2402 Says:

    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….

  5. gigman7 Says:

    I know where the folder is. How do I get the prompt?

  6. smithy2402 Says:

    You have to navigate the directories until you get to the mysql prompt…

    Depends on what folder mysql is stored on your computer…

  7. gigman7 Says:

    How do you get to the MySQL prompt?

  8. ironfalcon100 Says:

    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.

  9. Chubigans Says:

    This video was PERFECT for my understanding

  10. collafulbutterfly Says:

    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

  11. zenpher Says:

    Command line is much quicker than GUI. If you know what you want, you just type out the query and finish with it.

  12. evelin6315 Says:

    If you want to insert more then one values, just separate the different values with comma in one insert :)

  13. QuantumAnomaly Says:

    Isn't there a GUI version? This looks archaic, having to type all that out each time you want to add/delete something…

  14. gigman7 Says:

    I can't hear anything.

  15. BMuris Says:

    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.

  16. wunderfan Says:

    muhaha text kommi post:)

  17. st0ne2thedge Says:

    Omg you are the greatest person i have ever met ty !!!!

  18. schecter420 Says:

    voice would have been nice, but i still give 5 stars because it was easy to follow

  19. dinmamma164 Says:

    Awesome dude, i love this kind of tutorial as "stevebasset" said makes it clear for beginners to understand. Keep up the good work!

  20. stevebasset Says:

    At last something nice and easy I can understand! Thanks for that.

Leave a Reply

Powered by WP Status.net plugin.


Fantastic web hosting at cheap prices
© Copyright 1996-2012 Xavier Media®. All rights reserved.
Contact us | Support/help | Privacy Policy | About Xavier Media
The World According to Xavier | Powered by Yahoo! Answers