Problem Installation

20Hi; I had a working installation of MySQL, and then I zapped it. I found out the hard way that when you delete symlinks, you also delete the files to which they are linked :( I wiped my entire /usr/local/include dir. I'm using ports on FreeBSD 6.2. As it happens, I had a complete copy of the

Problem Installation

Hi; [After waiting 4 hours, I don't think my post posted, so I'm re-posting] I had a working installation of MySQL, and then I zapped it. I found out the hard way that when you delete symlinks, you also delete the files to which they are linked :( I wiped my entire /usr/local/include dir. I'm

Re: Undelete a droped table

Sorry, Microsoft SQL! From: Panos Tsapralis [EMAIL PROTECTED] Sent: Wednesday, November 08, 2006 6:48 AM To: [EMAIL PROTECTED] Subject: Re: Undelete a droped table I suppose you mySQL - not mSQL (there

auto_increment

Hi All, I'm trying to restore a database where the first column is set to auto_increment. When I apply the inserts created from the mysqldump I get errors about the auto_increment column. Is there a may to turn it off while I run the inserts or do I have to modify the table? Thanks, Scott

setting the data directory.

, Scott Johnson [EMAIL PROTECTED] Tel.: (514) 917-4922 Fax: (514) 673-0011 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Crystal reports with MySQL

Hi, You simply install the MyODBC interface and away you go. You simply create a connect and Us crystal as if it was a connection to the other windows database. hahaha I have included the link below: http://dev.mysql.com/downloads/connector/odbc/3.51.html Scott. [EMAIL PROTECTED] www.Wilty.ca

RE: zip code search within x miles

Hi, Just as a speed note! It's faster to calculate a square and find those records and then drop the corners with the circle calculation. Scott. -Original Message- From: Eamon Daly [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 19, 2005 11:20 AM To: Scott Haneda; MySql Subject: Re:

RE: zip code search within x miles

Hi all, I have done this type of setup before. There is a company that puts out a zipcode file with the Latitude and longitude in it. You can then calculate what's in the distance you are looking for. Scott. -Original Message- From: Robert Dunlop [mailto:[EMAIL PROTECTED] Sent:

RE: Query last record in table

Hi Tia, I'm not sure, but my old SQL trick was to do a select * top 1 from subscribers order by acctid desc Scotty. -Original Message- From: Mike Blezien [mailto:[EMAIL PROTECTED] Sent: July 5, 2004 2:52 PM To: MySQL List Subject: Query last record in table Hello, what is the most

DBD or InnoDB or not?

? Just as a note, I'm trying to setup a small company with DBmail and MySQL. So file blobs and back logs of saved data will be the norm. I'm also going to be storing faxes as well. Thanks for your time, Scott Johnson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http

re: Questions about MySQL's INSERT syntax....

Hi Scott, Yes this will work. But, you the columns you are leaving out, must be auto fill or allow blank/Null entries. Scotty. Original Message: From: Scott Fletcher [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Questions about MySQL's INSERT syntax Date: Thu, 17 Jun 2004 12:28:16

sql syntax help

I have a db with slightly over 614,000 records of names and addresses. In the address column, there are quite a few records like 123 any rd # 2 319 w. 1st st # B 4321 test blvd # 42 etc I want to replace all the number signs with the actual word 'number'. Is there a SQL command I can use for

Question

Hello, Does anyone know where I should look on the http://www.mysql.com web site or anywhere else I can find documentation for being able to SSH to the box and setup additional databases as necessary using the MySQL command line tools? Scott Scott =