Can't MS SQL export to an "SQL Script?" I imagine it would be a simple
matter of cat'ing said script and piping it into the MySQL CLI client.
(Are you on a UNIX box?)
On Fri, 13 Apr 2001, AJ wrote:
>
> Does anyone know any good source of info for the conversion of MS Sql
> databases to MySql
Never mind; thanks for the pointers to TFM... =)
The updated, working query looks like this:
TO_DAYS(NOW()) - TO_DAYS(customers.last_mod) > 14
Thanks all!
On Thu, 12 Apr 2001, Chris Harshman wrote:
> At the first of the month (no changes made to the database; this script is
> jus
You should be able to use 'find' on the directory and search by UNIX atime
(atime is updated whenever the database is accessed, be it a read or a
write). `find . -atime ...` man find for more details.
>From there, it's a simple shell script
On Thu, 12 Apr 2001, Gary Huntress wrote:
> I have
At the first of the month (no changes made to the database; this script is
just running SELECT statements at present) the number of rows returned by
this query dropped noticeably. Is this a bug, is my query just fubar'd,
or...?
SELECT account.username AS account_username, customers.username AS
c
