Suppression of result in SELECT @temp := column?

2004-08-25 Thread info
Is there any way to not sending the result of a user variable assignment to the client? I.e. Suppress the result of; SELECT @temp := columnID FROM table WHERE column = whatever LIMIT 0,1 ...since I only use @temp in my next statement to produce the actual result. Also, is there a equivalence

A new Machine

2004-08-21 Thread Info
After 2 days in Microsoft HELL with my SQLsvr databases, I'm ready to rob the piggy bank and build a new linux mysql server. Here's my problem: I have, at present, two rather large databases. (A: 4Million records in one table, 15 Million in another; B: 1.5Million and 5Million) The

info

2004-05-17 Thread info . autoresponder
We have received your email, thank you. Normally it is our goal to respond to all of our email within 24 hours. Please insure that you have gone to our FAQ's page at: http://www.affordable-fuel-injection.com/fuel-injection-questions.htm for basic information on fuel injection. -- MySQL

Re: COBOL Syntax of calling MySQL's C API

2004-01-02 Thread info
I am COBOL illiterate. You could try passing hex zero 0x00 as NULL. I have no idea of the correct syntax for doing this in COBOL. Pat... - Original Message - From: Arunachalam [EMAIL PROTECTED] To: Patrick Sherrill [EMAIL PROTECTED] Cc: mySQL List [EMAIL PROTECTED] Sent: Friday,

Re: Bug in mysql.h header file

2003-12-16 Thread info
This is not a bug, you need to set your project/programming environment in VC++ to include support for sockets. I haven't written any non socket programs in several years, so it's part of my standard set-up. MySQL is client/server and uses sockets. You do need to link with a socket library. In

Re: Field Name whitespace via MyODBC

2003-12-12 Thread info
Yes, if you are using v3.23.6 or above, ALTER TABLE on the command line should accept quoted column names to allow you to change the column names. Pat... - Original Message - From: Brian Duke [EMAIL PROTECTED] To: 'Patrick Sherrill' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday,

Re: msaccess frontend

2003-10-18 Thread info
There are many tools in the contributions section to manipulate a mysql database without the need to resort to Access and odbc. What do you need to do? Pat... - Original Message - From: Colleen Dick [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, October 18, 2003 11:42 AM

Re: Re: My details [INF2003082300000269]

2003-08-27 Thread info
Thanks for writing to [EMAIL PROTECTED] This is an auto-generated response to let you know that your message has reached our general information box on 8/23/2003 at 5:38:55 AM. Customer Service will be processing and, if necessary, responding to your inquiry shortly. We usually reply to general

[kapper.net #16695] Re: Another Replication Problem

2003-08-19 Thread info via RT
Hallo User, diese eMail wurde automatisch als Antwort auf Deine Nachricht generiert und bestaetigt Dir die Uebernahme in unser Bearbeitungssystem. Wir werden schnellstmoeglich antworten. Bitte ein wenig Geduld, wir vergessen niemanden. Solltest Du Information sofort benoetigen, rufe uns bitte

Re: mysql stops processing

2003-07-25 Thread Info
Estoy tomando el sol . q -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysql stops processing

2003-07-25 Thread Info
Estoy tomando el sol . q -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: two masters replicating to a single slave

2003-07-25 Thread Info
Estoy tomando el sol . q -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: two masters replicating to a single slave

2003-07-25 Thread Info
Estoy tomando el sol . q -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: InnoDB locking: Different behavior on 3.23.55 and 4.0.13

2003-07-25 Thread Info
Estoy tomando el sol . q -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: InnoDB locking: Different behavior on 3.23.55 and 4.0.13

2003-07-25 Thread Info
Estoy tomando el sol . q -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Problems with MySQL, Windows 2003, IIS6, ASP?

2003-07-25 Thread Info
Estoy tomando el sol . q -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Help with DELETE and a subquery

2003-07-25 Thread Info
Estoy tomando el sol . q -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Problems with MySQL, Windows 2003, IIS6, ASP?

2003-07-25 Thread Info
Estoy tomando el sol . q -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Function to extract difference in Minutes from DateTime variables

2003-07-25 Thread Info
Estoy tomando el sol . q -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Function to extract difference in Minutes from DateTime variables

2003-07-25 Thread Info
Estoy tomando el sol . q -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: SQL Help...

2003-07-25 Thread Info
Estoy tomando el sol . q -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: SQL Help...

2003-07-25 Thread Info
Estoy tomando el sol . q -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysql setup problem

2003-07-25 Thread Info
Estoy tomando el sol . q -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Access Denied

2003-07-25 Thread Info
Estoy tomando el sol . q -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: select part of a field into another field

2003-07-25 Thread Info
Estoy tomando el sol . q -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: select part of a field into another field

2003-07-25 Thread Info
Estoy tomando el sol . q -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: RedHat 8 and mysql-server-3.23.52-3

2002-10-22 Thread Terra Info
I have a RH 7.1 system that is fully patched and it happens to me as well. What is the fix? I am using RH provided binary RPMs so am at mysql-server-3.23.36-1 . Thanks, Tom Egor Egorov wrote: Nicholas, Tuesday, October 22, 2002, 10:11:52 AM, you wrote: NC I have recently installed RedHat 8

Re: Connectiva 7.0

2002-10-22 Thread Terra Info
Before you do that. Try: mysql -u root -p mysql And put in your root password (when prompted) for the machine. The Connectiva installation may have initialized the mysql database with the machine's root password. If so follow the docs to change that, as it is not a good security measure to

Re: RedHat 8 and mysql-server-3.23.52-3

2002-10-22 Thread Terra Info
Got it. It is --skip-name-resolve and that worked around the problem. What should I be on the lookout for to get a real fix? Will there be a patch/update/etc for glibc from RH or is there something that the mysql dev team is coming up with? Thanks, Tom Egor Egorov wrote: Terra, Tuesday,

Re: RedHat 8 and mysql-server-3.23.52-3

2002-10-22 Thread Terra Info
| | skip_show_database | OFF Terra Info wrote: Got it. It is --skip-name-resolve and that worked around the problem. What

Re: creating database

2002-07-11 Thread Info
sql,query How can i have each users database to be stored in it's home dir ? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request

creating database

2002-07-11 Thread Info
As i selling web hosting with mysql as a package, and i like to restrict on the amount of space used. I had setup quotas on the plans. How can i create databases to the user's account, home dir, so that the customer can check his quota. Or how should i go about restricting? sql,query

mysql - problem with timeout

2002-05-03 Thread info
hello ... first excuse my bad english ;-( we have a problem . one of our servers is working with the following components and configuration: linux suse 7.1 mysql 3.23.33 phpadmin 2.2.5 webmin 0,90 our problem . we work with a few databases in mysql ... often when we start more

Updated: Lost data problem Was: Corrupt .FRM files

2002-04-08 Thread DanceGrooves Info
Hi all, Some days ago (March 11) permissions were broken in catalogue of the mySQL database. Even though the permissions were not correct any more, MySQL continued to work. We think MySQL started to work with cache (with image of tables in RAM...) instead and all this time our backup system

corrupt .FRM files?

2002-04-06 Thread DanceGrooves Info
Yesterday we discovered a strange problem with our database running on MySQL version 3.23.45 on a Linux OS version 2.2.16 The MySQL database had been running perfectly with a PHP interface on the web since january 30th and records were added normaly. Now suddenly the MySQL server is brought back

WebStream Announces move into the WebCasting arena

2002-01-25 Thread info
This is an Official WebStream Press Release Release date: January 25, 2002 For more information contact: Crawford Grimsley, Vice President of WebCasting Services [EMAIL PROTECTED] 954-730-7127 Ext. 217 WebStream Announces move into the WebCasting arena FOR IMMEDIATE RELEASE WebStream

Internet Usage Surging and Outsourcing Web Hosting Saves Millions!

2001-08-31 Thread info
It's been a hot summer indeed, not only for the weatherman, but for Internet folks as well. The latest round of economic warnings come at a time when everyone has been once again scared by the media. Don't believe all the hype that you hear on the news. As a matter of fact, a surprising new

WebStream Internet Solutions Signs Contract With Broward Alliance

2001-08-25 Thread info
This is an Official WebStream Press Release Release date: August 23, 2001 For more information contact: Gary Lee at 888-932-2333 WebStream Internet Solutions Signs Contract With Broward Alliance FOR IMMEDIATE RELEASE Fort Lauderdale, FL - August 23, 2001 - WebStream Internet Solutions has

full text indexes

2001-04-06 Thread Pearl Info Com Media Pvt Ltd
Hi, I am facing aproblem in full text index catalog. I have uploaded tables using sql server 7 from client to server having database mysql server. I am finding that while connecting to the server the full text index feature becomes inactive, though on client machine it is active. Now I am not