Using double quotes around search string gives an exact match.

It will be look like
$sql = "UPDATE inventory WHERE userID = '$_SESSION[userID]' SET money = money+ $ssmoney ";

Can you explain this?

Use MySQL's FULLTEXT (http://dev.mysql.com/doc/refman/5.0/en/fulltext-boolean.html) searching capability.

First create a database named forum by executing the following command on mysql prompt

CREATE DATABASE forum;

Or you can use Navicat (http://www.navicat.com/en/products/navicat_mysql/mysql_feature.html) to directly import from Excel.

Save the Excel file as .csv and then use LOAD DATA INFILE (http://dev.mysql.com/doc/refman/5.1/en/load-data.html) to import data to MySQL.

Just a thing I learnt when replying to a MySQL thread :)

wamp supports MySQL. MySQL does not store databases with .db extentsion. You can find all databases under data directory i.e.
c:\wamp\bin\mysql\mysql5.x.x\data\

I assumed you have installed wamp...

No

Sorry for that, I didn't realize that you are using Windows. You should use 'c:\mysql\data.txt' instead of the path I mentioned.

If you remember the MySQL root password, then go to phpMyAdmin directory under directory like wamp\apps\phpmyadmin3.1.3.1 and open config.inc.php. And provide the correct password in...

Mention the full path to the destination where you mention the file name e.g.
SELECT col1, col2 INTO OUTFILE 'c:\mysql\data.txt'
FIELDS TERMINATED BY ','
....

Then you must use TEXT type if the length is more than 255. VARCHAR consumes the space according to the string length.

Yes, 150 is the maximum string length that can be strored in this column. This can be any value upto 255 for VARCHAR. You can not manually set the length for each row, MySQL adjust it automatically...

Creating a table with VARCHAR columns of a specified length is very easy. e.g
CREATE TABLE `table_data` (
`col1` VARCHAR( 150 ) NOT NULL ,
`col2` VARCHAR( 150 ) NOT NULL ,
`col3` VARCHAR( 150 )...

I am dealing with tables with 50+ million rows with much more columns. But they do not contain more than 1 text column. Are columns of type text or varchar?

The performance also depends on the...

I never faced any problem with much larger tables (in GBs).

Are you properly indexing your tables? For performance, you can split the tables on year/month basis if you have datatime field....

There is a simple rule, always treat user input an evil :)

You are welcome.

Can you clarify the "certain data"? Read all about JOINs at MySQL Manual (http://dev.mysql.com/doc/refman/5.0/en/join.html).

No, you can not.


You are right, you have to use views.

I am not sure about this. You have to test it yourself by implementing both approaches.

Don't forget to index email and username in tables before uisng JOIN.

Use \ before any special character. If you using PHP, then use mysql_real_escape_string() (http://php.net/mysql_real_escape_string) function.

MySQL does not have any native GUI as MS Access have. You can choose from a lot of 3rd party MySQL GUIs (http://www.mwasif.com/2008/6/mysql-gui-tools). There is another open source option available...

Yes, it will increase the performance dramatically.
Check this article for more info http://articles.sitepoint.com/article/optimizing-mysql-application

Do you have index on username and date columns?

This is the way to do. If you need only name from the db, then simply use name in the SELECT statement instead of *.

$row=mysql_select("SELECT name FROM table where id='1'") or die(mysql_error());

If ip field is varchar then use quotes around $ip in the query. But if you want to insert in INT format then use INET_ATON()...

Do not use quotes around column names.

$sql = mysql_query("INSERT INTO tc_mailist (fname, lname, email, ip) VALUES ('Joe', 'Bloggs', 'joe@bloggs.com', $ip)");

The above queries are for MySQL. Did you try it?

You are welcome

From PHP Manual (http://www.php.net/manual/en/mysqli.overview.php).

The mysqli extension, or as it is sometimes known, the MySQL improved extension, was developed to take advantage of new features...

The correct query will be

SELECT * FROM quotes WHERE job_status = 'active' AND date_posted<= DATE_SUB(NOW(), INTERVAL 7 DAY)

You don't need to install XAMPP if you want to run MySQL there. Simply download (http://dev.mysql.com/downloads/mysql/5.1.html) MySQL separately from MySQL.com and install it.

Your question is not clear. Do you want to use MySQL running on other machine?

This post (http://forums.mysql.com/read.php?61,17950,18900) on MySQL Forum might help you.

I believe MySQL does not support dblink.

Look at MySQL manual to Enable Incremental Backups (http://dev.mysql.com/doc/refman/5.1/en/backup.html).

GRANT privileges to MySQL user to connect remotely.