`college_id` int(100) NOT NULL

The second value row in your insert tries to add all blank values, which is not allowed. You should remove it, so the insert looks like this:


INSERT INTO...

Perhaps Navicat (navicat.com). Been using it several years. Data migration is one of it's features.

The .sql file is just a dump of the database. If you make changes to this file, it won't affect the database itself. You either need to use e.g. phpMyAdmin, a database tool or import the sql file...

Table 'craftyartsalesmailcatcher.swd_account' doesn't exist

You're missing a table. Make sure your database is correct.

SELECT
elec.sum(votes) as votes,
stat.sum(rating) as rating,
votes/rating as percentage
FROM elec, stat
WHERE YEAR=2009


Only thing I'm not sure about is the YEAR = 2009 in the...

SELECT dname, cno, sectno, avg(grade) as avg_grade
FROM enroll
GROUP BY dname, sectno, cno
ORDER BY avg_grade DESC LIMIT 1

No, use phpMyAdmin to export your database to an .sql file. It is a text file containing all queries to recreate your database.

Something like this:

select * from product where id not in (select product_id from discount)

$strSQL = "SELECT DISTINCT area FROM hospital where area like '%$strSearchVal' ";

You can insert a datefield as '1971-10-28'. The data you are trying to insert does not fit in the date column.

You can create a password in phpmyadmin, in the priviliges section. There are some settings that you can change in the config file of phpmyadmin, whether or not it should ask for your password, or...

IIRC the older versions of wamp had a default root user (named: root) without a password.

Any specific reason you've installed 1.7, and not 2.0 ?

Check out this first: http://dev.mysql.com/doc/refman/5.1/en/
It contains everything you need to know to get started.

Can you post what you did ?

You can use mysqldump. You can find examples in this site.

This will help:

http://dev.mysql.com/doc/refman/5.0/en/storage-requirements.html

Did you check the links, and tried it ?

His question was to add dates to columns automatically. Ergo, the use of triggers. Please clarify how php would solve this.

That is not a valid query, but I am unsure of what you want to achieve.

Duplicate again.

$sql="SELECT * FROM $tbl1_name WHERE sex='$show_all' AND age BETWEEN '$from' AND '$to'";

Try:


(($cat_parent_id == 0) ? "sub_cat_name = '$name'," : "cat_name = '$name',")


If it still doesn't work, echo the query after you built it, so maybe you can determine where it goes wrong.

Calculate the difference:
http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_timediff

Create a trigger to do it automatically:...

1. He could poll the database to see if there have been any changes.
2. He could write a specific page which you can trigger.

insert into table (mycolumn) values (encode('myvalue', 'mykey'))
select decode(mycolumn, 'mykey') from table

http://dev.mysql.com/doc/refman/5.1/en/encryption-functions.html

If you are using a different user for the dump, than you could disallow priviliges to the general user, while dumping/truncating, and reset priviliges afterwards.

"FLUSH TABLES WITH READ LOCK" may...

Not sure about security, but mySQL will eventually be dropped in favour of mySQLi. That should be reason enough to decide...

Hmm. The error points to typo's or too long identifiers.

http://www.dba-oracle.com/t_ora_00904_string_invalid_identifier.htm

EUIPMENT_FEATURES_MVIEW

shouldnt that be

EQUIPMENT_FEATURES_MVIEW

I think your group by and where are in the wrong order.

http://dev.mysql.com/doc/refman/5.1/en/server-logs.html

You get a hyperlink in Excel because Excel recognizes the email format. Navicat just treats it as text.

SELECT * FROM products,images WHERE products.id = images.product_id GROUP BY products.id

select * from products,images where products.id = images.product_id

Don't understand what you are trying to achieve.

select name,score from scores where name = 'jen140'

The first link in your post explains what settings to use.

Don't know about lunarpages, but some hosts need information in two places, an "allow remote" (server setting) and a "white list"...

Remove the http:// from the host, in the mysql_connect.

Yes, you can, but mysql won't accept the double quotes. If the id field is an integer, you can remove them. If it is a string field, use single quotes instead.

There may be an issue when the id...