SOLVED: MySQL immediately closes connection on 3306 with no message at all

(I forgot to mention in my original message that I *had* commented out the skip-networking directive in /etc/mysql/my.cnf; the directive would have resulted in in the connection being refused; the problem here was that the connection was immediately and silently closed.) $ telnet localhost

mysql 4.x for debian?

Hello, what is the status of MySQL 4.x for debian? Does MySQL AB plan to release deb paketes or will MySQL AB support or encourage the debian pakete maintainers? Best regards Gunnar - Before posting, please check:

Re: MySql uses 98% CPU

Thank you everybody for the info. I am considering switching to linux, do you think it is worth it? Does MySql perform better on linux than on a freebsd box overall? Much appreciated Toni Vall - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: Nicolas MONNET (Tech) [EMAIL

RE: MySql uses 98% CPU

I like FreeBSD so it pains me to say it but the penguin has it. As threads are so important to MySQL Linux it just better at this at the moment (we will see what happens with V5 FreeBSD). MySQL was developed on Suns Slowlaris so it is a bit more native to Linux... Simon PS the devil will be back

Mysql does not start, what can I do?

Hello! I was few days avay from my office, and when I came back today, I got some emails, nobody can't connect to database server. When I tried to restart mysqld (3.23.46, debian (woody) initscript failed. Manually starting the server say: 021106 10:24:12 mysqld: Can't open file:

_rowid

What about the following info in the manual p. 55? Add a PRIMARY KEY or UNIQUE key to the table and use this. New in Version 3.23.11: If the PRIMARY or UNIQUE key consists of only one column and this is of type integer, one can also refer to it as _rowid Isn't _rowid some type of internal

Re: mysql 4.x for debian?

On Wed, 6 Nov 2002, von Boehn, Gunnar wrote: Hello, what is the status of MySQL 4.x for debian? Does MySQL AB plan to release deb paketes or will MySQL AB support or encourage the debian pakete maintainers? I think MySQL policy is to support generic packaging formats applicable to all

default-character-set problem

Hello there... I have a problem with sort order. I use greek and english characters. The manual says to put the following lines to my.cnf: [client] character-sets-dir=/usr/local/mysql/share/mysql/charsets default-character-set=greek i restart the demon but the problem still exist. I have 3.23.49

Re: Mysql does not start, what can I do?

On Wed, 06 Nov 2002 11:23:30 +0200 Tuomas Jrvinen [EMAIL PROTECTED] wrote: Hello! I was few days avay from my office, and when I came back today, I got some emails, nobody can't connect to database server. When I tried to restart mysqld (3.23.46, debian (woody) initscript failed.

Re: mysql 4.x for debian?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wednesday 06 November 2002 11:20, andy thomas wrote: Does MySQL AB plan to release deb paketes or will MySQL AB support or encourage the debian pakete maintainers? I think MySQL policy is to support generic packaging formats applicable to

RE: PHP mysql

Hi Jeff, many thanks for your reply. I have checked my installation and all the things you suggested were already implemented. Today I re installed. still with no joy. The asp still works however so the server is OK. One difference I cannot find 'Method exclusions' in my configuration settings.

find longest string in column

Hi, How can I find the longest string in a column? I can probably write a PHP-script that checks the str_length recursively, but I would like to be able to do this within MySQL... I would like to have the value and the length of the string if this is possible. Is this possible or should I try

Re: find longest string in column

Mertens Bram wrote: Hi, How can I find the longest string in a column? I can probably write a PHP-script that checks the str_length recursively, but I would like to be able to do this within MySQL... I would like to have the value and the length of the string if this is possible. Is

Re: Access replacement...

I'm afraid to say it (but I will), but what you are asking for sounds like FileMaker Pro. It's available for Windows, Mac and Linux. If you really want to empower your users to create reports, databases, forms and the like, FileMaker is actually a lot easier than Access. For an experienced

Re: find longest string in column

On Wed, 2002-11-06 at 14:39, Brent Baisley wrote: SELECT MAX(LENGTH(column)) FROM db Thx Brent! This works perfectly! That will give you the length of the longest string but won't tell you what the value is. To get the value also, you could do something like this, but I think there should

Re: My Database Manager

Yesterday, someone (I cannot recall who) posted a link for a piece of software called My Database Manager. I tried going to that link on and off for the last day and I'm always getting a 404. Has anyone successfully DL'd this app? If so, could you send me a copy? I'd be very interested in

A way to get into the code to add functionality to FullText Searches

Hi Just I wondering the posibility of adding some functionality to MySQL MyISAM fulltext functionality, but I am quite confused. I read the ft_* files under $(MYSQL)/myisam, and there is nothing I can do. I'm wondering to add SGML support to FullText searches, so I need to exclude every thing

Character-sets

If I want to create a database with an arabic character-set, will only the data-cells be affected by this or will the table names, column names etc also be in arabic? Can I mix two character-sets (English and Arabic) in the same database, or does it have to be in two separate databases? Any

Re: Access replacement...

I've been looking at a similar scenario Here is what I've arrived at so far: There is little that rivals the ease of use of MS Access - but most alernatives offer different features (like security, performance improvement, and other database related functions) that make the loss of ease of use

90.

mysql:ÄúºÃ! 90¿îÍøÉÏÓªÏúÈí¼þµÍ¼ÛתÈÃ. ±¾ÈËÒÔ400Ôª¹ºÈëȺ·¢Èí¼þ,ËÑË÷Èí¼þµÈ90¿îÍøÉÏÓªÏúÈí¼þ, ¼°1000Íò¸öEMAILµØÖ·,ÏÖÒò¹¤×÷±ä¶¯,ÒÔ50ÔªµÍ¼ÛתÈà QQ:8223613 0574-63133687 Ö Àñ! mike

Re: load data infile syntax

I did my testing. If I use ESCAPED BY '\\', I got 1064, You have an error in your SQL syntax near ''' at line 2 Using ESCAPED BY '\', then no error and result is fine. If the data contains \, then database will automatically takes \ away and shift 1 byte left. My data will mass up. That is why I

lost connection....

I try to update my linux to next version, and it was running a previous version of mysql and when I update to version 3.23.52-3 it works correct, but when I try to connect from a windows Workstation to server it broke with this message in mysql.log : Number of processes running now: 1 mysqld

WinMySQLAdmin

When first used, the WinMySQLAdmin program puts up a box requesting Username and Password. Can anybody tell me what this is intended to do? Normally leave it blank, but when someone else did not do so, it created an unwanted user with a forgotten password in the database. Furthermore, when we

Re: lost connection....

Flavio, If your running RedHat check https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=75128 off topic question flavio. Did you ever work in New York City? -Mike On Wed, 2002-11-06 at 10:09, Flavio wrote: I try to update my linux to next version, and it was running a

Re: index question

At 1:19 -0600 11/6/02, D. Walton wrote: At 01:05 AM 11/6/2002 -0600, you wrote: Paul, the point was to have 'value' be part of the primary key for pure lookup speed (data file would not need be referenced), but not to have it effect the uniqueness of the 'id'/'date' key pair so that I could

Re: My Database Manager

People, now the site is running. Please, if anyone could get, send me suggestions and criticals. Ok I count with you. Alexander - Original Message - From: Chris Boget [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, November 06, 2002 11:13 AM Subject: Re: My Database Manager

error (61)

Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) any suggestions on this Jeremiah Ngure #254733684376 ___ Freeserve AnyTime,

Re: default-character-set problem

At 10:23 + 11/6/02, nick gatsis wrote: Hello there... I have a problem with sort order. I use greek and english characters. The manual says to put the following lines to my.cnf: [client] character-sets-dir=/usr/local/mysql/share/mysql/charsets default-character-set=greek i restart the demon

Newbie: Intersecting entities

I'm trying to find some documentation on creating intersecting entities in MySQL, but haven't been able to track any info down on the MySQL site or on the web. At least we called them intersecting entities while I was in Oracle training (which was some time ago). I think I remember how to set

Re: load data infile syntax

At 10:03 -0500 11/6/02, Vivian Wang wrote: I did my testing. If I use ESCAPED BY '\\', I got 1064, You have an error in your SQL syntax near ''' at line 2 Using ESCAPED BY '\', then no error and result is fine. If the data contains \, then database will automatically takes \ away and shift 1

Re: PHP mysql

So did you find the window with all the extension mappings? Here's what you need to do - Right click on your server root under IIS Manager Under Master Properties click 'Edit' Click on the 'Home Directory' tab Click on 'Configuration' towards the bottom of that window You should see a window

Re: load data infile syntax

This is my statement using python, db.query(load data infile '/data/winshare/experian/test' into table d_adds fields terminated by '' escaped by '\' lines terminated by '\n'); Is python problem? not sure. At 10:01 AM 11/6/2002 -0600, Paul DuBois wrote: At 10:03 -0500 11/6/02, Vivian Wang wrote:

Re: load data infile syntax

At 11:18 -0500 11/6/02, Vivian Wang wrote: This is my statement using python, db.query(load data infile '/data/winshare/experian/test' into table d_adds fields terminated by '' escaped by '\' lines terminated by '\n'); Is python problem? not sure. Looks like what's happening is that Python

Re: _rowid

[EMAIL PROTECTED] wrote: Add a PRIMARY KEY or UNIQUE key to the table and use this. New in Version 3.23.11: If the PRIMARY or UNIQUE key consists of only one column and this is of type integer, one can also refer to it as _rowid Isn't _rowid some type of internal variable? What is its exact

Re: Re: find longest string in column

sql,query Hi, Joseph Bueno suggested the following syntax: SELECT column_name,length(column_name) as len FROM table_name ORDER BY len DESC LIMIT 1 When I tried this on a column that contains NULL values I get: +--+--+ | text | len | +--+--+ | NULL | NULL |

re: HP-UX10.20 binary distribution aborted, SRC compiler error

knauff, Tuesday, November 05, 2002, 9:26:29 AM, you wrote: kauduhdd I want to use MySQL on a HP9000/800 server mith HP-UX 10.20: kauduhdd + HP9000/839 K210, 1 Processor HPPA1.1 7200 (32 Bit), 256 MB RAM kauduhdd 1. Binary Distribution kauduhdd -- kauduhddVersion:

re: unique data sets

Petre, Tuesday, November 05, 2002, 9:26:08 PM, you wrote: PA just out of interest, PA How can I create unique data sets, or rather, set a set of data as PA unique, to prevent another entry in the table that meets the same PA criteria, PA for instance: PA id namesurname address

re: Problem creating InnoDB tables.

David, Tuesday, November 05, 2002, 4:05:57 PM, you wrote: DAF I'm have trouble creating InnoDB tables. I'm using MySQL version DAF 3.32.51-max. I have innodb_data_file_path = ibdata1:30M:autoextend in my DAF my.ini file. According to the manual, I should be able to use and create DAF InnoDB

re: folders ibdata, iblogs

Arthur, Tuesday, November 05, 2002, 9:58:03 AM, you wrote: A Backpacker in the foot hills of mySQL A I have 4.04beta max-nt running on win 2k SP3 A I can create manipulate InnoDB tables happily. A What are Folders ibdataiblogs for? A Nothing ever appears in them. A my tables

re: server no longer starts after data folder copy.

Steve, Tuesday, November 05, 2002, 7:47:34 PM, you wrote: SB I have messed up my server just a bit, it no longer starts ;) I have 2 SB servers one on a 98 machine for testing, and another on a 2000 box that is SB being set up for intranet applications at my company. I usually do changes SB etc on

re: SQL question

John, Tuesday, November 05, 2002, 1:50:32 AM, you wrote: JJ I have a callers table and a citylist table. Both tables have a field JJ 'town' and both tables have a field called 'zipcode'. JJ The citylist is a list of cities and their zip codes. JJ citylist.city and citylist.zipcode JJ The

re: Mysql Problems

Aaron, Tuesday, November 05, 2002, 9:38:34 PM, you wrote: AA My main problem is that I am unable to run the mysql_install_db file. AA Below is what I have tried: AA I can start mysql by using the folowing option: AA shell BINDIR/safe_mysqld --skip-grant-tables AA shell BINDIR/mysql -u root

Re: _rowid

Hello. On Wed 2002-11-06 at 10:59:36 +0100, [EMAIL PROTECTED] wrote: What about the following info in the manual p. 55? Add a PRIMARY KEY or UNIQUE key to the table and use this. New in Version 3.23.11: If the PRIMARY or UNIQUE key consists of only one column and this is of type integer,

Problem importing data from Access

When I import data from the text file I exported out of Access it works correctly except that MySql seems to append and/or prepend some sort of mystery character to the fields it imports. So, I can get the data into the database, but I can't get it out (since the SQL statement can't match the

hierarchical Structure in Mysql

Hi listErs! I need to design a database, under a hierarchical structure. This Mysql database aims to store a catalog in which I should be able to define: CATEGORIES - SubCategories - Sub-SubCategories - Product the only problem, is that I usually use cascaded indexes, but in this case I

Troubleshooting - Can't connect and won't shut down

I have been running a server for almost 2 years completely without incident. I have made no significant changes recently, but for the past month or so I have been having connection problems. Users cannot connect, but existing connections seem to be maintained. Here are some symptoms: I

DateTime comparation problems

Hello bugs, SELECT ... FROM table o WHERE o.date = 2002090100 AND o.date=2002110624 MySQL 3.23.xx - work (returns 0 rows) MySQL 4.0.4 - not work (returns 0 rows) P.S. also in 4.0.4 not work BETWEEN in this case (but as i can see it will be fixed in next release) Best regards, Andrew

Re: load data infile syntax

I tried, db.query(load data infile '/data/winshare/experian/test' into table d_adds fields terminated by '' escaped by '' lines terminated by '\\n'); db.query(load data infile '/data/winshare/experian/test' into table d_adds fields terminated by '' escaped by '' lines terminated by

InnoDB row level locking?

In the documentation it says that InnoDB supports row level locking. How can I ensure that rows are locked using ADO in a VB Applications communicating with MySQL through MyODBC? I have tried setting my Recordsets to adLockPessimistic, but that does not seam to work. Any help will be really

Re: HP-UX10.20 binary distribution aborted, SRC compiler error

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tuesday 05 November 2002 08:26, [EMAIL PROTECTED] wrote: scripts/mysql_install_db[292]: 28678 Memory fault(coredump) This is not supposed to happen. Does it happen with all

Re: load data infile syntax

At 12:38 -0500 11/6/02, Vivian Wang wrote: I tried, db.query(load data infile '/data/winshare/experian/test' into table d_adds fields terminated by '' escaped by '' lines terminated by '\\n'); db.query(load data infile '/data/winshare/experian/test' into table d_adds fields terminated by

RE: DateTime comparation problems

Try using dashes. -mm-dd -Original Message- From: Andrew Sitnikov [mailto:sitnikov;infonet.ee] Sent: Wednesday, November 06, 2002 9:39 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: DateTime comparation problems Hello bugs, SELECT ... FROM table o WHERE o.date =

publishing mysql database to cd-rom

I've got a web-based mysql database solution that I'd like to publish to cd-rom. It's a catalog solution using PHP and mySQL. Is it possible to publish a website such as this to a cd-rom as a stand-alone application? Could somebody point me towards some resources for doing this or outline the

Re: Problem importing data from Access

Hi, Are you sure that .txt file is OK? Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Schroeder, Bradley

RE: PHP mysql

Hi Jeff.Again thanks for your help. Yes, as I said I have done all the obvious (to me) things according to the windows install under win 2000. I am not using .ASP to test so no point in playing with that. You did not explain what or where is 'Method exclusions'. Thanks again Regards

RE: Problem importing data from Access

I have seen this when Windows was involved. Windows word and note pads have a different new line character than Un*x type systems. Perhaps that's what's foiling the sql query. ~K Black -Original Message- From: Gelu Gogancea [mailto:ggelu;arctic.ro] Sent: Wednesday, November 06, 2002

Re: using libmysqld - can't connect to remote DB as client.

I'm using libmysqld so I can have an embedded mysql server in my application. It helps with performance because there is not socket communication and all I/O is done from the program directly to the files. Anyway, I have the need to also connect to a remote database in the same application. My

RE: using libmysqld - can't connect to remote DB as client.

From the mysql docs on the website (URL: http://www.mysql.com/documentation/mysql/bychapter/manual_Clients.html#mysql_real_connect) The proto is: MYSQL *mysql_real_connect(MYSQL *mysql, const char *host, const char *user, const char *passwd, const char *db, unsigned int port, const char

mysqld_multi

Any opinions on running mysqld_multi? Our architecture, X-serve, 2GBs RAM,Dual Procs, 480 GB stogage as Master MySQL server replicated to a less impressive server. Seems logical to separate the heavy-hitter dbs to their own servers and take more advantage of the server's resources. Chris

Re: Problem importing data from Access

Hi, Is no difference but in *nix some text editors (like vi for example) put only the LineFeed(0Ah) character and not CarriageReturn and LineFeed like in Windows(0Dh,0Ah). Almost sure is something wrong with the .txt file.Few days a go i have a similar situation and it was from the the dump/.txt

RE: Problem importing data from Access

This is incorrect. !google new line character linux windows -Original Message- From: Gelu Gogancea [mailto:ggelu;arctic.ro] Sent: Wednesday, November 06, 2002 11:33 AM To: Black, Kelly W [PCS]; Schroeder, Bradley (Contractor); [EMAIL PROTECTED] Subject: Re: Problem importing data from

publishing mysql database to cd-rom

I've got a web-based mysql database solution that I'd like to publish to cd-rom. It's a catalog solution using PHP and mySQL. Is it possible to publish a website such as this to a cd-rom as a stand-alone application? Could somebody point me towards some resources for doing this or outline the

RE: Problem importing data from Access

The text file seems to be fine as far as I can tell. The columns are all in the correct order. It sounds like I need to look out for the line feed character, as well as the carriage return since I'm working on Windows. Anybody know how the line feed character is represented? -Original

Re: hierarchical Structure in Mysql

Your structure is going to be a lot like a message board: Message Board- Topic-Reply-Reply-... Where you can reply to someone else's reply or reply to the main topic. Your setup would have two tables, a category table and a product table. You get your cascade by each category having a field to

Re: mysql 4.x for debian?

On Wed, Nov 06, 2002 at 11:44:03AM +0100, Lenz Grimmer wrote: Yes, we plan to add more package formats apart from tarballs in the future, it's on my TODO. Debian packages are quite high on the priority list there, but I don't know, when I will be able to start with it - I have a lot of RPM

problems dumping from mysql 3.23 to 4.0

hi having some issues dumping from mysql 3.23 to 4.0 getting table error messages trying to import back into 4.0 sometimes i've had to change the cell names ie group to groups somehow having a cell name group was causing error :| sql

Re: Problem importing data from Access

ASCII table is the same for ALL OS. In my understanding to be a new line character is to have a different representation.. So ...always: the LineFeed is 0Ah and CarriageReturn is 0Dh Windows use 0A,0D and some *nix editors use only 0A to make new line. This is means only the rule for breaking

Re: Problem creating InnoDB tables.

- Original Message - From: Victoria Reznichenko [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, November 06, 2002 11:47 AM Subject: re: Problem creating InnoDB tables. David, Tuesday, November 05, 2002, 4:05:57 PM, you wrote: DAF I'm have trouble creating InnoDB tables. I'm

Re: Problem importing data from Access

Hi, You must use a HEX editor to see this characters which are not printable.I use DOS NAVIGATOR...it's free and you can download it from the INTERNET. You must view the file in HEX and find the characters 0A,0D on the end of line. Regards, Gelu

publishing mysql database to cd-rom

I've got a web-based mysql database solution that I'd like to publish to cd-rom. It's a catalog solution using PHP and mySQL. Is it possible to publish a website such as this to a cd-rom as a stand-alone application? Could somebody point me towards some resources for doing this or outline the

RE: hierarchical Structure in Mysql

IIRC, SQL For Smarties has some excellent advice on how to handle tree structures in an SQL database efficiently, by treating nodes as sets (set in the mathematical sense). You can efficiently do queries along the lines of get me everything in category X or any of it's sub(-sub)-categories. -JF

Re: problems dumping from mysql 3.23 to 4.0

Group is a reserved word. GROUP BY Dan Rossi wrote: hi having some issues dumping from mysql 3.23 to 4.0 getting table error messages trying to import back into 4.0 sometimes i've had to change the cell names ie group to groups somehow having a cell name group was causing error :| sql

RE: publishing mysql database to cd-rom

I saw something mentioned here once about a product called Microweb. I have never used it nor do I know anyone that has used it. For what it's worth, I think the website is here http://www.indigostar.com/microweb.htm. Duncan --- Duncan Salada Titan

RE: publishing mysql database to cd-rom

This is a good lead. Thanks. Salada, Duncan [EMAIL PROTECTED] 11/06/02 03:40PM I saw something mentioned here once about a product called Microweb. I have never used it nor do I know anyone that has used it. For what it's worth, I think the website is here

RE: problems dumping from mysql 3.23 to 4.0

thats the thing group is a cell name, it should be totally seperate from the query command , it obviously worked in 3.23 but when moving over to 4 it causes errors, this is not good, how are we supposed to move over an entire hosting site with client databases if some fields are going to cause

RE: Problem importing data from Access

I figured it out. Thanks for all the tips everyone. I didn't know there were 2 characters at the end of a line in Windows. For anyone who has this problem: Use \r\n to separate records Use \t instead of a comma to deliminate fields -Original Message- From: Gelu Gogancea

mysqladmin shutdown leaving stray processes

Hi all. This is a re-post of a problem I originally had under MySQL-4.0.3, which I thought might be due to me compiling with K6 flags, but I have recompiled using i686 flags (and using MySQL-4.0.4) and still get stray processes running: bash-2.05# ps ax | grep mysql 11565 ?S 0:00

Re: problems dumping from mysql 3.23 to 4.0

Dan Rossi wrote: thats the thing group is a cell name, it should be totally seperate from the query command , it obviously worked in 3.23 but when moving over to 4 it causes errors, this is not good, how are we supposed to move over an entire hosting site with client databases if some fields

Re: performace question

On Wed, Nov 06, 2002 at 12:28:00AM -0500, Murad Nayal wrote: thanks jeremy for the reply Jeremy Zawodny wrote: any idea why is it that the mysqld daemon is not using the CPUs and/or why is this taking so long?? You might benefit from a larger key buffer. Can you show

GROUP BY - CONCAT query question?

Hi all. 3 tables. Ticket Pipeline_Dept, and Ticket_Matrix. Ticket_Matrix matches tickets to pipeline depts. A ticket can be posted to multiple pipeline depts. I want to select all tickets and the pipeline departments they are posted to but only one row per ticket. So: SELECT

Mysql/courier-imap/postfix socket problem

Hi, I try to get courier-imap, mysql, postfix installed. I followed all the howto's I could find, but I have still some problems. Perhaps anybody ideas. I know the problem may not origin from an sql problem, but you never know. I use debian woody 3.0 and installed with apt-get the packages, also

Re: timestamp updated on select

Hello I have a column of type timestamp(14) and I thought it would not be updated on a query with simple select statements, though it does! I read in the manual that it shouldn't, what could be wrong? Thanks. -

Re: using libmysqld - can't connect to remote DB as client.

At 11:09 -0800 11/6/02, Steven Webb wrote: I'm using libmysqld so I can have an embedded mysql server in my application. It helps with performance because there is not socket communication and all I/O is done from the program directly to the files. Anyway, I have the need to also connect to a

Re: mysqld_multi

At 13:22 -0600 11/6/02, Raymer, Chris wrote: Any opinions on running mysqld_multi? Our architecture, X-serve, 2GBs RAM,Dual Procs, 480 GB stogage as Master MySQL server replicated to a less impressive server. Seems logical to separate the heavy-hitter dbs to their own servers and take more

Re: Newbie: Intersecting entities

if a succinct statement is possible, perhaps you could give us an idea of its nature? somebody may be familiar with the concept under a different name. I'm trying to find some documentation on creating intersecting entities in MySQL, but haven't been able to track any info down on the

Re: Problem importing data from Access

try this: 1. export the data from ms access to a file on the windows box. 2. fire up ftp from the command line and set it to ascii mode. 3. ftp the file from the windows box to the linux box. if the eol is the problem, the ftp protocol will insure that the eol is correctly translated

Re: timestamp updated on select

At 23:47 + 11/6/02, Nikolas Galanis wrote: Hello I have a column of type timestamp(14) and I thought it would not be updated on a query with simple select statements, though it does! I read in the manual that it shouldn't, what could be wrong? Thanks. You're saying that performing a SELECT

Re: timestamp updated on select

Yes, that is exactly what happens. It is updated with a simple select statement. It is a select from a table which contains only one timestamp column and the order by is made by this timstamp column. And every time the value if the timestamp is updated. On Wed, 6 Nov 2002, Paul DuBois wrote:

RE: problems dumping from mysql 3.23 to 4.0

thanks man = Original Message From Mark Matthews [EMAIL PROTECTED] = Dan Rossi wrote: thats the thing group is a cell name, it should be totally seperate from the query command , it obviously worked in 3.23 but when moving over to 4 it causes errors, this is not good, how are we

Complicated (to me) query

Hello All, I have a SQL query I need help with: Here are my tables: mysql desc file; +-+-+--+-+-+ ---+ | Field | Type| Null | Key | Default | Extra |

MySQL Closing Bug

Description: If I launch MySQL 3.23.38, everything is fine. If I open tables, creat db, add records whatever, no problem. When I close MySQL my hard drive is ? alot and I can do nothing except a hard reboot. I have tried quitting immediatly after launching MySQLadmin and then

mysql hangs, restarts on odbc connect

I'm running MySQL 3.23.49 on Red Hat 7.3, with the latest kernel (2.4.18-17.7.x) installed. It is running in smp mode on a dual P3 1.0 gHz. MySQL works perfectly fine when connecting from the localhost. However, I have another machine that needs to connect via ODBC. The ODBC client can connect,

Re: FW: php J2EE .NET

Peter Lovatt wrote: Hi There is an article on sitepoint.com about benchmarking J2EE and .NET and some controversy over the result http://www.sitepoint.com/newsletters/viewissue.php?fid=3id=3issue=52 If you're knowledgable about J2EE, and go read the benchmark, you see that the J2EE

statement doesnt work onMySQL

Hi, I have the following SQL statement that works fine on Access but it doesn't work on MySQL... select MarketData.* FROM MarketData where MarketData.CustID IN (SELECT ContactID from Contacts where CustID =1) Any advise please?? Regards, Sam

RE: statement doesnt work onMySQL

Sub-Selects do not work on MySQL Yet. Wait for Version 4.1. I am waiting! In the mean time you could do this SELECT * FROM MarketData INNER JOIN Contacts ON MarketData.CustID = Contacts.CustID WHERE Contacts.CustID = 1; HTH JFernando ** sql *** Original Message: - From:

Re: statement doesnt work onMySQL

[EMAIL PROTECTED] wrote: Hi, I have the following SQL statement that works fine on Access but it doesn't work on MySQL... select MarketData.* FROM MarketData where MarketData.CustID IN (SELECT ContactID from Contacts where CustID =1) Any advise please?? Regards, Sam Try something

Re: Access replacement...

Only the Filemaker server is available for Linux. The client is Windows and Mac only. You will need to use ODBC to get Filemaker to talk to MySQL. Even then it's pretty limited. like FileMaker Pro. It's available for Windows, Mac and Linux. If you really want to empower your users to create

ActiveX error Visual Basic Integration MySQL

Hi, I'm attempting to get the MySQL ODBC Drive to work with Visual Basic 6.0 Leaning version I'm getting the following error: Run-time error '429': ActiveX component can't create object On the following line cnMySql.CursorDriver = rdUseOdbc Does anyone have any idea what I might be doing

How MySQL Works?

Hi Guys, I wanna know what the steps MySQL perform when we do INSERT in Database? Anyone can explain? Or anyone here have some reference about how MySQL works? Thanks, Han Lin - Before posting, please check:

Re: timestamp updated on select

At 2:09 +0200 11/7/02, Galanis Nikolas wrote: Yes, that is exactly what happens. It is updated with a simple select statement. It is a select from a table which contains only one timestamp column and the order by is made by this timstamp column. And every time the value if the timestamp is

  1   2   >