How To Use MySQL ? How do you use MYSQL?

	How To Use MySQL ? - How do you use MYSQL?
	Discussion by carl with 12 Replies. Last Update: June 20, 2006, 11:08 am

carl

I was wondering how you use MYSQL? It seems a hard database to create, any help on this?

Thu Jun 15, 2006 Reply New Discussion

Houdini

QUOTE (carl)

I was wondering how you use MYSQL? It seems a hard database to create, any help on this?

Link: view Post: 80828

MySQL is just another Database management system, except that it is free, and is highly supported.
Suppose that you wanted to create an inventory of all the items in your household for insurance purposes. Well with a database you could create a database called inventory and within that database you would of course have tables which contain various data such as household so you create a table within the inventory database called household. In this table you would then have various items, their description, price paid, serial numbers, photographs, and so on.

After you have created your inventory database and table of household item table then you would place the actual data into the household table one item per row in the dable along with the description, price, and other important data for insurance purposes. MySQL uses the SQL language which is not difficult to learn basically it uses english words to perform its work. do a search for MySQL tutorial or go to W3C schools and look at their tutorial and you will find that it is not that difficult at all.

As an example to create a database with MySQL or just about any other database the command is:

CODE

CREATE DATABASE inventory

What was so hard about that?

Fri Jun 16, 2006 Reply New Discussion

finaldesign

The CMS on my web uses Mysql as backend database. So it's not hard to understand it, try to get some begginers book for Msql - that should clear some issues for you.

Fri Jun 16, 2006 Reply New Discussion

Ola Daniel

In addition to what the other guys have said MySQL is a very easy database to use unless of course you have no database back groud at all.

To create a database:
create database myDb;

To create tables
CREATE TABLE `account01` (
`ACCOUNT_NO` bigint(20) NOT NULL auto_increment,
`account_id` varchar(255) default NULL,
`accountname` varchar(255) default NULL,
`emailAddress` varchar(255) default NULL,
`DATE_CREATED` datetime default NULL,
PRIMARY KEY (`ACCOUNT_NO`)
)

Besides the ease of using MySQL i think its a very light fast database compared with other databases on the market. PLUS ITS FREE!

Fri Jun 16, 2006 Reply New Discussion

yordan

QUOTE

It seems a hard database to create, any help on this?[\QUOTE]
From a user point of view it's practically not hard to use at all.
May I suggest you to connect to your astahost cpanel and click in Fantastico and then create a gallery. You will see it's really simple, you give the name you choose ("my_preferred_photos" for instance) and it creates the database and the application server programs. And then
1) you see that everything worked easily.
2) you go inside the "my_preferred_photos" subfolder and you look at the install php scripts in order to see how they did the things. And you will see that they simpli fired very standard syntaxes, like
CREATE DATABASE
CREATE TABLE
INSERT INTO TABLE
SELECT * FROM ...
Regards
Yordan

Fri Jun 16, 2006 Reply New Discussion

vhortex

QUOTE (carl)

I was wondering how you use MYSQL? It seems a hard database to create, any help on this?

Link: view Post: 80828

mySQL is a relatively easy one database system to use.

It uses standard SQL commands to create and build databases and tables.

--
If you have any database background, you will be amazed on how this software handles data, plus it is free and have the capability of the other paid database systems. [ver 5 that is]

Maybe you have a difficulty in visualizing how you will translate your real world data into a structure of tables. And perhaps connecting together this data.

It was also my first wall in my early years in programming database system.

Fri Jun 16, 2006 Reply New Discussion

Alegis

Started to learn more about MySQL this year.

There is GREAT documentation out there, I really don't see why learning it would be such a chore or troublesome experience. Really, dozens and dozens of great tutorials for different user levels.

Sat Jun 17, 2006 Reply New Discussion

lonebyrd

I for one am new to programming, so learning MySQL is proving to be a little difficult. Some things I can pick up on easily, but others, like the error messages I get, I just can't figure out. There is a book I want to get Called MySQL Tutorial (2nd Ed.) that looks pretty good. The user reviews seemed the best of all the MySQL beginner books I looked at. Of course, I need to practice, practice, practice. And for now, on-line tutorials are fine.

Sat Jun 17, 2006 Reply New Discussion

Hercco

I don't think database is hard to use. Quite the contrary, it makes things lot easier.

When I started out doing web applications, I first used simple text files to store data. This was adequate for my simple applications but once I started doing more advanced stuff, text files would have just been too clumsy and less effecive. I was familiar with relational databases and knew SQL but I hadn't bothered to learn the mysql api that PHP has. Naturally I was surptised how easy it was to use and now, even for simple things I tend to prefer mysql over text files. It just saves you from doing lot of boring stuff like parsing text files. Plus, searcing is way faster due to the intellectual stucture of the database.

Sun Jun 18, 2006 Reply New Discussion

HellFire121

It is easy to use phpmyadmin webadmin interface as well. The mysql website has a hell of a in depth documentation on all the features so if you get stuck on something visit their site for an answer first. When you think about it mysql is a very easy to use if not complex database system, if you use phpmyadmin you should be right.

-HellFire

Mon Jun 19, 2006 Reply New Discussion

Arbitrary

QUOTE

Yeah, definitely. The phpMyAdmin interface makes it really easy to create a database table. All you have to do is click a few buttons and follow the directions on the screen (about making an index row and then inputing all the values). The browse feature is really useful. I also like how they generate PHP code for each row of info that you add to the database so that you can learn a bit of PHP through mySQL.

Text files are horribly inefficient. I used them to run a test database, and it took me a while to figure out how to access the correct pieces of information stored in the text file. I often ran into the problem of writing over my entire text file with the new text because I had chosen the wrong read/write variable.

Although I do have a question about mySQL--how do I encrypt the data with mySQL? I've heard of md5 encryption...but how is that supposed to be applied to mySQL? Does phpMyAdmin offer some kind of feature that you can turn on to enable md5 (or any other kind, for that matter) encryption? Or do I have to write some other PHP file to make this work?

Tue Jun 20, 2006 Reply New Discussion

yordan

QUOTE

Does phpMyAdmin offer some kind of feature that you can turn on to enable md5 (or any other kind, for that matter) encryption?

The non-authorized users do not have access to the database files (I am sure even yourself don't know where the datafiles are), so there is no need to krypt the database data. Moreover, the data are by themselves krypted because they are mysql or Oracle ore Informix records, coded ad offsets to the beginning of a logical point on the disk.
And, of course, authorized users have access, so they will also have access to your krypted data.
The only problem is the user password. So, read the various posts here around, no-one should have a file matching users and passwords, you should simply ask the user password (preferably through ssh or any other standard secured media) and let the database accept or refuse the connection.

Tue Jun 20, 2006 Reply New Discussion