Newbie question

Hi, I've just started with MySQL. I want my table to have a column containing an ID which is an integer that gets incremented on each insert, just like Autonumber in Microsoft Access. How do I do this in MySQL ? Thanks Dave -

time calculate

hi, I'd like to calculate hour usage between 2 time value. Which data type I should to use in mysql? and how to write sql to calculate hour usage especially when the second time is in the next day?? Thanks SF - Befor

Re: RH7.1 install question

to find out where your files ended up: cd / find . -name mysql mine weren't where I expected, but even so MySQL runs just fine where they are ;) At 04:38 17/10/01 -0700, you wrote: >The MySQL manual refers to files in /usr/local/. >/usr/local/ in RH7.1 is empty. >Could this be the reason why I'm

Re: Newbie question

Hi Use Create Table Test ( ID INT NOT NULL AUTO_INCREAMENT, .. ); At 08:48 18/10/2001 +0100, Dave Prout wrote: >Hi, > > I've just started with MySQL. I want my table to have a column > containing >an ID which is an integer that gets incremented on each insert, just l

AW: Newbie question

Hi John, looks like an error: AUTO_INCREMENT s the right spelling. Gerald *G* -Ursprungliche Nachricht- Von: John Dean [mailto:[EMAIL PROTECTED]] Gesendet: Donnerstag, 18. Oktober 2001 10:38 An: [EMAIL PROTECTED]; [EMAIL PROTECTED] Betreff: Re: Newbie question Hi Use Create Table Tes

MyODBC:Update with SQLSetPos doesnt work with some "kind of" primary keys?

MySQL Version: 3.23.42-max-nt MyODBC Version:2.50.39 OS Version= Windows 2000 Server If I change the order of fields in a multi-column primary key table, I cant update the table with SQLSetPos. ie: If I declare my table :(Primary key fields's order is the same as in table) create table A( name

MyODBC:Update with SQLSetPos doesnt work with some "kind of" primary keys?

MySQL Version: 3.23.42-max-nt MyODBC Version:2.50.39 OS Version= Windows 2000 Server If I change the order of fields in a multi-column primary key table, I cant update the table with SQLSetPos. ie: If I declare my table :(Primary key fields's order is the same as in table) create table A( name

newbie - questions about timestamp(14)

Hi all I'm having a problem getting a query to work where I want to compare the current_timestamp to the logged timestamp, and return false if less than 300 seconds, can you tell me if it is possible to have the current timestamp returned as part of a query, so as I can then do my calculations in

Frequently corrupt tables

Hello all; I'm running several MySQL installation (all version 3.23.37 under Linux) under what I presume are some fairly harsh conditions, and wondered what circumstances cause tables to be corrupted and need fixing with myisamchk. This is happening once every few days and it's becoming a pain.

Re: AW: Newbie question

Hi I never could spell :o) At 10:54 18/10/2001 +0200, Gerald-Markus Zabos wrote: >Hi John, > >looks like an error: AUTO_INCREMENT s the right spelling. > >Gerald > >*G* > >-Ursprungliche Nachricht- >Von: John Dean [mailto:[EMAIL PROTECTED]] >Gesendet: Donnerstag, 18. Oktober 2001 10:38 >A

ANNOUNCING: Rekall, DataArchitect and Quanta Plus GOLD

Hi TheKompany is pleased to announce the release of Rekall RC1. Rekall is a=20 cross platform programmable, Database Management System (DBMS), which=20 supports multiple database systems, including MySQL. With Rekall you will=20 be able to quickly and easily build database applications using Rekal

Installation Problem

Dear Sir, I have a problem with mysql-3.23.43 installation during the configuration step on Solaris 2.7 with Netscape Enterprise Server. The last three lines are shown as below : checking for a BSD compatible install... ./install-sh -c checking for bison... bison -y checking for pdftex

UPDATE IGNORE

I am running MySQL 3.22.30 and UPDATE IGNORE is failing. Was this function introduced in some later version? Error is "You have an error next to 'IGNORE mytable .'. As soon as I remove ignore it works OK. What is a work around? Ajdin -

Problem using mysql++

Okay i manage to build mysql++ after building gcc 2.95.3.Now i have problem in making c++ programs to run with mysql++. I try to compile the following code #include #include #include int main() { connection conn("mysql"); Query query = conn.query(); query<<"select * from test"; Re

Re: how to get the correct result -- Thrid Time --

You didn't appear to answer last time (grump) - reply repeated below. =dn - Original Message - From: "Adrian D'Costa" <[EMAIL PROTECTED]> To: "Mysql Mailing List" <[EMAIL PROTECTED]> Sent: 18 October 2001 05:34 Subject: how to get the correct result -- Thrid Time -- > Hi, > > I have s

What sites?

Im currently in a debate with someone who prefers PostgreSQL. He says that MySQL is unstable etc. Can you please give me examples of some well known sites built on MySQL so I can tell him that MySQL rocks? Sorry if this is off-topic. But atleast im patriotic :) /Philip ---

RE: What sites?

Eurobell.net Eurobell.com Eurobell.co.uk We have been runing MySQL over 3 year 24/7/362 and it has never gone down. Simon -Original Message- From: Philip Johannessen [mailto:[EMAIL PROTECTED]] Sent: 18 October 2001 12:06 To: [EMAIL PROTECTED] Subject: What sites? Im currently in a d

Re: What sites?

On Thu, 18 Oct 2001, Philip Johannessen wrote: > Im currently in a debate with someone who prefers PostgreSQL. He says that > MySQL is unstable etc. Can you please give me examples of some well known > sites built on MySQL so I can tell him that MySQL rocks? Have a look at http://www.20min.ch/. (

SV: newbie - questions about timestamp(14)

You can use NOW() to get the current timestamp: mysql> select NOW(); +-+ | NOW() | +-+ | 2001-10-18 12:49:29 | +-+ But it would be easier to let MySQL calculate the elapsed time: select IF(TIME_TO_SEC(NOW()) - TIME_TO_SE

Re: What sites?

You may see list of this sites at MySQL manual: http://www.mysql.com/doc/U/s/Users.html On Thu 18 Oct 2001 14:05, Philip Johannessen wrote: > Im currently in a debate with someone who prefers PostgreSQL. He says that > MySQL is unstable etc. Can you please give me examples of some well known > s

Re: MySQL 4.0 questions

Pete Harlan writes: > On Wed, Oct 17, 2001 at 02:51:50PM +0300, Sinisa Milivojevic wrote: > > SQL_CALC_FOUND_ROWS has sense (and will have any effect) only when > > used with LIMIT clause. > > So could it be a syntax error to use it otherwise? Or could the name > be SQL_CALC_FOUND_ROWS_FOR_LIMIT

problem with big selects

Hi, i have a problem when executing big selects. i am using mysql in a client - server environment. the server database is a mysql database, whereas the clients are MS Access databases, contining forms, queries, reports and a lot of VBA code. The tables of the mysql database

Re: MySQL 4.0 - Order By & Limit

I just saw the mistake I made in my original post.. I want to Order By letter, but when I do that with the Limit clause the results are as shown in the original post.. Anyone know what the problem could be? Steve Meyers wrote: >That is actually how it is supposed to work -- MySQL gets all the

Re: sql-bench failures with BDB

Neal Probert writes: > Both the alter-table and insert tests in the sql-bench suite fail if the > default-table-type=BDB is set in /etc/my.cnf. This is with version 3.23.43. > > Anybody got any ideas about this? > > > -- > Neal Probert [EMAIL PROTECTED] > !Uniphied Thoughts, LLC. > > What

The opposite of where column_name LIKE "%string%"

*This message was transferred with a trial version of CommuniGate(tm) Pro* Hi, I need to select from a table all the records that do not contain a certain string. Any idea how I can do this? For example if I want to select all the fields that contain the string "my_string" I type: $ select * f

newbie can't connect error

I had mysql running fine on linux (redhat 7.1 ). Today I get this error: "can't connect to local Mysql server through socket '/tmp/mysql.sock.' Thanks for any advice. - Before posting, please check: http://www.mysql.com/man

Re: What sites?

Hi Philip! On Thu, 18 Oct 2001, Philip Johannessen wrote: > Im currently in a debate with someone who prefers PostgreSQL. He says that > MySQL is unstable etc. Can you please give me examples of some well known > sites built on MySQL so I can tell him that MySQL rocks? At http://www.mysql.com s

Backups and flush logs

Hi I've been trying to answer this question for a while with no success :) I know someone here has the answer! As part of my backup, I have the following line in the my.cnf # Activate Update Log log-bin=update-bin.log I then run a script by logrotated every night, the config file is: # This l

Re: The opposite of where column_name LIKE "%string%"

CA> $ select * from table_name where column_name like "%my_string%". select * from table_name where column_name NOT like "%my_string%". ;))) - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re: The opposite of where column_name LIKE "%string%"

"Ciprian A." wrote: > Hi, > > I need to select from a table all the records that do not contain a certain > string. Any idea how I can do this? > > For example if I want to select all the fields that contain the string > "my_string" I type: > $ select * from table_name where column_name like "%

Re: UPDATE IGNORE

AJDIN BRANDIC writes: > I am running MySQL 3.22.30 and UPDATE IGNORE is failing. Was this > function introduced in some later version? Probably. You really should consider upgrading. 3.23 has been out for ages now. > What is a work around? I fail to see a situation where you would actually

Re: newbie - questions about timestamp(14)

Thanks for your reply, I have tried using the query as you suggest, see below: SELECT user_ip IF(TIME_TO_SEC(NOW()) - TIME_TO_SEC(log_time) < 300, 'true', 'false') FROM clinic_log But this just gives me an error, ie the query won't run? Does the query seem to be right? Thanks again Paul -

charset latin1_de: several problems and questions

Hi I have installed mysql 4.0 from source, configured with ./configure \ --with-charset=latin1_de -- Matthias Ragaz Informatik - Entwicklung Schweizerische Bibliothek für Blinde und Sehbehinderte Albisriederstasse 399 CH-8047 Zürich S

Binary dist of 3.23.43 ok, 4.0.0 alpha fails to start

Dear All I've reverted back to 3.23.43 from 4.0.0 as I was unable to get it to start on my (patched) Redhat 6.2 box. Has anyone else managed to get the binary distro of 4.0.0-alpha to start on a Redhat 6.2 box ? Thanks Greg sql ---

Large Memo Type Field

Hello, I am working on a school project and I want to use mysql db, as a back end. Anyway, I want to make a column really large. Paragraph size. I know I can use varchar and make it large, but is that the best way to go, and if so what is the max size you can use for a varchar? The user will put

Re: What sites?

You may also want to point him to this article on PHPBuilder.com http://phpbuilder.com/columns/tim2705.php3 I've just read it and it seems appropriate. No it isn't a PHP centered article. It does a pretty good comparison (in my mind) of the plusses and minuses of both MySQL and PostgreSQL

character set latin1_de : several questions

Hi I have installed mysql 4.0 from source with ./configure \ --with-charset=latin1_de --with-extra-charsets=all Question 1: Is it true that the above does not make latin1_de my default character set for sorting? When I tried to set the default character set to latin1_de in /etc/m

Fw: Converting to SQL 7?

I have a mySQL database that I am trying to bring into SQL7. I have tried using the enterprise manager of SQL 7 to import the data, however the table that I am trying to import has many blob fields, which do not come over with the import. SQL Enterprise manager either tells me that the field is t

Re: Large Memo Type Field

Make it a text column, this has an allowable length of 0-65535 .. HTH Paul - Original Message - From: "Purcell, Scott" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, October 18, 2001 2:12 PM Subject: Large Memo Type Field : Hello, : I am working on a school project and

Re: group by clause

You might want to add an ORDER BY clause. Sommai Fongnamthip wrote: > Hi, > did someone tell me why group by clause not work? I'd like to group > volume of order from my customer at the same price and my supplier. > here is my code > > Select custid, symbol, sum(volume) as sumvol,

Re: newbie - questions about timestamp(14)

Thanks, the query is now working, butit is not producing the required results. I have now tried many different methods, it does not seem to me to be possible to compare these times!! Thanks anyway Paul - Original Message - From: "Torgil Zechel" <[EMAIL PROTECTED]> To: "'p.whiter'" <[

RE: Compiling 3.23.40 on Digital Unix 4.0e

Quentin Bennett writes: > Hi, > > I can't see anything specific to make problems, but I notice that all the > examples use gnumake, not Compaq's make - is that what you were referring > to? > > Regards > > Quentin > Yes. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /

Re: Newbie question

LAST_INSERT_ID() At 08:48 AM 10/18/2001 +0100, you wrote: >Hi, > > I've just started with MySQL. I want my table to have a column > containing >an ID which is an integer that gets incremented on each insert, just like >Autonumber in Microsoft Access. How do I do this in MySQL ? > >Thanks

Re: BLUE WORLD RELEASES BETA VERSION OF LASSO PROFESSIONAL 5STANDARD EDITION

At 11:06 PM -0500 10/17/01, David Dahl wrote: >WOW, now you can BUY MySQL from blueworld and run it on MacOS X and >Windows 2000 only, or you can download the source code from MySQL and >run it anywhere for free... hmmm... sounds great:) > >>Bill Adams writes: >> >>> Seriously, is there a bette

Re: newbie can't connect error

Hello Daniel! > I had mysql running fine on linux (redhat 7.1 ). > > Today I get this error: "can't connect to local Mysql server through socket > '/tmp/mysql.sock.' Shooting[trouble] tips: Does 'cat /etc/my.cnf |grep socket' confirm the path to the sock for both server and client? Should be ye

Two bugs with complex aggregate functions.

>Description: parsing/executing aggregates involving IF() statements. Everything needed to reproduce the bug available from http://www.ebi.ac.uk/~lijnzaad/mysql/bugreport.tar.gz It's tested and reproduced on MySQL, version 3.23.32 on TrueUnix (two bugs) or version 3.22.32 on Lin

general sql question

Hi all- I know this might seem simple, but for some reason I'm stumped. What I'm trying to do is get a count (from one table) of all the distinct values in a particular field. So for example, I'd be trying to find out how many unique email addresses are in the table. Right now I'm doing this w

Set up a test database/data source in JDBC and MySQL?

Hi, I have just stated with JDBC and MySQL. I just don't know how to start playing with them. How to set up a test database? How to get a datasource? What's the URL of a datasource? There are a whole lot of help on how to connect, but just very few about how to load the driver and create a tes

RE: time calculate

hi. store the information in a datetime column for easy handling. check out the function DATE_ADD() or DATE_SUB() on this page: http://www.mysql.com/doc/D/a/Date_and_time_functions.html it has examples of usage that could be helpful. i would do something like this: select TO_DAYS(secondDate) -

/usr/local/mysql/var/ bin files

Hi All, A quick query, in the directory /usr/local/mysql/var there are machinename-bin.001, 002, 003 etc files that are being created. What are these files and what do they do. Can I get rid of them as they are taking up massive amounts of space. Any help greatly appreciated. thanks Leon. --

Re:Possible bug in ORDER BY timestamp

Thanks for the help everyone. I tried changing the type to Œtimestamp¹ and that did not fix the problem, however when I changed the type to Œint¹ and it worked as it was suppose to. Thanks, Lael

Re: /usr/local/mysql/var/ bin files

Hello Leon, Thursday, October 18, 2001, 5:09:13 PM, you wrote: LN> A quick query, in the directory /usr/local/mysql/var there are LN> machinename-bin.001, 002, 003 etc files that are being created. What are LN> these files and what do they do. Can I get rid of them as they are taking up LN> mass

RE: general sql question

Try tuning mysql for faster queries. You could try indexing you domain name, If you have data fields which have a common value you can index the rest of the rows by the one common value. Takes up a bit more space but is faster. more info @ http://www.mysql.com/documentation/mysql/bychapter/manua

RE: /usr/local/mysql/var/ bin files

I found a MySQL system variable max_binlog_cache_size| 4294967295 would caching have anything to do with it rather than replication? thanks Leon. -Original Message- From: SAE's System Administrator [mailto:[EMAIL PROTECTED]] Sent: 18 October 2001 15:22 To: Leon Noble Cc: [EMAI

Re: Problem using mysql++

Hi! Your commands are wrong. Please have a look how is Makefile in examples written and when executed, how are examples built. Use the same method for your code. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /

RE: general sql question

Thanks Matthias, Jay... I gave that a shot and got an error: mysql> select count(distinct email) from subscribes; ERROR 1064: You have an error in your SQL syntax near 'distinct email) from subscribes' at line 1 I have a feeling this has something to do with running 3.22 instead of 3.23. ;) Wha

Re: general sql question

> > select count(distinct(email)) from subscribes; select count(distinct email) from subscribes; should work just fine Magic word: sql -- _/_/ _/_/_/ - Rafał Jank [EMAIL PROTECTED] - _/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl _/_/_/_/ _/_

Re: why

Adrian D'Costa writes: > > If you 'office system' is, for example, Sun Solaris, you will see only > > 1 mysqld process with 'top'. The fact that in Linux 'top' shows > > actually more than 1 process can be regarded as a bug in the way 'top' > > shows things on Linux for threaded applications (

RE: general sql question

> > select count(distinct(email)) from subscribes; > > > > But that's not legal. Any thoughts/ideas you all could send in would be > > great. TIA! > > > > Chris Blessing > > [EMAIL PROTECTED] > > http://www.330i.net > > Try: select count(distinct email) from subscribes; Jay Fesco Magical M

Problem using Specialized SQL Structures (MySql++)

Hello, I'm reading and doing some testing with Specialized SQL Structures. I've included both mysql++ and custom-macros.hh . I'm using MSVC as compiler. The problem I'm facing is that I can't get it compiled. I get undeclared identifiers syntax error : identifier 'sql_dummy_type' 'sql_dummy' :

RE: general sql question

> > I have a feeling this has something to do with running 3.22 > instead of 3.23. > ;) > > Whadya think? > Oops... Yup, according to page 57 of Mr. Dubois' MySQL COUNT() combined with DISTINCT is a 3.23.2+ feature... I'll be interested to see the proper answer to this... (besides 'upgrade' - I

RE: general sql question

Thankfully we're upgrading in the very near future (this weekend) so I can take advantage of this and other changes (like temp table memory issues!). Thanks again for everyone's help! -Chris -Original Message- From: Jay Fesco [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 18, 2001 1

Replication of ALTER TABLE commands

Hi, I habe a problem with replication on mysql 3.23.31: If I issue an ALTER TABLE command at the master, it is not send to the slaves when the table name is qualified with the database name. eg. this doesn't replicate: ALTER TABLE `database`.`ReplicationTest` ADD `einezahl` INT DEFAULT '0'

RE: [ANNOUNCE] BLUE WORLD RELEASES BETA VERSION OF LASSO PROFESSIONAL 5STANDARD EDITION

Good reply, Cathy. I'm not sure why there is such an outspoken negative reaction to a commercial software company announcing a related product on a mysql list...Not only can Mysql AB be considered a commercial software company, but so could myself and many others on this list. For the record, I (

Re: RH7.1 install question

cedric <[EMAIL PROTECTED]> writes: > The MySQL manual refers to files in /usr/local/. > /usr/local/ in RH7.1 is empty. > Could this be the reason why I'm having so much trouble installing MySQL? > If so, how can I get rpm to install MySQL in /usr/local/? Files managed by rpm shouldn't be in /usr

Import Data

I want to import data from text file that contains decimal number (occasionaly with 9 decimal) but mysql import only 2 decimal. My columns is set to DECIMAL(6,9) Hi, Moreno - Before posting, please check: http://www.mysql.com

Mysql 3.23.43 not working on SCO Open Server 5

When running MySQL when only got as far as trying to set up users and passwords for MySQL using 'mysqladmin' before mysqld restarted. This also happens when connecting to Mysql with clients we have written and also the 'mysql' program and other MySQL utilities suggesting the problem is not with ou

Possible bug in self-join order optimization

I am sending this again as I am desperate for some help and believe this to be a signifigant bug if it actually is one...which it seems to be. See below for examples. What is quite puzzling is MySQL's estimation of the number of rows from each of the self-joins. The conditions on alias queryTab

RE: A COMPANY RELEASES A NON-FINAL VERSION OF SOME PRODUCT NON-PREMIUM EDITION

The harm doesn't come from you offering something beneficial to the MySQL community. It comes when you abuse the privileges of being on this list and send spam. While there may not be anything in stone that says not to send commercial software advertisements, you should know better. The only thing

Problem listing enum vars

Hey there, first off all, please CC me any replies, as I'm no longer a member of the list... Sorry about that but I just receive too much... Over 2000 emails a day is no exception and I can no longer keep track of them. Ok, for the problem, I want to list the possible values of a enum variable

Re: Two bugs with complex aggregate functions.

HI! Please try our latest 3.23 version and see if problems still persists. There have been a few bug fixes since 3.23.32 regarding IF(). -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, F

Re: Import Data

Riccardi Moreno wrote: > I want to import data from text file that contains decimal number > (occasionaly with 9 decimal) but mysql import only 2 decimal. > My columns is set to DECIMAL(6,9) Someone correct me if I am wrong: The '9' is how many decimal places after the period you want and eats u

RE: Frequently corrupt tables

Well, for one, I believe that Slashdot uses InnoDB tables, which tend to handle a little better under very high load. Steve Meyers > -Original Message- > From: Matthew Bloch [mailto:[EMAIL PROTECTED]] > Sent: Thursday, October 18, 2001 3:34 AM > To: [EMAIL PROTECTED] > Cc: Peter Tapho

RE: how to get the correct result -- Thrid Time --

Trim won't work because the newline is in the middle of the string. Try using the REPLACE function, ie UPDATE hotel SET nome_hotel=replace(nome_hotel, '\n', '') For the second question, it actually doesn't matter if it's CAPS or not. The group by will be done in a case insensitive manner. H

[OT] FAQ and Commercial Announcements

Ravi Raman wrote: > I'm not sure why there is such an outspoken negative reaction to a > commercial software company announcing a related product on a mysql > list... As another poster pointed out, this is a HELP list. If someone posted to the list looking for a product where Lasso meets that n

RE: Import Data

Hi Riccardi, > > I want to import data from text file that contains decimal number > (occasionaly with 9 decimal) but mysql import only 2 decimal. > My columns is set to DECIMAL(6,9) > Hi, Moreno > try DECIMAL(15,9) because I think the first argument specifies the total number of digits.

RE: redaht 7.1 / AMD K6-2: 4.0 rpm error (illegal instruction)

I have the same problem with RedHat 7.1 (fully updated) and a Pentium. Any answer/solution? -Mensaje original- De: Jean-Luc Fontaine [mailto:[EMAIL PROTECTED]] Enviado el: miercoles, 17 de octubre de 2001 9:33 Para: [EMAIL PROTECTED] Asunto: redaht 7.1 / AMD K6-2: 4.0 rpm error (illegal i

RE: MySQL 4.0 - Order By & Limit

It would help if you posted the actual query and results you are getting, instead of showing "simulated" results. You mention the query below in your first post, but you never give the actual results of it. Steve Meyers > -Original Message- > From: Ashwin Kutty [mailto:[EMAIL PROTEC

MySQL vs. PostgreSQL [was Re: What sites?]

Philip Johannessen wrote: > Im currently in a debate with someone who prefers PostgreSQL. He says that > MySQL is unstable etc. Can you please give me examples of some well known > sites built on MySQL so I can tell him that MySQL rocks? PostgreSQL: Unless something has changed in the more recen

Re: Frequently corrupt tables

Matthew Bloch wrote: > I'm running several MySQL installation (all version 3.23.37 under Linux) > under what I presume are some fairly harsh conditions, and wondered what > circumstances cause tables to be corrupted and need fixing with myisamchk. > This is happening once every few days and it'

Re: Problem using Specialized SQL Structures (MySql++)

Elm Gysel writes: > Hello, > > I'm reading and doing some testing with Specialized SQL Structures. > > I've included both mysql++ and custom-macros.hh . I'm using MSVC as > compiler. > > The problem I'm facing is that I can't get it compiled. I get undeclared > identifiers > > syntax error : i

RE: Frequently corrupt tables

Hi! >Well, for one, I believe that Slashdot uses InnoDB tables, which tend to handle >a little better under very high load. >Steve Meyers > -Original Message- >> From: Matthew Bloch [mailto:[EMAIL PROTECTED]] >> Sent: Thursday, October 18, 2001 3:34 AM> To: [EMAIL PROTECTED] >> Cc: Peter

RE: Problem listing enum vars

Since it's a LIKE, you need to put the table name in quotes: SHOW COLUMNS FROM test LIKE 'Var' This also allows you to use things like 'Var%' in you query. Steve Meyers > -Original Message- > From: TD - Sales International Holland B.V. [mailto:[EMAIL PROTECTED]] > Sent: Thursday, Oct

Re: MySQL Data Recovery Information Requested

Good morning: My vendor (Campus Pipeline) directed me to your website to obtain some documentation, but they did not specify the title of the documentation to retrieve. I am to locate information on performing data recovery with update logs and repair scripts. Can you please direct me to the UR

Re: Large Memo Type Field

You never considered reading the manual, eh? Look up types in the manual - check out TEXT type -Jason Garber IonZoft.com At 08:12 AM 10/18/2001 -0500, Purcell, Scott wrote: >Hello, >I am working on a school project and I want to use mysql db, as a back end. >Anyway, I want to make a column rea

ENUMs as user defined types?

Hi all, Is it possible to define an enumeration as a new MySQL data type and then define columns using the user defined type? I've heard that you can produce aliases for types but I can't find anything in the manual about doing this for ENUMs. Thanks for your help, Chris --

Very Slow Performance to Build Index in Large mySQL Table

Hi, I am experiencing a very slow performance while I am building an index on a table. The following are some facts of system and the table I am dealing with: Table size: 13,857,354 Number of distinct value in the column I use as index: 176,322 Platform: Linux system with dual CPUs 1G Hz and 4G

Re: [OT] Commercial Announcements

Replying to myself just HAS to be in bad taste. But I guess I burt out my taste buds a while ago. ;) Bill Adams wrote: > Ravi Raman wrote: > > > I'm not sure why there is such an outspoken negative reaction to a > > commercial software company announcing a related product on a mysql > > list..

Windows 2000

I am a new mysql user. I have been unable to start mysql on my laptop running Windows 2000. Each time I start mysql, I get the following error: ERROR 2003: Can't connect to MySQL server on 'localhost' (10061). I have searched through the archive for earlier mails on this problem. This looks like

Re: MySQL Data Recovery Information Requested

In the last episode (Oct 18), Terry Westry said: > Good morning: > > My vendor (Campus Pipeline) directed me to your website to obtain some > documentation, but they did not specify the title of the documentation > to retrieve. I am to locate information on performing data recovery > with update

RE: MySQL 4.0 - Order By & Limit

Point well taken.. The query is as follows:- SELECT * FROM dddeli WHERE title LIKE "%$keyword%" ORDER BY title desc LIMIT $start,$end; Where $keyword is the keyword to search by from the field title, $start and $end are to dictate which page of the results, etc.. title is varchar(128) and dd

RE: A COMPANY RELEASES A NON-FINAL VERSION OF SOME PRODUCT NON-PREMIUM EDITION

Hi, This is complete crap. One of the tools I use is because of an email I saw on this list that might have been called spam. I say that this type of email is on topic. Maybe they could have eased up on the BS tone of the email, but I would still want to know about a new product. The only other

Re: Two bugs with complex aggregate functions.

> Please try our latest 3.23 version and see if problems still persists. Yes, it also occurs for mysqld Ver 3.23.43 for pc-linux-gnu on i686. Please try and reproduce it using http://www.ebi.ac.uk/~lijnzaad/mysql/bugreport.tar.gz.

Re: [OT] FAQ and Commercial Announcements

Hello All! > would be cool. Or another moderated list that contains announcements for all > things MySQL related. I would sign up for that 'though I think a web-site > would be better. http://www.mysql.com/documentation/lists.html : [EMAIL PROTECTED] announce This is for announcement of new v

RE: A COMPANY RELEASES A NON-FINAL VERSION OF SOME PRODUCT NON-PREMIUM EDITION

I agree. The attitude I have towards MySQL-related announcement messages on this list is roughly the same as the attitude I have towards all the other messages...read them if they look interesting, ignore them if they don't. I really doubt most people read _every_ message on this list, and if the

RE: A COMPANY RELEASES A NON-FINAL VERSION OF SOME PRODUCT NON-PREMIUM EDITION

Eric, That's nice and all that you can have an extra tool to use because of spam - I mean, they ARE real products. Most people consider TV infomercials to be useless, but some people find use out of them. The problem is that it's annoying to see these types of advertisements. The reason you don't

Re: [OT] Commercial Announcements

At 10:21 AM -0700 10/18/01, Bill Adams wrote: >Now that I have had some coffee I am thinking that the subjects like >"URGENT! HELP NEEDED" are just the worse ever. Cathy, Please just fix the >capitalization from your marketing dept. the next time and I for one will not >complain. And rest assure

RE: MyODBC:Update with SQLSetPos doesnt work with some "kind of"primary keys?

Hi !!! > -Original Message- > From: Cenk Akyüz [mailto:[EMAIL PROTECTED]] > Sent: Thursday, October 18, 2001 1:55 AM > To: [EMAIL PROTECTED] > Subject: MyODBC:Update with SQLSetPos doesnt work with some "kind of" > primary keys? > > > MySQL Version: 3.23.42-max-nt > MyODBC Version:2.50.39

Re: [OT] FAQ

"Carsten H. Pedersen" wrote: > > > > What about FAQ-o-Matic? > > http://faqomatic.sourceforge.net/ > > We would just need it hosted somewhere. > > Not to put a too fine point on it, but how 'bout > referring them to: http://www.bitbybit.dk/mysqlfaq? > > I thought this address was well published b

RE: [OT] FAQ

>I do keep forgetting about it. And it seems that MySQL has a 'Dynamic FAQ' >linked from their site. Perhaps we could get them to add a link to the >bitbybit version too? (MySQL Folks?) Ideally linked from this page: http://www.mysql.com/documentation/index.html -

  1   2   >