Search Discussions
-
I'm building a new clipart site. I need to have keyword searching. I'm seeking opinions about table design. Here are my proposed options. If anyone has any other suggestions, please make them. Option ...
Robb Kerr
Nov 25, 2005 at 5:00 pm
Nov 29, 2005 at 1:46 pm -
Good morning everybody! We are working on a big project involving SugarCRM and in the end it will contain around 1 000 000 records per table in MySQL database. Whole system is running on dedicated ...
Marko Knezevic
Nov 22, 2005 at 9:23 am
Nov 23, 2005 at 1:21 pm -
Hello everyone, Is it possible or makes sense to key a field that is a part of Unique Index already? Regards and thank you Mikhail Berman
Mikhail Berman
Nov 17, 2005 at 9:03 pm
Nov 18, 2005 at 8:38 pm -
Mike, ----- Original Message ----- From: "mos" <mos99@fastmail.fm Newsgroups: mailing.database.myodbc Sent: Saturday, November 05, 2005 12:11 AM Subject: Heikki: What will become of InnoDb once MySQL ...
Heikki Tuuri
Nov 5, 2005 at 2:32 am
Nov 7, 2005 at 10:51 am -
13
Database IDs
Hello, If I am relying on MySQL's AUTO_INCREMENT feature for the id for a table, how can I reliably retrieve the ID of an item I just entered into the database? For instance, I have a table that ...Robert Crowell
Nov 11, 2005 at 5:38 am
Nov 21, 2005 at 2:04 am -
Hi Friends, I have a ticky mysql problem. I need to find the country name from the country prefix so eg. i have a mysql table with prefix and name as the coumns and with datas like : Prefix, Name 1 ...
Abhishek jain
Nov 19, 2005 at 1:13 pm
Nov 20, 2005 at 1:00 pm -
Not sure if this is the right place to ask. I have a table, Weight, with the following test data: idx VBS_ID Date Weight 1 111111 10/3/2005 11.5 2 111111 9/5/2004 10 3 111111 10/7/2005 11.51 4 111111 ...
Gobi
Nov 4, 2005 at 8:03 am
Nov 6, 2005 at 9:01 am -
Hi, Unfortunately I need to use a query on an old MySQL (4.0.xx) and the one I currently have uses a subquery. So it works on my 4.1 but not with this 4.0. I have read in the MySQL manual that I can ...
Alex Gemmell
Nov 30, 2005 at 3:08 pm
Dec 6, 2005 at 3:29 pm -
I'm using MySQL-Cluster 5.0, and we're doing some research. What is everyone's opinion as to what the best fieldtype to store an IP address in? varchar(16) ? because 16 is the max chars of an ip ...
Cory @ SkyVantage
Nov 11, 2005 at 8:32 pm
Nov 12, 2005 at 3:49 pm -
I just installed MySQL 3.23 (the only one I could get to work) and I find that I can log into the server just by typing mysql at the DOS prompt. Ho do make it so you have to use a user name and ...
Beauford
Nov 30, 2005 at 4:29 am
Dec 1, 2005 at 6:02 am -
MyISAM has a cool feature where it keeps track of the internal row count so that SELECT COUNT(*) FROM FOO executes in constant time. Usually 1ms or so. The same query on INNODB is O(logN) since it ...
Kevin Burton
Nov 1, 2005 at 8:38 pm
Nov 14, 2005 at 10:31 pm -
I'd like to delete all but the newest 100 records from a table. I have a timestamp field. I can't figure out how to do this in a single SQL statement - can anyone help? Thanks!
Brian Dunning
Nov 6, 2005 at 3:13 pm
Nov 8, 2005 at 3:30 pm -
I've been using ASP for years but I have to work on a bigger project involving many users and data so of course, Access is not an option anymore. Since it's a project requiring thousand of files and ...
Marc Pidoux
Nov 4, 2005 at 7:47 am
Nov 4, 2005 at 6:02 pm -
Hi, I'm on Solaris 9 with mysql 4.1. I've moved the datadir to a new location, and edited the mysql start script directly so that it now has the line: datadir=/export/www1/data The server restarts no ...
Rajesh Olafson
Nov 18, 2005 at 8:54 pm
Nov 24, 2005 at 9:42 pm -
Hello everyone, I have changed a value of "max_allowed_packet" in "my.cnf". Do I need to restart MySQL itself for the change to take place or is there a way to refresh this variable (parameter) ...
Mikhail Berman
Nov 15, 2005 at 3:26 pm
Nov 16, 2005 at 4:24 pm -
Whenever I try to create a table using innodb, i get a 1266 warning that the table has been created with myisam instead. I receive the error both at the mysql command line and using the mysql query ...
P. Evans
Nov 9, 2005 at 8:32 pm
Nov 13, 2005 at 1:00 am -
I am trying to create a table to import data on cpu usage based on certain programs. the following is a sample of the data..... When I import into the tables their is no field type that matches up to ...
Longstreth, Lance
Nov 8, 2005 at 10:11 pm
Nov 12, 2005 at 4:26 am -
How to create ssh tunnel for Mysql? TH
Jerry Swanson
Nov 20, 2005 at 2:59 pm
Dec 8, 2005 at 4:02 pm -
I'd like to do the following in my view select fieldOne, fieldTwo, if(fieldThree.length 0) then fieldThree as Company else fieldFour as Company from table; I realize this syntax isn't correct and ...
Scott Klarenbach
Nov 28, 2005 at 6:56 pm
Dec 5, 2005 at 8:09 pm -
Hi, I'm relatively new to the database-scene. I've installed MySQL on Mac OSX 10.3, which was easy. I've installed Perl support for MySQL, which was suprisingly difficult. I've installed CocoaMySQL ...
Maurice van Peursem
Nov 27, 2005 at 11:32 pm
Nov 28, 2005 at 2:26 pm -
Hi, I'm really desperate on this on. After struggling with some really weird bugs I finally finished my project. Buuuuuuuuuuttttt I can't perform a good backup and restore. I'm using : MySql ...
Barak Mery
Nov 23, 2005 at 6:50 pm
Nov 24, 2005 at 10:24 am -
Hi guys, I need some help with an query that I know I must use joins, but I can't figure out how to. The problem is, when the contact has an address, phone and email it works just fine, but I want it ...
Bruno b b magalhães
Nov 19, 2005 at 2:49 pm
Nov 19, 2005 at 11:23 pm -
When I log in as root using: mysql -u root -p mysql I get the mysql prompt: mysql I then issue this command or statement: mysql GRANT ALL PRIVILEGES ON *.* TO 'testUser'@'' IDENTIFIED BY ...
Bruce Martin
Nov 5, 2005 at 2:55 am
Nov 6, 2005 at 7:43 pm -
Hi, I'm relatively new to the MySQL / Web development - database environmeent, having moved from Microsoft SQL. Just two questions ? 1. I have an ASP.Net page that commits data to a MySQL database. I ...
Dewald Troskie
Nov 29, 2005 at 12:11 pm
Mar 12, 2006 at 11:27 am -
All, I can't get this query to run, it keeps compaining that there is a problem: The Query: insert into tickets(id,from,department,subject,body,lastaction,lastpost,priority,sta ...
Jeff
Nov 29, 2005 at 4:41 pm
Nov 30, 2005 at 2:41 pm -
Hi I was wondering how the index process worked internally for UPDATE statements. If I was to "set" a value for a column with the UPDATE statement but the value was the same, would MySQL re-work the ...
Mike OK
Nov 22, 2005 at 1:42 am
Nov 28, 2005 at 3:32 pm -
hi all i want to install mysql5 on fc3 but i cant when i trying to implement it by rpm. i remove mysql3 with rpm -e directive. who cabn help me?:( thanks ************************************ rpm -ivh ...
Ali asghar torabi parizy
Nov 19, 2005 at 1:26 pm
Nov 22, 2005 at 2:00 pm -
How long should it take to insert approx 30,000 rows into MySQL. It takes me about 30 mins. I'm using version 4.1.10-nt. Any ideas? Thanks, Dhiren
Dhiren Bhatia
Nov 9, 2005 at 6:46 pm
Nov 12, 2005 at 10:18 pm -
I would like to find the missing subset of rows in table2 based on the rows in table1. Normally it would look like this: select * from table1 t1 left join table2 t2 on t1.date1=t2.date2 where ...
Mos
Nov 8, 2005 at 10:28 pm
Nov 9, 2005 at 7:23 pm -
I am trying to update a couple of rows in a table by doing the following: update table set column5 = number1 where column 1 = number2 and column1 = number3 but it is not working. I tried listing the ...
Kraer, Joseph
Nov 30, 2005 at 4:55 pm
Nov 30, 2005 at 10:10 pm -
Hi all, Is there a command similar to "SHOW CREATE TABLE. . ." that will output the commands to fully duplicate a table; data and all? I want to retrieve the command and write it to a text file. ...
Michael Williams
Nov 30, 2005 at 4:28 am
Nov 30, 2005 at 3:40 pm -
I have not used an 'if' clause in select before but I think I may have a scenario which calls for it. I have a table with the following sample data: idx status1 status2 1 "Neg" "Neg" 2 "Pos" "Neg" 3 ...
Gobi
Nov 28, 2005 at 1:46 pm
Nov 29, 2005 at 4:51 pm -
I have a happily working 5.0.15 installation on RHEL4, installed from the standard RPMs. I'm upgrading using rpm -Uvh to the new 5.0.16 release. -Server, -client and -devel packages install ok, but ...
Marcus Bointon
Nov 27, 2005 at 12:00 pm
Nov 28, 2005 at 3:56 pm -
IS there a way to reset a lost mysql root password?
Dustin Krysak
Nov 25, 2005 at 10:26 pm
Nov 27, 2005 at 3:38 am -
is it possible to do a mysql dump to more than 1 file? We will shortly be needing to dump a db that will be in excess of 50gb so will encounter file size issues This is on 4.1.x and rhel 4 thanks
Tom Brown
Nov 21, 2005 at 3:57 pm
Nov 22, 2005 at 6:33 pm -
I am trying to populate a table using the archive engine that I estimate will take up ~ 8gb of disk space when finished. Right now I am crashing the server as soon as my file gets to the 2gb mark. OS ...
Marc Rossi
Nov 17, 2005 at 4:44 am
Nov 21, 2005 at 6:35 pm -
Hi guys, I don't really understand the character set in mysql from the doc. Tu summarize my problem: users upload xml files (UTF-8). part of the data is then inserted into MySQL (CHARSET=latin1) at ...
Mel list_php
Nov 8, 2005 at 5:29 pm
Nov 20, 2005 at 9:17 pm -
Hello All. I am hoping for a bit of help with some code that has really given me some trouble. If this is not he correct forum for this any help in pointing me to a more suited list would be ...
Rick Dwyer
Nov 17, 2005 at 3:28 pm
Nov 17, 2005 at 7:44 pm -
Hi All, I will need to change my.cnf in master machine, but I can't afford to restart MySQL server as the server has been used for heavy traffic databases. Can anyone tell me how to do it? Cheers, ...
Tedy Aulia
Nov 14, 2005 at 10:12 pm
Nov 17, 2005 at 1:57 pm -
{ this is a resend, forgot subject in original posting } Hello, I am using MySQL 4.0.24 on OpenBSD 3.8. I am having difficulty creating a SQL schema. My attempts contain lines like: CREATE TABLE ...
Peter Matulis
Nov 15, 2005 at 5:25 am
Nov 15, 2005 at 3:45 pm -
I'm runnung MySQL-Cluster 5.0.15 on Linux. I have to do some re-design of a website database that has quickly outgrown itself. I'm trying to migrate to MySQL Cluster 5.0.15. Mostly I've used VarChar ...
Cory Robin
Nov 10, 2005 at 9:11 pm
Nov 11, 2005 at 9:23 am -
I have a question related to connection control. If I want to connect to one database A in the server from another computer. I am using 'root' and it password. But how shall I add the host in which ...
Xiaobo Chen
Nov 3, 2005 at 7:52 pm
Nov 3, 2005 at 10:53 pm -
Hi, When I migrated from 3.23 to 4.0 version (if I'm remember well), I think I missed to upgrade something, so all my MySQL users are able to see the list of the databases on my server. Currently, ...
BÁRTHÁZI András
Nov 1, 2005 at 10:33 pm
Nov 3, 2005 at 7:46 pm -
Hi, all. First, I should give some information on the setting: I have mysql database, say, mydatabase, existing in one machine A which is Solaris; I am trying to connect this database from another XP ...
Xiaobo Chen
Nov 2, 2005 at 4:28 pm
Nov 3, 2005 at 5:26 am -
Please help. Newbie running Centos 4.2 with mySQL & PHP (binary RPM install) as per versions given below. Getting error in vegadns package (DJB TinyDNS GUI) : Fatal error: Call to undefined function: ...
Sanjay Arora
Nov 24, 2005 at 7:11 pm
Nov 28, 2005 at 3:41 pm -
Hi All, We have upgraded from 4.1.0 to 5.0.16 and notice all left joins not working. It works fine on 4.1 but 5.0.16 gives us an error: How to reproduce: CREATE TABLE `user_master` ( `user_id` int(5) ...
Terence
Nov 24, 2005 at 1:20 am
Nov 24, 2005 at 7:13 pm -
Not sure if this is the place to ask but hopefully someone can help me here. I am setting an application system and have successfully setup MySQL 5.0.15 and Tomcat 5.5.12. However, I cannot seem to ...
Gobi
Nov 23, 2005 at 4:45 am
Nov 24, 2005 at 2:20 am -
Noga, if SET FOREIGN_KEY_CHECKS=0 affects other connections to the database, that is a serious bug. If you can repeat the problem, please file a bug report to bugs.mysql.com I tested this with ...
Heikki Tuuri
Nov 21, 2005 at 9:19 am
Nov 21, 2005 at 1:40 pm -
Hi There, We are reaching 4GB with one of our tables (v4.1 on debian sarge) and are needing to run: ALTER TABLE tbl_name MAX_ROWS=1000000000 AVG_ROW_LENGTH=nnn; as per the documentation.. I would be ...
Simon
Nov 18, 2005 at 1:55 am
Nov 20, 2005 at 8:16 pm -
Recently I ran into a problem with 'LIKE' in mysql on Debian Sarge: mysql select VERSION(); +---------------------------+ +---------------------------+ 1 row in set (0.00 sec) with the following ...
Delta
Nov 11, 2005 at 9:17 am
Nov 19, 2005 at 6:50 am
Group Overview
group | mysql |
categories | mysql |
discussions | 359 |
posts | 1,283 |
users | 361 |
website | mysql.com |
irc | #mysql |
361 users for November 2005
Archives
- November 2014 (14)
- October 2014 (37)
- September 2014 (75)
- August 2014 (47)
- July 2014 (42)
- June 2014 (50)
- May 2014 (66)
- April 2014 (59)
- March 2014 (96)
- February 2014 (72)
- January 2014 (71)
- December 2013 (19)
- November 2013 (44)
- October 2013 (53)
- September 2013 (54)
- August 2013 (44)
- July 2013 (123)
- June 2013 (146)
- May 2013 (142)
- April 2013 (206)
- March 2013 (178)
- February 2013 (217)
- January 2013 (52)
- December 2012 (115)
- November 2012 (180)
- October 2012 (316)
- September 2012 (184)
- August 2012 (184)
- July 2012 (164)
- June 2012 (180)
- May 2012 (297)
- April 2012 (193)
- March 2012 (171)
- February 2012 (202)
- January 2012 (173)
- December 2011 (88)
- October 2011 (314)
- September 2011 (250)
- August 2011 (174)
- July 2011 (124)
- June 2011 (194)
- May 2011 (214)
- April 2011 (176)
- March 2011 (212)
- February 2011 (255)
- January 2011 (338)
- December 2010 (231)
- November 2010 (220)
- October 2010 (285)
- September 2010 (435)
- August 2010 (372)
- July 2010 (344)
- June 2010 (287)
- May 2010 (287)
- April 2010 (364)
- March 2010 (284)
- February 2010 (320)
- January 2010 (500)
- December 2009 (461)
- November 2009 (348)
- October 2009 (303)
- September 2009 (337)
- August 2009 (225)
- July 2009 (320)
- June 2009 (265)
- May 2009 (380)
- April 2009 (411)
- March 2009 (428)
- February 2009 (422)
- January 2009 (323)
- December 2008 (377)
- November 2008 (292)
- October 2008 (398)
- September 2008 (410)
- August 2008 (356)
- July 2008 (418)
- June 2008 (406)
- May 2008 (512)
- April 2008 (620)
- March 2008 (435)
- February 2008 (378)
- January 2008 (563)
- December 2007 (328)
- November 2007 (460)
- October 2007 (503)
- September 2007 (470)
- August 2007 (510)
- July 2007 (534)
- June 2007 (648)
- May 2007 (705)
- April 2007 (535)
- March 2007 (623)
- February 2007 (579)
- January 2007 (578)
- December 2006 (485)
- November 2006 (613)
- October 2006 (806)
- September 2006 (654)
- August 2006 (1,131)
- July 2006 (911)
- June 2006 (1,067)
- May 2006 (1,010)
- April 2006 (1,074)
- March 2006 (1,113)
- February 2006 (851)
- January 2006 (1,040)
- December 2005 (1,022)
- November 2005 (1,283)
- October 2005 (1,267)
- September 2005 (1,277)
- August 2005 (1,392)
- July 2005 (1,000)
- June 2005 (1,314)
- May 2005 (1,373)
- April 2005 (1,464)
- March 2005 (1,285)
- February 2005 (1,481)
- January 2005 (1,292)
- December 2004 (1,326)
- November 2004 (1,551)
- October 2004 (1,562)
- September 2004 (1,617)
- August 2004 (1,791)
- July 2004 (1,856)
- June 2004 (1,769)
- May 2004 (1,778)
- April 2004 (1,797)
- March 2004 (2,158)
- February 2004 (1,933)
- January 2004 (2,195)
- December 2003 (1,842)
- November 2003 (1,873)
- October 2003 (2,044)
- September 2003 (2,042)
- August 2003 (2,122)
- July 2003 (2,519)
- June 2003 (2,817)
- May 2003 (2,470)
- April 2003 (2,734)
- March 2003 (2,371)
- February 2003 (2,319)
- January 2003 (2,614)
- December 2002 (2,573)
- November 2002 (2,473)
- October 2002 (2,695)
- September 2002 (2,524)
- August 2002 (2,438)
- July 2002 (2,619)
- June 2002 (2,742)
- May 2002 (3,026)
- April 2002 (2,985)
- March 2002 (3,254)
- February 2002 (3,189)
- January 2002 (3,125)
- December 2001 (2,308)
- November 2001 (3,108)
- October 2001 (2,933)
- September 2001 (2,519)
- August 2001 (2,985)
- July 2001 (3,136)
- June 2001 (2,902)
- May 2001 (2,466)
- April 2001 (2,579)
- March 2001 (3,195)
- February 2001 (3,227)
- January 2001 (3,427)
- December 2000 (2,545)
- November 2000 (2,852)
- October 2000 (2,824)
- September 2000 (2,620)
- August 2000 (3,275)
- July 2000 (3,936)
- June 2000 (3,325)
- May 2000 (3,101)
- April 2000 (2,955)
- March 2000 (3,342)
- February 2000 (3,507)
- January 2000 (3,409)
- December 1999 (2,597)
- November 1999 (2,607)
- October 1999 (2,569)
- September 1999 (2,906)
- August 1999 (2,930)
- July 1999 (2,656)
- June 1999 (2,093)
- May 1999 (1,523)
- April 1999 (1,457)
- March 1999 (1,253)