What is Digg?28 Comments
- mdweezer, on 10/12/2007, -0/+3Sorry but this tutorial is completely dry and could have just as easily demonstrated all of this from the command line SQL tools since phpMyAdmin isn't always available.
This is definitely the basics as the description states. - jahufar, on 10/12/2007, -0/+2i personally would not recommend using phpmyadmin to 'learn SQL'... your just not going to learn it that way since the GUI insulates from writing actual SQL code most of the time. I realized this after using phpmyadmin for so long that i forgot my basic DDL commands. phpmyadmin is useful for shared web enviroments where you are not allowed shell access of any sort.. but give me the command line any day because i find working it much faster.
- jesusphreak, on 10/12/2007, -3/+5Heh, yeah, drives me crazy when the guys here at work refer to SQL as "sequel".
- llbbl, on 10/12/2007, -0/+2When I was learning SQL I used phpmyadmin frequently to run the SQL statements or troubleshoot ones that I have already written, but were giving me trouble. They have a large text box where you can cut and paste SQL queries in and is the equivalent of running queries at the command line. This is what I found to be most helpful about phpmyadmin.
- blincoln, on 10/12/2007, -1/+3"SQL is a fairly easy language.. Pick up a book on it."
I was thinking the same thing. Select x from y where z. How hard is that? Even things like joins are pretty easy to wrap your head around.
The challenging part I see is proper DB administration, not the query language. - inactive, on 10/12/2007, -1/+3actually, it IS prounouced 'sequel', and those of us around since .. well dirt, know it. Here's a clip from the wiki:
"During the 1970s, a group at IBM's San Jose research center developed a database system "System R" based upon Codd's model. Structured English Query Language ("SEQUEL") was designed to manipulate and retrieve data stored in System R. The acronym SEQUEL was later condensed to SQL because the word 'SEQUEL' was held as a trademark by the Hawker-Siddeley aircraft company of the UK. " - strictnein, on 10/12/2007, -0/+1"Heh, yeah, drives me crazy when the guys here at work refer to SQL as "sequel"."
Well, that's too bad, since it's correct, as the poster above me has noted. - inactive, on 10/12/2007, -1/+2SQL is a fairly easy language.. Pick up a book on it.
- JNitz36, on 10/12/2007, -0/+1Agreed.
Although the article does show the generated sql, I guarantee you most users will never bother with the sql when the GUI can generate and apply it for them. They will always have an excuse.
I would suggest the title be changed, I would never use the terms "phpmyadmin" and "learn sql" in the same sentance. I do use phpmyadmin on occasion for some database driven websites (on mysql), I would not tell anyone to learn with it. Had I used phpmyadmin before knowing sql, I would not be confident at a sql command prompt. Odds are, you get a job somewhere or work for someone else, you wont have your pretty GUI to make the sql for you.
Best to "learn" the hard way. - jimio, on 10/12/2007, -0/+1http://www.w3schools.com/sql/default.asp
- Darrelc, on 10/12/2007, -0/+1Just what I been looking for, cheers bonlebon :D
- Kogut, on 10/12/2007, -0/+1Anybody have some tips on how to start learning SQL/MySQL? I don't envision ever programming databases but I want to understand the technology and language to build up my reporting/analysis skills.
- gator99, on 10/12/2007, -0/+1I thought people were ignorant that called it "sequel" until I found out this history a few years back. However, it has not changed my opinion. Anyone that stills calls it "sequel" should be slapped and sterilized.
- MannaPC, on 10/12/2007, -0/+1I found the tutorial to be poorly written. The guys who did the tutorial had no way of explaining anything in an entertaining way and in fact, he didn't explain much at all.
Second, I have to agree with the guys at the top. PHPMyAdmin does not seem like too well of a place to begin learning PHP. While it does spit out the queries it uses to complete operations, I still wouldn't recommend just learning off that.
I'd rather learn off the ever complicated and poorly created MySQL website :P. - equusdc, on 10/12/2007, -1/+2I don't understand why you were modded down. I've been writing SQL nearly since it has existed and I can't imagine using phpMyadmin as a tool for learning SQL. This "tutorial" states it's aimed at programmers, not Joe Sixpack. Anyone with a basic understanding of logic (rather required for a "programmer") should be able to pick up the basics of SQL in, oh, about ten minutes, and a book or online reference would be the best way to do that. Like maybe this:
http://www.w3schools.com/sql/default.asp
If you want to get into SQL, you have already installed the server, so use the command line tools to learn so you have half a clue how the server actually works. If you want a GUI and your server didn't come with one to begin with, MySQL has had a nice GUI for ages:
http://www.mysql.com/products/tools/
or use something like SQuirreL:
http://squirrel-sql.sourceforge.net/ - bonlebon, on 10/12/2007, -0/+1Cheers ;).
- F1R3, on 10/12/2007, -0/+1While this won't give someone a complete understanding of SQL, i think the point is to get them started, and it does that. Its an easy way for people who are looking to start learning to get their feet wet without having to worry about swimming.
- uymai, on 10/12/2007, -0/+0i kinda think that learning sql from phpmyadmin is similar to learning it from Microsoft access
- SweetsGreen, on 10/12/2007, -1/+1dugg for all the noobs out there
- inactive, on 10/12/2007, -0/+0Why would you use this instead of something like the (free) MySQL Query Browser? phpMyAdmin is notoriously slow and buggy.
BTW, I've always considered SQL to be one of those things that's easy to learn but tough to master. - djseamus, on 10/12/2007, -0/+0"Heh, yeah, drives me crazy when the guys here at work refer to SQL as "sequel"."
S-Q-L or SEQUEL: it's all a question of frikkin' semantics. Getting your nickers in a twist over the pronunciation amounts to a desperate sort of geekish snobbery - lordsnooty, on 10/12/2007, -0/+0phpMyAdmin is a very popular vector for those hunting for web server vulns, I don't think it should ever be deployed anywhere except an entirely trusted network.
- cheesy, on 10/12/2007, -0/+0The people who "learn SQL" using phpMyAdmin are the same people who "learn" HTML and whatnot using Frontpage...
- ChrisrWilliams, on 10/12/2007, -0/+0This is, personally, a very well written tutorial. Seriously, two thumbs up.
- uymai, on 10/12/2007, -1/+0http://www.sqlcourse.com/ is how i learnt sql..mainly
- strictnein, on 10/12/2007, -1/+0wtf... anyone else having issues with digg?
- kewlceo, on 10/12/2007, -3/+2Hopefully this will at least stimulate some interest in MySQL (noob alert, it's pronounced "My S-Q-L"). An awesome and lively study on using MySQL can be found in the database chapter of the online book "Practical PHP" by Paul Hudson. Source: http://www.hudzilla.org/phpbook/index.php
- inactive, on 10/12/2007, -9/+1this one looks like a good one.... hopefully it is good... will read it tomorrow...
Check out the new & improved 
© Digg Inc. 2009
— Content created and posted by Digg users is