jumpingrightin asked:


How do you backup and restore a MySQL database on a Linux system without using the plain dump?
“Just copy the whole data folder of MySQL”

What is the Linux path to this?

John B asked:


I need to extract a decimal column from a MySql table but the result must be Integer instead decimal, somebody please??

stephenstripling asked:


I have tried lots of tutorials but I NEVER can get it to work. So, How can I make a Flash guestbook without using php or mysql?

Design Is Everything asked:


Two dbases - Stores and Registrations. Each registration record is related to the Stores by a Store ID. I’m trying to get a count how many registration records there are per store. So a simple Group with would suffice:

select count(*) as thecount, store.id, store_name, registration_store_id, from STORES left join REGISTRATION on store.id = registration_store_id Group by registration_store_id

BUT, what I want is to also display ALL of the Store names regardless of whether they have a related record in the registration database. The problem is that with the Group by statement I’m simply left with a single row that is a count of ALL the stores with no related record (a NULL value in the registration_store_id.

How can I do this?

Kizzeith asked:


I want to be able to enter info into a MySql db via a php form (I know how to do that.) When it’s entered, I want to have a URL generated automatically that the record (entered) can be viewed from…

Does that make sense? Does PHP have a function for this?

Nicholas M asked:


How is the Microsoft SQL better than MySQL? Which is better for security? E-Commerce? Most importantly, Which uses a cheaper server to run on the web?

Carbonbased Lifeform asked:


I am trying to create a MySQL table with three columns. Two colummns are for data and a third the time at which the data is inserted. When I create the table, how do I write out the command to tell MySQL to create a timestamp column?

Uncle Rico asked:


I`ve heard postgreSQL is better for transaction processing than MySQL with InnoDB?

Although I don`t know why, how or by how much?

I`d appreciate a simple English analysis.

hawkal2k5 asked:


I have a table in a database with about 2000 entries and 3 of the field in the database of all these entries need to be reset to their original value. How could I do this without manually going through all 2000 values and editing them?
I need to reset them to their default values which is just “blank” no value also its only for 3 field in the table not the whole table

chesswizard asked:


Nothing works. I can’t get MySQL to work on my mac OS 10.5.5
Is there some trick to installing it and getting the mysql> to
show up.