FAQ

Search Discussions

293 discussions - 1,022 posts

  • Hi, For the first time, I'm working with a really large database. I have 1 SQL statement that brings my server to it's knees. This setup is currently on my home development PC, and not in production. ...
    Grant GiddensGrant Giddens
    Dec 21, 2005 at 3:35 am
    Dec 23, 2005 at 11:02 pm
  • One technique that I see a lot on this mailing list is people putting auto-incremented integer primary keys on their tables. Maybe I'm just "old school" but I've always thought that you should choose ...
    RhinoRhino
    Dec 21, 2005 at 8:52 pm
    Oct 21, 2006 at 6:42 pm
  • Hi; [Mysql 4x] In a table where I get data from another program, I have many records (about 1000) that have illegal chars in a [unique] indexed varchar field. I would like to clean the illegal ...
    Nathan GrossNathan Gross
    Dec 20, 2005 at 10:33 pm
    Dec 21, 2005 at 10:29 pm
  • What is the best (most optimal) way to perform a case-insensitive search for a VARCHAR column with COLLATE utf8_bin? I'm assuming the answer is not: SELECT * FROM MyTable WHERE UPPER(MyColumn) LIKE ...
    Robert DiFalcoRobert DiFalco
    Dec 27, 2005 at 11:30 pm
    Jan 9, 2006 at 3:37 pm
  • 无法显示邮件 Outlook Express 在显示此邮件时遇到了意外的问题。请检查你的计算机是否有足够的内存或磁盘空间,然后再试。 -------------------------------------------------------------------------- Outlook Express
    WangxuWangxu
    Dec 19, 2005 at 7:44 am
    Dec 21, 2005 at 3:17 pm
  • in an application i have written there is the need to do a search from mysql using numbers that are stored in a varchar column. it is not possible to store only the results with numbers in a seperate ...
    Test USERTest USER
    Dec 9, 2005 at 7:58 pm
    Dec 19, 2005 at 6:45 pm
  • How do I square a number in MySQL 4.1? I thought it would be something simple like: select 3**2 but that produces a syntax error. I can use Pow(3,2) but that produces a float. Is there a Square ...
    MosMos
    Dec 18, 2005 at 11:34 pm
    Dec 19, 2005 at 11:18 pm
  • Hi I have the following tables: CREATE TABLE `livres`( `id` int(10) unsigned NOT NULL auto_increment, `isbn` varchar(12) NOT NULL default '', 'titre' varchar(80) NOT NULL default '', `auteur` int(10) ...
    SandySandy
    Dec 17, 2005 at 8:17 pm
    Dec 19, 2005 at 8:44 pm
  • Hello all....new to the list...having a bit of an issue here. I have a reservations table that is linked to three separate tables, food, packages and options. A reservation can have multiple food ...
    Kevin FrickeKevin Fricke
    Dec 5, 2005 at 8:12 pm
    Dec 6, 2005 at 5:07 am
  • Hi there i am trying to use usewr variables in a select statement to add to a where clause in a sub query. Ie select @id:=id,@month:=month, (select SUM(totals) from table where id=@id and ...
    Dan RossiDan Rossi
    Dec 28, 2005 at 4:38 am
    Dec 29, 2005 at 3:57 pm
  • Dear All, I do not have much experience with PHP or MySql although I have used SQL quite a lot. I am going to set up a relatively small MySQL database (circa 40 tables) and we are expecting a hit ...
    Charles WalmsleyCharles Walmsley
    Dec 11, 2005 at 10:50 pm
    Dec 13, 2005 at 2:16 pm
  • Greetings. I'm trying to copy & paste some data from a web page into MySQL ( and yes it's our data ). I'm getting problems with characters such as quotes, dollar / euro signs, etc, that won't import ...
    Daniel KasakDaniel Kasak
    Dec 5, 2005 at 10:10 pm
    Dec 7, 2005 at 8:48 pm
  • I'm trying to use teh parameter sql_slave_skip_counter at run-time to restore slave replication. When a slave replication broke due some errors in code, my be a duplicate key, the only working way to ...
    AESYS S.p.A. [Enzo Arlati]AESYS S.p.A. [Enzo Arlati]
    Dec 28, 2005 at 3:41 pm
    Jan 10, 2006 at 12:07 pm
  • I have the following setup - mysql 4.0.24 running on Debian Linux stable. I set up a user 'mark' with a password. When I log into my Linux box as user 'mark', I cannot connect to mysql - I get this ...
    Mark PhillipsMark Phillips
    Dec 22, 2005 at 6:29 am
    Dec 22, 2005 at 2:48 pm
  • Hello! I wanted to upgrade from 4.0.16 to 5.0.16, but already notized a slow performance on restoring data with INSERTS. When dumping a table with mysqldump (4.0.16) and then restoring it with mysql ...
    PgmHelmiPgmHelmi
    Dec 4, 2005 at 8:58 pm
    Dec 19, 2005 at 8:53 pm
  • I have read the replicate document in reference manual.But i have some question. 1.If a deterministic storeprocedure only use in replication? 2.If a procedure within replication must be ...
    WangxuWangxu
    Dec 14, 2005 at 6:26 am
    Dec 19, 2005 at 1:58 pm
  • I use various script files with queries to update a MySQL base periodically. These scripts are run from the mysql line with the \. command. I would like to have a BEEP command at the end of the ...
    C.R.VegelinC.R.Vegelin
    Dec 16, 2005 at 2:21 pm
    Dec 17, 2005 at 1:16 pm
  • What's the deal with SPAM on the list?
    Stephen CookStephen Cook
    Dec 15, 2005 at 6:20 am
    Dec 17, 2005 at 7:41 am
  • Greetings, I have a bunch of names and addresses that I am adding to MySql database. I would like to automatically assign a unique sequence number to each person. Is there a way to do this easily? id ...
    Joseph AlottaJoseph Alotta
    Dec 14, 2005 at 3:29 pm
    Dec 16, 2005 at 5:26 pm
  • I am using MySQL 4.0.x on a Linux machine with a JSP/Servlet front-end to display the data. I have a table with experimental data for each flight of a rocket. Conceptually, it looks like (with many ...
    Mark PhillipsMark Phillips
    Dec 14, 2005 at 4:29 pm
    Dec 14, 2005 at 8:58 pm
  • I'm trying to get mySQL installed on my machine but im having a bit of trouble, obviously :) When i come to install mySQL server as below: rpm -ivh MySQL-server-standard-5.0.16-0.rhel3.i386.rpm I get ...
    Lewis Ashley FosterLewis Ashley Foster
    Dec 12, 2005 at 3:20 pm
    Dec 13, 2005 at 8:51 pm
  • last week i upated to 4.1.16 and the average load increased. today i switched back to 4.1.15 and the average load decreased immediately. i added a jpg of our cacti graph. the top graph shows avg load ...
    Christian MeisingerChristian Meisinger
    Dec 21, 2005 at 12:29 pm
    Jan 9, 2006 at 5:20 pm
  • I need some advice re my choice of a storage engine for transaction-safe processing and including tables that are not transaction-safe within transactions. The problem: We need to insert related ...
    John HooverJohn Hoover
    Dec 31, 2005 at 9:17 pm
    Jan 6, 2006 at 5:18 pm
  • I keep a lot of personal information in a MySQL database. I have a few querys premade for the wife to use, but we have gotten to the point where we need a solution for her to be able to run her own ...
    Dotan CohenDotan Cohen
    Dec 16, 2005 at 10:47 am
    Jan 1, 2006 at 9:51 am
  • I'm trying to write a trigger that will update the age of a camper when ever a record is updated or inserted. I have a table named Campers which contains basic information about the camper as well as ...
    JesseJesse
    Dec 27, 2005 at 9:32 pm
    Dec 28, 2005 at 8:34 pm
  • Hi List, I have recently had a crash coursh in the fineer points of db recovery due to a mis-managed server. Could someone help me out with advice on the proper syntax for doing mysqldump? I have a ...
    Bruce CareyBruce Carey
    Dec 19, 2005 at 7:13 am
    Dec 20, 2005 at 3:09 pm
  • Hi all, We have a MySQL server used for a queueing system. It worked fine so far but now we are experiencing some load problems couple with crashes. The load ( around 5-7 ) is due, according to ...
    Dilipan SebastiampillaiDilipan Sebastiampillai
    Dec 15, 2005 at 12:01 pm
    Dec 20, 2005 at 2:58 pm
  • I have the following code: ... query = "INSERT INTO a_test_table (a_test_table_id,name,last_mod_date,create_date) VALUES (?a_test_table_id,?name,?last_mod_date,?create_date)"; ... command.Prepare(); ...
    Colin ShrefflerColin Shreffler
    Dec 4, 2005 at 10:28 am
    Dec 7, 2005 at 9:50 am
  • Dear MySQL fans, I have a 260 GB huge file with 1045175762 rows. Two weeks ago, I wrote a Java program to read the huge plain text file into MySQL 4.1.12. 300 million of rows could be loaded in one ...
    Chenzhou CuiChenzhou Cui
    Dec 5, 2005 at 3:40 am
    Dec 6, 2005 at 3:05 am
  • Hi, I am trying to run an sql query such as below to list items=x randomly and then items != x randomly.. mysql (select * from tablea where item=1 order by rand()) union all (select * from tablea ...
    HALIL DEMIREZENHALIL DEMIREZEN
    Dec 5, 2005 at 9:26 am
    Dec 5, 2005 at 4:41 pm
  • hello i'm umit Tas; i have a problem. i'm writing programme in visual basic 6.0 but i must use MySQL server. i'm installed MySQL server and executing my program (no problem) but my problem is : MySQL ...
    Umit tasUmit tas
    Dec 2, 2005 at 9:57 am
    Dec 2, 2005 at 7:43 pm
  • This should be so simple, yet I've struck out. I have 2 tables, each with a common column called "pid" which is an integer and is a unique index. There are approx 18 million rows in each table, and ...
    MosMos
    Dec 31, 2005 at 9:01 pm
    Jan 2, 2006 at 3:21 pm
  • I noticed rather interesting thing... If you deduct 1 from the 0 which is stored in integer unsigned field, you get 2^32, not 0. I think that's how things are not working with version 4, and want to ...
    Marko DomanovicMarko Domanovic
    Dec 23, 2005 at 1:59 pm
    Dec 31, 2005 at 2:55 am
  • I have a strange question for you all. I've inherated some code and the way the code works is that I can only mess with the WHERE part of a query. Therefore, I was wondering if something like this ...
    Jay Paulson \(CE CEN\)Jay Paulson \(CE CEN\)
    Dec 27, 2005 at 6:48 pm
    Dec 27, 2005 at 8:06 pm
  • Okay, so I haven't been able to find any corrupted tables. Has anyone ever run into problems with joins between tables that contain funky data? I have a table that contains encrypted info and some of ...
    SubscriptionsSubscriptions
    Dec 12, 2005 at 3:44 am
    Dec 23, 2005 at 4:06 pm
  • I am experiencig an odd thing when usig this listserv. When replying to posts, my replies are being addressed to the sender, not going back to the list. Does this list not have the reply-to enabled? ...
    Bruce CareyBruce Carey
    Dec 19, 2005 at 4:27 pm
    Dec 20, 2005 at 8:26 am
  • I am running mysql 4.1.13 on Suse 10 and I get an error on a simple select query, I have checked the threads on lost connection and my connection times as well as making sure my calls are all made ...
    Doug DaltonDoug Dalton
    Dec 15, 2005 at 2:00 am
    Dec 16, 2005 at 10:43 am
  • [Apologies for my first post here being semi-off-topic!] I normally deploys apps I develop (MySQL with Lasso web middleware) with an ISP, so I have no experience of choosing hardware configurations ...
    James HarvardJames Harvard
    Dec 12, 2005 at 4:38 pm
    Dec 13, 2005 at 4:05 pm
  • I have two tables 'table1', 'table2' with a matching column 'column1'. How can I return all rows from table2 where the entry for table2.column1 does not match any entries in table1.column1? SELECT * ...
    John MistlerJohn Mistler
    Dec 12, 2005 at 5:32 am
    Dec 13, 2005 at 5:14 am
  • Is there a command that will load in all of the data from a table within a database ".sql" file on disk? The only import option I am seeing is "LOAD DATA INFILE" which requires a text file already ...
    John MistlerJohn Mistler
    Dec 12, 2005 at 1:22 am
    Dec 13, 2005 at 3:36 am
  • Hello Friend, Can you please let me know how to copy data from a column in table A to a column in table B. e.g. I want to copy value of column "age" from table 2 to column "age" in table 1, provided ...
    Sachin BhugraSachin Bhugra
    Dec 9, 2005 at 7:36 pm
    Dec 9, 2005 at 9:49 pm
  • On a 1.6ghz, 1gb ram, Linux machine running Mysql 4.1x. I have an Innodb table with over 20 million records and index size about 3.7 gig, data size 2.2gig (yes, many indexes, more space then the data ...
    Nathan GrossNathan Gross
    Dec 8, 2005 at 6:56 pm
    Dec 9, 2005 at 9:26 pm
  • Hi, I have a berkeley db table containing about 50000 rows where I do this transaction (pseudocode follows): begin work delete from mytable where myfield='boo' /*delete about 100 rows*/ for (i=0; ...
    Marco BaroettoMarco Baroetto
    Dec 7, 2005 at 12:42 pm
    Dec 9, 2005 at 10:07 am
  • system freebsd 4.10 mysql is binary: mysql-standard-5.0.15-freebsd4.7-i386 after mysql installation and root password set up i can type: /usr/local/mysql/bin/mysql -u no_matter_what_user_here and i ...
    Kalin mintchevKalin mintchev
    Dec 7, 2005 at 5:14 am
    Dec 7, 2005 at 10:07 am
  • I am sending this message to both Eventum and MySQL support lists. I am trying to write a select statement in the MySQL Query Browser (v. 1.1.10) on my Eventum (v. 1.4) database; MySQL version is ...
    Kraer, JosephKraer, Joseph
    Dec 5, 2005 at 4:39 pm
    Dec 6, 2005 at 7:56 pm
  • Hello there, I am running MySQL 5 Community Edition on Mac OS X Tiger.... Here's what I did: 1. Ran the MySQL server from System Preferences 2. Launched Terminal and typed in the following: untz$ ...
    UntzUntz
    Dec 1, 2005 at 6:35 am
    Dec 1, 2005 at 11:48 pm
  • I am trying to do a fulltext search with a multi-field index using MySQL 4.1.15. When I create a full text index of my Comments field which is of type TEXT. I can do a fulltext search fine. But when ...
    Michael StearneMichael Stearne
    Dec 27, 2005 at 10:02 pm
    Dec 31, 2005 at 3:00 am
  • I'm using mysql 5.0.15 on windows 2000. I connect to database using MYDAC component, which seems to work well enough. I got a problem when I tried to load the resultset returned by a query like 'show ...
    AESYS S.p.A. [Enzo Arlati]AESYS S.p.A. [Enzo Arlati]
    Dec 27, 2005 at 2:04 pm
    Dec 29, 2005 at 4:50 pm
  • Hi all. I'm working on splitting a 5G myisam fact table into separate parts, and putting a merge table on top. his will definitely help with table management, but I am hoping that a merge table might ...
    Tom CunninghamTom Cunningham
    Dec 21, 2005 at 2:43 am
    Dec 25, 2005 at 8:46 pm
  • Hi; Mysql 4x on Linux Fc4. In /var/lib/mysql there is an ibdata1 file. Also in this directory I also have various database folders, with *.ibd data files. I would like to locate the ibdata1 somewhere ...
    Nathan GrossNathan Gross
    Dec 19, 2005 at 12:04 am
    Dec 20, 2005 at 6:43 pm
Group Navigation
period‹ prev | Dec 2005 | next ›
Group Overview
groupmysql @
categoriesmysql
discussions293
posts1,022
users307
websitemysql.com
irc#mysql

307 users for December 2005

Gleb Paharenko: 112 posts Sgreen: 79 posts Wangxu: 25 posts Michael Stassen: 23 posts Logan, David (SST - Adelaide): 19 posts James Harvard: 18 posts Rhino: 16 posts Daniel Kasak: 13 posts Jesse: 13 posts Nathan Gross: 13 posts Peter Brawley: 13 posts Test USER: 11 posts Untz: 11 posts AESYS S.p.A. [Enzo Arlati]: 10 posts Grant Giddens: 10 posts Octavian Rasnita: 10 posts C.R.Vegelin: 9 posts Joerg Bruehe: 9 posts Cal Evans: 8 posts Dan Rossi: 8 posts
show more
Archives