RE: Removal of Primary Key in Mysql

Because a primary key is a table property and the index of the key is a property of the primary key. If you want ot drop a primary key you alter the table > -Original Message- > From: Eric Frazier [mailto:ef@;kwinternet.com] > Sent: Tuesday, 5 November 2002 15:26 > To: Paul DuBois > Cc: Um

Contain of my.cnf File

Hi, Where can I find the complete sample configuration include the explanation of my.cnf file? I tried mysql.com documentation, but only a bit there. Please Advise. Thanks, Han Lin - Before posting, please check: http://www

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

>Description: I want to use MySQL on a HP9000/800 server mith HP-UX 10.20: + HP9000/839 K210, 1 Processor HPPA1.1 7200 (32 Bit), 256 MB RAM 1. Binary Distribution -- Version: mysql-3.23.53-hp-hpux10.20-hppa1.1 Installation: OK, my.cnf: small,

Re: Removal of Primary Key in Mysql

Hi, This is a why questionk, which may be somewhat pointless, but. Why is this under alter table instead of drop index? Thanks, Eric At 01:10 AM 11/5/02 -0600, Paul DuBois wrote: >At 12:08 +0530 11/5/02, Uma Shankari T. wrote: >>Hello, >> >> I have set one of my field in the mysql table as

MySQL Authentication Problem

Hi Guys, I just installed MySQL-3.23.53, Apache 1.3.27 and Jakarta-Tomcat 4.0.6 (All from Tarball). Everythings seems to be fine until the user can't login from a web and from the log file, it said Authentication Error, can't connect to db. But when I restarted the MySQL and Apache/Tomcat server,

Re: Removal of Primary Key in Mysql

At 12:08 +0530 11/5/02, Uma Shankari T. wrote: Hello, I have set one of my field in the mysql table as primary key..no i want to remove that primary key setting in mysql..Can anyone please tell me how to do that ??? Regards, Uma ALTER TABLE tbl_name DROP PRIMARY KEY; ---

RE: Problems with "ORDER BY" from C API (works from command-line tool mysql.exe)

Yes, but the problem was in the listbox with auto-sort ;-) /Chris -Original Message- From: Paul DuBois [mailto:paul@;snake.net] Sent: den 5 november 2002 00:20 To: Joseph Bueno; Christer Holmström (at Home) Cc: [EMAIL PROTECTED] Subject: Re: Problems with "ORDER BY" from C API (works fro

Removal of Primary Key in Mysql

Hello, I have set one of my field in the mysql table as primary key..no i want to remove that primary key setting in mysql..Can anyone please tell me how to do that ??? Regards, Uma - Before posting, please check: http://w

Re: Mysql newbie

On Mon, 2002-11-04 at 23:51, Ken Arck wrote: > > > then it's compiled under dbx functions not mysql functions run > >configure again with the same arguments except for mysql just run > >--with-mysql and it should be ok. > > <-As I said, it was installed from an rpm as part of the Redhat inst

Re: MySql uses 98% CPU

At 07:07 AM 11/4/02 -0800, Jeremy Zawodny wrote: >On Mon, Nov 04, 2002 at 12:37:15PM +0100, Nicolas MONNET (Tech) wrote: >> >> We get the same thing on FreeBSD machines quite often, and it's not >> related to the actual work being done; MySQL can sit idle but use up >> all CPU. It happens after a

Re: Mysql newbie

> then it's compiled under dbx functions not mysql functions run >configure again with the same arguments except for mysql just run >--with-mysql and it should be ok. <-As I said, it was installed from an rpm as part of the Redhat install package and not from a tarball. Are you saying to rei

Re: Mysql newbie

On Mon, 2002-11-04 at 23:20, Ken Arck wrote: > At 10:32 PM 11/4/2002 -0500, you wrote: > > > What exactly do you mean by compiled in ? what does your phpinfo say. > >You should have a section on mysql not just the line supported databases > >mysql,pgsql,etc. > >

Re: Difficult query

Alexander Newald wrote: I have a table with only ips in it. I want to get all networks the ips belong to: If you always use 24 bit netmasks, then the other solutions given should work just fine. If you're working with arbitrary sized networks though, you might want to store the IP addresse

Re: Mysql newbie

At 10:32 PM 11/4/2002 -0500, you wrote: > What exactly do you mean by compiled in ? what does your phpinfo say. >You should have a section on mysql not just the line supported databases >mysql,pgsql,etc.

Re: Mysql newbie

On Mon, 2002-11-04 at 21:51, Ken Arck wrote: > Hi folks. I'm a real newbie to mysql (believe it or not!) > > While just starting to get my feet wet in it, I've come across a huge > stumbling block already. I am familiar with php however. > > A php script I'm playing with has this line: > > $db =

Re: mysql DATETIME substraction problem/?

Hi. On Mon 2002-11-04 at 15:24:19 -0600, [EMAIL PROTECTED] wrote: > More appropriately, use curdate()feature from within sql. > > select * where date= < curdate()-1; Two points: - How does this relate to the origianl question? He wanted to know how to calculate a time interval. - The above h

Mysql newbie

Hi folks. I'm a real newbie to mysql (believe it or not!) While just starting to get my feet wet in it, I've come across a huge stumbling block already. I am familiar with php however. A php script I'm playing with has this line: $db = mysql_connect("localhost", "root"); Here's the html output

insert into ...selct union

Is it possible to do a insert into blah (select...)union(select.) with mysql 4.03? John Coder - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the

mysql: access denied for what?

Dear all, After I made mysqld running, I then tried: >mysql -u root ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) What does this mean? Thanks Jack Jack Chen, Stein Lab, Cold Spring Harbor Labs 1 Bungtown Road, Cold Sp

Re: Newbie help needed with mysql

On Mon, 2002-11-04 at 18:52, john wrote: > > > When I start safe_mysqld &, I get a command prompt back again and ps aux > shows this: > > mysql30269 0.0 0.1 10580 1024 pts/1S17:38 0:00 > /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql > --pid-file=/var/lib/my

Re: Difficult query

you might also try this: select substring(someField, 1, 6), count(substring(somefield,1,6 from theTable group by substring(someField, 1,6) i tried it in corereader and it seemed to do what you want. > Hello, > > I have a table with only ips in it. I want to get all networks the ips >

RE: Newbie help needed with mysql

Make sure you use the complete line of syntax mysqladmin -u username -p -h hostname create databasename password: (enter the password to that userid here) Oh yeah sql query . ~Kelly W. Black -Original Message- From: john [mailto:john@;cllug.org] Sent: Monday, November 04, 2002 3:53 P

Re: JDBC J/Connect driver is seriously slow against InnoDB

j.random.programmer wrote: Mark: Once of the great things about MySQL is the prompt attention and response on this list. Thanks for replying to this email so quickly. Read on... No problem! --- Mark Matthews wrote: >j.random.programmer wrote: > >>Hi: >> >>Thought I'd mention this (using t

Newbie help needed with mysql

When I start safe_mysqld &, I get a command prompt back again and ps aux shows this: mysql30269 0.0 0.1 10580 1024 pts/1S17:38 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/rock.pid mysql30271 0.0 0.1 10580 1024 pts/1

SQL question

Hello, anyone care to show me how I can do this in SQL? I have a callers table and a citylist table. Both tables have a field 'town' and both tables have a field called 'zipcode'. The citylist is a list of cities and their zip codes. citylist.city and citylist.zipcode The callers table has the

mysql server with different character sets per user

Hello I was wondering about the following: I am hosting an application with a web hosting company and the character set doesn't satisfy me because I am doing some sorting of greek names and the hosting company uses the default character set for the mysql server. Is it possible that they let my

RE: newbie: creating database error

Try using shell>mysqladmin -u root -p -h hostname databasetobecreated password: ~Kelly W. Black -Original Message- From: Admin-Stress [mailto:meerkapot@;yahoo.com] Sent: Monday, November 04, 2002 2:41 PM To: [EMAIL PROTECTED] Subject: newbie: creating database error After playing aroun

Bug with "limit" clause

Hello MySQL AB, I want to inform you about a strange behaviour I just had with the MySQL server. Probably it's a bug, probably I've not read the docs good enough. Here it goes: Situation: My application splits huge queries into a bunch of smaller ones using the "limit" clause. One can doubt wh

RE: Interesting Challenge

Thanks!!! I appreciate all the help I can get. I am trying to validate what appears to be a working query, and will post back to the list as soon as I can confirm it works. I think many others will benefit from my working this out.. Thanks again and all my best! ~Kelly W. Black -Original

Re: Problem in decimal separator

At 12:44 +0100 11/4/02, [EMAIL PROTECTED] wrote: I have a problem when I load a text file using the sentence "load data infile" as long as decimals are separated by commas and mysql ignores those decimals, is there any way to specify that decimal separator is comma or point? No. sql, query -

Re: Interesting Challenge

I know this is not elegant, but have have you tried using a temporary table? It adds up your function column correctly. There was an example of this earlier today from Oyekanmi - "Re: getting around a subselect", http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:123911:200211:onbajmklkgifeckohcpa

Re: Problems with "ORDER BY" from C API (works from command-line tool mysql.exe)

At 11:56 +0100 11/4/02, Joseph Bueno wrote: Christer Holmström (at Home) wrote: Hi! This SQL works perfect when running the command line tool mysql.exe SELECT exe, sum(duration) FROM data GROUP BY exe ORDER BY 2 BUT when running from the C API, the "ORDER BY" part doesn't seem active, wh

RE: newbie: creating database error

try www.mysql.com, i heard they have docs there you can read...:) -Original Message- From: Admin-Stress [mailto:meerkapot@;yahoo.com] Sent: Monday, November 04, 2002 1:41 PM To: [EMAIL PROTECTED] Subject: newbie: creating database error After playing around with 'test' database, then I w

Locking is hard!?

Hi! I have a rather large problem. I run a multi-process-robo-data-collector wich are connected to a single database. To make things faster, it runs on several machines leeching on the processor-power that machines can spare. The problem is to make them do diffrent things all the time! This is a

Re: MySQL MY.INI file

At 17:27 -0500 11/4/02, <[EMAIL PROTECTED]> wrote: Hello, How do you enable logging of slow queries in the MY.INI file under Windows? It's not Windows-specific: [mysqld] log-slow-queries or [mysqld] log-slow-queries=filename In the former case, the default name is HOSTNAME-slow.log in the d

Re: JDBC J/Connect driver is seriously slow against InnoDB

Mark: Once of the great things about MySQL is the prompt attention and response on this list. Thanks for replying to this email so quickly. Read on... --- Mark Matthews <[EMAIL PROTECTED]> wrote: > j.random.programmer wrote: > > Hi: > > > > Thought I'd mention this (using the latest dev > > J/co

MySQL on Win2000

Hello, I am running MySQL on my local Windows 2000 box and I am experiencing extreme slowdowns. I have an application that writes query data to MySQL using two, separate threads. After writing 2000-3000 records, all of a sudden, MySQL goes to 98% CPU usage and throughput drops to 1 update every 2

newbie: creating database error

After playing around with 'test' database, then I would like to create my own database. I logged in into mysql using root account and created a database. But, when I logged in using regular user, I got his error : ERROR 1044: Access denied for user: '@localhost' to database 'card' What necessar

MySQL MY.INI file

Hello, How do you enable logging of slow queries in the MY.INI file under Windows? Also, does anyone have a reasonably good MY.INI file for a configuration under Windows 2000 for a local MySQL host? Thanks, Dan Cumpian - Befor

RE: (beginner) mysql connection problem!

If it was a problem with mysql permissions you would get an access denied for user@host using password(YES/NO) error. Since the error is cannot connect through socket, either the socket is not in the specified directory or you do not have permission to it or mysqld is not running. -Original M

RE: mysql shared library.

Try using mysql>show variables; Some variables can be exported to the sql server via the environment table. For example: shell>ulimit=2046 shell>export ulimit shell>mysqld restart Hope this helps, ~Kelly W. Black -Original Message- From: Nissim Lugasy [mailto:lugasy@;lerc.nasa.gov] S

RE: Interesting Challenge

This simply returns me to the documentation. Thanks -Original Message- From: James Northcott [mailto:jnorthcott@;dpmg.com] Sent: Monday, November 04, 2002 12:13 PM To: Mysql (E-mail) Subject: RE: Interesting Challenge > mysql> SELECT cell, sector, If you only want one row, then sel

RE: mysql DATETIME substraction problem/?

More appropriately, use curdate()feature from within sql. select * where date= < curdate()-1; for example ~Kelly W. Black -Original Message- From: Benjamin Pflugmann [mailto:benjamin-mysql@;pflugmann.de] Sent: Monday, November 04, 2002 1:06 PM To: Jim Hogan Cc: [EMAIL PROTECTED] Subject

RE: (beginner) mysql connection problem!

You might also need to add hostname. It depends on what GRANT sql statement was used to add the user id. Something like mysql -u userid -p -h hostname dbasename should work. If not, check that mysqld is in fact running. You can use ps -aux | grep mysql Regards, ~Kelly W. Black -Orig

RE: Difficult query

Or, you could use distinct and substring_index instead of my last convoluted answer :) > -Original Message- > From: Kip Turk [mailto:kipt@;wcc.net] > Sent: Monday, November 04, 2002 4:17 PM > To: Alexander Newald > Cc: mySQL Mailing Liste > Subject: Re: Difficult query > > > On Mon, 4 No

Re: Mysql seg faults on remote connections

Whats the workaround?? How should I start with mysql with defualt setting in a command line??? Thanks guys On Monday, November 4, 2002, at 01:33 PM, Chris West wrote: [EMAIL PROTECTED] - Before posting, please check: http:/

Mysql seg faults on remote connections

Same thing here. Local sockets are working find. Remote connections segfault. Getting ready to try the *workaround*. I am using mysql from the stock install of RH8.0 Chris - Before posting, please check: http://www.mysql

Re: Difficult query

On Mon, 4 Nov 2002, Alexander Newald wrote: > Hello, > > I have a table with only ips in it. I want to get all networks the ips > belong to: > > Example: > > 123.123.123.1 > 123.123.132.2 > 123.123.123.3 > 1.1.1.4 > 1.1.1.5 > 1.1.1.6 > 12.12.12.1 > 12.12.12.2 > 12.12.12.10 > > The result shoul

Re: Problems with "ORDER BY" from C API (works from command-line tool mysql.exe)

Hi. On Mon 2002-11-04 at 11:56:40 +0100, [EMAIL PROTECTED] wrote: > Christer Holmström (at Home) wrote: [...] > > This SQL works perfect when running the command line tool mysql.exe > > > > SELECT exe, sum(duration) FROM data GROUP BY exe ORDER BY 2 > > > > BUT when running from the C API, the "OR

Re: mysql DATETIME substraction problem/?

Hello. On Sun 2002-11-03 at 10:44:43 -0800, [EMAIL PROTECTED] wrote: > Hello! > > I am working on an analysis that is very much dependent on calculating > time differences in seconds. The most simple example: > > I have 3 variables: time_begin (DATETIME) time_end (DATETIME) and elapsed_ > sec

Difficult query

Hello, I have a table with only ips in it. I want to get all networks the ips belong to: Example: 123.123.123.1 123.123.132.2 123.123.123.3 1.1.1.4 1.1.1.5 1.1.1.6 12.12.12.1 12.12.12.2 12.12.12.10 The result should be: 123.123.123.0 1.1.1.0 12.12.12.0 Instead of converting on matching row (f

Re: DeadLock bug using mysql/Innodb

Rafa, - Original Message - From: <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Monday, November 04, 2002 6:06 PM Subject: DeadLock bug using mysql/Innodb > Description: > Hello, > > I have a deadlock problem when I try to execute some update sentences > using 'Lock For U

Scripts/mysql_install_db error

Any suggestions?? I just installed and compiled mysql 3.23.53 and I get this error: [root@Alpha mysql-3.23.53]# scripts/mysql_install_db Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepar

RE: Maintaining #'s between 2 databases

create a sequence table. (Possibly in a third database?) sequence sequenceID bigint label varchar(25) NextValue bigint Put 1 record in the table for each autoincrement field using the fieldname as the label. Then use it instead of the built-in autoincrement fields. begin; select @nextID:=NextVa

RE: (beginner) mysql connection problem!

Sounds like mysql service hasn't started yet. > -Original Message- > From: David Wu [mailto:dwu@;stepup.ca] > Sent: Monday, November 04, 2002 2:59 PM > To: [EMAIL PROTECTED] > Subject: (beginner) mysql connection problem! > > > Hi everyone, > > On my local machine I had mysql installe

RE: Interesting Challenge

> mysql> SELECT cell, sector, If you only want one row, then selecting cell doesn't make any sense. Cell is different in each row you've selected. If you only want one row, don't select cell. > -> sum(att) as att, > -> sum(lc) as lc, > -> sum(csh) as csh, > -> ROUND((SUM( lc + cs

Scripts/mysql_install_db error

Any suggestions?? I just installed and compiled mysql 3.23.53 and I get this error: [root@Alpha mysql-3.23.53]# scripts/mysql_install_db Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepar

(beginner) mysql connection problem!

Hi everyone, On my local machine I had mysql installed, and I was able to log in and doing a test on it. but today as I am trying to login using >mysql or >mysql -u root -p, I got the error message saying; ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2), I h

Re: Q about replication & timing

On Mon, Nov 04, 2002 at 02:04:35PM -0500, Ray Zimmerman wrote: > I'm looking into options to improve performance of mysql in our app > and have a question about replication. I need the following > guarantee, which I believe is not possible with replication ... > > If a client successfully update

Interesting Challenge

Hi sql query wizards! I need some help. Is there a way I can take this query here => mysql> SELECT cell, sector, -> sum(att) as att, -> sum(lc) as lc, -> sum(csh) as csh, -> ROUND((SUM( lc + csh ) * 100 ) / (SUM(att) - SUM(tccf + bpp + bpc + suf)),2) AS drops, -> sum(tccf) as

mysql shared library.

Hi, I'm trying to access mysql shared library. mysql_init() function returns the address of MYSQL structure . I need to know what the structure looks like.? can all mysql structure parameters be configured in /etc/my.cfg ? Thanks --

Maintaining #'s between 2 databases

I have two databases (rt2 & jobs) and within each of these DBs tables that autoincrement email Ticket #'s and Work Request #'s respectively. I'm looking for the best way to maintain the numbers between the databases (e.g. if I had a rt2, jobs, then rt2 requests: rt2 issues ticket #1024, then jo

Q about replication & timing

I'm looking into options to improve performance of mysql in our app and have a question about replication. I need the following guarantee, which I believe is not possible with replication ... If a client successfully updates the master, any subsequent read from a slave must reflect that update.

RE: rounding behavior

Use the ROUND statement ROUND(sum(CLICKS),sum(IMPS)/sum(CLICKS)*100.0,0),2); -Original Message- From: David Garamond [mailto:davegaramond@;icqmail.com] Sent: Sunday, November 03, 2002 2:31 AM To: [EMAIL PROTECTED] Subject: rounding behaviour hi, mysql> select 1/29; +--+ | 1/29 | +-

RE: mysql dieing

Typically if your OS runs, the mysql will too. You should only be worried with hardware if you are running large database apps on a slow system. -Original Message- From: Stephen Hitchner [mailto:steve@;number41media.com] Sent: Friday, November 01, 2002 9:40 PM To: Mysql Subject: mysql die

RE: Cannot Log into MySQL

If you have installed MySql in some non-standard location, or if the original installation was from the OS install, it may be that you need to link the socks. I have done this, others will probably complain. I had this problem on many systems newly installed. I fixed it with ln -s /var/lib/path/t

MySQL & Berkeley DB

Hello Everyone, I have been going through the documentation on MySQL and on Berkeley DB looking for an answer for my question for several weeks and have yet to come up with one, so I figured I post it. I have a situation where the customer that I have wants to use their current Berkeley DB, altho

Re: mysql compile problem under Solaris 9

I've found that previous build-attempts that have failed (IE did you have a bad/nonexistant LD_LIBRARY_PATH, fix it, and then try 'make' again?) cause this, and even a make distclean doesn't fix it. Try starting from a freshly untarred source ... that's always done it for me. -=| Ben - O

RE: BETWEEN

> sql,query Would it be possible to supply BETWEEN in any order (or rather to allow to do that)? Such as WHERE timestamp BETWEEN 2002100100 AND 20021031235959 would get the same results with WHERE timestamp BETWEEN 20021031235959 AND 2002100100 or any other case where BETWEEN can be u

Re: New to MySQL, ported from MS Access. Using ASP & MyODBC - UPDATEproblem...

Luis Sanches wrote: Hi, I've recently made the move over from Access to MySQL. So far, everything has been fine. I'm using: Win2K server (ASP) WinMySQLadmin 1.4, MyCC 0.8.4-alpha, MyODBC 3.51 and MySQL 3.23.51-nt First problem: (fixed) -- I had used some keyword

Size

I and my friend will do a test with SQL Server, Oracle and MySQL We´ll start with a table with 2.000.000 rows. What´s the best table type to do it? I thought to do in InnoDB but how much do I set the size? Maybe 200MB? Regards Alexander sql, query _

RE: Problems with "ORDER BY" from C API (works from command-line tool mysql.exe)

Hmm, sorry, but it works! Found the problem, it was all my misstake. It was my win32 dialoglist that was sorted :-( Thanks! /Christer -Original Message- From: Christer Holmström (at Home) [mailto:Christer.Holmstrom@;home.se] Sent: den 4 november 2002 15:59 To: 'gerald_clark' Cc: 'Joseph

Re: help create new user

Jeremy Zawodny wrote: On Mon, Nov 04, 2002 at 12:54:17AM -0500, Bob Lockie wrote: That fixed it, thanks. What did it use since I didn't specify an @'localhost'? It used '%' which matches everyhing *except* localhost. The manual explains this. Jeremy It's not obvious in the MySQL manu

re: Newbie question: Storing text

At 19:15 +0200 11/4/02, Egor Egorov wrote: Paul, Saturday, November 02, 2002, 5:11:43 PM, you wrote: P> I am kind of new to MySQL. I have ordered MySQL Cookbook but I still P> have a week before it arrives. In the meantime, I am looking for some P> basic help. P> I am looking to store the text/d

Missing my.cnf file

Having some other folks helping me out here with this MySQL problems that I am having. I have found out that I am missing the my.cnf from the /etc directory and I am trying to create the file from scratch, this is what I have so far and also MySQL is installed from .tgz in this directory. /usr

NO PROBLEM: Re: mysql DATETIME substraction problem/?

On Mon, 4 Nov 2002, gerald_clark wrote: > You can't just subtract datetime fields. Check the date and time functions > in the manual. Thanks, I should know I run the risk of posting a RTFM/FAQ when I'm tired! I got off track by misinterpreting "In MySQL Version 3.23, you can use + and - inste

RE: newbie: SQL question

Try this: http://www.devshed.com/Server_Side/MySQL - Hi, I am just a starter. Anyone can suggest me good web resources for learning SQL command that I can use (compatible) with mySQL ? I read from www.mysql.com documentation, but it's not complete ... Well, if you hav

re: mysql DATETIME substraction problem/?

Jim, Sunday, November 03, 2002, 8:44:43 PM, you wrote: JH> I am working on an analysis that is very much dependent on calculating JH> time differences in seconds. The most simple example: JH> I have 3 variables: time_begin (DATETIME) time_end (DATETIME) and elapsed_ JH> seconds (INT). The dat

re: Re: mysqladmin missing

aman, Saturday, November 02, 2002, 6:18:58 PM, you wrote: am> If I have an old copy of Mysql on the system and want to uninstall that, how am> would I make sure that all the database associated should get deleted, or do am> I do it manually? If you uninstall MySQL server, data directory will not

re: Newbie question: Storing text

Paul, Saturday, November 02, 2002, 5:11:43 PM, you wrote: P> I am kind of new to MySQL. I have ordered MySQL Cookbook but I still P> have a week before it arrives. In the meantime, I am looking for some P> basic help. P> I am looking to store the text/description for the purpose of retrieving P>

re: Problem in decimal separator

Juan_Andres_Torregrosa, Monday, November 04, 2002, 1:44:11 PM, you wrote: Jaedddc> I have a problem when I load a text file using the sentence "load data Jaedddc> infile" as long as decimals are separated by commas and mysql ignores those Jaedddc> decimals, is there any way to specify that decimal

re: ORDER BY and charset iso-8859-2 and windows-1250

Bc., Monday, November 04, 2002, 12:14:53 PM, you wrote: BRK> I have problem with ORDER BY in MySQL if I have some characters in iso-8859-2 BRK> and windows-1250. What I should do for fix it. Set up corresponding default-character-set in my.cnf. -- For technical support contracts, goto http

re: RE: Select by row number

> There is no row number in MySQL. You should use ORDER BY to >> retrieve data in particular order. handf> What about the following info in the manual p. 55? handf> Add a PRIMARY KEY or UNIQUE key to the table and use this. New in Version handf> 3.23.11: If the PRIMARY or UNIQUE key consists of o

re: connecting a remote mysql-server always fails

Jochen, Saturday, November 02, 2002, 3:49:18 PM, you wrote: JK> when I try to connect to a remote computer running mysql JK> I always get the following error on the remote machine: JK> Number of processes running now: 1 JK> mysqld process hanging, pid 7262 - killed JK>

re: explain bug?

Robert, Monday, November 04, 2002, 12:39:34 AM, you wrote: RGp> I've tried an EXPLAIN of the SELECT below. RGp> Please can anyone tell me why it's RGp> "Impossible WHERE noticed after reading const tables" RGp> ? RGp> I've droped and created the table - but the error/message occurs. RGp> When I

RE: safe_mysqld crashing

On Mon, 4 Nov 2002, Alston, Tony wrote: > Kip, > > Do you use RedHat's 'up2date' program? No, but it was a problem with glibc (sort of) anyhow. The problem is resolved. For posterity, here's what we did. 1.) Per the bug report at https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=75128,

RE: newbie: SQL question

http://hotwired.lycos.com/webmonkey/backend/databases/ might be a good place, haven't read it, but I send people that want to learn HTML to webmonkey, and they liked it. > -Original Message- > From: Admin-Stress [mailto:meerkapot@;yahoo.com] > Sent: Monday, November 04, 2002 10:50 AM > To

mysql compile problem under Solaris 9

I have tried compiling the latest 3.23 version of mysql under Solaris 9 using gcc 3.2 and keep getting the following error: g++ -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME="\"/usr/local/mysql\"" -DDATADIR="\"/usr/local/mysql/var\"" -DSHAREDIR="\"

Re: MySQL and binary data

The problem is that you are starting mysql with the wrong arguments. I think you need to set the max_allowed_packet parameter to something larger than the default 1 M. I got mine to do that by using this command: safe_mysqld --user=mysql -O key_buffer=16M -O table_cache=128 -O sort_buffer=4M -O r

newbie: SQL question

Hi, I am just a starter. Anyone can suggest me good web resources for learning SQL command that I can use (compatible) with mySQL ? I read from www.mysql.com documentation, but it's not complete ... Well, if you have collection for beginner, please :) Thanks, kapot __

DeadLock bug using mysql/Innodb

Description: Hello, I have a deadlock problem when I try to execute some update sentences using 'Lock For Update'. I need to create a new document which is identified by a unique number, which is stored in the field 'Ped' of the table 'Pedidos'. To obtain a new document number I add 1 to the co

New to MySQL, ported from MS Access. Using ASP & MyODBC - UPDATE problem...

Hi, I've recently made the move over from Access to MySQL. So far, everything has been fine. I'm using: Win2K server (ASP) WinMySQLadmin 1.4, MyCC 0.8.4-alpha, MyODBC 3.51 and MySQL 3.23.51-nt First problem:

RE: Distributing table-files to other machines

You can move the files and then set up symlinks to them in the /mysql/data/dbName directory. Arthur -Original Message- From: Michelle de Beer [mailto:michelledebeer@;yahoo.com] Sent: Monday, November 04, 2002 8:21 AM To: [EMAIL PROTECTED] Subject: Distributing table-files to other machine

[Error] winmysqladmin.exe - Entry Point not Found

I have the following problem after installing MySql version 3.23.53-max on the Windows NT Server. 1. When I start winmysqladmin.exe, I get a error as follows, - Entry Point not found. The procedure entry point CreateToolhelp32Snapshot could not be located in the dynamic library KERNEL32

Re: select using regexp

Hi, REGEXP is much more powerful than LIKE; you can match full words with this syntax: SELECT * FROM TABLE WHERE field REGEXP "[[:<:]]cat[[:>:]]"; (Easy, isn't it ? ;) ) You can find more examples in the manual: http://www.mysql.com/doc/en/Regexp.html Regards, Joseph Bueno NetClub gerald_clar

MAX_BINLOG_SIZE

I am using MySQL V4.0.2alpha and I have set MAX_BINLOG_SIZE to 2M in order to not have to run a CRON job or something similar to do a "FLUSH LOGS" intermittently. This should cause the binary log file to be rotated after it has reached 2M according to the documentation. This hasn't been happening a

safe_mysqld crashing

I tried to send this Friday, but was a bit frazzled and probably didn't give enough information. So, I'll try again and see if anyone can help. My RedHat 7.3 system running MySQL 3.23.52 crashed. On reboot, everything came up normally except MySQL. When safe_mysqld is run, I get the followi

RE: MySQL and binary data

> Whenever I insert data that is > around 1 Megabyte in size, I get an error saying > "MySQL server has gone away". It doesn't happen with > smaller data, and even if I change the column type to > LONGBLOB I still have this problem. You've hit the default maximum packet size of 1 MB. This is a pr

Re: MySql uses 98% CPU

On Mon, Nov 04, 2002 at 12:37:15PM +0100, Nicolas MONNET (Tech) wrote: > > We get the same thing on FreeBSD machines quite often, and it's not > related to the actual work being done; MySQL can sit idle but use up > all CPU. It happens after a few days/weeks of uptime. That's a known bug in FreeB

Re: MySQL and binary data

- Original Message - From: "Steven Nakhla" <[EMAIL PROTECTED]> To: "QT" <[EMAIL PROTECTED]> Cc: "MySQL" <[EMAIL PROTECTED]> Sent: Monday, November 04, 2002 3:47 PM Subject: MySQL and binary data > I am using Qt 3.0.5's QSql database classes to store > information in a MySQL database. MyS

  1   2   >