Sponsored Links

comp.databases.mysql comp.databases.mysql

Page 1 of 115

101

Last »

Threads in Forum : comp.databases.mysql

Forum Tools

Rating Thread / Thread Starter	Last Post	Replies	Views
enabling remote access my.cnf, stops from pid file ( 1 2 ) I changed my.cnf to allow remote access to mysql. This is what I changed: user= root pid-file = /var/run/mysqld.pid socket = /tmp/mysql.sock port =... JRough	07-10-2010 03:22 PM Kees Nuyt	13	178
Any way to get max size of VARCHAR column? Is there any way to get the maximum size of a VARCHAR column? Some function like "COLUMN_WIDTH(columname)", perhaps? LENGTH gives the size of the... John Nagle	07-10-2010 07:07 AM Captain Paralytic	4	34
Re: LOAD INFILES FROM a directory and UPDATE queries JRough <jlrough (AT) yahoo (DOT) com> wrote: Then start reading here: http://dev.mysql.com/doc/refman/5.0/en/load-data.html and make sure you... Doug Miller	07-09-2010 06:35 PM Axel Schwenke	1	22
Whitepaper - Spreadsheet reporting within a BI framework Whitepaper - PDF (No signup Required - Just click or Paste the link) http://www.yellowfin.com.au/Document.i4?DocumentId=109023 Extract Despite all... JTP PR	07-08-2010 08:30 AM JTP PR	0	28
'2010-07-01 00:00:00' vs '2010-07-01' i have two SQL queries: SELECT column_name FROM table_name WHERE column_name >= '2010-07-01 00:00:00' SELECT column_name FROM table_name WHERE... yawnmoth	07-07-2010 09:25 PM Peter H. Coffin	3	36
[Help!] A birthdate selection that's to make more precise.. Hello to all, I'm in trouble :) I've prepared a sql statement extracting the typical ranges of dates from a table of users: 20-25 years old, 25-30... Luk	07-07-2010 03:09 PM Luk	4	39
change mysql from localhost to host name I have been using mysql localhost for testing with php. I want to use my host server for testing on my outside IP for one demo database. In... JRough	07-07-2010 01:53 AM Johannes Keßler	4	33
Re: Are there any MySQL queries or software packages for "findingsimilar items" We, the Senate of Arcturus, take note that Ignoramus12110 said: I'd suggest that you make a dictionary of all the words in the questions, then for... Robert Billing	07-05-2010 04:11 PM Ignoramus12110	2	31
subquery using IN with 2 values ( 1 2 ) Ok, I admit I am over my head. I need to query a table, episodes, returning ptNum, epiNum, ptStmtDir for all rows that have had a transaction in the... bill	07-05-2010 07:58 AM bill	14	45
Stats comp.databases.mysql (last 7 days) "Caveat: Quantity is not necessarily a measure of Quality" Newsgroup.................: comp.databases.mysql Stats Were Taken..........: Mon, 05 Jul... me	07-05-2010 03:36 AM me	0	21
How to SELECT the most approximated value? I have an integer column, and I want to search a value that could not be there. Example column values: 114,54,223,67,187,991 Example search value:... Rafael Patro	07-04-2010 09:54 AM Lennart Jonsson	1	24
filters in the WHERE clause ( 1 2 3 4 ) JRough: Good! This must be a language thing (english is not my native tongue). What does this sentence mean? How do you 'pull' a query? And how... JRough	07-04-2010 08:46 AM JRough	30	95
Data Corruption ( 1 2 ) A client's server is having a problem with a table that gets all records overwritten in the table with the same data. Server info: MySQL 4.1.22 PHP... Tyrone Slothrop	07-02-2010 09:46 AM Tyrone Slothrop	18	68
select parent? ( 1 2 ) Hello, I have the following table: id=int pid=int name=varchar(100) It will hold tree items where 'pid' is the parent id. If zero then the item... lallous	06-30-2010 10:29 AM Lennart Jonsson	19	51
Re: MySQL not designed for LARGE databases? ( 1 2 ) Op 27-6-2010 18:42, Ignoramus12901 schreef: On a 64 bit machine it will probably crash when it reaches the 64 bit 'hard limit'.... I think this is... Luuk	06-30-2010 05:53 AM Bodo	18	63
connection form Excel On 30 June, 05:19, Michael Vilain <vil... (AT) NOspamcop (DOT) net> wrote: No where did they suggest that they didn't have the MySQL... Melody	06-30-2010 03:47 AM Captain Paralytic	2	27
some pointers for database newbie Hi, having quite some experience in programming (mostly C++), I'm just about starting to dig into databases. So far, I found some useful help on... Christof Warlich	06-28-2010 07:47 AM Christof Warlich	3	32
Stats comp.databases.mysql (last 7 days) "Caveat: Quantity is not necessarily a measure of Quality" Newsgroup.................: comp.databases.mysql Stats Were Taken..........: Mon, 28 Jun... me	06-28-2010 03:27 AM me	0	25
commit? On 6/21/2010 10:33 PM, Michael Vilain wrote: If you're doing large batch adds, consider the LOAD DATA command. It's many times faster than doing... SpreadTooThin	06-27-2010 01:02 PM John Nagle	8	45
help with a specific query given the following two tables, i am looking for help writing a query that returns all rows in table the first table along with the data from the... elubin	06-24-2010 03:12 PM Captain Paralytic	6	55
doubt about backup ( 1 2 ) Hi, I've a doubt about the backup method to dump a mysql database. I've tried to dump a database using "Sql export" on Phpmyadmin interface and the... remigio	06-24-2010 09:35 AM Brian Cryer	11	55
C Access 2 questions: - How do I access MySql from within a C/C++ program (without invoking the unix shell, i.e. without calling "system" or "popen"? - How... lalawawa	06-24-2010 02:11 AM Axel Schwenke	3	37
Prepared statement with SET PASSWORD in a stored procedure ( 1 2 ) Having trouble getting this to work ... running MySQL 5.0.51a on Ubuntu 8.04. I'm trying to create a stored procedure using phpMyAdmin. It compiles... Robert Hairgrove	06-23-2010 05:25 PM Peter H. Coffin	18	57
Getting and incorrect key file error ( 1 2 ) I am trying to join 4 different tables. Here's the statement: SELECT profile_image_url, screen_name, url, description, first, last, coName FROM... EastSideDev	06-23-2010 11:21 AM Jerry Stuckle	17	58
Stats comp.databases.mysql (last 7 days) "Caveat: Quantity is not necessarily a measure of Quality" Newsgroup.................: comp.databases.mysql Stats Were Taken..........: Mon, 21 Jun... me	06-21-2010 03:27 AM me	0	30
Get the results in reverse order SM: "Common solution"? You've only received one reply! -- Erick SM	06-21-2010 02:03 AM Erick T. Barkhuis	5	41
Function myschema.HEX doesn't exist??? Has anyone run into this before? Is it documented as expected behavior somewhere, or just a bug? I have a statement like this in a stored procedure... Robert Hairgrove	06-20-2010 05:22 PM Axel Schwenke	3	34
need some help on a UPDATE function How do I change a table column to have NULL default values? This doesn't work: ALTER TABLE cart_order modify column cart_inventory DEFAULT NULL I... JRough	06-20-2010 06:14 AM Captain Paralytic	7	46
Re: DB dump available for download? Tetsuya: How about using a test data generator? http://www.webresourcesdepot.com/test-sample-data-generators/ -- Erick Erick T. Barkhuis	06-19-2010 03:12 AM Luuk	1	35
dump di mysql su lan Ciao, ho un piccolo server mysql realizzato con debian, ora vorrei fare il dump del database mediante contab e mysqldump ma il file risultante... remigio	06-18-2010 06:54 AM Jerry Stuckle	7	50
mysqld_multi correct access over socket, ignores port 3307 Hello, for three days I'm trying to solve my problem. On OpenSuSE 11.1 two MySQL (5.0.67) databases are running. When I try to connect to mysqld2 by... Axel Wild	06-16-2010 01:32 PM Axel Wild	0	24
Create a view from an external database Hi, I need to create a view (internally) from an external database. How could you do this ? Is it possible ? TIA. apolloj	06-16-2010 01:23 PM Robert Hairgrove	5	43
This should be easy This seems like such a simple problem that I feel really stupid even asking. However, I seem to be banging my head against the wall. I have TABLEA... sheldonlg	06-14-2010 12:54 PM Lennart Jonsson	5	43
Not able to create a MySQL connection ( 1 2 ) I created a new user, as follows: mysql> CREATE USER 'masterUser'@'localhost' IDENTIFIED BY 'somepassword'; Query OK, 0 rows affected (0.00... EastSideDev	06-14-2010 10:38 AM EastSideDev	10	63
Stats comp.databases.mysql (last 7 days) "Caveat: Quantity is not necessarily a measure of Quality" Newsgroup.................: comp.databases.mysql Stats Were Taken..........: Mon, 14 Jun... me	06-14-2010 03:29 AM me	0	30
Not able to create a MySQL connection I created a new user, as follows: mysql> CREATE USER 'masterUser'@'localhost' IDENTIFIED BY 'somepassword'; Query OK, 0 rows affected (0.00... EastSideDev	06-12-2010 08:28 PM EastSideDev	0	26
Re: AVG function with LIMIT? Op 12-6-2010 22:15, Jonas Smith schreef: AVG() is not working together with LIMIT; if you have a this: 2 3 4 Luuk	06-12-2010 03:33 PM Jerry Stuckle	2	37
User@host and multiple hostnames Hello, I am quite new to MySql and its 'user'@'host' username approach. If I understand correctly, I can create a user like 'foo@bar' and only user... Federico Cozzi	06-12-2010 04:01 AM The Natural Philosopher	5	47
@mysql_select_db($database) fails Help. Im trying to get MySQL,Apache,PHP working on my system to learn about them. I have succeded in getting Apache and PHP to read and process... Paul	06-12-2010 02:19 AM Kees Nuyt	5	57
updating a date ( 1 2 ) I want to update a date column ('lastPayment) if the transaction date is more recent than the date already in that column for that record. I... bill	06-11-2010 02:28 PM Erick T. Barkhuis	10	44
Need help with sql statement. ( 1 2 ) I have a table of images called ImageTable Each image has a patient id, study uid, series uid, image uid and a filesize. Images are grouped... SpreadTooThin	06-11-2010 12:18 PM SpreadTooThin	10	62
Getting row number following an insert One of the fields in my table is rownum. It is an aut-increment field. When I do an insert into this table, is there a way for me to get the row... EastSideDev	06-11-2010 03:50 AM Captain Paralytic	2	40
SUM and COUNT in the same SELECT query? SELECT some_column, COUNT(another_column), SUM(another_column) FROM table_name GROUP BY some_column Why doesn't that work? If I remove either the... yawnmoth	06-09-2010 08:12 AM The Natural Philosopher	4	49
Unify selects Hi to all, I'm sortof a newbie in MySql (and Sql), so sorry if I'm doing a stupid question. I would like to optimize some Select statements that are... Luk	06-09-2010 05:41 AM Lennart Jonsson	5	36
making mysql query browser apply limits when browsing large tables? If you click on a table in the Schemata tab it'll try to pull every row from that table even if there are, say, millions and millions of rows in it... yawnmoth	06-08-2010 12:04 PM yawnmoth	5	37
Stats comp.databases.mysql (last 7 days) "Caveat: Quantity is not necessarily a measure of Quality" Newsgroup.................: comp.databases.mysql Stats Were Taken..........: Mon, 07 Jun... me	06-07-2010 03:34 AM me	0	36
Can't Start MySQL 5.1 Service on Windows XP SP3 The .err file contains these messages: 100605 14:27:02 Plugin 'FEDERATED' is disabled. C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld:... Joe	06-06-2010 05:11 PM Axel Schwenke	4	47
Alternatives to phpMyAdmin We have users who currently use the desktop client MySQL Query Browser to run adhoc selects and export data. For various reasons we would like to... Todd	06-04-2010 07:25 PM Peter H. Coffin	1	55
Multiple Inserts across multiple tables ( 1 2 ) Hi Guys, After a bit of advice really. We have a number of tables in our database, that when a new account is created it should insert into all of... David	06-04-2010 12:35 PM Captain Paralytic	18	75
reThink Migration – It’s Time for Change! Watch the latest video in the DB2 vs. Oracle series. This one is an animated tale of two peasants from the “Village of Orrible” who want to break... Anil Mahadev	06-03-2010 07:28 AM Jerry Stuckle	1	40

Page 1 of 115

101

Last »

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