fenway
-
Posts
16,168 -
Joined
-
Last visited
-
Days Won
4
Everything posted by fenway
-
Finding a random X of Y where X <<<< Y can never be fast.
-
You can't use a primary key as a foreign key.
-
First, never post login credentials to your DB. Second, there are countless tutorials.
-
You can't refer to LEFT JOIN-ed column values in a WHERE clause, since they might be null -- you need these in the ON condition.
-
What error?
-
You likely mean DECIMAL(10,2) -- no price has just one decimal place.
-
That's because you don't have a full-text index on just those 2 columns.
-
You have a trailing comma for no reason.
-
Read about sanitizing mysql input.
-
There are lots of good resources in the sticky.
-
I feel like we just covered this question...
-
Drop the group by and the sums, and bring them back one at a time.
-
Huh?
-
Add "UNSIGNED" to your column definition.
-
You're talking about building replication.
-
Perhaps if you followed the format of the sticky in my sig, others would be able to help.
-
Seriously, read about caching.
-
I highly doubt that made the auto-increment "stop working", but if you think your problem is "solved", mark it as asuch.
-
Why not use mysql's MONTH() and DAY() functions?
-
Sorry, I don't follow.
-
You've asked 3 completely unrelated questions in the same topic. Prove that you can actually connect to the DB outside of php.
-
Depends on a great many things -- two obvious ones are (a) db running? and (b) myisam or innodb?
-
Transferring my DB onto another WAMP server onto my external HD
fenway replied to nvidia's topic in MySQL Help
Mysqldump dump in/out. -
Huh? You have to have the data or the database.
-
I don't follow... relational algebra has no concept of "previous row".