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 477 of 508 Previous 100   Previous 10   471   472   473   474   475   476   477   478   479   480   Next 10  

nested transactions

TO <tofu_optimist@(protected) > wrote > Does INNODB support nested transactions? If so what version? No InnoDB doesn 't support nested transactions. -- For technical support contracts go

FULLTEXT query format question

Hi! On Mar 21 Shane Allen wrote > I 've read through the boolean mode fulltext docs and they address all > my questions well except how searches containing exact phrases are > handled when t

SQL Group by months, return all months even if zero

In article <01e901c40fe0$e581da80$c90010ac@(protected) > "Terence " <terence@(protected) > writes > Hi > Is there a short way to return the results from a query grouped by months > and retur

Reduce Log Level?

"Michael B Allen " <mba2000@(protected) > wrote > For some reason mysql is logging every sql statement. I don 't recall > turning on such a thing. Can someone tell me how to turn that down/off. It > s

Executing MySQL Commands From Within C Program

I am attempting to interface between a simple C program and MySQL but without luck. I searched the MySQLforum archives to see if there was info specific to this problem. While there were other f

Strange behavior, Table Level Permission

Udbhav Shah <udbhav4me@(protected) > wrote > > Using Mysql 4.1.1-alpha release on RH9 > I have used RPM provided on Mysql site to upgrade from > 3.23 to 4.1.1 > > I have a very strange behavior

Subject: Re: Preventing Duplicate Entries

Is it possible to use a primary key to avoid duplicates? The reaction to duplicate rows will depend on what type of statement you are issuing. An update/delete would update/delete all rows that are

AW: retrieving last record for all distinct users

If I 've understood you what I want then MySQL time functions can help. It is always possible to substract time with MySQL. So if you substract the value of your column "TIMESTAMP " from current time

ezmlm warning

Hi! This is the ezmlm program. I 'm managing the mysql@(protected) mailing list. I 'm working for my owner who can be reached at mysql-owner@(protected) Messages to you from the mysq

Batch table structure update tool

Hi I 'm looking for a tool (program library) which given a file describing the structure of the tables in a database could update the structure of those tables i.e. create new table add fields

accessing MySQL from VB6 application ( without ODBC )

Hi I 've succesfully connected to MySQL from a VB .NET application using a MySQLDriverCS I 'm now looking for the same thing but on a Visual Basic 6 environment. For a number of reasons ( the fi

*very* strange...

At 01 30 AM 3/20/2004 you wrote > > insert into table (username password) values ( 'username ' 'password ') > > > > Skip out the "username " and "password " part. What you are ending up > > doin

memory usage probs

Hi I 've been having problems with segfaults under mod_auth_mysql in Apache 1.3 which I think i 've narrowed down to the MYSQL connection structure getting corrupted on my particular mysql instal

PHP MYSQL DWMX04 can 't link tables

Hello and I hope to god someone in here can answer my question as I am at my wits end. System Mysql 4xx php 4.3x DWMX 2004 phpMyadmin 2.5 WinXP Pro IIS Will be uploading to a unix serv

Comparing and writing out BLOBS

I had posted the following code in the plusplus mailing list but it was suggested I post this question in this list instead. I 've been writing a test program using the MySQL C API to test the r

Guru 's advice needed ........[Security: SQL injection]

This reply has two purposes. Firstly a small suggestion (modest compared to the others which will follow no doubt!) - check out mysql_escape_string() - this may be useful to you. Secondly a

newbie: increment an existing record

miasmo@(protected) wrote > Is there a mysql command that will increment the value of a field in an > existing row? I would think this would be pretty basic but I can 't seem > to find anything

Can 't access mysql after kernel upgrade

James Packham wrote > Hi all. > > I 've just upgraded the kernel on my server from v. 2.4.21 to 2.4.25 (The > original had some problems) but now I can 't access my database ( If I > revert bac

Select Performance

At 05 32 PM 6/22/2005 you wrote >Hi > >I use MySQL for years with very much respect of it 's stability and >performance. >But in these years one of my servers has grown to several hundreds of

Problems with 4.0.18 and mysqldump

Jochen Kaechelin wrote > > >/usr/bin/mysqldump Got error 2003 Can 't connect to MySQL > > >server on '212.87.142.236 ' (111) when trying to connect > > > > > > > > >Permissions are ok and I can modify th

How can I upload dumped data (fwd)

Hi List Once I have dumped my database using mysqldump how can I upload the data again using the mysql command line (MySQL in ansi mode)? Thanks. -- Andre Matos amatos@(protected)

Subject: Re: SQL To Change Last Approvers

>You could use a temporary table for that >CREATE TEMPORARY TABLE tmp ( > deptID INT NOT NULL > appSeq INT NOT NULL >) AS >SELECT deptID max(appSeq) AS appSeq >FROM approvers >GROUP BY d

--replicate-do-table usage example

Andrew Pasetti wrote > I 'm a bit new to mysql replication. Can someone please > explain how to implement the --replicate-do-table > start up option? > > Replication is up and running but I wou

Subject: How can I upload dumped data

Andre MATOS <amatos@(protected) > wrote > Hi List > > Once I have dumped my database using mysqldump how can I upload the data > again using the mysql command line (MySQL in ansi mode)?

server backups

All I 'm new to mysql. I 'm interested in writing a cron job to backup mysql that will - Backup all the global information first (users and groups typically) - Backup each database independ

JVM unable to access MySQL intermittently?

-----BEGIN PGP SIGNED MESSAGE----- Hash SHA1 Eric B. wrote > Hi > > I 'm running into a strange problem with my JVM and MySQL. I 'm using > Macromedia JRun 4 as my JVM and everytime I rest

alter table tt union=(t1,t2,t3);

On Monday 22 March 2004 18 26 Shane Nelson wrote > Thanks the help file cleared up the rest. > > In my case the table tt wasn 't a merge table it was just a table I > created normally. Even so

Key Buffer Size

Hi Terence key_buffer_size is the amount of memory that is used to cache your index tables. If you are using 100% of it most of the time you may benefit from an increase in it if you can affor

Subject: SQL wrapper for MySQL

> > Is there a program/project/software suite out there that traps/wraps MS SQL > commands (or database calls/commands/etc) and wraps that into MySQL > commands? I 'd like to "trick " a program that

AddressBook CMS

Let me ask a few more questions before making any attempt to say anything else. Once I understand your requirements better I may not be able to say anything useful but hopefully others on this li
Page 477 of 508 Previous 100   Previous 10   471   472   473   474   475   476   477   478   479   480   Next 10