FAQ

Search Discussions

93 discussions - 303 posts

  • Hi iam getting the following error while login into mysql server. andd141# mysql -u root ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) Can someone please help me ...
    F.A.I.Z.A.LF.A.I.Z.A.L
    Oct 1, 2009 at 5:31 am
    Oct 3, 2009 at 12:22 pm
  • I am new at database design, and my question relates to the trade-offs between putting all data in one database or several for mysql. For example, say I have an application where a users login from ...
    Mark PhillipsMark Phillips
    Oct 3, 2009 at 9:38 pm
    Oct 5, 2009 at 10:26 pm
  • Hello All, I am trying to insert a unique random number* with each row when inserting into a table. I can do it in the application layer (php) but just wondering if there is an easier way in the ...
    RayRay
    Oct 16, 2009 at 3:43 pm
    Oct 19, 2009 at 6:10 pm
  • Hello Everyone, I am a newbie using innodb. How can I implement START TRANSACTION COMMIT ROLLBACK when I need to update two tables that are located in two different databases. Would a single START ...
    Mosaed AlZamilMosaed AlZamil
    Oct 28, 2009 at 5:16 am
    Oct 28, 2009 at 3:43 pm
  • Hi, Will you plesae guide me ? We are about to launch one website whose database is in MySQL. I am very exited about the server setting specially about .cnf file. I have below hardware and .cnf ...
    Jeetendra RanjanJeetendra Ranjan
    Oct 14, 2009 at 10:21 am
    Oct 28, 2009 at 9:38 am
  • Dear all, I have a table which contains taxonomic data (species, genera, family, order, class) and it is organized as adjacency list model. mysql select* from taxonomic_units1 limit 5; ...
    Olga LyashevskaOlga Lyashevska
    Oct 29, 2009 at 3:30 pm
    Oct 30, 2009 at 10:39 am
  • Hi; I'm new to join statements. Here's my python syntax: cursor.execute('select * from %s left join products on %s.Item=products.Item (left join categories on products.Category=categories.ID);' % ...
    Victor SuberviVictor Subervi
    Oct 1, 2009 at 8:38 pm
    Oct 2, 2009 at 12:57 pm
  • Hi, We are currently running a early version of MySQL and are looking to upgrade to the latest version 5. However, we have a number of external applications which use the MySQL Connector/ODBC 3.51. ...
    Tompkins NeilTompkins Neil
    Oct 22, 2009 at 2:04 pm
    Oct 26, 2009 at 2:37 pm
  • Hello there, I have been using MySQL 5 on my OS X Leopard based laptop for quite some time now... Didn't have a password set and my login was "root" on localhost. Downloaded just now the Spring ...
    James DekkerJames Dekker
    Oct 14, 2009 at 7:06 pm
    Oct 14, 2009 at 11:23 pm
  • Hi, I'm trying to create a table with 2 columns both are primary key (combined) and both are foreign key as well. I'm getting error cannot create table. Here is the sql CREATE TABLE `userroles` ( ...
    Sharique uddin Ahmed FarooquiSharique uddin Ahmed Farooqui
    Oct 4, 2009 at 6:18 pm
    Oct 5, 2009 at 7:16 pm
  • Hi; I get the following error: *SQL query:* SELECT ID, Item FROM products JOIN categories ON categories.ID = products.Category LIMIT 0 , 30; *MySQL said:* #1052 - Column 'ID' in field list is ...
    Victor SuberviVictor Subervi
    Oct 2, 2009 at 3:56 pm
    Oct 2, 2009 at 5:04 pm
  • Sorry if this is a n00b question, I did read the docs for mysqldump before posting, but couldn't figure it out. I'm successfully doing a mysqldump, but I want only a few of the columns, and want them ...
    Brian DunningBrian Dunning
    Oct 29, 2009 at 5:10 pm
    Nov 4, 2009 at 1:01 am
  • Dear all, I run a query and I try to save results as a table. On the results of this first query I want to run yet another query (perhaps a few). I have been trying to use CREATE VIEW statement, ...
    Olga LyashevskaOlga Lyashevska
    Oct 27, 2009 at 2:59 pm
    Oct 27, 2009 at 5:11 pm
  • I currently have a query like so: SELECT p.fldId, p.fldFName, p.fldLName, p.fldEmail, p.fldPhone, p.resellerId, d.timezoneId, d.bestTime, d.lastDate, d.lastTime, d.lastConnected FROM tblProspects as ...
    JeffJeff
    Oct 23, 2009 at 2:45 pm
    Oct 26, 2009 at 5:16 pm
  • I have a problem with MySQL passwords... I set them, write them down... and they stop working. I have to go in and manually reset them. Right now, I have a database that, even after resetting the ...
    John OliverJohn Oliver
    Oct 19, 2009 at 11:30 pm
    Oct 22, 2009 at 5:29 pm
  • Hi; I have successfully inserted images, like yesterday, before into MySQL with the following code: sql = 'update productsX set pic1="%s" where ID=2;' % pic1 cursor.execute(sql) where pic1 is simply ...
    Victor SuberviVictor Subervi
    Oct 15, 2009 at 7:05 pm
    Oct 16, 2009 at 4:57 pm
  • Hi, I'm trying to replace this: <h2 style="margin: 0px 0px 5px; padding: 0px; font-family: 'Trebuchet MS',Arial,Helvetica,sans-serif; font-weight: bold; line-height: 30px; font-size: 30px; color: ...
    Lex ThoonenLex Thoonen
    Oct 14, 2009 at 5:38 am
    Oct 14, 2009 at 3:28 pm
  • Hello Everyone, I would like to verify that which mysql 64 bit binary i need to use for PowerEdge 1950 ? Will it be *IntelEM64T* ? Following is the cpu info Processor 1 Processor Brand : Intel(R) ...
    Sanjeev SagarSanjeev Sagar
    Oct 31, 2009 at 12:16 am
    Nov 9, 2009 at 11:40 pm
  • Hello, I am populating mysql with data, from an external source, that now and again in different fields has single quotes within the data intended to be inserted into varchars. This causes a sql ...
    Sydney PuenteSydney Puente
    Oct 30, 2009 at 4:06 pm
    Oct 31, 2009 at 11:52 pm
  • Hello, I have an application which is inserting rows into a Mysql 5.024 db. It seems to stop when an insert generates a warning. when I insert the suspect line on the mysql commandline I get this: ...
    Sydney PuenteSydney Puente
    Oct 30, 2009 at 12:02 pm
    Oct 30, 2009 at 3:01 pm
  • hi experts ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) iam facing the above error while connecting the mysql database. i am also checked the ...
    F.A.I.Z.A.LF.A.I.Z.A.L
    Oct 27, 2009 at 6:30 am
    Oct 27, 2009 at 7:17 pm
  • Hello, I have a task in hand to pull 3 tables of data from a MS SQL db and populate a mysql 5.x db. So I plan to use perl DBI for yank the data out of MS SQL and push it into MYSQL. I think I can ...
    Sydney PuenteSydney Puente
    Oct 21, 2009 at 4:48 pm
    Oct 22, 2009 at 9:32 am
  • I'm trying to formulate a query on a Wordpress database that will give me the highest 'object_id' with the highest 'term_taxonomy_id', something like: +-------------------------+------------------+ ...
    Eric AndersonEric Anderson
    Oct 20, 2009 at 9:42 pm
    Oct 21, 2009 at 3:06 am
  • What are the best MySQL GUI tools available at the moment, for example SQLyog. Thanks Neil
    Tompkins NeilTompkins Neil
    Oct 14, 2009 at 3:57 pm
    Oct 15, 2009 at 4:15 pm
  • Hi, I found no built in function in mysql to check whether a record is numeric or string. Is there any trick to do so? Many thanks. Willy
    SangprabvSangprabv
    Oct 15, 2009 at 9:34 am
    Oct 15, 2009 at 11:04 am
  • Hi, I have a table that stores article views per day per article: `post_id` int(11) NOT NULL, `date` date NOT NULL, `views` int(11) NOT NULL A couple of entries: 1987 2009-10-04 1744 1583 2009-10-04 ...
    IanIan
    Oct 8, 2009 at 7:29 pm
    Oct 9, 2009 at 6:27 pm
  • 1) When I select * from whatever; is there a way to have the results go by one screen at a time? 2) In reference to the above, is there a way to just display the row that shows the names of each ...
    John OliverJohn Oliver
    Oct 8, 2009 at 9:19 pm
    Oct 8, 2009 at 10:49 pm
  • I have 2 - 5.0.51a mysql databases setup in a dual master scenario. A is master of B and vise versa... In Linux 2.6.26 (if that matters). Everything is great while all is running normally. But, when ...
    Bryan CantwellBryan Cantwell
    Oct 7, 2009 at 5:47 pm
    Oct 7, 2009 at 8:03 pm
  • I did try to find out how to do this in the manual, but "row" and "table" occur so many times... I want to dump a certain number of rows from one table, and then restore them to another database. I'm ...
    John OliverJohn Oliver
    Oct 7, 2009 at 4:29 pm
    Oct 7, 2009 at 7:12 pm
  • I have Dell PE2950iii with 16GB of RAM, and 1 Quadcore processor @2.00G. Installed with MySQL 5.075 on 64bit Ubuntu Jaunty. I have these parameters in my.cnf: [mysqld] key_buffer = 512M ...
    SangprabvSangprabv
    Oct 6, 2009 at 1:12 am
    Oct 6, 2009 at 2:47 pm
  • Hi; I have the following python code: sql = 'insert into products values(%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s);', (id, name, title, description, price, ...
    Victor SuberviVictor Subervi
    Oct 4, 2009 at 6:04 pm
    Oct 5, 2009 at 10:01 pm
  • I've written a helpdesk ticket problem and am working on the statistics module. I'm having problems with group by. For instance, I want to get the count of the number of different problem types, by ...
    Adam WilliamsAdam Williams
    Oct 28, 2009 at 4:05 pm
    Oct 28, 2009 at 4:33 pm
  • I'm not sure what to search on to see if someone has reported this as a bug or if I'm doing something wrong... Generic code to draw a SELECT element on the screen sometimes it ends up like such... ...
    Matt NeimeyerMatt Neimeyer
    Oct 22, 2009 at 3:28 pm
    Oct 22, 2009 at 4:36 pm
  • Hola List /. We are facing a preformance issue with a desktop application which connects remotly to a Mysql / DB ( ping times 300-800ms). We do not have time to invest in modifications to create a ...
    Bermejo, Rodrigo (GE Infra, Aviation)Bermejo, Rodrigo (GE Infra, Aviation)
    Oct 20, 2009 at 11:09 pm
    Oct 21, 2009 at 6:31 am
  • I'm trying to speed up Load Data Infile and after some experimenting have noticed this "qwirk". BTW, all of the tables used below are empty and have identical table structures. The value being loaded ...
    MosMos
    Oct 17, 2009 at 9:48 pm
    Oct 19, 2009 at 3:16 pm
  • This is the first time I have attempted to expand beyond basic sql for storing data in a table like structure. So my level of knowledge is "familiar with basic SQL, but lacking in expanded ...
    Dan SaulDan Saul
    Oct 17, 2009 at 6:20 pm
    Oct 17, 2009 at 7:05 pm
  • In case anyone might find this of the least interest, probably not, but I always hope to add to discussion just as part of the thank you for help. Further work with same issues found that a file ...
    Patrice Olivier-WilsonPatrice Olivier-Wilson
    Oct 16, 2009 at 7:10 pm
    Oct 16, 2009 at 7:32 pm
  • We have an InnoDB table on MySQL 5.0. We recently encountered an this error during a multirow insert(200 rows). We identified the data causing it and it's a a series of long strings exceeding the ...
    Kyong KimKyong Kim
    Oct 13, 2009 at 12:37 am
    Oct 16, 2009 at 1:31 am
  • Newbie question, please. I have a csv file of 950 records, 20 fields. I used this converter http://csv2sql.evandavey.com/ and copied/pasted insert code into SQL in phpMyAdmin and got this error SQL ...
    Patrice Olivier-WilsonPatrice Olivier-Wilson
    Oct 15, 2009 at 3:26 pm
    Oct 15, 2009 at 3:54 pm
  • Hi guys. Ok lets say i've 2 server running MySQL, NDB node and NDB manager on each. Now I don't want to convert all tables to NDB instead I leave a few as MyISAM. Is it officially supported if I ...
    Christian MeisingerChristian Meisinger
    Oct 14, 2009 at 3:03 pm
    Oct 15, 2009 at 8:13 am
  • Hi List, i have a problem with an OR STATEMENT. Maybe someone can explain to me why the mysql optimizer doesn't work like expected. Please have a look at following "similar" queries. mysql explain ...
    Majk SkoricMajk Skoric
    Oct 13, 2009 at 10:48 am
    Oct 13, 2009 at 1:43 pm
  • Hi people! Can anyone suggest a query manager on linux environment - like Heidisql? I using MySQL Navigator: http://www.bookofjesus.org/images/fl8ze90wpgyt87bkp5.png Thanks! -- Marcelo de Assis
    Marcelo de AssisMarcelo de Assis
    Oct 12, 2009 at 11:24 pm
    Oct 13, 2009 at 6:30 am
  • I seem to recall a SQL select syntax along these lines: SELECT col1, col2 WHERE col1 IN (set) Is this or similar syntax in MySQL or is my dotage coming upon me Thanks in advance, Bruce
    Bruce FerrellBruce Ferrell
    Oct 12, 2009 at 7:47 pm
    Oct 12, 2009 at 7:51 pm
  • Hello I have a table with a compound primary key (a1,a2) and I want to insert a record (b1,b2) in th cases where there's no a1 value matching b1, and if there's already a b1 value in the form (b1,c2) ...
    Fer C.Fer C.
    Oct 7, 2009 at 3:09 pm
    Oct 7, 2009 at 5:12 pm
  • Hello I have to upgrade many mysql databases from mysql 4 and 4.1 to 5.4 with a large size 2.7 TB All tables use the MyISAM engine. I have to make that update on live system with minimal down time ...
    Monem mysqlMonem mysql
    Oct 1, 2009 at 4:34 pm
    Oct 2, 2009 at 9:35 am
  • Hi Everyone, I am trying to backup a database regularly, without using Administrator tool in mysql, Can anyone help to write a scipt regarding backup database. -Thanks in Advance Ganeswar
    Ganeswar MishraGaneswar Mishra
    Oct 29, 2009 at 5:33 am
    Oct 29, 2009 at 8:57 am
  • I saw so many open tables in my server, is it dangerous? And if I execute flush tables what does it impacts to the open tables? Thx. Willy
    SangprabvSangprabv
    Oct 28, 2009 at 12:00 pm
    Oct 28, 2009 at 12:44 pm
  • Hi All, Any body can explain the difference between socket connection and tcp/ip connection. Thanks, Krishna
    Krishna Chandra PrajapatiKrishna Chandra Prajapati
    Oct 27, 2009 at 4:48 pm
    Oct 27, 2009 at 4:55 pm
  • The socket hets created when you start the server It might be in the mysql home dir, it might be in /var/run. See if its declared in my.cnf Sent via BlackBerry from T-Mobile
    ListsLists
    Oct 27, 2009 at 6:33 am
    Oct 27, 2009 at 10:18 am
  • Hi all I hope someone can help me out here as I am still new with MySQL. I am trying to determine when last a MySQL database was shut down and when last the tables were analyzed. Can someone please ...
    Machiel.richardsMachiel.richards
    Oct 26, 2009 at 7:30 am
    Oct 26, 2009 at 2:50 pm
Group Navigation
period‹ prev | Oct 2009 | next ›
Group Overview
groupmysql @
categoriesmysql
discussions93
posts303
users117
websitemysql.com
irc#mysql

117 users for October 2009

Gavin Towey: 17 posts Michael Dykman: 16 posts Victor Subervi: 11 posts Jerry Schwartz: 10 posts F.A.I.Z.A.L: 9 posts Martijn Tonies: 9 posts John Daisley: 7 posts Prabhat kumar: 7 posts Tompkins Neil: 7 posts Joerg Bruehe: 6 posts Olga Lyashevska: 6 posts Sydney Puente: 6 posts Bryan Cantwell: 5 posts Jaime Crespo Rincón: 5 posts Mark Phillips: 5 posts Patrice Olivier-Wilson: 5 posts Claudio Nanni: 4 posts Jeetendra Ranjan: 4 posts Johan De Meersman: 4 posts John Oliver: 4 posts
show more
Archives