bind-address question

binds to two, but not all available addresses) - how can I do this in the my.cnf file? Thanks, ANdrew. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: OOC: Reply / Return Address of this List

Barry wrote: Jason Teagle wrote: 1. Please always reply to the List. Who runs this list? Could it please be configured to send replies back to the list rather than the individual? It's really annoying to keep ending up with a personal address - it would make things so much easier, and i

free MySQL conversion to MSSQL tool

Does anyone know a free tool to convert MySQL to MSSQL Thank you Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: free MySQL conversion to MSSQL tool

So all I can do is copy tables as they already exist? I obviously need to keep the structure in place Andrew > Am Thursday 28 July 2005 11:19 schrieb [EMAIL PROTECTED]: >> Does anyone know a free tool to convert MySQL to MSSQL > > mysqldump? > > Seriously, what do you

Query PHP

I need some help with a MySQL query using PHP can someone help please? Andrew > > Have you adjusted your queries? MSSQL uses a different dialect (T-SQL), > then MySQL uses. There are quite some difference, although some queries > still might work. > > Arjan. > >

history not working (up-arrow does nothing)

blank. the $HOME/.mysql_history file does exist, but all it's got in it is: _HiStOrY_V2_ in the first line. Please help! what am i doing wrong? TIA andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

history not working -- additional info

e that writes to its own local .mysql_history file. So, why is my client failing to write to .mysql_history? This appears to be an "out-of-the-box", default setting, or am I wrong? Does it work for anyone out there? Please help! andrew -- MySQL General Mailing List For list archiv

Client does not support authentication protocol requested by server

7;m a mere client at the mercy of administrators (I suppose I could install a local DBI, if need be, but fear it might be a hastle and a lot of time, which I can't afford at the moment.) TIA andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Client does not support authentication protocol requested by server

>In the last episode (Mar 26), Andrew said: >> What could ever be the problem with the failing Perl DBI (C->B) >> connection, if everything is OK with a C->A connection (with and >> without Perl), and, in addition, a command-line C->B connection >> works?

RE: history not working -- it's a bug!

t there besides me doing their own build !? Surely they should have noticed non-functioning command history. I understand that the moral of the story is RTFBR (read the fine bug report), but, still... andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySQL to MSSQL

I posted a while back for a solution to make a MySQL DB into a MSQL DB can anyone help please? Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re[2]: Line Breaks Problem (\r\n) in Query

Hello Brent, Thanks for reply. But I would like to know if we have desired behavior in latest versions of MySQL or it is a bug. -- Best regards, Andrewmailto:[EMAIL PROTECTED] Tuesday, April 5, 2005, 11:46:57 AM, you wrote: BB> I'm not sure

String of 150 queries fast locally, but takes much longer accross cross connect

Hello, We are running FreeBSD on two Dual 2.5GHZ Xeon's each with 2 gigs of ram. One is our web server and the other our mySQL database server. The machines are connected directly with a cross connect cable. We are seeing transfer speeds of 8mb/s with scp between the two of them. Also, pinging is

Many Slow Queries

Hello, I am running MySQL Ver 12.22 Distrib 4.0.17 for intel-linux (i686) on RedHat 7.3 kernel 2.4.20-20.9smp We use apache+php with persistant connections. Everything worked fine until we implemented transactions We go this way: BEGIN; select order.state from order where id=100 for update

weird replication problem with master.info being created empty

out to be legit permissions errors (which isn't the case here), and this: http://lists.mysql.com/bugs/15135 which I don't really follow as far as what the final solution was. Anyone have any ideas? This is confusing! thanks, Andrew -- MySQL General Mailing List For list archives

Re: weird replication problem with master.info being created empty

f the server changing, but that isn't the case here, the hostname is the same as always (should have added that in the first place). thanks, Andrew > From: "Lightware Software" <[EMAIL PROTECTED]> > Date: Thu, 29 Jan 2004 08:53:48 +0200 > To: [EMAIL PROTECTED] > Subje

Re: weird replication problem with master.info being created empty

e created but be empty, and when you try "slave start" it'll tell you: "ERROR 1201: Could not initialize master info structure, check permisions on master.info" Hope that helps someone down the line! Andrew > From: "Lightware Software" <[EMAIL PROTECTE

RE: Cant connect with SSL support

try connecting using the server name not localhost hth Andrew >-Original Message- >From: Karam Chand [mailto:[EMAIL PROTECTED] >Sent: 02 June 2003 14:43 >To: [EMAIL PROTECTED] >Subject: Cant connect with SSL support > > >Hello > >I have a MySQL 4.0.3 server

varchar restriction

Hi MySQL gurus If I chnage a varchar in one table will it effect another related column in another table? Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: varchar restriction

age- >> From: Efficient E [mailto:[EMAIL PROTECTED] >> Sent: Monday, June 23, 2003 8:50 AM >> To: Mike Hillyer; [EMAIL PROTECTED]; MySQL-Lista >> Subject: RE: varchar restriction >> >> >> not sure I understand your relpy Mike >> >> do you mean i

table query oscommerce

oduct category (cat_id) is in a table not called during the checking_out process so it looks like I need to do a table join to pull associated cat_id wiht the product id, sounds like fun! If any of you out there have done such a thing with oscom and know any pitfall it would be rather useful :) A

joins

Any ideas? Thanks andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

CF & MySQL

Hi All I've had a quick scoot about and could see anything about cold fusion and mysql is it possible to use this combination successfully if at all? Thanks Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[

RE: CF & MySQL

PHP and MySQL in the future be smooth or a waste of time. Not necessarily a full conversion but addons to the site at least. Andrew >-Original Message- >From: Curtis Maurand [mailto:Curtis Maurand] >Sent: 15 July 2003 17:02 >To: [EMAIL PROTECTED] >Subject: Re: CF &

RE: first time to use MySQL on MS Platform with PHP.

I think it is the code in functions you need to look at or the path in one of your ini files :) Andrew >-Original Message- >From: Prabu Subroto [mailto:[EMAIL PROTECTED] >Sent: 16 July 2003 10:14 >To: [EMAIL PROTECTED] >Subject: first time to use MySQL on MS Platform with

oscom table structure

are there any of you guys really familar with the mysql table structure of oscommerce and in particular the search queries? Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: oscom table structure

are related to one another and possibly thereafter adding new tables to the existing structure. I have added tables to oscom but I really want to develop the structure further, the plan is to add a full blown CMS Andrew >-Original Message- >From: Nils Valentin [mailto:[EMAIL PRO

RE: oscom table structure

actually just add a little more to this, perhaps what I am after is some kind of tool that creates a DB schema layout , dare I say it like access ;) Is there something that does this for MySQL ? Andrew >-Original Message- >From: Andrew [mailto:[EMAIL PROTECTED] >Sent: 19 Jul

DB Design

is there a tool to view a schematic of a MySQL DB I don't mean the .sql file I mean a pretty chart type schematic :) Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: DB Design

this is exactly what I am looking for :) Is there a free one of these guys hanging around somewhere? Andrew >-Original Message- >From: Peter Brawley [mailto:[EMAIL PROTECTED] >Sent: 19 July 2003 17:50 >To: MySQL-Lista >Subject: Re: DB Design > > >You probably

calender table - time column?

? Cheers Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: calender table - time column?

Hi did anyone reply to this? Andrew >I am currently in the process of building a calender/date MySQL table that will >be searched for available dates for holiday tours? > >I want to use a time column as there will be a restriction on places >for up to 3 >days so this will hav

RE: calender table - time column?

Andrew > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: calender table - time column?

;23:12', ''); $query = "select id,day from booking where month='$month' and date='$day' and year='$year'"; $result = @mysql_db_query ($database, $query); if ($result){ $dbid = mysql_result ($result, 0, "id"); echo

RE: calender table - time column?

Hi Roger this was very useful indeed thank you. I would really like to know any other views on this design and implications for the future development of such a system in terms of flexibility Andrew >-Original Message- >From: Roger Baklund [mailto:[EMAIL PROTECTED] >Sent: 02 Au

forms query

I want to create a simple three field form for querying my db could someone point me in the right direction to make a start? Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

replace text in a field

same in each one. All I want to do is change one expression in every record? Can anyone remember this questionand know the answer? I lost my emails :( Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: New Article on SSH Port Forwarding of MyODBC

known? Andrew >-Original Message- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] >Sent: 27 October 2003 15:39 >To: [EMAIL PROTECTED]; [EMAIL PROTECTED] >Subject: Ann: New Article on SSH Port Forwarding of MyODBC > > >Hi Everyone; > >I have published a

Upgrading help please

4.0.16-0.i386.rpm is a list of the RPMS that I downloaded and ran. Any ideas and help would be most appreciated. Thank you Andrew Message sent using UebiMiau 2.7.2 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

select option from associated id query

hed a little light on the quesry or a bit of guidance on how to approach this? Thank you Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: select option from associated query

inerary.i_id and present them >in a select menu. I am using php but it's been a while and have only >got so far >inot a tizz :) > >Can anyone shed a little light on the quesry or a bit of guidance on how to >approach this? > >Thank you >Andrew > This is what I

query with a select output?

hed a little light on the quesry or a bit of guidance on how to approach this? Thank you Andrew This is what I have used for the query and the php "; $result=mysql_query("select dates2.d_objid ,dates2.d_startdate,dates2.d_enddate from dates2 left join itinerary.i_id on dates2.d_objid =

replace field records

mysql test -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

replace query

someone shed some light in this please :) Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: replace query + RTFM?

inister and change you details whenever you need to and it just the telephone I want to change :) so is the correct query> REPLACE items SET description="new telphone number" WHERE (old telephone number) Thank you so much Andrew PS what does RTFM mean? >-Original Messa

RE: replace query + RTFM?

[EMAIL PROTECTED] >Subject: SV: replace query + RTFM? > > >RTFM = "read the fucking manual".. > >-----Ursprungligt meddelande- >Från: Andrew [mailto:[EMAIL PROTECTED] >Skickat: den 17 november 2003 18:55 >Till: Mikael Fridh; [EMAIL PROTECTED]; MySQL-Lista >

RE: replace query + RTFM?

ta; Rodolphe Toots >Subject: RE: replace query + RTFM? > > >Andrew, > >Please allow a small amount of grief to come from these lists... >People are usually glad to help, and Mike sent the info that he knew >to you. There is a certain amount of frustration that develops when >

RE: replace query + RTFM?

find it. I'll have a read on the UPDATE and see if I can work it out. Thank you Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: replace query + RTFM?

Z Business Directory Please call 0116 27 960 41 for further details Replace these details simply by calling 0116 27 960 41 Unlike YELL we only list a maximum of 5 businesses per Business Category The chances of your business being called has been increased already. Be Seen by calling 0116 27 960 41&

RE: replace query + RTFM?

Worked like a dream Dan Thanks Paul for being patient :) Thank you Andrew >-Original Message- >From: Dan Greene [mailto:[EMAIL PROTECTED] >Sent: 17 November 2003 21:27 >To: [EMAIL PROTECTED]; Mikael Fridh; MySQL-Lista >Subject: RE: replace query + RTFM? > > >you

RE: sql CSV import

Hi all I am trying to import a csv file from MySQL and keep getting an error on line one. Is there an alternative way to import a csv file other than using phpmyadmin? I exported the file from MySQL but can't import it back in, any ideas? A

backup data

I am now thinking about using MySQL as my main office DB. Is it going to be easy te retrieve dta if there is crash or worse case senario my OS dies? I guess this is a back up question really? Thank you all. Andrew PS although this is slow it is brilliant. Is there a PHP equivalent

RE: query inserts from a table join and back again ina diiferent guise

I managed to sort this out.. There wasn't anything wrong with the query or the inserts my brains was frozen! having problems with the new query to pull the records back though if anyone wants to give a hand? Andrew >-Original Message- >From: Andrew Maynes [mailto:[EMAI

MySQL SELECT and INSERT not following (my) logic

inserting color_id and cName too but no joy. This is not making >sense. I has previously been said but that just doesn't follow with the logic. > >If a color name has been pulled why isn't the said color name

RE: Hash-Functions

I thought this was PHP Andrew >-Original Message- >From: Bernhard Döbler [mailto:[EMAIL PROTECTED]] >Sent: 19 February 2003 14:53 >To: [EMAIL PROTECTED] >Subject: Hash-Functions > > >Hi, > > there's a Password()-Function in MySQL. Can somebody tell my

With or Without PHP

out the completely obvious that this list is MySQL. As a matter of interest can I have a show of hands for all those using PHP with MySQL Andrew > - Before posting, please check: http://www.mysql.com/manual.php (the man

RE: left outer join

I am not sure whether you have checked for case sensitive issues but it could be that? document_fields.id,document_fields_link.id are you getting any errors? Andrew >SELECT DF.id, DFL.id >FROM document_fields AS DF LEFT JOIN document_fields_link AS DFL on DF.id = >DFL.document_field_

mysql@lists.mysql.com

I am talkingabout? Using MySQL and PHP PS. Do any of you knw of a forum specifically out there for PHP and MySQL? Andrew - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysq

query or php with a join

PHP Guys & Dolls I have a sight display issue that I just need to resolve :) After a select I end up with a record = 9 but I want to display the record as the name not the value. The value was inserted as a value so I need to make a join to the original table in the query, but alas I have tried a

count rows

Here's a nice MySQL simple returning records query question! I want to return a staement saying 'number of records shave been found' for your selection. so presumably this is a simple row count based on the the returning rec

Query with php

quot;; echo ""; echo "$IN"; echo "a: $Caddress"; echo "a: $Ctown"; echo "p: $CpostC"; echo "t: $Ctele "; echo ""; echo ""; echo ""; echo ""; echo ""; echo "\n\n"; echo ""

Query selected

while ($row = mysql_fetch_array($result)) { $city_id=$row['CityID']; $city=$row['City']; echo " $city "; } echo ""; Andrew - Before posting, please ch

RE: Query selected

Absolutely brilliant Roger this has sorted the problem out :) Andrew >-Original Message- >From: Roger Baklund [mailto:[EMAIL PROTECTED] >Sent: 04 March 2003 15:48 >To: MySQL-Lista >Cc: [EMAIL PROTECTED] >Subject: Re: Query selected > > >* Andrew >> Can an

another Table another query coming soon

Hi Guys and Dolls I am going to add another table to my lovely MySQL DB. Basically it is the city table I need to add to. For each city I am going to have Towns. So I need to relate many Towns to one CityID The city table at the moment is: City CityID What the best way forward? Andrew

RE: another Table another query coming soon

ch will then involve adding another column to the items table :( Andrew >-Original Message- >From: Roger Baklund [mailto:[EMAIL PROTECTED] >Sent: 07 March 2003 14:51 >To: MySQL-Lista >Cc: [EMAIL PROTECTED] >Subject: Re: another Table another query coming soon > >

simple query

come on guys I nedsome help here! MySQL Rocks I have a set of drop downs I want to determine the dropdown menu by query? I have: "; $result=mysql_query("SELECT County, CountyID FROM county ORDER BY County"); while ($row = mysql_fetch_array($result)) { $county_id=$row['CountyID'];

Combining Two Queries losing a drop down! with PHP

row = mysql_fetch_array($result)) { $county_id=$row['CountyID']; $city_id=$row['CityID']; $city=$row['City']; echo " $city "; } echo ""; ?> Andrew --

Updat not Updating

cription', PostCode='$PostCode', Category='$Category', CityID='$CityID' CTelephone='$CTelephone' Cfax='$Cfax' Cemail='$Cemail' Caddress='$Caddress' Cfax='$CTown' Cwww='$Cwww' WHERE ItemID='$ItemID&#

RE: Updat not Updating

line 23 Error with query: You have an error in your SQL syntax near 'WHERE ItemID='01296 483402'' at line 14 I'm not really happy because I dont know why!! Andrew >-Original Message- >From: nobody [mailto:[EMAIL PROTECTED] >Sent: 14 March 2003 17:31

RE: Updat not Updating

SKU', ItemName='$ItemName', ItemDescription='$ItemDescription', PostCode='$PostCode', Category='$Category', CityID='$CityID', CTelephone='$CTelephone', Cfax='$Cfax', Cemail='$Cemail', Caddress='$Caddress'

RE: Updat not Updating

can you explain how I would do this tracking? Andrew >Subject: Re: Updat not Updating > > >If this is really exactly what your code looks like, you've got an >extraneous comma after the Cwww line. But when you're tracking down a bug >like this, you may find it helpf

another table to query!

em is in a city and the same item will more than likely be in more than one city. Thanks Andrew ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received i

FW: another table to query!

ns? > >Basically the items are being called when an item is in a city and the >same item will more than likely be in more than one city. > >Thanks >Andrew > > > > >** >Information in this email is

RE: another table to query!

yID' ORDER BY CityID"); Presumably I need to do a JOIN ? Andrew >-Original Message- >From: Bruce Feist [mailto:[EMAIL PROTECTED] >Sent: 19 March 2003 16:53 >To: [EMAIL PROTECTED] >Subject: Re: another table to query! > > >Andrew wrote: > >>I have just discover

RE: another table to query!

>Sent: 19 March 2003 17:59 >Cc: MySQL-Lista >Subject: Re: another table to query! > > >Andrew wrote: > >>I have done this and have now started to populate the items_city >table with the >>appropriate records what I now need to do is show the records using the city

Query Help

ets bigger. Andrew - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe

RE: db connection

yes I just looked in the manual and this is really very easy almost as easy as php. Andrew >-Original Message- >From: Tan Siewling [mailto:[EMAIL PROTECTED] >Sent: 20 March 2003 08:20 >To: [EMAIL PROTECTED] >Subject: db connection > > > > >Hi, >I wo

PHp MySQL

I have a MySQL query associated with PHP code and would like to know if there are any of you interested in working on this project for me? Andrew - Before posting, please check: http://www.mysql.com/manual.php (the manual

RE: Re[4]: Import Batch syntax error

I have been having a similar problem with a backup file from a phpBB forum errors keeping showing a syntax error which from what you are all suggesting is the size of the sql, is that correct? Andrew >-Original Message- >From: Stefan Hinz [mailto:[EMAIL PROTECTED] >Sent: 20 Marc

sql or import file

be so easy for the backup not to happen as opposed to easily backing up a DB that cannot be restored. Its like having a nice pair of shoes you cant wear! Andrew ** Information in this email is confidential and may be privile

MySQL Two Tables - PHP Query Insert UPdate

nt, Cfax varchar(100) NOT NULL default '', Cemail varchar(200) NOT NULL default '', Caddress varchar(200) NOT NULL default '', CTown varchar(200) NOT NULL default '', Cwww varchar(200) NOT NULL default '', PRIMARY KEY (ItemID) ) TYPE=MyISAM;

Two Tables Diplay Using PHP

$row['11']; $Cw=$row['12']; however the CityID is no longer stored in the items table. It is in the city table :) So I presumably need to do a join? Any suggestions to get me on the right track? Andrew - Be

query Three Tables

ss, items.CTown, items.Cwww FROM items Inner Join item_city ON item_city.city_id= items.ItemID WHERE items.Category='$Category' and item_city.city_id='$ItemID' but now that I have become a DB design guru and dropped the CityID from items the new query doesn't want to recognise my other tables!! Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

table three MySQL

il, items.Caddress, items.CTown, items.Cwww FROM items Inner Join item_city ON item_city.city_id= items.ItemID WHERE items.Category='$Category' and item_city.city_id='$ItemID' but now that I have become a DB design guru and dropped the CityID from items the new query doesn't want to recognise my other tables!! Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Unidirectional replication

I didn't think MySQL could be master and slave! Andrew >-Original Message- >From: trashMan [mailto:[EMAIL PROTECTED] >Sent: 23 March 2003 10:07 >To: [EMAIL PROTECTED] >Subject: Unidirectional replication > > >Hi, > >I've installed a mysql server

RE:

³×AI¹o ¸ÞAImysql sql er's Does anyone else get this? Andrew -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 23 March 2003 16:36 To: [EMAIL PROTECTED] Subject: 메일 전송 실패 알림 <[EMAIL PROTECTED]>

RE: MySQL access denied

this as it says is an incorrect username or password Andrew >-Original Message- >From: Jon L. Miller [mailto:[EMAIL PROTECTED] >Sent: 06 April 2003 10:42 >To: [EMAIL PROTECTED] >Subject: MySQL access denied > > >I'm having a problem accessing MySQL via phpM

MySQL - ERROR 2002

re-install with the binary version has anybody had a similar problem ? Thanks. Andrew - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To re

How to create a table using .php script ?

y ftp. All logins, passwords, database name are known. Thank you for your answer. Andrew. E-mail: [EMAIL PROTECTED] (sure, delete "" from my email address (antispam)) - Before posting, please check: http:

problem with 3.23.44 and 4.0 alpha post install

I an running Slackware with the 2.4.5 kernel on a Dual PII system. I have run mySQL versions from 3.20.something to 3.23.29 (or so) under kernels from 2.0x-2.2.19 with no real problems. I always compile from source when possible. I have down;oaded the mysql source tarballs for 3.23.44 and 4.0 alp

Re: problem with 3.23.44 and 4.0 alpha post install

Andrew wrote: > > I an running Slackware with the 2.4.5 kernel on a Dual PII system. I > have run mySQL versions from 3.20.something to 3.23.29 (or so) under > kernels from 2.0x-2.2.19 with no real problems. I always compile from > source when possible. > > I have down;o

Automatic rounding in INTERVAL calculations

Submitter-Id: n/a >Originator:Andrew Smith >Organization: Technotopia >MySQL support: none >Synopsis: interval calculation problem >Severity: serious >Priority: low >Category: mysql >Class: sw-bug >Release: mysql-3.23.38 (Sourc

RE: MySQL on VB

I need some help. I would like to know if VB can interface directly with MySQL. If possible, then how shall I go about on it. Thanks. Andrew. - Before posting, please check: http://www.mysql.com/manual.php (the manual

InnoDB corruption and crash on Windows 2000

I am running MySQL with hMailServer on Windows 2000 Pro. I was forced to hard reboot the machine this morning, and this is now the result of running mysqld-nt with --console: 060520 21:38:23 InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Startin

MS access query in mysql

2/1/2006#)) GROUP BY ReturnTbl.ComponentID, ReturnTbl.PartDescription, ReturnTbl.USL, ReturnTbl.RtnMfgr HAVING (((Sum(ReturnTbl.Quantity))<>0) AND ((ReturnTbl.USL)=0) AND ((ReturnTbl.RtnMfgr)=0)) ORDER BY ReturnTbl.PartDescription; Thanks, Andrew Zahn -- MySQL General Mailing List For

Re: MS access query in mysql

Thank you very much for the tips and for the links. I think I have it working now with a subquery. cheers, Andrew Zahn Peter Brawley wrote: Andrew Zahn wrote: I am using MS Access to read from a MySQL database. The query generated through access listed below returns incorrect data when

Compile Problems -- Solaris 10 -- mysql-5.0.22

Hello, I'm trying to compile mysql-5.0.22 on Solaris 10 using the Forte Compiler (cc: Sun C 5.8 2005/10/13). I'm doing this so I can build the DBI driver for mysql (DBD::mysql). The .pkg versions are missing libmysqlclient.so required to build DBD::mysql (http://bugs.mysql.com/bug.php?id=17205).

Re: Disaster with dash on mysql cli interface

On Wed, 21 Jun 2006 11:12:40 -0400, Kevin Old wrote: > Hello everyone, > > I had a horrible thing happen to me this morning and wanted to make it > known to the community. > > I needed to delete a record from a very large table (yes, it was > backed up) and like the cli interface of mysql. I ra

Re: How to look for balanced parenthesis?

As of Ultraedit version 12, it's not quite transparent, but it's pretty close. If you Open a file from FTP (File menu option), and hit save, it will automatically upload the file to the server. It's a little slow on the save (as in hit save and count to 10), but it does the job well. Ultraedit

Self Join Performance

ere FieldValueID = '1344'; +--+ | count(*) | +--+ | 7357 | +--+ 1 row in set (0.01 sec) Can anyone shed any light on this? -- Cheers, -Andrew All generalizations, with the possible exception of this one, are false. - Kurt Goedel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

  1   2   3   4   5   6   7   8   9   10   >