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 330 of 508 Previous 100   Previous 10   321   322   323   324   325   326   327   328   329   330   Next 10   Next 100  

Subject: setting system variables

Do you mean this page <http //dev.mysql.com/doc/mysql/en/Option_files.html >? Michael SGreen@(protected) wrote > Could it be that you have put your variables into the wrong section of > your c

mysqld-nt error 23. Urgent pls

Hi! 4.0.14 on Windows prints a wrong (errno) explanation. You should look at http //dev.mysql.com/doc/mysql/en/Operating_System_error_codes.html " 23 (ERROR_CRC) Data error (cyclic redundancy

ANN: Advanced Data Generator 1.2.5 released!

Dear ladies and gentlemen Upscene Productions is happy to announce a new version of the database developer tool "Advanced Data Generator " (version 1.2.5) A fast test-data generator tool that

Subject: Re: Upgrading mySQL

Warning!! Make sure the php module will handle the new password scheme in 4.1. DBD mysql from AS will not. There are work arounds. I 'm having to fall back to 4.0 because I can 't get .jsp to work

Solaris 8 error make on mysql_4.1.7

Hello. It looks like you don 't have g++ in you path. Check if you have installed g++ or may be you have something like g++-3.xx and there are no symlink to g++. You may specify your compi

syntax question..

----- Original Message ----- From "kalin mintchev " <kalin@(protected) > To <mysql@(protected) > Sent Sunday November 14 2004 6 05 PM Subject syntax question.. > hi everybody.. > > can

Connecting to MySQL using C API

At 21 20 +0000 11/14/04 premal mishra wrote >I 'm using MySQL version 4.0.20a on win98. >Compiler is Bloodshed Dev-C++ version 4. > >My program compiles and links but gives a page fault error on

4.1.7: bug in FT search? (cont.)

Przemyslaw Popielarski <premax@(protected) > wrote > SELECT TYTUL FROM tKsidata > WHERE MATCH (TYTUL) AGAINST ( "space ") > ORDER BY TYTUL > > TYTUL > Shaping Space 2ed > National Air & Space Museum

Subject: Test post to test new client

Hope it works John B -----Original Message----- From Robb Kerr [mailto rkerr.news@(protected)] Sent 14 November 2004 17 35 To mysql@(protected) Subject Test post to test new c

Conditonal where

Stuart Felenstein wrote > --- "Adams Pat 006 " > <AdamsJr.Patrick@(protected) > wrote > > >You could add a where condition that 's always true > >to the main part of > >the SQL statement

Subject: Concatinating Two Columns

I would like to know how I can make two columns out put as one? For Example I have +-------+-------------+----------+-----------+---------+ | AttID | SessionDate | LastName | FirstName | Prese

Subject: 4.1.7: bug in FT search?

SELECT TYTUL FROM tKsidata WHERE MATCH (TYTUL) AGAINST ( "space ") ORDER BY TYTUL TYTUL Shaping Space 2ed National Air & Space Museum Light & Space Free Space Architecture Does Economics Space

Subject: Re: SQL syntax error

--- Jim Winstead <jimw@(protected) > wrote > My point was that you can 't compare a column with an > array > of numbers using the ' ' operator. You have to use > the IN > operator as in the line

Re: Searching a table and replacing all instances of a string with
another

Have you read the page in the manual which documents the string functions <http //dev.mysql.com/doc/mysql/en/String_functions.html >? UPDATE your_table SET name_col REPLACE(name_col 'Pet

How many rows?

Your sample query doesn 't really make sense but perhaps you are looking for SQL_CALC_FOUND_ROWS. From the manual "SQL_CALC_FOUND_ROWS (available in MySQL 4.0.0 and up) tells MySQL to calculate

Subject: Problem with an insert query

In my database I have the following tables +

Help!!! The error message "SELECT in a stored procedure must have INTO "

Hi everyone This is my first project in MySql database. I use VB.Net and OleDb to connect to MySql(5.0.1 alpha-max). When I call the stored produce I get the error message E

Searching a table and replacing all instances of a string with another

Hi All I would like to search through all fields in a table and anytime a search string comes up have it replace it with another string. By way of example let 's say I wanted to replace eve

Subject: Low-end SATA vs. SCSI

Which SATA drive works under LINUX O/S? Kirti -----Original Message----- From Larry Lowry [mailto Larry.Lowry@(protected)] Sent Friday November 12 2004 4 06 PM To Fagyal Csongor mysql@(protected)

Report Designer

Ron Thomas wrote > > What do most people use for a report designer for linux? Perl. ) -- MySQL General Mailing List For list archives http //lists.mysql.com/mysql To unsubscribe

long update query does not replicate correctly (cont.)

Przemyslaw Popielarski wrote > >I 'm executing on master a long and complicated query such > >UPDATE (lots of tables lots of LEFT JOIN) SET ... WHERE . > > > Okey I simplified the query to

Subject: MySQL Database Designer

Hi! I 'm looking for a good graphical database designer supporting the latest stable release of MySQL MyISAM and InnoDB tables and foreign keys. So far there are a lot of products. But I need

long update query does not replicate correctly

I 'm executing on master a long and complicated query such UPDATE (lots of tables lots of LEFT JOIN) SET ... WHERE . The query updates i.e. 3816 rows. The query DOES replicate do master 's and

What 's MYSQL equivalent to Oracle 's TRUNC(date_time_var)?

Look at the DATE() fucntion you can find in the REF Manual of MySQL at URL http //dev.mysql.com/doc/mysql/en/Date_and_time_functions.html Regards Bernard On Friday 12 November 2004 12 14

Searching for an equivalent to the Oracle "POSITION " parameter

While reading http //dev.mysql.com/doc/mysql/en/LOAD_DATA.html I found this passage " If the FIELDS TERMINATED BY and FIELDS ENCLOSED BY values are both empty ( ' ') a fixed-row (non-delimited)

Subject: Forcing repair with sort

I have a semi-large table (about 6GB 27 million records) and an index called LNAME on three of the columns. I am trying to DROP the index to re-create and it is taking over 2 hours (and still g

Three Questions

1. All char 's are automatically changed to varchar whenever there is any field that is not fixed length. This is not a bug or a problem it 's smart design. Fixed length records are great for perfo

ODBC connection

It is my Digital Signature. Sorry that it didn 't come through. J.R. -----Original Message----- From Ferguson Michael [mailto ferguson@(protected)] Sent Friday November 12 2004 11 19 AM

Subject: Milliseconds to date string

Hi Rafal binary is a reserved word you need to quote it with back-ticks ` if you want to use it SELECT s2u.valus as `binary` FROM ... /Johan Rafal Kedziorski wrote > Hi > > I get th

Subject: Help to write a report

Hi all I have the following select select cons_nome as "Consultorio " dent_nome as "Dentista " pac_nome as "Paciente " pac_convenio as "Tipo " Pac_matricula as "Matricula " concat
Page 330 of 508 Previous 100   Previous 10   321   322   323   324   325   326   327   328   329   330   Next 10   Next 100