FAQ

MySQL > mysql > November 2005

Search Discussions

359 discussions - 1,283 posts

  • 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 KerrRobb 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 KnezevicMarko 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 BermanMikhail 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 TuuriHeikki Tuuri
    Nov 5, 2005 at 2:32 am
    Nov 7, 2005 at 10:51 am
  • 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 CrowellRobert 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 jainAbhishek 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 ...
    GobiGobi
    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 GemmellAlex 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 @ SkyVantageCory @ 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 ...
    BeaufordBeauford
    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 BurtonKevin 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 DunningBrian 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 PidouxMarc 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 OlafsonRajesh 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 BermanMikhail 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. EvansP. 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, LanceLongstreth, Lance
    Nov 8, 2005 at 10:11 pm
    Nov 12, 2005 at 4:26 am
  • How to create ssh tunnel for Mysql? TH
    Jerry SwansonJerry 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 KlarenbachScott 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 PeursemMaurice 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 MeryBarak 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ãesBruno 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 MartinBruce 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 TroskieDewald 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 ...
    JeffJeff
    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 OKMike 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 parizyAli 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 BhatiaDhiren 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 ...
    MosMos
    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, JosephKraer, 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 WilliamsMichael 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 ...
    GobiGobi
    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 BointonMarcus 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 KrysakDustin 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 BrownTom 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 RossiMarc 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_phpMel 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 DwyerRick 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 AuliaTedy 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 MatulisPeter 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 RobinCory 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 ChenXiaobo 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ásBÁ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 ChenXiaobo 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 AroraSanjay 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) ...
    TerenceTerence
    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 ...
    GobiGobi
    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 TuuriHeikki 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 ...
    SimonSimon
    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 ...
    DeltaDelta
    Nov 11, 2005 at 9:17 am
    Nov 19, 2005 at 6:50 am
Nov 2005
12345…8
Group Navigation
period‹ prev | Nov 2005 | next ›
Group Overview
groupmysql @
categoriesmysql
discussions359
posts1,283
users361
websitemysql.com
irc#mysql

361 users for November 2005

Gleb Paharenko: 109 posts Sgreen: 81 posts Rhino: 41 posts Michael Stassen: 37 posts Peter Brawley: 25 posts Sheeri kritzer: 24 posts Paul DuBois: 23 posts Gobi: 21 posts Björn Persson: 18 posts Jasper Bryant-Greene: 15 posts Logan, David (SST - Adelaide): 15 posts Martijn Tonies: 15 posts Brian Dunning: 13 posts Heikki Tuuri: 13 posts Jesse Castleberry: 13 posts Jigal van Hemert: 13 posts ISC Edwin Cruz: 12 posts Mos: 12 posts Xiaobo Chen: 12 posts Joerg Bruehe: 11 posts
show more
Archives