Re: DISTINCT LEFT JOIN

try something like this: select site_id, max(service_date), name from site_service left join site on site.id = site_service.site_id group by site_id; --- Tom Beidler <[EMAIL PROTECTED]> wrote: > I¹m having problems with a left join. I¹m not even > sure if I should be using > a left join. > >

Re: importing database

Hi There are many ways to convert an Oracle DB to MySQL. 1 - Scan, process Oracle exp files, very painful 2 - Use a tool that can access both databases, ie Excel via ODBC 3 - Access oracle schema tables, user_tables, user_tab_columns, user_objects etc and create a MySQL SQL file. The third appr

segfault during make

>Description: segfault during make >How-To-Repeat: CFLAGS="-O3" CXX=gcc CXXFLAGS="-O3 -felide-constructors -fno-exceptions -fno-rtti" ./configure --prefix=/usr/local/mysql --enable-assembler --with-embedded-server make >Fix: >Submitter-Id: >Originator:Nigel Wetters >Organizatio

segfault during make (more details)

>Description: with my setup (rh8.0), no matter what configuration options I use, I get segfaults during make. here's the error with a straight ./configure && make os0file.c: In function `os_aio_simulated_handle': os0file.c:2406: internal error: Segmentation fault Please submit a full bug report,

Re: Last record

* Deependra b. Tandukar > How do I select the very last record in a column in MySQL database? The expression "last record" implies that there is an ORDER in your query... if you add the keyword "DESC" and a "LIMIT 1", you should get the desired result: SELECT * FROM mytable ORDER BY mycolumn

Slow imports on Solaris 8

I have just set up a new MYSQL cluster running MySQL 3.23 on a 6 processor Sun 4500 running Solaris 8. I installed from a Solaris binary and everything loks functionally OK. The only thing I couldn't do what run the sql-bench tests as are version of Perl doesn't have the requirired modules.

stuck

hi, i am having no end of problems with installing mysql (any 3.23.* version) on linux. i started off on SuSe and received different errors, I am now trying with mandrake, The current error is that I have downloaded the mysql.3.23.55-pc-linux-i686.tar.gz and done the following: tar -zxvf mysq

Re: stuck

Um - you would only ./configure if you have downloaded the source tarball - you have the linux binary so you need to follow the instructions for binary installation. DC \"J. A. Tovey\" <[EMAIL PROTECTED]> wrote: > > hi, > > i am having no end of problems with installing > mysql (any 3.23.* ver

Re: stuck

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tue, 11 Feb 2003, J. A. Tovey wrote: > i am having no end of problems with installing mysql (any 3.23.* > version) on linux. > > i started off on SuSe and received different errors, I am now trying > with mandrake, > > The current error is that I h

question on "select group by a 'set' field"

Dear all, I have a table Kids which has the following fields: kid char(20), favorite_fruits set('apple','pear','orange',) favorite_fruits has choices of up to 64 items. Now I want to query the count of each fruit appears in the favorite_fruits of the kids in the table. Is there anyway to

What the required files to include in order to run mysql

Hi We've put together an installation of our tool together with MySQL The question is now what files are required (must be included) to run MySQL? I've included: Bin/ mysql.exe mysqladmin.exe mysqld-nt.exe mysqldump.exe mysqlimport.exe libmySQL.dll

Re: question on "select group by a 'set' field"

Hello Anya, On Tue, Feb 11, 2003 at 07:51:00PM +0800, Anya wrote: > > > Dear all, > I have a table Kids which has the following fields: > > kid char(20), > favorite_fruits set('apple','pear','orange',) > > favorite_fruits has choices of up to 64 items. > > Now I want to query the count o

Re: Merge table limit

Hi, On Sat, 2003-02-08 at 09:33, Jerry wrote: > Hello all. > > Does any one know, or can anyone point me in the direction of the limits of > a number of tables I can put in a union of a merge table, I can figure out > what the sql would be. Don't know if there is a limit.. But you must take int

error if I post a record

Hello everybody, I have a problem with MySQL and an application made with Delphi. If I try to save a modified record in a table, I get the following error: "Record can not be locked because the record is already in use." I don't know if that is the exact translation. The original errormessage is G

AW: stuck , mysql on SUSE

Hi , if you used SUSE , why didn't you just install the mysql-packages distibuted there with yast. It's very easy and I never had a problem with it. It is also possible to install foreign packages with yast later , if you want to udate your mysql-server later. The problem is , that SUSE is not ver

Re: question on "select group by a 'set' field"

Thanks, Fred. It works perfectly. At 01:00 PM 2/11/2003 +0100, Fred van Engen wrote: >Hello Anya, > >On Tue, Feb 11, 2003 at 07:51:00PM +0800, Anya wrote: >> >> >> Dear all, >> I have a table Kids which has the following fields: >> >> kid char(20), >> favorite_fruits set('apple','pear','orange

Re: tricky regrex and case case query

Hi, you could try: SELECT name, SUBSTRING_INDEX(name,' ', 1) as first, SUBSTRING_INDEX(v2, ' ', -1) as last FROM table For the uppercase of the first letter, as i don't know a specific functions to do that in MySQL (it has ucase and lcase but for all the word), you must "play" wit

Re: Merge table limit

Cheers. The only limit I've hit so far on 365 tables, was the max number of open files, so I've ramped that up and its working fine at the moment. Jerry - Jeremy Hutchings Apps R&D Cable and Wireless - - Original Message - From: "Diana Soares" <[E

Query Help

Hi, How can I write a MySQL query to grab single lines of the form: ColumnNames: EnquiryID, Name, Address, Detail1, Detail2, Detail3, Detail4 From two joined tables: Tbl1: Enquiries -- ID Name Address Etc Tb12: Details ID EnquiryID Detail Etc -

SET field manipulation

Hi, how can I update a set field such that all table rows get what they had in the set ORed with some other set value. I.E. If I have a field called SetField and rows: SetField A A,B A,B,C B etc How can I do what I'm trying to do with this mysql query? UPDATE MyTable SET SetField = (SetField

Re[2]: Robot Replies (Off topic)

Unfortunately, good intentions don't always produce alike results. How about if the bot replies to messages matching "newbie", "novice" and "beginner" in the subject? They most likely tend to be from beginners, and online manual and/or list archives are pretty much perfect solutions for their iss

Re: encrypted password

The manual suggests that the password function is really for intenal mysql functions. Ideally you should use the encode or md5_encode functions. update user set password=encode('password', 'salt') where user = 'your_user'; Curtis On Wed, 5 Feb 2003, Natale Babbo wrote: > try to use the pas

Re: MySQL IMAP Server

Courier IMAP can. www.courier-mta.com Curtis On Wed, 5 Feb 2003, Paul DuBois wrote: > At 17:26 + 2/4/03, Ben Clewett wrote: > >MySQL, > > > >My first post, please go easy if this is the wrong pleace! > > > >I'm trying to find an IMAP server which used MySQL so that my > >Mozilla Email cli

Re: exist

Heya: > HI > Does mysql support function EXIST No. It doesn't support subselects before 4.1 either. > mysql> select * from arcdata d > -> WHERE year='2003' AND semester='1' > -> AND EXIST (SELECT * FROM arcdata_unitCodes u > -> WHERE u.idnum = d.idnum AND u.semester=d.semester AN

Top MYSQL Sites

Hello Can somebody tell me what are the top sites ( except ofcourse mysql.com ) for general MySQL News, Tutorials etc. Insane - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mys

socket error

hi - i have got to the beginning stages of installation - on trying to create a root password with: bin/mysqladmin -u root password 'password' i get bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)' Check

Strange Updates

Hi everybody I got weird behaviour from Mysql while doing some updates. Before doing the update I did a count, like this: select count(*) from Yellow WHERE MATCH(street_add) AGAINST('+GUIDO +MIGLIOLI' IN BOOLEAN MODE) AND street_short = ''; and the result was 50 rows in set. But when I ran t

Re: socket error

- Original Message - From: "J. A. Tovey" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, February 11, 2003 9:09 AM Subject: socket error > hi - > > i have got to the beginning stages of > installation - on trying to create a root > password with: > > bin/mysqladmin -u root pass

mysql overhead

Hi, I am using PhpMyAdmin and today I got a red message saying that one table has overhead and I need to optimize the table. This is the first time I got this message, I looked online and I understood why it shows. But my question is: can I do something to avoid it? What effects daoe the overhea

Very slow request with many ORs in where parts

Hi! I have the following table: create table law_words ( l_id int unsigned not null, w_id int unsigned not null, primary key (w_id, l_id) ); The request is: SELECT DISTINCT w0.l_id FROM law_words as w0 inner join law_words as w1 on w0.l_id=w1.l_id where w0.w_id in (258,282,... ab

RE: Very slow request with many ORs in where parts

Can you post your explain plan? -Original Message- From: Artem Koutchine [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 11, 2003 8:23 AM To: [EMAIL PROTECTED] Subject: Very slow request with many ORs in where parts Hi! I have the following table: create table law_words ( l_id i

Re: socket error

ah ok, yes, the error log says " 030211 12:10:27 mysqld started 030211 12:10:27 Can't start server: Bind on TCP/IP port: Address already in use 030211 12:10:27 Do you already have another mysqld server running on port: 3306 ? 030211 12:10:27 Aborting " how do i get rid of this other mysql !

Re: socket error

- Original Message - From: "J. A. Tovey" <[EMAIL PROTECTED]> To: "Peter Grigor" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, February 11, 2003 9:34 AM Subject: Re: socket error > ah ok, yes, > > the error log says > " > 030211 12:10:27 mysqld started > 030211 12:10:27 Can't s

SERIOUS PROBLEM

Hi, I am encountering a serious problem with MYSQL 3.23.48. Mine is a java application with the following flow. Make a connectionobject to Mysql Get a record from table1 Update table2 with the table1 info. It works in 99% of the cases i am able to fetch the record from table1. But in 1

create temp table

In MySQL is it possible to create a temporary table without having to specify all the properties? On SQL Server (at least via query analyzer) you can create temp tables fairly easily and the properties of each field are inherited from the regular table. Doesn't look like thats the case with MySQL

Re: SERIOUS PROBLEM

- Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, February 11, 2003 9:52 AM Subject: SERIOUS PROBLEM > Hi, > I am encountering a serious problem with MYSQL 3.23.48. Mine is a java > application with the following flow. > >Make a connectionobject to

Re: create temp table

create newtable select from oldtable where 1=0; Admin wrote: In MySQL is it possible to create a temporary table without having to specify all the properties? On SQL Server (at least via query analyzer) you can create temp tables fairly easily and the properties of each field are inherited from

RE: Very slow request with many ORs in where parts

Artem, Have you considered using a full text index? I don't really understand exactly what you are trying to do, but consider it if you haven't already. Andy > -Original Message- > From: Artem Koutchine [mailto:[EMAIL PROTECTED]] > Sent: 11 February 2003 14:23 > To: [EMAIL PROTECTED] > S

Re: socket error

i'm sorry - could you explain that for a simpleton :-) i have no idea what you mean :-/ --- Peter Grigor <[EMAIL PROTECTED]> wrote: > - Original Message - > From: "J. A. Tovey" <[EMAIL PROTECTED]> > To: "Peter Grigor" <[EMAIL PROTECTED]>; > <[EMAIL PROTECTED]> > Sent: Tuesday, February 11

Re: socket error

> i'm sorry - could you explain that for a > simpleton :-) > i have no idea what you mean :-/ > > --- Peter Grigor <[EMAIL PROTECTED]> wrote: > > - Original Message - > > From: "J. A. Tovey" <[EMAIL PROTECTED]> > > To: "Peter Grigor" <[EMAIL PROTECTED]>; > > <[EMAIL PROTECTED]> > > Sent: Tu

problem with the load data

I'm trying to load a text file, I've extract from access, and Ihave the following error mysql> LOAD DATA INFILE '/home/dapasedg/provedores.txt' INTO TABLE proveedores -> FIELDS TERMINATED BY '|' ENCLOSED BY '"'; ERROR 13: Can't get stat of '/home/dapasedg/provedores.txt' (Errcode: 13) Anybo

optimizing left join query

Hello All, I have the following 2 tables and "LEFT join" query as follows: mysql> describe user_lic; +++--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +++--+-+-+---+ | license_id | big

Re: socket error

ok :) all killed now, (not quite there yet though :)) I am now getting the error: 030211 16:26:51 mysqld started 030211 16:26:51 /usr/local/mysql/bin/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 030211 16:26:51 mysqld ended ? --- Peter Grigor <[EMAIL PROTECTED]> wrote: > > i'm

Re: socket error

- Original Message - From: "J. A. Tovey" <[EMAIL PROTECTED]> To: "Peter Grigor" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, February 11, 2003 11:33 AM Subject: Re: socket error > ok :) > > all killed now, > > (not quite there yet though :)) > > I am now getting the error:

Re: Last record

On 11 Feb 2003, at 10:30, Deependra b. Tandukar wrote: > How do I select the very last record in a column in MySQL database? That depends on what you mean by "last record". What are you sorting by? Once you've figured that out, do a query like this: SELECT * FROM table_name ORDER BY sor

Re: optimizing left join query

Your user_info table is not indexed... (user_info.uid should have an index) Check the manual: http://www.mysql.com/doc/en/MySQL_indexes.html On Tue, 2003-02-11 at 16:16, [EMAIL PROTECTED] wrote: > Hello All, > > I have the following 2 tables and "LEFT join" query as follows: > > > mysql> desc

Re: socket error

yes, i ran everything again --- Peter Grigor <[EMAIL PROTECTED]> wrote: > - Original Message - > From: "J. A. Tovey" <[EMAIL PROTECTED]> > To: "Peter Grigor" <[EMAIL PROTECTED]>; > <[EMAIL PROTECTED]> > Sent: Tuesday, February 11, 2003 11:33 AM > Subject: Re: socket error > > > > ok :)

Re: socket error

- Original Message - From: "J. A. Tovey" <[EMAIL PROTECTED]> To: "Peter Grigor" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, February 11, 2003 11:52 AM Subject: Re: socket error > > yes, i ran everything again > Well, the host.frm file is a mysql database table def...your perm

Fw: Very slow request with many ORs in where parts

Yes of course. Here you go: mysql> EXPLAIN SELECT DISTINCT w0.l_id FROM law_words as w0 -> inner join law_words as w1 on w0.l_id=w1.l_id -> WHERE -> w0.w_id IN (258,282,287, 615, 1101, 1949, 1968, 3417, 3574, 3578, 3643, -> 4345,4768, 5297, 5976,6133, 7243,7245, 9271, 9348, 11

Re: optimizing left join query

Diana, Thanks for the suggestion. I completely forgot to add the index/primary key. Now it works just fine :) Thanks again. In Peace, Saqib Ali "I fear, if I rebel against my Lord, the retribution of an Awful Day (The Day of Resurrection)" Al-Quran 6:15 http://docbook.sc-icc.org |+

RedHat 8.0 and MySQL 3.23.55 install problem

I am having problems installing MySQL 3.23.55 on RedHat 8.0. The version that came with RedHat will not let me remotely login. I found a thread at RedHat that said that this is a known problem. One of the suggestions was to upgrade MySQL. That is what I am attempting to do. This is what happens

Re: RedHat 8.0 and MySQL 3.23.55 install problem

I get this message back: Failed dependencies: MySQL-DBI-perl-bin is needed by MySQL-bench-3.23.55-1 I know I have this dependency installed, but I think I know where the problem is just not sure how to fix it. Here is what I get when I do a 'rpm -qa | grep DBI-perl': Mysql-DBI-perl-bin-1.182

Re[2]: socket error

J.A., >> > Can't find file: './mysql/host.frm' (errno: 13) >> > 030211 16:26:51 mysqld ended >> Did you run the mysql_install_db script?? > yes, i ran everything again I bet my b* you didn't, or maybe something went wrong when running it. If mysqld cannot find host.frm, this means the grant t

Re: problem with the load data

Edgard, > I'm trying to load a text file, I've extract from access, and Ihave the > following error mysql>> LOAD DATA INFILE '/home/dapasedg/provedores.txt' INTO TABLE proveedores > -> FIELDS TERMINATED BY '|' ENCLOSED BY '"'; > ERROR 13: Can't get stat of '/home/dapasedg/provedores.txt' (Errc

Re: mysql overhead

Ciprian, > I am using PhpMyAdmin and today I got a red message saying that one > table has overhead and I need to optimize the table. > This is the first time I got this message, I looked online and I > understood why it shows. But my question is: can I do something to avoid > it? What effects da

mysql privs table level security

Hi all, Can anyone help me please? I have a database with hundreds of tables and I want to lock down certain tables for select only. The order of presidence for mysql privs as far as I can tell is that if there are database level privileges, these override the table level privs. I don't want to

3.23.41: auto_increment bug with TRIPLE primary key? (really strange)

mysql -V: mysql Ver 11.15 Distrib 3.23.41, for redhat-linux-gnu (i386) (Upgrading may not be an option.) Not subscribed to the list, so please CC me on any responses. I'd submit this to bugs@, but my MySQL version is way out of date and I'm not sure if the current version has been fixed. A q

client side RAD

I am desperately searching for a GUI RAD environment to develop database applications for MySQL. I'm not talking about database administration such as provided by ControlCenter or SQLyog. I'm talking about the ability to build formatted forms/screens, queries and reports along the lines of Access.

IP Addresses -- How to Store

I'm looking to develop a database of IP addresses for the company and have, of course, chosen mySQL as the backend. I want the app to add (remove, etc.) a host, giving its hostname and segment. The app will add the next available address to the database and, looking at the segment, provide the su

Re: IP Addresses -- How to Store

In the last episode (Feb 11), Aaron Conaway said: > I'm looking to develop a database of IP addresses for the company and > have, of course, chosen mySQL as the backend. I want the app to add > (remove, etc.) a host, giving its hostname and segment. The app will > add the next available address t

Re: IP Addresses -- How to Store

On Tue, 11 Feb 2003, Dan Nelson wrote: > Store your addresses as INTs, so you would have three fields: > "address", "netmask", and "gateway". You can either encode the values > yourself, or use mysql's INET_NTOA()/INET_ATON() functions. ...and beware, INET_NTOA/ATON calls aren't compatible (as f

Re: Query Help

You have one column detail - What do you mean by detail1, detail2 and so? = On Tue, 11 Feb 2003 13:13:31 +, Jeff Snoxell <[EMAIL PROTECTED]> wrote: Hi, How can I write a MySQL query to grab single lines of the form

Re: Maximum of 16 indexes per table

Has the maximum number of keys in a MyISAM table been tested more since this post? Is it possible to get above 64 keys? (I'm going for 90, btw) ~Seth to get past spam filter: MySQL sql query Subject: Re: Maximum of 16 indexes per table From: Michael Widenius Date: Fri, 30 Jul 1999 23:57:19 +0300

**RE: client side RAD**

Charles. Have you tried Omnis Studio (www.omnis.net). It's a 4GL RAD which supports Mac Classic, OSX, Windows, Linux and Solaris. I use the Mac and Windows version nearly everyday and find it an excellent tool for creating database front-ends (mySQL access is via ODBC). The Omnis-Underground host

newbie sql statement help

The people who run our mysql server are using version 3.23.51, so I don't have access to some of version 4's features like sub selectes. I have a table with data like this: firm firm_rank time time_rank student A 1 10 1 jones A 1 10 1 smith A 1 10 1 alvin A 2 10 1 bob A 2 10 2 charlie

Re: encrypted password

Hi! On Feb 04, Jianping Zhu wrote: > > I have mysql in a redhat machine. I need to use mysql do user > authentication to a website. > I have a table like following. > > +--+--+ > | username | passwd | > +--+--+ > | jianping | jian1830 | > | chichi | jian1830 |

RE: IP Addresses -- How to Store

Thanks to Peter, Ravi, and Dan. That's exactly what I needed to know. -- Aaron Conaway Network Engineer III Verisign, Inc. -- Telecom Services Division http://www.verisign.com Office: 912.527.4343 Fax: 912.527.4014 -Original Message- From: Peter Hicks [mailto:[EMAIL PROTECTED]

re: Strange Updates

On Tuesday 11 February 2003 16:21, Daniele Lo Re wrote: > I got weird behaviour from Mysql while doing some updates. > > Before doing the update I did a count, like this: > > > > select count(*) from Yellow WHERE MATCH(street_add) AGAINST('+GUIDO > +MIGLIOLI' IN BOOLEAN MODE) AND street_short = ''

re: How to modify ft_min_word_len?

On Monday 10 February 2003 17:55, Octavian Rasnita wrote: > Please tell me how to modify the variable ft_min_word_len. > > I've tried: > > set ft_min_word_len=2; > set @ft_min_word_len=2; > > The second creates a new variable I think and the first one tells me that > there is no such variable. Yo

re: Caching queries

On Monday 10 February 2003 17:54, Octavian Rasnita wrote: > Please tell me what should I do to make MySQL cache all the queries that > can be cached. > > Can I do this if I am not the administrator of MySQL server? (on a session > basis...). Take a look at query cache: http://www.mysql.co

re: problem with the load data

On Tuesday 11 February 2003 18:13, Edgard Dapás wrote: > I'm trying to load a text file, I've extract from access, and Ihave the > following error > > > mysql> LOAD DATA INFILE '/home/dapasedg/provedores.txt' INTO TABLE > proveedores -> FIELDS TERMINATED BY '|' ENCLOSED BY '"'; > ERROR 13: Can't ge

Migrating Microsoft Access to MySQL

I am with a small business in Southern California that would like to migrate our MS Access databases to MySQL server. Are their any computer service companies who can help me? - Before posting, please check: http://www.mysql.

RE: Strange Updates

: > select count(*) from Yellow WHERE MATCH(street_add) : AGAINST('+GUIDO : > +MIGLIOLI' IN BOOLEAN MODE) AND street_short = ''; : > : > and the result was 50 rows in set. : > : > But when I ran the update: : > UPDATE yellowtest.Yellow SET street_short = 'MIGLIOLI'

Re: MySQL book TOC

On Sat, Feb 08, 2003 at 10:47:55PM -0800, Nasser Ossareh wrote: > > SQL in the "What is SQL?" phrase threw me... I thought > you were talking about MS SQL.. SQL is and should be known as a query language, not a product. It should be perhaps clarified the first time it is used as not refering to t

Re: Robot Replies (WAS: Re: support question (win98_se) (auto))

On Sun, Feb 09, 2003 at 03:11:54PM -0700, Doug Thompson wrote: > Am I the only one that equates these robot replies with spam? Most of > them are as meaningful as talking to micro$oft. I don't know why they're sent to the list and not to the Sender address. > > > > * http://www.mysql.com/doc

Re: IP Addresses -- How to Store

On Tue, Feb 11, 2003 at 01:15:01PM -0500, Aaron Conaway wrote: > I'm looking to develop a database of IP addresses for the company and > have, of course, chosen mySQL as the backend. I want the app to add > (remove, etc.) a host, giving its hostname and segment. The app will > add the next availa

Compiling on Solaris 2.6

I have tried multiple times to build a version of 3.23.55 with support for innodb under Solaris 2.6. I can not upgrade the version of the OS. Here is the error: source='mysql.cc' object='mysql.o' libtool=no \ depfile='.deps/mysql.Po' tmpdepfile='.deps/mysql.TPo' \ depmode=gcc3 /bin/ksh ../depcom

Slow Fulltext Index Creation

Hi. I'm adding a fulltext index to two fields in a large (2300MB) table. The index created the first 200MB or so of data pretty quickly (in a couple of hours), but progress from there has been very slow. After 48 hours the temporary table is only 640MB / 2300MB original table size. I've chang

Re: IP Addresses -- How to Store

- Original Message - From: "Michael T. Babcock" <[EMAIL PROTECTED]> To: "Aaron Conaway" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, February 11, 2003 3:25 PM Subject: Re: IP Addresses -- How to Store > On Tue, Feb 11, 2003 at 01:15:01PM -0500, Aaron Conaway wrote: > > I'm

Re: socket error

chown -R mysql.mysql/var/lib/mysql Substitute the actual location where mysql stores its data files. J. A. Tovey wrote: ok :) all killed now, (not quite there yet though :)) I am now getting the error: 030211 16:26:51 mysqld started 030211 16:26:51 /usr/local/mysql/bin/mysqld: Can't

Re: Migrating Microsoft Access to MySQL

there is a tool called SQLyog at http://www.webyog.com/sqlyog/download.html It has a very good ODBC import tool which will import your Access data to MySQL without any fuss and its FREE!!! Insane - Original Message - From: "Edward Kim" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wed

Re: need 4.1 binaries

I am waiting for Mysql's UTF8 support as well. NOt sure if the binaries can solve your issue, according what I know, we need to specify the charset information in configuration/compilation time inorder to enable UTF8. I actually tried to build mysql 4.1 out of the source tree(my system is RH 8

Re: IP Addresses -- How to Store

On Tue, Feb 11, 2003 at 03:34:52PM -0500, Peter Grigor wrote: > Dood, he's not gonna be very happy storing an IP as 16 bits :) Excuse my long day; 32 bits would be much more useful. -- Michael T. Babcock CTO, FibreSpeed Ltd. (Hosting, Security, Consultation, Database, SQL) http://www.fibresp

Re: client side RAD

G'day Charles > I am desperately searching for a GUI RAD environment to develop database > applications for MySQL. Try www.servoy.com and you might find what you're looking for cheers kim - Before posting, please check:

Safe way to allow users to create databases?

Is there a safe way to allow ordinary users, who should not have MySQL root privileges, to create databases using any name they choose? It seems to me that I would need to use "GRANT ALL ON *.* TO user WITH GRANT OPTION". This would be dangerous because of the other user's databases and the mysq

re: newbie sql statement help

This might help. http://www.mysql.com/doc/en/example-Maximum-column-group-row.html I had the same problem. Before I found the webpage above, I went with a less efficient but simpler way. I wanted the highest revision ("revision") for each news article ("id"). $SQL = "CREATE TEMPORARY TABLE

Re: Safe way to allow users to create databases?

Kevin, > Is there a safe way to allow ordinary users, who should not have MySQL root >privileges, to create databases using any name they choose? It seems to me that I >would need to use "GRANT ALL ON *.* TO > user WITH GRANT OPTION". This would be dangerous because of the other user's >databas

Re: RAND() Problems in mysql version 3.23.54 and 3.23.55 (linux)

Hi! On Feb 05, Tue Tønning wrote: > Hey, > > I have discovered a strange error in the mysql versions mentioned in subj. > > Example. > A table with 10 entries ...i want to draw 3 randomly > => "select fieldName from tableName order by RAND() limit 3" > > this have worked for the last year or so

RE: Safe way to allow users to create databases?

: Is there a safe way to allow ordinary users, who should : not have MySQL root privileges, to create databases using : any name they choose? It seems to me that I would need to : use "GRANT ALL ON *.* TO user WITH GRANT OPTION". This : would be dangerous because of the othe

Re: Maximum of 16 indexes per table

I have a table of between 90-100 columns and currently 70k rows. I don't care how long it takes to enter the data, but I would like to select it as fast as possible. Each column should be theoretically queried as much as any other. Right now I am using static MyISAM tables, which seem good enough f

Re: Slow Fulltext Index Creation

Hi! On Feb 12, Peter Bryant wrote: > Hi. I'm adding a fulltext index to two fields in a large (2300MB) table. > > The index created the first 200MB or so of data pretty quickly (in a couple > of hours), but progress from there has been very slow. > > After 48 hours the temporary table is only

Strange sorting in table

Hi! I have a couple of tables in a MySQL database. In one of the tables, PhpMyAdmin sorts very strange. ID 1002 is places between ID 21 and ID 22. Any idea why? Best Regards, Viktor Vasiliou - Before posting, please check:

Full text search

I'm working on a full text search that will search through subject lines. The search word is not necessarily a discreet word but could be a fragment like ... dog where dog could appear as hotdog, doggone, dognapper etc. My question is, is there a way of wildcarding the search request to look

Why no console window?

I am new to mysql, but am learning fast. I have recently downloaded several front-ends to Mysql. I used some, deleted others. In the process of this, I lost the ability to use the default Mysql console window for inputting data. The front ends are fine, but I would like to still learn the syntax n

wrong Polish translation in mysql 3.23.52 (and previous)

>Description: Wrong translation of YES/NO for Polish language. They are swapped. Same bug in mysql 4.0.10. >How-To-Repeat: Look into sql/share/polish/errmsg.txt >Fix: Here is patch that fixes problem: diff -urN mysql-3.23.55.org/sql/share/polish/errmsg.txt mysql-3.

Re: Full text search

Hi Try this. select * from table where upper(text) like upper('%dog%') Then all words with 'dog' in it, will appears in your query. Hope this helps /Frank > > I'm working on a full text search that will search through subject > lines. The search word is not necessarily a discreet word bu

bug with MERGE tables and MAX

>Description: MAX fails to return the correct value in some MERGE table situations. Based on experimentation I am guessing that the query fails to read all of the member tables when the query can be performed entirely by reading the index. I seem to be able to reproduce this every time on MySQL 3

Transaction problems using InnoDB, "not locked with LOCKTABLES"

Hello, We are experiencing severe problems when running MySql with INNODB in a production environment. Applications which work fine under light load fail when under production load. Our MySql environment is as follows: OS Platform: Windows 2000 Service Pack 2 Machine description: C

Re: Transaction problems using InnoDB, "not locked with LOCKTABLES"

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 [EMAIL PROTECTED] wrote: Hello, We are experiencing severe problems when running MySql with INNODB in a production environment. Applications which work fine under light load fail when under production load. Our MySql environment is as follows

[Announcement] for PHP and MySQL 4.1 Users/Testers

Hi, The new mysql extension (ext/mysqli) is now in the php-cvs-repository. Please note that you need MySQL Version 4.1 (both server and client library) and that this extension has experimental status. Configuration: --with-mysqli=/path-to-mysql-4.1 -without-mysql If you want to use both ext/

  1   2   >