Your query probably belongs more in Computer Science, but it fits here well enough. I was in a similar position a while ago, in that I had to take over maintaining a general ledger and time & billing...

It's telling you exactly where to look for the error. Hint: look at the first non-whitespace character before 'FROM'.

Give up? OK. You have a trailing comma in your AS clause. (You've no idea how...

There are several reasons I use the '... SET col=name ...' syntax:

When written with good spacing, the source code is much more readable and grokable.
I don't have to keep printouts of the...

Do you need to assign the result of the query to $result before you can use the result?

You're quite right; it doesn't work, and wasn't supposed to work verbatim. :)

The regular expression needs to be a pattern that matches your data, not the fictitious data in my fictitious table....

You need a regular expression. Something like this will match rows that contain at least one capital letter in the remainder of the field:

select * from myTable where myField regexp 'CAPS.*[A-z]';

In order to relate two tables of information, you need a value that ties them together, a value that is the same in each. If you give each company in the CompanyName table a unique ID, you then store...

MySQL has a migration toolkit available; I think it is part of typical distributions. See http://dev.mysql.com/doc/migration-toolkit/en/index.html for the documentation. Try...

It would seem to be possible. Use the BACKUP command to make the dump. Use the RESTORE command to restore it.

And from Experts Xchange...

Of course there is. Don't be ridiculous. :) :)


#! /bin/sh

typeset -i i
typeset -i imax

i=0
imax=1000

No, not showing the definition. Rather, showing the current date. For example, on my desktop computer:mysql> select curdate();
+------------+
| curdate() |
+------------+
| 2009-02-10 | ...

What does 'select curdate();' return?

Here's a bit of code that might do the trick, assuming the checkboxes are ANDed together: if they check all three, then they will see records that show open on Sunday, have video and have at least...

'index' is a reserved word. You must name that column something else.

Since the script times out, I assume you are attempting to do this via a web browser/server. If you don't have shell access to the server, you may be stuck doing it in chunks. However, there are...

Would this do the trick?

SELECT DISTINCT ip, * FROM links WHERE url contra = FALSE ORDER BY rand() LIMIT 0,5

I don't know if there is anything built into MySQL to do this. It's been a while since I've had to 'track' autoincrement values, but that's where you can look. But you can get close using...

You're on your own for accessing the MySQL server.

The following statements usually work for creating databases and tables:
create database;
use;
create table a (field1, field2, ..., key);
...

This is pseudo-codeish so you have to RTFM and google to make it work. :) You need to use count() and group by. Something like this is kind-of close:

select count(id), id from table where...