Mailing List
Home
Forum Home
MySQL General - General MySQL discussion
MySQL++ - Programming with the C++ API to MySQL
MaxDB - Everything about MaxDB, formerly known as SAP DB
ODBC - ODBC with the MySQL Connector/ODBC driver
MySQL on Win32 - Runing MySQL on Windows 9x/Me/NT/2000/XP
Java Help - Mostly related to the MySQL Connector/J driver
Perl - Perl support for MySQL with DBI and DBD::mysql
GUI - MySQL GUI Tools
Announcement
Subjects
Subject: mysql openssl Question
ERROR 1045: Access denied for user: 'root@localhost ' (Using
password: NO)
Update one field with more fields from another table
Subject: Getting Identity after INSERT
ERROR 2002: Can 't connect to local MySQL server through socket
mysql test 4 1 fails with the gis test
Subject: MySQL Cluster Software
Downgrade Mysql from 4 to 3 23
Mysql 4 0 Oracle Stored Procedure Trigger Conversion
Can 't access mysql after kernel upgrade
Executing MySQL Commands From Within C Program
Comparing and writing out BLOBS
Subject: Re: Preventing Duplicate Entries
FULLTEXT query format question
Strange behavior, Table Level Permission
Does the binary log enabling affect the MySQL performances?
mysql:it 's a db not a dbms how it 's possible?!
mysql have same function mthod as Oracle decode()
 
MySQL General
Page 131 of 508 Previous 100   Previous 10   131   132   133   134   135   136   137   138   139   140   Next 10   Next 100  

Subject: download link to file

I have a pdfs/documents saved in a field called 'content ' on my db and I want to create an active hyperlink so users can download. any ideas how I can achive this. I am sure it is simple but cannot f

Subject: GROUP_CONCAT() use on query

SELECT * GROUP_CONCAT(DISTINCT language.language SEPARATOR ' ') AS Sprachen FROM item_all_language LEFT JOIN item ON itemitem_identity item.item_identity LEFT JOIN language ON languagelanguage_id

Replication between Mysql 4.1.8-standard and MySql 5.0

Hi Comunity I have a problem while configuring 'Replication '. My Master Database is MySql 4.1.8-standard version and Slave is 5.0. I want to set Replication between them. Problem here is in MySql 4

Timeseries

In the last episode (Apr 29) David Lindelf said > Is there an easy way to get the last timestamped record not later > than a given date/time? > > I record data for a scientific application and I do

Possible?

Ren? Fournier wrote > Simple problem Many client apps need to send data to a server. > > By default each client will open a persistent TCP socket connection to a > common IP address port (10.10.10

Matching fields from two different tables

-Patrick wrote > Folks I could really use your assistance. > Take a look here http //pastebin.com/687889 > > How can I manipulate totalRows_numberComments so that I get the number > of blg_comment

Help with subqueries... MAX() and GROUP BY [sovled]

Well I think this is mostly working. I have a 'NULL ' user ID which is 'system ' that I need to get into here but I think I 'm mostly on track... There are lots of ways to accomplish this task it seems

Streaming LOB Data

Hi! On Apr 28 Robert DiFalco wrote > It appears (for InnoDB at least) that while INSERTing a LOB that all LOB > data must be loaded into memory before it is written to disk. Or is it > just the siz

MySQL PHP Connector

Could you give me MySQL PHP Connector both mysql and mysqli connectors version 5.0.18? Thanks.

Matching Different Tables ' Columns and Rows

Hi I am having the toughest time accomplishing this. I am asking for any examples or links to info pertaining to this as I want to make an effort before posting any code. After matching the specific

Subject: Quick Replication Question

When you have master-slave replication enabled and something goes wrong with one of the tables on the master and you have to run mysqlcheck -r to fix it does the fix get written to the binlog and r

Best column type for latitude / longitude?

Just curious the majority use. I 've been using decimal(18 14) but that appears bigger than necessary... Maybe varchar(21) for latitude and varchar(22) for longitude? ...Rene

Killing MySQL connections on a specific interface from a specific host

On 4/28/06 Dominik Klein <dk@(protected) > wrote > > Hi > > I 'd like to know if there is anything to kill connections from a > specific client ip that came to the server on a specific interface.

Invitation to find out about Freestateprojects.org and join our mailing list

Hi. Came across your work and just thought I 'd send you this intro email about the Free State Projects as we are looking to make connections! Daryl --- This email is to inform you about http //free

~Mysql performance~

On Fri 28 Apr 2006 Mohammed Abdul Azeem wrote > Hi > > I have 2 mysql servers with version 5.0.15-standard-log running on > redhat es4 installed on 2 different geographic locations. The default >

Help with subqueries... MAX() and GROUP BY

> -----Original Message----- > From Alex Arul [mailto alex.lurthu@(protected)] > Sent Thursday April 27 2006 11 28 PM > To Daevid Vincent > Cc mysql@(protected) > Subject Re Help with sub

Subject: Help with subqueries...

vmware reviewit # mysql --version mysql Ver 14.12 Distrib 5.0.19 for pc-linux-gnu (i686) using readline 5.1 Given two tables CREATE TABLE `logs` ( `id` bigint(20) unsigned NOT NULL aut

Problem with bk tree of MySQL 4.1 for two days.

-----BEGIN PGP SIGNED MESSAGE----- Hash SHA1 I have been unable to use the bk client to update my bk trees. I just hangs /usr/local/bin/bk-update bk //mysql.bkbits.net/mysql-4.1 mysql-4.1 I usua

Can I select from remote tables in mysql 5.0.18-standard-log?

On 4/27/06 P. Evans <pevansdba@(protected) > wrote > > Hello Listers > Is it possible to run a query on one mysql server to another database on > a different server ? > eg creating an alias in databa

Can I select from remote tables in mysql 5.0.18-standard-log?

At 14 38 -0700 4/27/06 P. Evans wrote >Hello Listers > Is it possible to run a query on one mysql server to another >database on a different server ? > eg creating an alias in database A on s

selecting all records inserted last 1 minutes?

At 20 52 +0200 4/27/06 afan@(protected) wrote >Hi >I was trying to list all registeed users they are "online " last 15 minutes. >I can do it by using timestamp > > <?php >$current_time time() >$star

How to select the last entry per item

Brian > Hi > > I hope this is the right list for this question. If not I 'm happy > to get help on where to post this question. Apologies in advance if > this is an old question. > > We are designi

Subject: Multiple primary keys

MySQL will not use the primary key unless you use the left most columns. For a 1 column primary key then it 's easy. For a 2 column primary key you can either use the 1st column in the primary key or

Update not working in a script, but going fine running with MySQL Browser

--655616-436608764-1146146436 26013 Content-Type TEXT/PLAIN charset iso-8859-1 Content-Transfer-Encoding 8BIT Hi Luis. It sounds like your script may not be initialising those two variables cor

HELP --- Slow SP

> > CREATE TABLE `his_msisdn_imei_activ_hist` ( > > `MSISDN` varchar(23) NOT NULL > > `ACTIV_IMEI` varchar(20) NOT NULL > > `ACTIV_PHONE_TYPE` varchar(100) NOT NULL > > `PREV_IMEI` varchar(20) def

Consenus on best column type for Latitude / Longitude?

Just curious the majority use. I 've been using decimal(18 14) but that appears bigger than necessary... Maybe varcar(21) for latitude and varchar(22) for longitude? ...Rene

VIEW not working with myODBC in XP and Access 2003

I have a critical problem that I hope there is a simple solution for. I 've just spent a couple days converting a very messy "hack " to populate a table using a much more elegant VIEW solution now. Ev

Subject: Out of memory (Needed xxx ...

Hi Robert are you using the extended parameters to increase the jvm heap memory ? ie. java -Xms256m -Xmx512m .... Carlos On 4/26/06 Robert DiFalco <rdifalco@(protected) > wrote > > Getting thi

Alternate forms of given name, lookup table

Does anyone know where I mind find a table to look up alternate forms of a certain given name? For example if I give it Bob it gives me Robert and if I give it Bill it gives me Will and William. Or

DBManager Professional 3.3.0

DBTools Software is pleased to announce the availability of the new DBManager Professional 3.3.0 Enterprise Edition. This release brings a lot of new features and lots of improvements and bug fixes. S
Page 131 of 508 Previous 100   Previous 10   131   132   133   134   135   136   137   138   139   140   Next 10   Next 100