FAQ

Search Discussions

691 discussions - 2,158 posts

  • Please how can I remove a RPM installation. I used MySQL-server-4.1.1-1.i386.rpm to install MySQL, but how can I delete it.
    Rafael Diaz ValdesRafael Diaz Valdes
    Mar 2, 2004 at 2:08 pm
    Mar 2, 2004 at 3:36 pm
  • What advantages, besides ease of setup, does MySQL hold over PostgreSQL? It would seem, to me, that the two are close competitors (both in quality, and performance). Thanks.
    Mark WarnerMark Warner
    Mar 3, 2004 at 2:13 pm
    Mar 13, 2004 at 12:29 pm
  • g'day, i'm looking for a way to do two BETWEEN ranges. Currently I have sys.sectorID BETWEEN 1 AND 20 but I want it so that I can search between 1 and 20 and also between 30 and 42 but all my efforts ...
    KeithKeith
    Mar 13, 2004 at 4:13 pm
    Apr 21, 2004 at 1:33 pm
  • I finally managed to install MySQL succesfully. I created a simple DB with two different tables. I also created a simple PHP script to list all DBs and tables. However, it seems that the PHP script ...
    Sami MaisniemiSami Maisniemi
    Mar 22, 2004 at 6:24 pm
    Mar 24, 2004 at 1:07 am
  • Hi there, I have some weird sql statements that seem to eat up all resources from mysqld. Once I have two of them running at the same time no one can log on any more. Simple queries involving ...
    Bernd JaglaBernd Jagla
    Mar 2, 2004 at 3:06 pm
    Mar 2, 2004 at 9:27 pm
  • Hi List, My tablespace is getting filled up so quick when no. of transactions increase without number of rows increasing considerably. I have a test client which adds and deletes row dynamically ...
    Sp.RajaSp.Raja
    Mar 3, 2004 at 7:42 am
    Jul 27, 2004 at 4:15 pm
  • Table ProductSums has not been created. Can you create this table when you insert data into it? INSERT INTO ProductSums SELECT DISTINCTROW IndenturedList.NSIPartNumber, Sum(tblInvTransaction.Qty) AS ...
    Jacque ScottJacque Scott
    Mar 4, 2004 at 6:53 pm
    Apr 1, 2004 at 11:24 am
  • Hi, I'm trying to compile mysql 4.0.18 with icc 8.0 on RH AS 3u1. I'm including my last configuration for compiling and how it died- I've tried about a million other ways- this seems to come the ...
    Yonah RussYonah Russ
    Mar 24, 2004 at 1:51 pm
    Mar 26, 2004 at 12:06 pm
  • SQL puzzle from the Informix mailing list: Two mathematicians (Boris and Vladimir) met accidently for the first time in 20 years. They greet each other and begin catching up on their respective ...
    Tom RoosTom Roos
    Mar 8, 2004 at 8:34 am
    Mar 19, 2004 at 10:54 pm
  • Hi there. How could I deny users or applications issuing INSERT or UPDATEs queries on my SLAVE server? This is intended to ensure that slave will not have data which MASTER don't know. Thanks... []s, ...
    CvardaCvarda
    Mar 16, 2004 at 8:02 pm
    Mar 19, 2004 at 5:36 pm
  • I have used access in the past and now I have started using MySQL. I have customer table, customer order table, customer order detail table. How would I make sure that when a particular customer ...
    Mulugeta MaruMulugeta Maru
    Mar 10, 2004 at 1:35 am
    Mar 13, 2004 at 1:17 am
  • Hi, I would like to save a binary file into a mysql database, for later being able to use the file. I am using a perl interafce. Is this at all possible??? And would it be possible to then read that ...
    Isa WoltIsa Wolt
    Mar 9, 2004 at 9:49 am
    Mar 12, 2004 at 7:50 pm
  • Hi there, I have a hard question, don't know if its possible to solve my query. I have set up two tables like this Table1: softid (integer) (unique) nameofcd (string) softid | nameofcd 1 test cd 1 2 ...
    Timon BerkowitzTimon Berkowitz
    Mar 29, 2004 at 10:56 pm
    Mar 31, 2004 at 6:35 pm
  • Hi all, I am using MySQL 4.0.x to run a community website which has (among other things) over 19,000 pictures. There is a page that selects 30 random thumbnails. I have noticed that the performance ...
    Neil GuntonNeil Gunton
    Mar 8, 2004 at 6:37 pm
    Mar 11, 2004 at 10:34 am
  • Hi all, I have a table of users which contains a lot of information, and also a column called membershiptype which can either be 0, 1, or 2. This table is used a lot in various searches, and all ...
    Henrik SchröderHenrik Schröder
    Mar 24, 2004 at 2:48 pm
    Mar 25, 2004 at 6:55 pm
  • My master server was hard booted and now my slave can't execute the replicated binary sql logs. mysql show slave status\G *************************** 1. row *************************** Master_Host: ...
    Daniel GibbyDaniel Gibby
    Mar 15, 2004 at 7:39 pm
    May 11, 2004 at 7:36 pm
  • Some users' code is causing MySQL's memory use to explode. By the time we reach about 200 simultaneous connections, the MySQL server is using 8GB of virtual memory, and then falls over (the machine ...
    Tim CuttsTim Cutts
    Mar 22, 2004 at 6:24 pm
    Mar 26, 2004 at 4:47 pm
  • Recently I tried to convert our largest table from MyISAM to InnoDB. During the process I believe there was a problem where something was corrupt along the way. It was stupid, but I did not verify ...
    CliffCliff
    Mar 4, 2004 at 2:07 am
    Mar 7, 2004 at 6:07 am
  • Hello, I am having a hard time getting Mysql to let root@localhost connect. I am constantly getting this: ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) when I issue mysql ...
    Leslie VanceLeslie Vance
    Mar 12, 2004 at 1:26 pm
    Apr 3, 2004 at 7:11 am
  • . Hi, After 4 hours I am finally seeing a bit of results...am a newbie in MySql and have just been able to setup PHPMyAdmin, after loggin in I see the database MySql and 6 tables: columns_priv db ...
    RyanRyan
    Mar 13, 2004 at 2:52 pm
    Mar 15, 2004 at 1:06 pm
  • Hi, I have a whole database I wanted to convert to InnoDB from MyISAM, but do not want to use alter table because of the problems I had last time. I made a whole dump of the table using mysqldump and ...
    CliffCliff
    Mar 7, 2004 at 6:14 am
    Mar 14, 2004 at 5:47 pm
  • I have a requirement for a system that is of the order of 8-10 times the size of my current system. Unfortunately (a) I don't know how many times larger it actually is, and (b) my current system, ...
    Alec CawleyAlec Cawley
    Mar 2, 2004 at 2:40 pm
    Mar 3, 2004 at 10:13 pm
  • It has come to my attention that we have maxed out our keys due to a stupid update script bug. It seemst that we've not been explicitly naming our keys and therefore mysql tried to be helpful and ...
    Daevid VincentDaevid Vincent
    Mar 29, 2004 at 8:50 pm
    Mar 30, 2004 at 11:04 pm
  • Having just set up a RedHat Enterprise Server V.3 I am trying to add a MySQL database function. I tried and failed using up2date (following instructions from RH), so downloaded the rpms and began to ...
    Robert RossRobert Ross
    Mar 11, 2004 at 12:40 pm
    Mar 11, 2004 at 7:52 pm
  • In order to get the max performance from our servers we're reading every bit we can lay our hands on about performance tuning. In this document: ...
    Jigal van HemertJigal van Hemert
    Mar 9, 2004 at 10:38 am
    Mar 10, 2004 at 1:47 am
  • Hello, I'm trying to determine the best way to optimize the query below. Right now it is taking around 9mins and we need it to take no more than 30 seconds (we can get it under 30s on MS SQL): ...
    Chris FossenierChris Fossenier
    Mar 9, 2004 at 4:40 pm
    Mar 10, 2004 at 12:56 am
  • Using v4.0.15 on WinNT under Apache. For my sins, the client has insisted on creating a page counter! The fields are to be CounterCode (Varchar 10), CounterValue (Int 10) and CounterStartDateTime ...
    Terry RileyTerry Riley
    Mar 9, 2004 at 5:12 pm
    Mar 9, 2004 at 7:06 pm
  • Hi, I am using MySQL 4.0.18 with InnoDB and I would to have some suggestions about how can I backup the data. I read in this list that some people are using mysqldump, others are using some tools ...
    Andre MATOSAndre MATOS
    Mar 4, 2004 at 2:56 am
    Mar 6, 2004 at 5:58 am
  • Hello, I am new to Linux, and mySQL. I am currently a MsSQL Server 2000 and VB programmer, but trying to break away from that side. I have my database set up and working great, but I am really ...
    HACKATHORN, TODD (SWBT)HACKATHORN, TODD (SWBT)
    Mar 4, 2004 at 1:57 pm
    Mar 4, 2004 at 3:50 pm
  • Hi I´'m new with mysql and have following question: I have a table, that has a primary key with two columns and want to add a third column to this primary key. Is this possible and when yes: Do I ...
    Ranetbauer, MichaelRanetbauer, Michael
    Mar 3, 2004 at 1:40 pm
    Mar 4, 2004 at 12:54 am
  • Hi, I've got very astonished to see with phpMyAdmin my MySQL database has received more than 3 Millions conexions for this last 14 days. But I don't knowwhich database is reponsable for this. Is ...
    Patrick GelinPatrick Gelin
    Mar 10, 2004 at 7:50 am
    May 5, 2004 at 6:45 pm
  • I have 2 tables (looks best in fixed width font): test_items +-------+----------+ +-------+----------+ test_attributes +---------------+------------+ +---------------+------------+ How can I query ...
    Chris BogetChris Boget
    Mar 31, 2004 at 9:07 pm
    Apr 4, 2004 at 6:53 am
  • I've downloaded and installed 5.0, it seems to be working fine. However, I need a graphical user interface to create tables and such (when I say I need, trust me, I need). I'm running on XP (that ...
    Mike GriffinMike Griffin
    Mar 30, 2004 at 4:26 pm
    Mar 31, 2004 at 1:16 am
  • Is there a simple php script out there somewhere (or an example of how to do it) to create a new database, username and password? I would like to have a form in a password protected folder on my web ...
    BGLeftyBGLefty
    Mar 17, 2004 at 5:39 pm
    Mar 23, 2004 at 11:02 am
  • (newbie warning) Hi, I just removed 3.23 and installed 4 (the first time I have done an installation.) as per the docs I then tried to make a password for "root" and ran this from SSH root: # ...
    RyanRyan
    Mar 17, 2004 at 6:04 pm
    Mar 17, 2004 at 9:32 pm
  • I didn't think this was too hard when I first created it, but now that I'm loading test data it's not working as expected. The core of the query is three tables: Event, Contact, and Regarding. There ...
    Brent BaisleyBrent Baisley
    Mar 15, 2004 at 9:32 pm
    Mar 16, 2004 at 4:17 pm
  • We recently started getting "Can't create thread" errors since switching to Debian. On Red Hat 8.0 we were able to spawn more than 400 mysql threads and never encountered this error. mysql 3.23.56 ...
    Michael BacarellaMichael Bacarella
    Mar 8, 2004 at 9:53 pm
    Mar 15, 2004 at 5:03 pm
  • I am using MySQL 5 issuing the following query when the application died on me three times.Query: Select name, year_of_birth from players where year_of_birth <= ALL(select year_of_birth from players) ...
    Mulugeta MaruMulugeta Maru
    Mar 5, 2004 at 2:25 am
    Mar 6, 2004 at 10:06 am
  • Are the TEXT column types padded out to their max length by spaces?
    Jim McAteeJim McAtee
    Mar 1, 2004 at 5:44 pm
    Mar 2, 2004 at 12:10 am
  • I have a table with the following: CREATE TABLE foo ( ... description text, ... FULLTEXT INDEX (description), ... ); select count(*) from foo where description like '%db2%'; returns 61 rows. Checking ...
    Shane AllenShane Allen
    Mar 31, 2004 at 4:43 am
    Mar 31, 2004 at 7:45 pm
  • I'm trying to set up two-way replication between our colo and our office (slow DSL line), so our web customers can get the fast speeds of our colo, and the people in the office can also get the fast ...
    Chris PetersenChris Petersen
    Mar 30, 2004 at 12:46 am
    Mar 30, 2004 at 9:39 pm
  • I have a table with just about 100 columns, and I would like to duplicate a row exactly, except for one column, which is the AUTO_INCREMENT column. Using 'INSERT INTO tbl_name SELECT * FROM tbl_name ...
    Eric J. JanusEric J. Janus
    Mar 29, 2004 at 6:38 pm
    Mar 29, 2004 at 8:40 pm
  • Greetings, I did: mysql grant all on LTM.* to ltm@localhost identified by 'secret'; But mysql select * from user where user='ltmuser'\G; shows: *************************** 1. row ...
    Bing DuBing Du
    Mar 25, 2004 at 4:49 pm
    Mar 26, 2004 at 7:53 am
  • I have a series of tables that were created by: CREATE TABLE ifInOctets ( id int(11) NOT NULL default '0', dtime datetime NOT NULL default '0000-00-00 00:00:00', counter bigint(20) NOT NULL default ...
    Jack CoxenJack Coxen
    Mar 24, 2004 at 4:36 pm
    Mar 24, 2004 at 8:50 pm
  • I copied the following from my coldfusion application.log "Error","2152","03/20/04","09:03:13",,"ODBC Error Code = S1000 (General error)<P [MySQL][ODBC 3.51 Driver][mysqld-4.0.18-max-nt-log]Incorrect ...
    Daniel GaddisDaniel Gaddis
    Mar 22, 2004 at 8:34 pm
    Mar 24, 2004 at 8:39 pm
  • I need to create a query that will sort by a alpha numeric field. I need the ID field returned and one problem that I will face is that when it sorts in alpha numeric the ID field will be out of ...
    Jacque ScottJacque Scott
    Mar 23, 2004 at 5:55 pm
    Mar 23, 2004 at 7:57 pm
  • Perl/DBI is a possibility. --Walt
    Weaver, WaltWeaver, Walt
    Mar 16, 2004 at 9:29 pm
    Mar 17, 2004 at 3:44 am
  • Hi, Recently we EOLed a machine that had a mysql instance. The /usr/local/mysql dir was backed up to tape before EOLing. Having now installed a new machine, we need to copy the old database from tape ...
    Mt mMt m
    Mar 15, 2004 at 1:50 pm
    Mar 16, 2004 at 11:32 am
  • I have 3 tables: main(id int, type tinyint(1)) categories(id int, name varchar) items(id int, name varchar) I want to select the id and name. If type is 1 then I want to select the name from ...
    Amir HardonAmir Hardon
    Mar 11, 2004 at 1:36 pm
    Mar 12, 2004 at 9:55 pm
  • in the show status there is a line that says Questions and it shows a number The manual says this is the number of questions asked the mysql database. what I want to know does one query equal one ...
    Rochester, DeanRochester, Dean
    Mar 10, 2004 at 5:36 pm
    Mar 10, 2004 at 7:00 pm
Group Navigation
period‹ prev | Mar 2004 | next ›
Group Overview
groupmysql @
categoriesmysql
discussions691
posts2,158
users635
websitemysql.com
irc#mysql

635 users for March 2004

Sasha Pachev: 88 posts Egor Egorov: 76 posts Victoria Reznichenko: 69 posts Victor Pendleton: 60 posts Paul DuBois: 56 posts Victor Medina: 37 posts Michael Stassen: 35 posts Heikki Tuuri: 23 posts Joshua J. Kugler: 23 posts Scott Haneda: 22 posts Donny Simonton: 20 posts Martijn Tonies: 20 posts Jigal van Hemert: 19 posts Richard Davey: 19 posts Rafael Diaz Valdes: 18 posts Rhino: 18 posts Tim Cutts: 18 posts Brad Eacker: 17 posts Ed Reed: 14 posts Lorderon: 14 posts
show more
Archives