MySQL

[kansasskydiver 0]

Anyone know sql? how hard was it to learn and how did you learn it? Self taught, class, online etc

Any tips and pointers are welcome

<--- See look, pink dolphins DO exist!

[Clownburner 0]

Yes, I program the crap out of it. it's totally my bitch. Seriously, it's what my company does.

It's pretty easy to learn. A good place to start for MySQL are these books.

There's even a 'for dummies' book if you like that kind of thing. The best way to learn is to set up Fedora on an old PC, install MySQL and phpMyAdmin and start messing with it.

7CP#1 | BTR#2 | Payaso en fuego Rodriguez
"I want hot chicks in my boobies!"- McBeth

[kansasskydiver 0]

i found an online tutor to teach me it pretty nice

create table kansasskydiver
(first varchar, last varchar, age number, dz varchar);

insert into kansasskydiver
(first, last, age, dz)
valvues ('Chris', 'Armstrong'. '22', 'KSUPC');

update kansasskydiver
set first = 'Christopher'
where first = 'Chris';

select * from kansasskydiver
where first LIKE '%Chris%';



I'm pretty impressed lol once i figured out what the heck sql was i'm good to go.

<--- See look, pink dolphins DO exist!

[loudawg 0]

Cool, I'm not the only computer geek here. I was actually surprised at the number of responses I got to my shirt when I jumped at Elsinore this past weekend. It read: "There are only 10 types of people in the world. Those who know binary and those who don't." I have 3 more super-geeky shirts like that too...LoL. Michele was the first to come up to me and make a comment. And I'm really glad she did because otherwise I may have never struck up a conversation with her and gotten to know her.

Anyway, I learned some basic MySQL stuff for a personal page I did that had a database of pictures and captions. That's when I also taught myself PHP, which interfaced beautifully with MySQL. What a cool language for dynamic pages, let me tell you!! It's so much like C, so that made things really easy.

MySQL is very nice, and easy to learn, I think. The docs on their web site tell you pretty much everything you need to know. I have a huge book on SQL programming and have only read the first 2 or 3 pages so far. LoL.

Linux for life!

~Lou

[ianmdrennan 2]

Quote

Linux for life!

Don't even get me started on you

Kansasskydiver:
As for the SQL part. SQL is SQL - there are normally some minor differences between each companies flavor (MySQL, T-SQL, PL-SQL,etc) but the basic concepts remain the same, as does much of the syntax. Normally the differences are in the creation/deletion of objects, cursors, etc.

Blue skies
Ian

Performance Designs Factory Team

[Hoot 0]

I have a shirt that says " rm -rf /bin/laden"

There are 2 types of people in this world: those who like Neil Diamond and those who don't. --Bill Murray

[nightjumps 1]

http://www.quest.com/toad/sql_editor.html

[caz 0]

I'm a DBA and use SQL each and every day (lucky me), its very easy to learn, do you have any previous knowledge of any other programming languages?

I actually learnt while I was at University by using the SQL script in MS Access (boo hiss yes I know) which is slighty different to standard SQL, but it gives you a good idea of what you are doing especially if you are already familiar with Microsoft products.

~~~ London Skydivers ~~~

[AndyMan 7]

SQL is whats called a 5th generation language, and is characterised as being most like human language. Literally, SQL is the kind of language where you write out a sentence that asks for a specific result.

I'm entirely self-taugh in SQL. There are countless very good books on how to teach yourself. I won't recomend any, because I haven't seen one in about 8 years.

I will say that SQL is by far the easiest "programing" language you'll ever learn, if you use it regularly.

_Am

__

You put the fun in "funnel" - craichead.

[AggieDave 6]

SQL?

Fucking simple dude! Just grab a good book on it and go , that's all you need. The rest of the more complext problems you face can be answered on the internet.

Are you building a front end for it, if so, whatcha using?

--"When I die, may I be surrounded by scattered chrome and burning gasoline."

[Bodyflight.Net 0]

That's HILARIOUS!!!

but that's not SQL!

[jumper03 0]

Quote

SQL is whats called a 5th generation language, and is characterised as being most like human language. Literally, SQL is the kind of language where you write out a sentence that asks for a specific result.

hehe, real programmers use assembler language...

Jump

Scars remind us that the past is real

[AndyMan 7]

Quote

hehe, real programmers use assembler language...

No argument from me. Only because of a few minor exceptions do I even consider SQL a programming language. It is for the most part simply a reporting tool...

_Am

__

You put the fun in "funnel" - craichead.

[indyz 1]

If you really want to go far with a free SQL database, I'd suggest installing PostgreSQL (if you run Unix) or the free versions of Oracle 9i or 10g (warning, massive downloads). As you get further into it, the various MySQL quirks will get old fast, and once you start using stored procedures, triggers, and subqueries (none of which stable MySQL supports yet) you will never want to go back.

[champu 1]

Building a Database-Driven Web Site Using PHP and MySQL

SQL has many other applications besides just storing content for websites, but that's the context I learned it in. I already knew my way around php pretty well, but there's some tips on getting started there too if you're interested.

[kansasskydiver 0]

ok so i have apache installed on my machine, how the hell do i get mysql and php installed? the setup.exe for sql does nothing, not even from the command line...

<--- See look, pink dolphins DO exist!

[Hoot 0]

Quote

That's HILARIOUS!!!

but that's not SQL!

LOL yeah I know I was replying to

Quote

Cool, I'm not the only computer geek here. I was actually surprised at the number of responses I got to my shirt when I jumped at Elsinore this past weekend. It read: "There are only 10 types of people in the world. Those who know binary and those who don't."

My girlfriend hates when I wear Unix shirts! That one was one of my favorites so I wanted to share it with loudog

There are 2 types of people in this world: those who like Neil Diamond and those who don't. --Bill Murray

[kansasskydiver 0]

Quote

ok so i have apache installed on my machine, how the hell do i get mysql and php installed? the setup.exe for sql does nothing, not even from the command line...

ok this is pissing me off, why won't it install. i've followed the instructions and it does Nothing

<--- See look, pink dolphins DO exist!

[indyz 1]

What instructions are you using? IIRC correctly, there a several good tutorials on installing Apache, PHP, and MySQL under Windows.

Edit: tutorial - haven't read the whole thing, but it looks promising.

Edit again: This one is a little terse, but it includes directions for slightly newer versions of PHP and MySQL, as well as Apache 2

[loudawg 0]

Just for kicks I'll post the rest of my shirts...you might find me at the DZ with this one:

$> cd /pub
$> more beer

or how bout this:

There's no place like 127.0.0.1

And finally, funny and sooo true, is:

$> man woman
Segmentation Fault (core dumped)

[Hoot 0]

hahaha..... I feel like a true geek every time I laugh at one of those

There are 2 types of people in this world: those who like Neil Diamond and those who don't. --Bill Murray

[kansasskydiver 0]

Quote

There's no place like 127.0.0.1

I must not be a true nerd yet, I only understood that one

<--- See look, pink dolphins DO exist!

[katiebear21 0]

You guys are giving me flashbacks!

I'm an ADA girl (don't ask me to do it today) from way back but we used SQL in my first Army job. Now I prefer Cisco CLI!

Katie
Get your PMS glass necklace here

[souleh 0]

Quote

Quote

There's no place like 127.0.0.1

I must not be a true nerd yet, I only understood that one

Bugger.. that means I'm doomed

Oh and for any horny linux geeks:

talk touch finger unzip mount gasp yes yes yes umount sleep

'buttplugs? where?' - geno

[loudawg 0]

Heh I saw one a while back that expanded a little more on that one:

Unix is Sexy
who | grep -i blonde | talk; cd ~; wine; talk;
touch; unzip; touch; strip; gasp; finger; mount; fsck; more; yes;
gasp; umount; make clean; sleep