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?

leanjhuls posted video:

introduction to mysql

SullivanSoftware posted video:

PHP MySQL reports

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?

tekhneek posted video:

This tutorial is designed to help newbies get a web server setup and running. This tutorial will take you from no web server, to a fully working WAMP (Windows, Apache, MySQL and PHP) web server installation including “Hello World” in PHP for the hell of it.

Read the article
www.crainbandy.com

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?