okay...online SQL tutorials suck...
i am at work, and i was trying to find one of my friend's phone numbers, but i didnt have it on me...so then i ftp'd into my account at school to see if i had uploaded my .txt file i keep with all my friends' phone numbers to my account, but unfortunately i had not...
so, in the hastle of trying to find my friend's phone number, i decided it would be a good little side thing to do to make a database on my site that i could personally get into in case i didnt have my phone number list on me and get any of my friends phone numbers in case i need to call them. Just a small project to practice with SQL. I am already very proficient with relational algebra and Prolog, so I know what select, project, rename, where, and all those other keywords do. So I downloaded MySQL.
But the problem is, where do I start? How the heck do I initially create the database in the first place?
I have found tutorials all over the net on what different keywords such as select and update do, but i dont NEED to know that stuff. I know all that already. I need to know how an SQL program is structured, what the entry point is, etc. I need to know how to initially create the database so SQL can access it and manipulate it. That is what I need to know. And I cant find any tutorials on the net that talk about that at all.
Anybody know any?