FAQ

Search Discussions

336 discussions - 1,267 posts

  • Hi to all! I have tables products and categories CREATE TABLE categories ( cat_id INT(6) NOT NULL AUTO_INCREMENT, cat_name VARCHAR(45) NULL, cat_description TEXT NULL, cat_parent INTEGER(4) UNSIGNED ...
    AfanAfan
    Oct 18, 2005 at 5:49 pm
    Nov 20, 2005 at 11:58 pm
  • Everyone, We're trying to do some bulk data loads on several different tables (on several different machines, using several different techniques) and seeing dramatically worse-than-linear ...
    Jon FrisbyJon Frisby
    Oct 11, 2005 at 2:11 am
    Oct 18, 2005 at 2:49 pm
  • I have a table doing time tracking. I don't use timestamps, I use datetime fields to record punch in times and punch out times. I have this query that computes the amount of time between a punch in ...
    JabbottJabbott
    Oct 24, 2005 at 4:40 am
    Jul 25, 2006 at 7:25 pm
  • Hi. I have a database that is used with wordpress blogging software. Yesterday the server that it's running on reset itself. Since then I can't access the database. What could be going on here? Any ...
    Luke VanderfluitLuke Vanderfluit
    Oct 20, 2005 at 1:46 am
    Oct 21, 2005 at 10:48 am
  • Dear list, I need some inputs/help on my finding below: 5.0.15 make my view (below) almost useless compare with 5.0.1-alpha: with the same data set, 5.0.15 took 18min but 5.0.1 took 6.3sec to get the ...
    YLYL
    Oct 30, 2005 at 3:23 pm
    Oct 31, 2005 at 5:53 pm
  • Hi, We've developed an automatic email mapping capability from Google Maps API. To try it out, we mapped origins of emails to this group from October 3 through October 14th. The result of this map is ...
    Claire McListerClaire McLister
    Oct 24, 2005 at 9:18 pm
    Oct 25, 2005 at 1:29 pm
  • As part of my 4th Year Group Design Project, I am required to build a database system that will validate and then store the data. As such I am currently investigating different DB, to choose the most ...
    Ledina HidoLedina Hido
    Oct 19, 2005 at 2:34 pm
    Oct 20, 2005 at 8:40 am
  • Hi, Is there a command for renaming a MySQL database? Thank you. Teddy
    Octavian RasnitaOctavian Rasnita
    Oct 16, 2005 at 4:40 pm
    Oct 17, 2005 at 7:53 pm
  • (I've posted to forums, but also send to this ML.) Hi, I took a look at mysql.com, but I still have a question about commercial license. If we build and host a web-system with MySQL, which provide ...
    Kenji HIROHAMAKenji HIROHAMA
    Oct 21, 2005 at 11:49 am
    Oct 24, 2005 at 2:20 am
  • I was wondering if anyone might have a canned query I could use for the following scenario. I need to search for a list of locations within a certain distance of a user given zip code and order them ...
    Steffan A. ClineSteffan A. Cline
    Oct 8, 2005 at 10:58 pm
    Oct 11, 2005 at 7:28 pm
  • I am unsure how to write this query, can someone help? I have two tables. One has a list of retailers (tbl_retailer): retailerid name postcode e.g. 1 Sprocket Supplies CH23 4PY The other has the ...
    Daniel BowettDaniel Bowett
    Oct 26, 2005 at 2:05 pm
    Oct 27, 2005 at 8:28 am
  • My bad. I was renaming some columns in a table. I incorrectly set the type to decimal(4,2) and the data was truncated/hosed. Is there a way to recover the data. I tried a system backup from ...
    Jim SeymourJim Seymour
    Oct 17, 2005 at 1:28 am
    Oct 19, 2005 at 8:43 pm
  • (please excuse the double post but I wanted to reach the two audiences I thought could help the best) This is a question about the interpreting the documentation in the manual for the C API. I ...
    SgreenSgreen
    Oct 7, 2005 at 3:59 pm
    Oct 11, 2005 at 3:11 pm
  • Hi all: I need some help in writing a sql statement. I have three tables (Sales, Cust and Product). The sales table contains a large volume of data and I want to create a sql to group the sales table ...
    ImranImran
    Oct 10, 2005 at 7:51 pm
    Oct 29, 2005 at 5:41 am
  • Hi I need to have a single db that will have in excess of 100gb of data in it - For this i will need to create more that 1 datafile as the max file size of linux would be exceeded in this scenerio. ...
    Tom BrownTom Brown
    Oct 25, 2005 at 5:05 pm
    Oct 27, 2005 at 9:54 pm
  • [root@tomsEmachine mysql-standard-5.0.15-linux-i686-glibc23]# Starting mysqld daemon with databases from /usr/local/mysql-standard-5.0.15-linux-i686-glibc23/data STOPPING server from pid file ...
    Tom wibleTom wible
    Oct 24, 2005 at 11:02 pm
    Oct 27, 2005 at 12:58 am
  • Hi all, We are a group of three students in Professor Ric. Holt's Software Architecture class at the University of Waterloo. As our project, we would like to examine the MySQL source to determine the ...
    Andrew RothAndrew Roth
    Oct 19, 2005 at 4:36 am
    Oct 21, 2005 at 5:10 pm
  • Hi, I have this query below, and I have been pulling my hair out for the past couple of hours trying to get it to do what I want. As is, it works, but I need it to consider other conditions. One of ...
    John NichelJohn Nichel
    Oct 10, 2005 at 8:29 pm
    Oct 18, 2005 at 3:00 pm
  • hi, i have a machine with 6G memory, loaded with RHEL4. now, my question is mysql support innodb as the default table type? will be stable running RHEL4? i saw /usr/share/mysql/my-innodb-heavy-4G.cnf ...
    Hiu Yen OnnHiu Yen Onn
    Oct 14, 2005 at 7:39 am
    Oct 16, 2005 at 11:36 pm
  • Due to the complexity of my query I don't know how to get this down to a simple test case to demonstrate the error. This works under mysql 4.1.8 btw, so it is failing due to a change introduced ...
    James BlackJames Black
    Oct 12, 2005 at 1:56 pm
    Oct 13, 2005 at 1:11 pm
  • I'd like to add a bit of history data to a table (who changed a record last, and when it was last changed). Is this the way to do it? alter table MEMBERS add CHG_BY varchar(3) alter table MEMBERS ...
    S. keelingS. keeling
    Oct 3, 2005 at 10:51 pm
    Oct 6, 2005 at 4:27 pm
  • Greetings everyone, I am having a problem with PHP and mysql I have copied a script exactly off a website to open the database and insert a new user I try to access the mysql database using the root ...
    Alastair RoyAlastair Roy
    Oct 25, 2005 at 9:08 am
    Oct 27, 2005 at 5:17 pm
  • Hi, I am currently using mysql 4.0.18 as distributed with red hat Linux. I find when I perform a select on a varchar(30) field, the index is used only if I have quoted the value in the where clause. ...
    Olaf FaalandOlaf Faaland
    Oct 19, 2005 at 6:22 pm
    Oct 24, 2005 at 3:48 am
  • Hello, could someone help me please to construct correct query or tell me what I'm doing wrong? I have three tables: table products table products_codes where some products could have assigned ...
    Duąan PavlicaDuąan Pavlica
    Oct 12, 2005 at 11:23 am
    Oct 22, 2005 at 10:58 pm
  • I suspect that this is the wrong list for this kind of question, but if someone could point me to appropriate sources, I would very much appreciate it. I am new to SQL but inherited project designed ...
    Jeffrey GoldbergJeffrey Goldberg
    Oct 19, 2005 at 7:23 pm
    Oct 20, 2005 at 1:39 am
  • The test system that is included in MySQL Server's Unix source distributions.(/mysql-test/mysql-test-run.sh) We can use the suite to run a test against to the MySQL Server. But these tests only can ...
    Lu mingLu ming
    Oct 13, 2005 at 10:49 am
    Oct 17, 2005 at 8:41 am
  • Does anyone know a sw that can reverse engineering a mysql table? I want to be able to draw a entity-relationship model from an already made MySQL table. Thanks, Bruno
    Bruno CochofelBruno Cochofel
    Oct 12, 2005 at 8:51 pm
    Oct 13, 2005 at 10:26 pm
  • Hello, Is it possible for a MySQL connection to request a downgrade in privileges? What I'd like to be able to do is create one database user account for a database application with read and write ...
    Andrew_hoyingAndrew_hoying
    Oct 12, 2005 at 2:55 pm
    Oct 13, 2005 at 9:09 am
  • Hi, I have a query: UPDATE dbseXyzOrders.tblOrder SET intPoUid = 98 WHERE intOrderUid = 100000798 intOrderUid is the primary key There are 25 columns in the table and a further 8 of these have ...
    Tony LeakeTony Leake
    Oct 5, 2005 at 1:55 pm
    Oct 7, 2005 at 9:54 am
  • I am converting some code from MSSQL to MySQL. In one place I need to have a conditional query depending on if a table exists or not. There are different versions of this application and the table ...
    Ryan StilleRyan Stille
    Oct 6, 2005 at 3:56 pm
    Oct 7, 2005 at 9:54 am
  • Suppose I have a simple table as follows: PartName Tolerance Cycles A 1 10 A 2 11 A 3 13 A 4 15 A 5 18 B 1 12 B 2 14 B 3 16 B 4 16 B 5 17 C 1 6 C 2 7 C 3 7 C 4 8 C 5 10 How do I set up a query whose ...
    Roy HarrellRoy Harrell
    Oct 4, 2005 at 7:08 pm
    Oct 4, 2005 at 10:21 pm
  • Where can I get tips on how to manually set up MySQL for MythTV? MythTV's site was not very helpful in this regards. Jim C.
    Jim C.Jim C.
    Oct 25, 2005 at 3:09 pm
    Oct 26, 2005 at 2:56 pm
  • ----- Original Message ----- From: "grKumaran" <grkumaran@sancharnet.in To: <mysql@lists.mysql.com Sent: Tuesday, October 18, 2005 16:08 Subject: query help : Hello, : : CREATE TABLE t ( : dt ...
    grKumarangrKumaran
    Oct 18, 2005 at 3:56 pm
    Oct 18, 2005 at 7:06 pm
  • hi , I have crerated a mysql database to store images , mp3 , video files..etc. In my first stage i stored images as jpg , gif . But when i try to store little but huge gif files it wont store . I ...
    Kane WilsonKane Wilson
    Oct 13, 2005 at 12:41 pm
    Oct 15, 2005 at 9:20 pm
  • Hi, What is better/faster to insert as a value for indexed fields, in case of 0 or Null values, to leave it blank ('') or to insert a '0'/'NULL'? Thnx, Lefteris
    Lefteris TsintjelisLefteris Tsintjelis
    Oct 3, 2005 at 8:31 am
    Oct 14, 2005 at 5:47 pm
  • I'm fairly new to MySQL and am getting an error messages like: ERROR 1064 (42000) at line 5: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for ...
    Hugh SasseHugh Sasse
    Oct 13, 2005 at 3:26 pm
    Oct 13, 2005 at 4:19 pm
  • How do I append one table's contents to another? Both have identical structure. Problem is I don't have shell access, only phpAdmin or a PHP file I write & upload myself.
    Brian DunningBrian Dunning
    Oct 11, 2005 at 2:56 pm
    Oct 11, 2005 at 4:06 pm
  • Hi, I have the following tables: ( some in Microsoft Access and some in Excel ) and I want to migrate the data into MySQL and develop an interface in PHP for easy administration and control. *1) ...
    InfernoInferno
    Oct 9, 2005 at 4:37 pm
    Oct 11, 2005 at 3:08 pm
  • I am trying to use triggers for the first time with MySQL 5.0. I have read the manual but I am not understanding why I would run into the following problem. I created the following triggers: CREATE ...
    Steffan A. ClineSteffan A. Cline
    Oct 9, 2005 at 7:39 am
    Oct 10, 2005 at 6:03 pm
  • I have two tables with date and uid cols. in common. Table 1 has one row per date, Table 2 has a maximum of 7 rows per date. select t1.date, t1.val, t2.val from t1 right join t2 on t1.date = t2.date ...
    Jonathan ManginJonathan Mangin
    Oct 7, 2005 at 6:56 pm
    Oct 10, 2005 at 7:43 am
  • FYI, from the Silicon Valley Business Journal: Oracle buys Finnish open source company Oracle Corp. said Friday it has bought Innobase OY, a software company based in Finland, for an undisclosed ...
    Hassan SchroederHassan Schroeder
    Oct 7, 2005 at 10:24 pm
    Oct 10, 2005 at 4:45 am
  • Hi All, I get a duplicate column error on 5.0.13 when creating a view. Am I doing something wrong here or do I submit a bug report? This should be allowed as the col names are not duplicated. ...
    TerenceTerence
    Oct 7, 2005 at 7:48 am
    Oct 10, 2005 at 4:30 am
  • One of our servers which is configured primarily for InnoDB has crashed in the same fashion three times in the past 48 hours. I've been going over the error log, and I would like to know if anyone ...
    DevanandaDevananda
    Oct 5, 2005 at 2:17 pm
    Oct 9, 2005 at 6:10 am
  • Hi, I'm pretty much an SQL newbie, so apologies in advance if this is basic stuff. That'll teach me for skipping the databases class in college... I just created an app using a table that has entries ...
    Donnie LynchDonnie Lynch
    Oct 6, 2005 at 9:32 pm
    Oct 7, 2005 at 1:47 am
  • Hi List, Is anyone familiar with optimizing indices, including primary key ? I do have a large myisam table with 6 non-unique key fields, lets say named A, B, C, D, E and F. Each of these columns may ...
    C.R. VegelinC.R. Vegelin
    Oct 4, 2005 at 11:51 am
    Oct 6, 2005 at 8:52 pm
  • Hi folks. Any chance on a tutorial from joins? I find them totally confusing and I know there's some power in them, so I need to learn them. Having asked that, another question arises...do my field ...
    RichRich
    Oct 4, 2005 at 4:42 pm
    Oct 4, 2005 at 11:46 pm
  • Hi, We are inserting the text data into mysql. But, when we see the dump of that table, we are seeing '\r' at the end of the value of that text. Actually we are not inserting the data with '\r'. Can ...
    Lakshmi NarasimharaoLakshmi Narasimharao
    Oct 4, 2005 at 3:31 pm
    Oct 4, 2005 at 6:19 pm
  • My table products has ship_status INT, where it is either 1 or 0. I have been moving those style fields to enum('now', 'soon') because it makes more sense to me to be able to see the real values. The ...
    Scott HanedaScott Haneda
    Oct 28, 2005 at 1:33 am
    Oct 31, 2005 at 5:01 pm
  • Why when I do select from database and try to compare float field with float number, I have no results amount --- type float select * from price where amount = 3.45 // doesn't work select * from ...
    Jerry SwansonJerry Swanson
    Oct 29, 2005 at 1:49 pm
    Oct 31, 2005 at 4:51 pm
  • Hi, I am a brand new newbie...two questions. Question 1 What is the best configuration for using MySQL and PHP from the three following combinations: #1 OS: Linux WebServer: Apache #2 OS:Windows XP ...
    Serge GoyetteSerge Goyette
    Oct 26, 2005 at 2:22 pm
    Oct 26, 2005 at 4:37 pm
Group Navigation
period‹ prev | Oct 2005 | next ›
Group Overview
groupmysql @
categoriesmysql
discussions336
posts1,267
users355
websitemysql.com
irc#mysql

355 users for October 2005

Gleb Paharenko: 116 posts Sgreen: 107 posts Michael Stassen: 35 posts Peter Brawley: 31 posts Jigal van Hemert: 26 posts Logan, David (SST - Adelaide): 16 posts Martijn Tonies: 16 posts Paul DuBois: 13 posts Sheeri kritzer: 13 posts Heikki Tuuri: 12 posts Jasper Bryant-Greene: 12 posts Jon Frisby: 12 posts Sujay Koduri: 12 posts C.R. Vegelin: 11 posts Joerg Bruehe: 11 posts Luke Vanderfluit: 11 posts Rhino: 10 posts Afan: 9 posts Brent Baisley: 9 posts Merlin: 9 posts
show more
Archives