dbTalk Databases Forums  

Sponsored Links


comp.databases.mysql comp.databases.mysql


Discuss in the comp.databases.mysql forum.



Post New Thread
Threads in Forum : comp.databases.mysql Forum Tools
  Rating Thread / Thread Starter Last Post Reverse Sort Order    Replies         Views     
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 Go to last post
13 178
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 Go to last post
4 34
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 Go to last post
1 22
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 Go to last post
0 28
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 Go to last post
3 36
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 Go to last post
4 39
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 Go to last post
4 33
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 Go to last post
2 31
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 Go to last post
14 45
"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 Go to last post
0 21
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 Go to last post
1 24
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 Go to last post
30 95
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 Go to last post
18 68
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 Go to last post
19 51
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 Go to last post
18 63
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 Go to last post
2 27
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 Go to last post
3 32
"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 Go to last post
0 25
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 Go to last post
8 45
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 Go to last post
6 55
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 Go to last post
11 55
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 Go to last post
3 37
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 Go to last post
18 57
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 Go to last post
17 58
"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 Go to last post
0 30
SM: "Common solution"? You've only received one reply! -- Erick
SM
06-21-2010 02:03 AM
Erick T. Barkhuis Go to last post
5 41
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 Go to last post
3 34
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 Go to last post
7 46
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 Go to last post
1 35
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 Go to last post
7 50
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 Go to last post
0 24
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 Go to last post
5 43
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 Go to last post
5 43
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 Go to last post
10 63
"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 Go to last post
0 30
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 Go to last post
0 26
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 Go to last post
2 37
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 Go to last post
5 47
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 Go to last post
5 57
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 Go to last post
10 44
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 Go to last post
10 62
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 Go to last post
2 40
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 Go to last post
4 49
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 Go to last post
5 36
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 Go to last post
5 37
"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 Go to last post
0 36
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 Go to last post
4 47
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 Go to last post
1 55
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 Go to last post
18 75
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 Go to last post
1 40
Post New Thread

Display Options
Showing threads 1 to 50 of 5718
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread 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


Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.