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 421 of 508 Previous 100   Previous 10   421   422   423   424   425   426   427   428   429   430   Next 10  

Subject: "MERGE Table Problem "

Hello * reproducable Problem Content of UNION logs_20040608 logs_20040609 logs_20040611 logs_20040612 logs_20040613 logs_20040614 logs_20040615 results 0E0 DBD mysql db do failed Can 't

OS X Version < 4.1 Multithreaded?

I 've heard some recent rumblings that MySQL before 4.1 wasn 't multithreaded on OS X. However in actual usage I see every indication that is IS. Does anyone have a definitive answer either way

Query on Projects Information Grouped by Month

Hi I have two tables in my database. One that holds information on bookings on varous projects for a scheduling system and the other holds project informtaion. Is it possible to produce a

Can 't connect to local MySQL server through socket '/var/run/mysqld/mysqld.s

You better download the binary release from mysql.com and install it. It 's statically linked so it should work fine on all Linuxes. Correctly installed MySQL binary release works fine and general

indexing text

On Friday June 11 2004 7 00 39 AM Csongor wrote FC > Hi FC > I have a table that has a few short text fields [text(4000) text(1000)] FC > I would like to index. Do you think it is a good id

Maximum number of simulatneous connections

venkata ramana <uvramana@(protected) > wrote > What is the maximum number of simulataneous connections > that can exist for MySQL. Can we change this limit? If yes please tell > me how to

Sending multiple queries to MySQL (sorry, hit send by accident!)

Yes you can save using multiple statements. We send hundreds...thousands of statements in a single batch in our machine automation application. The communication cost is relatively fixed (with in

Sending multiple queries to MySQL

Hi I have a situation where within a PHP loop I am creating over one hundred SQL statement (INSERTS and UPDATES). Would it cut any overhead to send 20 " " seperated queries in one mysql_query

Using IF

Hi Keith I think your problem comes down to the fact that IF() is a function that must return one value when you put in your '* ' you might be specifying more then one value to return. /Johan

Compiling 4.0.20 bug on Solaris 8 x86 ( gcc version 2.95.3 20010315 (release) )

Hi Configure run command ./configure \ --prefix ${INSTALL_DIRECTORY} \ --exec-prefix ${INSTALL_DIRECTORY} \ --libexecdir ${INSTALL_DIRECTORY}/bin \

Bug in 4.0.20

Wendell Dingus <wendell@(protected) > wrote > RedHat Enterprise 3WS fully up2date. MySQL binary RPMs for AMD64 won 't even > start for me what were they built on?. I installed the .src.rpm and

MySqldump not giving the right output

Hi I 'm dumping my database with Mysqldump using this command mysqldump --extended-insert --add-drop-table -K --user root xdatab xtable > xtable.sql For a certain number of tables the comma

Can a database be shared between different processes linked with
   the Embedded

Hello All Is it possible to share a database between two processes when using libmysql the embedded version of MySQL? My application will have one writer process and many reader proces

Column 's DataType -- TEXT vs BLOB...

"Scott Fletcher " <SFletcher@(protected) > wrote > I also have another table that use 4 columns of 800 characters along > with 5 columns that use 250 characters. I 'm thinking of using TEXT for > 9

COPY row?

John Try Insert into TABLE Select * from TABLE where TABLEID ? Update TABLE set column 'desired value ' where TABLEID newPK It 's a bit manual but defn the quick and

Updates locking out inserts in transactions for no apparent reason

Hi all This is my first time on the mysql mailing list I appreciate if someone can help me with a major problem I encountered with mysql. I have this weird problem with 1 transaction locking

Can 't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock '

BlankIn just installed mysql 3.23.58 on my debian system. and copied my.conf to /etc/mysql/ I tried to start the the database by >mysqld --user mysql& and it works just fine but as I tried to

mysql 3, subquerie alternative

On Thursday June 10 2004 1 20 03 PM Mark wrote MvB > Hi MvB > For a project I 'm creating a search function the deal is this a select MvB > query must be submitted and in this query a check

Subject: Server optimization issue

"Misao " <misaochankun@(protected) > wrote Take a deep look at http //dev.mysql.com/doc/mysql/en/Server_system_variables.html But ensure that this is MySQL who takes so much memory. Watch other

how mysql sends its data to clients.

Craig Harding <charding@(protected) > wrote MySQL protocol is a binary protocol. Still it 's not encrypted and data could be sniffed. Use MySQL-Max and SSL connections to encrypt data in protocol.

mysqlbindump feature request...

I 'm not sure of the right way to submit these things so I 'll do it here... I want to dump some data form the binlogs and process it back into the servers. However I just want to process the data

Adding replica server in a mixed MyISAM/InnoDB multi-master env?

"Tabor J. Wells " <twells@(protected) > wrote > Is it safe to just shutdown ServerB copy all of the mysql data dir (including > the ibdata files) to ServerC restart ServerB and then change the

Subject: "show table status " problem

Jean The "from jean1 " is looking for a database named "jean1 " it is not the table name. See http //dev.mysql.com/doc/mysql/en/SHOW_TABLE_STATUS.html If you are already conn

Corrupted .MYI file

There are too many reasons for that. Yes users who press "reset " button power outage buggy hardward or OS even corrupted MySQL builds may cause this to happen. Example we often have this ki

Subject: Help with apostrophe and FTS

"Andrea Gangini " <a.gangini@(protected) > wrote > Well yes it 's an option. I really need this functionality. > But on mysql site under source downloads there 's this warning " For > maximum sta

Problem with Merge Table, "ERROR 1016: Can 't open file: '#sql-407f_f.MRG '. (e

Michael Arndt <M.Arndt@(protected) > wrote > a) what could be reason /solution for the following Problem > > ERROR 1016 Can 't open file '#sql-407f_f.MRG '. (errno 144) [egor@(protected)

Last Modified

"Martijn Tonies " <m.tonies@(protected) > wrote > > > > If your table contains a timestamp field it will update each time the > > row > > > > is altered. Otherwise I don 't think it 's possible. > >

How do you display last modified date

Daniel Venturini <Dan@(protected) > wrote > Hello I am using PHP mysql. How would I query mysql to display the last > time a table was last modified/changed/or updated. For example I have a us

A query that groups information by month

Hi I have a table that holds information on bookings for a scheduling system. Is it possible to produce a report that lists total bookings data by month with one query i.e. Jan Feb Mar

Subject: (might be off list) MySQL AB

Hello MC The following is extracted from URL http //dev.mysql.com/doc/mysql/en/What_is_MySQL_AB.html which answers your questions. By the way the ``AB ' ' part of the company name is the acr
Page 421 of 508 Previous 100   Previous 10   421   422   423   424   425   426   427   428   429   430   Next 10