Rating Thread / Thread Starter	Last Post	Replies	Views
Query to show data but ignore dupes i have a database with 500,000 records. one column has the same data over and over. i am trying to get a list of the differnt names in that one... Andrew	08-09-2006 02:51 PM strawberry	3	88
select all users whose emails belong to two or more users Say I wanted to create a query to select all the users whose emails belong to two or more users. How would I go about doing this? Here's what I... yawnmoth	08-09-2006 01:50 PM Bill Karwin	3	76
MySQL and JDBC 4.0 Does anyone know if there are plans to add support for JDBC 4.0 to the MySQL and the java connector? I'm particularly interested in support for... Steven Buroff	08-09-2006 01:46 PM Bill Karwin	1	111
reordering table columns Hi, I have a table and i have added some columns already. Is it possible to rearrange the order of the columns? Thanx. Snef	08-09-2006 12:19 PM Snef	2	95
error 150 i have created 2 tables and want to make a FK between them, ALTER TABLE `icts`.`fact_customer_feedback` ADD CONSTRAINT `FK_fact_customer_feedback_2`... Teng Tao	08-09-2006 03:03 AM Bill Karwin	2	122
'Repair with keycache' on every optimize I tend to optimize all of our tables around once per week. However the last 4 or 5 times I have optimized a particular table it takes take a... Brian Wakem	08-05-2006 06:06 PM Brian Wakem	0	108
joins in mysql Hello, I've read numerous articles on the web advocating avoiding joins in MySQL whenever possible for performance reasons. I was curious as... Marcus	08-05-2006 04:13 PM Bill Karwin	2	118
Query to Find Difference in Greatest and Least Values in Field Hi -- I need to find the highest and lowest entries in a field, and calculate the difference. Can I do this with one query (mysql 4.0.2)? I'm just... BlueBrooke	08-05-2006 12:25 PM BlueBrooke	2	94
user@host length limit in GRANT Hello, is it possible to switch off length limit (16 chars) for username in mysql? I get an error '1145 (42000): The host or user argument to... opio	08-05-2006 12:22 PM strawberry	2	96
ssl on mysql 4.0.x I am trying to get ssl to work with mysql My system is: mysql Ver 12.22 Distrib 4.0.27, for sun-solaris2.9 (sparc) Followed the steps in "5.8.7.4.... AT	08-04-2006 06:39 PM AT	0	93
mySQL and Full Text Search MS SQL 2000 will only do a full text search on one table column - I can't do a full-text search on the text data in two table columns, only... Bill	08-04-2006 05:43 PM Brian Wakem	1	72
Strange MySQL permissions problem I'm trying to setup a MySQL database (foo) and user (bar) that will be used to store the data for a PHPBB website. For security reasons,... JR	08-04-2006 05:17 AM JR	2	71
Stopping Mysql started with mysqld_safe The INSTALL-BINARY file that came with my version of mysql recommends that you start mysql using "bin/mysqld_safe --user=mysql &" which works great... salvador	08-02-2006 03:49 PM Jerry Stuckle	1	107
Order by results of count using 'group by' Hi there, I'm querying a single table with the goal of selecting the number of distinct cities of the field 'city' where the count is greater than... salvador	08-02-2006 02:49 PM salvador	3	82
Re: What file or directory is mysql data stored in? You should use mysqldump to dump data from an old version and the mysql command-line client to restore it to a new version. You didn't say anything... AT	07-31-2006 06:28 PM AT	0	65
Problem Binding Collection Error Hallo i've migrated to Mysql 4 --> mysql 5 I 've an application with adodc. in edit mode view the error: 'binding collection error' wry ??? Popiero	07-31-2006 12:50 PM Popiero	0	81
Using ODBC to connect to remote MySQL server Hi, I have two computers on an LAN. I am trying to connect a client computer to the MySQL server. I have installed unixODBC... Lardy	07-31-2006 12:21 PM Lardy	2	113
Odd Behaviour with select SQL_CALC_FOUND_ROWS I've got a web site in beta testing right now. I've come across a bug that is turning up some strange results. I'm doing a query "select... salvador	07-30-2006 05:31 PM salvador	2	68
help with a SELECT query Hi all, I have tables with columns names containing dots and I'm trying to build up queries as in: select it.n.cuore.1.lemma from a027; But I get... halex2000	07-30-2006 04:34 PM halex2000	2	101
Deletion based on the result of a 3 table right joins select query (MySQL 3.23) Peter H. Coffin wrote: Thanks. I may have a go at the weekend. My log in scripts do use the MySQL PASSWORD() function though. I'll have a think... Steve	07-29-2006 10:02 PM Bill Karwin	4	84
query mutliple tables slow i ran the query below and it takes ages for it to be generated. i ran it on my machine locally aswell as on my web hosting site. is it because there... GTR	07-29-2006 02:08 PM GTR	3	85
To sum them all Hi all: Imagine that I have a table like this one: --------- The firts column has alphanumeric character and the second one only has numbers.... José Carlos Santos	07-29-2006 12:00 PM José Carlos Santos	2	125
ODBC driver for MySql V5 Hi, I am trying to call stored procedures from a legacy VB program written in MS Access into a MySql database. I tried running with the 3.51... Kris Jennings	07-27-2006 09:19 PM Kris Jennings	0	73
List words in fulltext index Hi all, Is there a way to get a list of all the words in a specified fulltext index? I'd like to be able to query the index for instance to get... Ruben van Engelenburg	07-27-2006 09:06 AM Ruben van Engelenburg	0	75
primary key - an email address or autoincrement integer I have a users table, the typical firstname, lastname, phone, email etc.. Will have about 10,000 users. Mostly all selects as opposed to updates,... AT	07-27-2006 07:55 AM AT	3	69
Does mysql++ 2.1.1 work on you comp.? Hello! I use Visual C++ 2005 Express Edition and mysql++2.1.1. Everythink works fine when I'm useing object... AT	07-27-2006 04:38 AM AT	0	95
mysql++ i mysqlpp::Query problem Hello all! I've a problem with mysql++-2.1.1 examples. Compiler compiles properly but when I create Query object program crashes (when it is... AT	07-26-2006 06:02 AM AT	1	90
Design issue with data points of given dates That's a decent idea, although the archival nature of the application means that the current price is no more likely to be searched for than any... Derek Fountain	07-26-2006 04:52 AM Derek Fountain	6	81
data base of countries of Europe and cities I need a data base of countries of Europe (or in its defect of the European Community), its provinces, or districts and the localities that there... Javier	07-26-2006 04:06 AM Brian Wakem	2	86
breaking 1st Normal Form - Design Question Hi, I have to store multiple values of an attribute. I won't be performing any manipulations on these, it will always stay as a list. Do you see any... AT	07-24-2006 11:25 AM AT	0	81
how to define new dataypes Hello, I would like to define a new datatype, the datatype gender should only include either m or f. how can i do this? thank you very much, dennis Dennis Kuntzemann	07-23-2006 11:10 PM Dennis Kuntzemann	0	74
MySql, PHP and Encoding Hi, I'm using mysql 4.0.18 on a web server with PHP 5.1.1 and I'm trying to pass from the iso-8859-1 encoding to utf8, but I'm still confused... Carlone	07-22-2006 09:04 PM Jerry Stuckle	5	91
converting a MySQL 4.1 subquery to something that'll work with MySQL 4.0 Say I have the following SQL query: UPDATE phpbb_users SET user_nthpost = ( SELECT post_time FROM phpbb_posts WHERE phpbb_users.user_id =... yawnmoth	07-22-2006 08:15 PM yawnmoth	0	81
adding a column with data It worked perfectly. Thanks a lot! TB Peter H. Coffin wrote: TB	07-22-2006 02:16 PM Bill Karwin	7	115
Tagging System well, this is not a completely mysql related topic, but i tihnk mysql users/developers might be interested in the topic, so i post here... Q. What... AT	07-22-2006 05:40 AM strawberry	1	121
backups "Peter H. Coffin" <hellsop (AT) ninehells (DOT) com> writes: mysqldump -u root --all-databases > backup.sql locks table after table and thus... Antoine Junod	07-22-2006 03:40 AM Antoine Junod	3	188
Error 1 : Can't create/write to file I'm really not able to resolve this. I have a SELECT...INTO OUTFILE query If I execute it I receive: Error 1 : Can't create/write to file... Luca	07-21-2006 09:54 PM Jerry Stuckle	1	96
MySQL Database not retrieving the full database Hi, I am using MySQL and PHP for my repository. It has 500+ records. till now it was displayiing all records in the database, but since from... AT	07-21-2006 05:34 PM Dikkie Dik	3	89
Anyone using Emacs as a client for MySQL I am still learning to use Emacs, so be kind. ;-) I have been able to use Emacs to edit, run and debug Perl. I can use it to work with C++ and... Ted	07-21-2006 03:06 PM Ted	0	76
programs for SQL Hallo, I'm beginer and I have question, witch program is the best for only SQL ? I work with mySQL dB and I have MySQL Query Browser, but it... uczen	07-21-2006 11:38 AM Martijn Tonies	2	121
Backup a part of a table Hello, what is the recommendet way to backup only the rows of a single table that have i.e. a timestamp older than 5... AT	07-21-2006 07:54 AM AT	2	98
MySQL Database not retrieving the full database Hi, I am using MySQL and PHP for my repository. It has 500+ records. till now it was displayiing all records in the database, but since from... AT	07-20-2006 05:35 AM AT	0	83
Index question... ( 1 2 ) Peter H. Coffin å¯«é“ï¼š this is apply to InnoDB or other DB such as Oracle, not apply to MySQL ISAM table AT	07-20-2006 03:09 AM Kai Ruhnau	16	184
Index selection issue Hi, I have an innodb table with about 8 million rows of data that has several indexes defined. While performing a select MySQL almost always selects... AT	07-19-2006 12:43 PM AT	0	115
my.cnf placement I am told that creating a my.cnf file, with the client's user id and password, and placing it it the user's home directory will provide... Ted	07-18-2006 04:42 PM Ted	0	90
MySql Replication question! Hi all, Rather an abstract question actually, but abstract answers are fine by me! If you had a mysql server that was used as the back end to a... AT	07-18-2006 03:32 PM AT	0	76
Foreign keys tut Hi group, Is there anyone out there that knows a good innoDB/foreign keys tutorial. I read upon it on the mysql site, but i find that information... frizzle	07-18-2006 01:45 PM frizzle	2	109
find null value in any column Hi, Assume I have a table with only 1 row and all column is 'int'. I just wonder is it possible to use SQL to check if any one of those... AT	07-18-2006 01:44 PM Al Balmer	7	84
Read a DB File I Must read a file named pippo.db. Opening the file with a editor I read: WATCOM International Corp., Copyright (c) 1987, 1994 If I remember it... Danilo Giuliani	07-18-2006 12:40 PM Bill Karwin	1	167
Whoops -- character limit per line in Mysql or dodgy debugging on my part? I accidentally posted the following message to mailing.databases.mysql, where I believe it is off-topic, so am reposting here with apologies to the... AT	07-18-2006 12:05 AM salvador	3	88

Page 115 of 128

115

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off