#.sql

us

So I'm doing this web thing were I need to make a whole page that sells items, and I need a database to store said items information. I ended up using mysql and I'm pretty familiar with it, I used it a couple of time for my Java programs. After a long time of not using mysql I kind of forgot how to connect to it which is super simple just write:

mysql -u $USER_NAME$ -p

equivalent for Oracle

CONNECT or CONN $USER_NAME

*There is no root account in Oracle, it's under the name System

At the terminal/prompt and that should ask you for given user name's password. If you have not created users and just need a quick fix just log in as root and do anything you need.

One of the things I really forgot about was to execute an instruction from the operating system, looked it up a couple of time and boy does this shit suck. Anyhow I found it after a couple of tries and it's

mysql> \. $COMMAND&

equivalent in Oracle would be

HOST $COMMAND$

Oh and also I had to create a table of Customers and fill it with some useless test data and I used a page my database professor gave us http://www.generatedata.com/ I have to say this page is good for generating quick data for database testing, and it even generates XML and CSV you name it. Best part of this website it that it generates the table's creating script which is awesome no more shitty table creating. This leads me to say that I when you wan't to run a Script on mysql just write the script's name as a command like so

mysql> $SCRIPT_NAME$

BEGINNER NOTE:

For some of you guys saying script is pretty obvious, but I remember as a starting student that it was not that obvious so for you beginners a script is just a file save with the extension .sql. Be very careful not to save it as a .sql.txt which happens a lot to newbies or as .docx.sql if for some bizarre you are using Mcirosoft Word, instead of using Notepad or something.