MySql info for beginner? 2

[Dirtrocker]

We have someone helping us to change over some of our site to MySql. He is doing a great job, but the problem is, I have no clue what is being done.
I understand that the info is being put into a database and being called from the page, but what I don't understand is how it gets put into the database.
What does a person need for modifying the database?
I use UltraEdit for cgi script, but can it be used for MySql?
Someone know of a site for dopeys like me who have no clue when it comes to MySql?(-:

Thanks everyone.

 

[piti]

hi

as long as that someone knows what he is doing is everything just fine

but seriously - to modify the database you need access to the server - there are more ways how to do that
- using the shipped command line utilities 'mysqladmin' and 'mysql'
- using some third party utils for managing the mysql server (i am not using such things, but i remember one recomended by my friend called mysqlfront)
- some web based server side scripting like php - phpmyadmin could be a good start for a beginer
- and many more - e.g. linking databases in ms access, using perl, ...

well, i don't know if ultraedit has some interface to mysql, but i suppose not, u'll need some of the stuff mentioned above

and mysql sites?
the best start would be

http://www.mysql.com/documentation/index.html

hope that helps

 

[Dirtrocker]

Thanks. Looks like I have alot of learning to do. LOL
There is a PHPadmin program on the server, so I guess that is a good thing.
Now here is where I lose understanding it.
I understand that it is a database, but do you list everything in the database and then configure a page like a cgi page to call the database?
Forgive me, but it took me a while to gain a grasp on cgi, now MySyl and PHP are being thrown at me and I am clueless.

 

[piti]

if i understand it right, you want to create a web page

well, all those utils and progs i mentioned are for accessing the data, not creating web pages

look at this site

http://www.mysql.com/doc/en/Clients.html

to see the possibilities on using mysql in your apps

 

[Dirtrocker]

Actually, someone is creating the pages for me. I am just trying to understand how it all works. Like adding the info to the database, so it shows on the pages.
You see, I am totally clueless.
I am going to have all these PHP pages and no clue how any of it works.
If someone has created the database, how hard is it to modify things?
Say I have a page that has 3 paragraphs, so now we want to add another paragraph to the database. The page is made, the database is made and we need to add this extra paragraph to the database and then make it show on the page. What would we need?
I know, really vague question, but I am searching for the right question to ask.

 

[snowboardr]

Like dirt said you can use MySql front which is a great program for editing mysql entries, you can even connect to a database accross the world.. its pretty easy too, takes a little bit to figure out.. just don't delete any databases or tables.. (haha)

http://www.anse.de/mysqlfront/

Good luck! www.vzio.com

/

 

[snowboardr]

must take out spaces at the end of the link..

http://www.anse.de/mysqlfront

www.vzio.com

/

 

[patlv23]

here's another. didn't really use it much, just had a look. anyone knows if it's any good?

http://www.dbtools.com.br/