Search Discussions

873 discussions - 2,611 posts

  • Hi, I have a system running MySQL 3.23.41. I read many times about InnoDB performance and that it is superior to the MyISAM one. I have a table 'sessions' in a MyISAM format with about 20 milion ...
    Sameh AttiaSameh Attia
    Jan 5, 2003 at 12:42 pm
    Jan 11, 2003 at 1:14 am
  • Dear gurus, here's my final stupid question for today. Why is the average row length 11 when it should be 10? mysql DESCRIBE myrowisam; +-------+----------+------+-----+---------+-------+ ...
    Stefan HinzStefan Hinz
    Jan 14, 2003 at 9:46 pm
    Jan 17, 2003 at 4:09 pm
  • How i list connected users(active) to mysql server? it is important to know connected users for me? Mysql runs in server-client system, and each host of clients are different (i assume) Mustafa ...
    Mustafa YelmerMustafa Yelmer
    Jan 31, 2003 at 11:49 am
    Feb 5, 2003 at 12:59 am
  • I've been trying to install MySQL 4.0.9 on FreeBSD 4.7, and have been getting stuck in the configure phase. I'd be grateful for any suggestions. I'm running FreeBSD 4.7 on a single-processor 1.4GHz ...
    Jesse SheidlowerJesse Sheidlower
    Jan 28, 2003 at 5:21 pm
    Jan 31, 2003 at 9:29 pm
  • Hello, I'm in the process of moving from Postgres to MySQL and I have a question. +How do you prevent a field from being left empty? I have an InnoDB table that looks like the following. CREATE TABLE ...
    Gabe GeisendorferGabe Geisendorfer
    Jan 13, 2003 at 9:39 pm
    Jan 23, 2003 at 2:04 pm
  • I just imported a .csv file and one of the columns of data was websites addresses. Those addresses aren't being recognized as links when I output an html table from my queries. I'm scratching me head ...
    Rick TuckerRick Tucker
    Jan 8, 2003 at 4:30 pm
    Jan 13, 2003 at 8:11 pm
  • Dear Sirs, I'm using PHP and MySQL to make my programs. But I think I discovered a bug in PHP or in MySQL (I don't know!). In one of my files I have the following: MYSQL_CONNECT("localhost", ...
    Nuno LopesNuno Lopes
    Jan 4, 2003 at 10:47 am
    Jan 8, 2003 at 9:19 am
  • Hello, While reading this you may think this is off-topic... but please read on.. I'll get on-topic in the end :-)) First of all I have Web Server on which I have a Paradox table with 320 records. I ...
    Thomas KvammeThomas Kvamme
    Jan 25, 2003 at 12:34 pm
    Jan 27, 2003 at 2:20 am
  • Could you clarify "This is a glibc problem"? A known standard glibc 2.2.5 against which every other piece of software functions correctly, even when receiving null returns on reverse lookups, but ...
    Christopher E. BrownChristopher E. Brown
    Jan 9, 2003 at 5:46 pm
    Jan 10, 2003 at 12:05 pm
  • Hi All Is it possible to mix javascript and PHP in the same script?? I have a number of web based apps written in PHP/MySql and while they are functionally pretty good they are aesthetically garbage. ...
    Steve DaviesSteve Davies
    Jan 31, 2003 at 8:27 am
    Aug 1, 2003 at 8:06 am
  • hi All, has anyone been able to setup ssl secure replication for mysql? how do i know whether the replication is actually done over ssl? there seem to be a lack of documentation on this part. ...
    Ivan HooIvan Hoo
    Jan 13, 2003 at 6:44 am
    Jan 23, 2003 at 12:25 am
  • The problem is this. Always when I start the server, when I try to show the table mysql, I get an error message that saids "Access Denied to user ...." but when I put the same command with the ...
    Alejandro C. GarrammoneAlejandro C. Garrammone
    Jan 21, 2003 at 2:07 pm
    Jan 21, 2003 at 9:00 pm
  • Hi, This is my 'my.ini' file where I specified 'language=spanish' but the sql errors appear in English yet. I don't see another line after this that changes the value. Can somebody help me? # Example ...
    Vicente ValeroVicente Valero
    Jan 28, 2003 at 7:57 am
    Apr 29, 2003 at 7:36 am
  • Hi, I'm wondering how well MySQL compress data. I'm about to design a database which will hold mainly _a lot_ of FLOAT-values, and since I do not really know how well MySQL compress data or how I ...
    Jonas AskåsJonas Askås
    Jan 30, 2003 at 7:46 am
    Jan 31, 2003 at 12:38 pm
  • Are there any general guidelines for optimizing ext3 for MySQL? I have a perl script that runs 200K + updates into my database once a day and I see pretty wildly fluctuating query/sec numbers using ...
    Jeff KilbrideJeff Kilbride
    Jan 15, 2003 at 7:34 am
    Jan 23, 2003 at 5:52 pm
  • Dear Editor, After installed the MySQL version 3.23.53, I tried to test the MySQL by typing the following command, relevant error message appears, please advise how to fix. Command: Display Error ...
    Seed ChanSeed Chan
    Jan 9, 2003 at 1:17 am
    Jan 10, 2003 at 9:25 pm
  • I have 2 Crystal Reports 8.5 (for the record I didn't make these reports) that draw straight from the MYSQL database. They use only 1 table. I am calling them to print from VB 6.0 Theses reports have ...
    Mary StickneyMary Stickney
    Jan 30, 2003 at 2:05 pm
    Jan 31, 2003 at 9:15 pm
  • Hello, I need help. I want to create a table with a numeric primary key as index in my sql. I want this index will be automatic. I've tried an auto_increment column, but if insert a non-correlative ...
    Vicente ValeroVicente Valero
    Jan 27, 2003 at 8:25 am
    Jan 29, 2003 at 9:49 pm
  • Hi all! I would like to build a query that I can use to search hierichally from an char(4) id composed as followed 2positions for the class of plant (for example) and 2 positions for the type of ...
    Leonardo Javier BelénLeonardo Javier Belén
    Jan 13, 2003 at 8:10 pm
    Jan 24, 2003 at 11:40 am
  • hello there, I have just installed mysql and am facing problems with the Load data local infile problem. I went through the manual and did all that was said like including the command ...
    Prathmesh J. MahidhariaPrathmesh J. Mahidharia
    Jan 7, 2003 at 4:26 am
    Jan 9, 2003 at 10:30 pm
  • Hello world! Every attempt I have made to find a decent way of backing up a database ends up with tons of reading to show hundreds of ways to do database backups. I want to know which way to do ...
    Jonas WidarssonJonas Widarsson
    Jan 7, 2003 at 3:09 pm
    Jan 9, 2003 at 4:13 pm
  • We have a *nix network and on that network we have 2 web servers. One for development (server1) and one for production (server2). And on each of those servers we have MySQL installed. Is there a way ...
    Chris BogetChris Boget
    Jan 7, 2003 at 4:10 pm
    Jan 8, 2003 at 3:06 pm
  • Hi, I'm staring mysql with mysql -u root mysql but I'm geting this error message: "Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'. I cannot find Mysql.sock anywhere, ...
    Pedro LeitePedro Leite
    Jan 27, 2003 at 7:02 am
    Feb 3, 2003 at 10:22 am
  • Hi, I got a difficult problem with a SELECT query: In my application there are two tables, one for all users (user_profile) one for a user-in-team relation. I want to know, which user is still not in ...
    Heiko mundleHeiko mundle
    Jan 28, 2003 at 2:08 pm
    Jan 30, 2003 at 3:10 am
  • I am trying to do an sql query and am trying to select the last x rows from the database. I see the limit function but that seems like that is from the first row down. I want to start from the last ...
    Christopher LyonChristopher Lyon
    Jan 28, 2003 at 4:26 pm
    Jan 28, 2003 at 11:58 pm
  • Hello All, For some time I've been wondering if it's possible to write a program that can automatically check my local MySQL server, create a recordset containing any new or updated records found in ...
    Murray WellsMurray Wells
    Jan 23, 2003 at 2:30 pm
    Jan 25, 2003 at 4:38 pm
  • This is wierd. When I run make on mysql 3.23.54 (Source Distro), using ./configure --prefix=/usr/local/mysql, --oh, and I'm running Mandrake Linux 9.0--I always get this: libmysql.c:1340: warning: ...
    Jan 11, 2003 at 5:04 pm
    Jan 15, 2003 at 6:59 pm
  • Hi All, Trying my best to maintain some production servers running mysql-max-3.23.53a-pc-linux-gnu-i686 with one master and one slave. We keep having issues where we create a new table on the master, ...
    David NedvedDavid Nedved
    Jan 13, 2003 at 7:16 pm
    Jan 15, 2003 at 3:23 pm
  • To begin with I am only about 3/4 of the pay through paul d's great book so bear with me. Say I have a table (names) with columns (id, first, last) and I want the next name when ordered by last, ...
    Jan 14, 2003 at 4:19 am
    Jan 14, 2003 at 8:49 pm
  • Hi! I have two tables: CREATE TABLE `pokoje` ( `nrpok_p` char(10) NOT NULL default '', `nip_h` int(10) NOT NULL default '0', `lozka_p` char(2) default NULL, `tv_p` char(1) default NULL, `lazienka_p` ...
    Rafal JankRafal Jank
    Jan 9, 2003 at 3:11 pm
    Jan 10, 2003 at 2:15 pm
  • Can anybody help me with select query how to do this: I have table "foo1" with two fields "image" "check" so I want to make query select * from foo1 where [so is it possible to make some if check=1 ...
    Svens KlaveSvens Klave
    Jan 8, 2003 at 1:29 pm
    Jan 8, 2003 at 7:23 pm
  • Hi, all -- I wonder if there's a best-practice line of when to bother to normalize data out to a table. Certainly I wouldn't want to have a table of integers and have a column in another table point ...
    David T-GDavid T-G
    Jan 14, 2003 at 11:49 pm
    Feb 23, 2003 at 6:27 pm
  • Is there any way to partition MyISAM tables in mysql? i have a huge table and want to partition it. Do InnoDB tables support partitioning? thanks. Prasanth
    Prasanth KrishnaPrasanth Krishna
    Jan 31, 2003 at 11:36 am
    Feb 3, 2003 at 4:12 pm
  • Hi List I'm using 2 WinNT-Servers, Sp6 with mysql 4.0.5. max-nt. I ve setup a replication between these two servers as discribed in the manual and some small problems comes up. Maybe someone can give ...
    Guddack Thorsten ICM MP SCM GO 21Guddack Thorsten ICM MP SCM GO 21
    Jan 30, 2003 at 1:43 pm
    Feb 2, 2003 at 9:06 am
  • Hi, I was already questioning my sanity, but the problem below is reproduceable: This is how my table looks: mysql describe T_ORDH; --------------+----------------------+-----+----+--------+-------- ...
    Marco DeppeMarco Deppe
    Jan 31, 2003 at 11:18 am
    Feb 1, 2003 at 12:23 am
  • Has anyone done any work with getting images into and out of a MYSQL database? I have used mysql for some time, but never stored an image in a blob field. I am curious on how to insert the image from ...
    Mike WalthMike Walth
    Jan 30, 2003 at 8:27 am
    Jan 31, 2003 at 3:15 pm
  • Alrighty then! Now FreeBSD 5.0 has been released, what are the plans for mysql to evaluate the new (really new :) thread implementation. Peter <^_^
    Grigor, PeterGrigor, Peter
    Jan 20, 2003 at 7:20 pm
    Jan 24, 2003 at 12:00 am
  • Hi, all -- In the music database I'm designing I want to store the words of the piece and then index on them to be able to pull up matches for a given term or keyword. I can't create very long ...
    David T-GDavid T-G
    Jan 20, 2003 at 1:39 pm
    Jan 23, 2003 at 12:01 pm
  • I've got a table whose structure looks like this: CREATE TABLE IF NOT EXISTS calc_hits (id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, hit_date DATETIME NOT NULL, PRIMARY KEY (id)) AUTO_INCREMENT = 1; ...
    Jefferey DonniciJefferey Donnici
    Jan 18, 2003 at 11:24 pm
    Jan 19, 2003 at 8:23 pm
  • Are many people using MySQL version 4 yet? I'm interested in it because I want to use it's SSL capabilities but would like to hear that people are not having trouble with it first. Thanks, David Rock
    David RockDavid Rock
    Jan 8, 2003 at 4:08 pm
    Jan 14, 2003 at 10:12 pm
  • Hello, I am trying to get a sort to use an index. The query is very simple: select nr from mytable where col1='const' and col2='another const' and col3='YA const' order by nr; The explain gives me: ...
    Jan 4, 2003 at 1:05 am
    Jan 10, 2003 at 11:25 am
  • Hi guys, I'm new here and need help. I'm installing MySQL on FreeBSD 4.7. I actually had/have MySQL installed but when I'm trying to run it says: error: 'Can't connect to local MySQL server through ...
    Anton ZavrinAnton Zavrin
    Jan 3, 2003 at 2:28 pm
    Jan 6, 2003 at 11:47 am
  • I've been reading every e-mail I could find within this list that talked about ReiserFS within the last year and I've found very little information on is ReiserFS really better than ext3. I did find ...
    Nicholas GauglerNicholas Gaugler
    Jan 22, 2003 at 6:26 am
    Jan 27, 2003 at 10:02 am
  • automake: strings/Makefile.am: Assembler source seen but `CCAS' not defined in `configure.in' automake: strings/Makefile.am: Assembler source seen but `CCASFLAGS' not defined in `configure.in' error: ...
    Lists @ Apted Tech.Lists @ Apted Tech.
    Jan 9, 2003 at 10:29 pm
    Jan 25, 2003 at 2:58 am
  • Maybe I'm a bit naive in saying this but. . . SQL joins are damn slow! I have a simple database of about 37,000 records in [Court Cases] and 2,000,000 records in [Defendants] (soon to be more). When ...
    Steve QuezadasSteve Quezadas
    Jan 21, 2003 at 9:34 am
    Jan 22, 2003 at 6:10 pm
  • Hi there, My hosting company tells me that they need to take down the MySQL server every day for 30 to 60 minutes to make a backup. This is the quote: "Please note that mysql is shutdown daily ...
    Jan 21, 2003 at 10:43 am
    Jan 22, 2003 at 3:46 pm
  • I have three tables, people, events and epeople. epeople includes a person id and an event id and works as a list of people attending events in the database. The following query returns a list of all ...
    Josh L BernardiniJosh L Bernardini
    Jan 21, 2003 at 4:45 pm
    Jan 22, 2003 at 7:48 am
  • Hi All, I'm trying to insert multiple lines to a table with 3 col. All 3 of them are a part of the primary key. But while inserting the data , sometime occurs the situation where I want to insert an ...
    Zysman, RoiyZysman, Roiy
    Jan 20, 2003 at 7:16 am
    Jan 20, 2003 at 7:51 pm
  • Hi, I've "inherited" a FreeBSD/MySQL database-server (Compaq DL360, dual P3 1GHz), running (at the moment): Server version: 4.0.3-beta However, as far as I can tell, MySQL/FreeBSD 4.6.2-RELEASE still ...
    Tommy F. EriksenTommy F. Eriksen
    Jan 10, 2003 at 8:13 am
    Jan 15, 2003 at 10:34 am
  • I got a gift certificate for book store. I am looking for good MySql books with reference, examples, etc? Anyone have some ideas on good books to look at Chuck ...
    Charles MabbottCharles Mabbott
    Jan 8, 2003 at 7:57 pm
    Jan 13, 2003 at 6:04 pm
Group Navigation
period‹ prev | Jan 2003 | next ›
Group Overview
groupmysql @

775 users for January 2003

Paul DuBois: 105 posts Stefan Hinz, iConnect \(Berlin\): 103 posts Jeremy Zawodny: 59 posts Michael T. Babcock: 43 posts David T-G: 42 posts Gelu Gogancea: 42 posts Heikki Tuuri: 42 posts Zak Greant: 35 posts Egor Egorov: 34 posts Octavian Rasnita: 33 posts Benjamin Pflugmann: 32 posts Gerald_clark: 32 posts Victoria Reznichenko: 29 posts Roger Baklund: 28 posts Dan Nelson: 25 posts Diana Soares: 24 posts Adolfo Bello: 23 posts Jennifer Goodie: 22 posts Frank Peavy: 17 posts Nasser Ossareh: 17 posts
show more