Re: MySQL 3.23.44 not using indexes

Steven Roussey wrote: Are the tables defined the same on both servers? Yes, the tables are defined exactly the same. Is the data the same? Just about. The data on the working server is a copy of the database on the broken server. For previous tests I used a several-weeks-old copy of the

Triggers

Hello All, Is Mysql supports sql triggers ...??.. Is anyone know this pls tell me.. Thanks in advance Uma - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

RE: Triggers

I think this is some thing that should be in on V4.1... Have a look at things to do on the site Simon -Original Message- From: Uma Shankari T. [mailto:[EMAIL PROTECTED]] Sent: 24 April 2002 08:28 To: [EMAIL PROTECTED] Subject: Triggers Hello All, Is Mysql supports sql

RE: Triggers

Uma I asked MySQL the same question earlier this week and got the following answer : Cameron, Actually Stored procedures and triggers will be in version 5.0, which is planned for release by end of year. Current development is underway. A stable version of 5.0 will likely be in Q1 of 2003, but

Re: Slow Shutdown with NET STOP MYSQL

At 14:41 23/04/02 -0500, Dave Butler wrote: Hi! I have version 3.23.41-max-debug running on Windows 2000 SP2. I have MySQL installed as a service and can use NET START MYSQL and NET STOP MYSQL to start and stop the server. One unusual item is that it takes about 30 seconds Yes in this server

Bug MySQL?

Hi I'm trying to extract data from 2 tables (A and B) with a subquery A has the fields (ID_person, name) B has the fields (ID_person,ID_country) This is my query select * from A where A.id_person IN (select B.id from B where B.ID_country =7) But I receive a message error. If I try to run each

Re: Bug MySQL?

Hi I'm trying to extract data from 2 tables (A and B) with a subquery A has the fields (ID_person, name) B has the fields (ID_person,ID_country) This is my query select * from A where A.id_person IN (select B.id from B where B.ID_country =7) Subqueries are not supported in mysql

Re: problem with libmysqlclient_r.so

Hi! Andrey Kotrekhov writes: my program crash in another plase (gdb) bt #0 _db_enter_ (_func_=0x280fe4dc mysql_ping, _file_=0x280fdd48 libmysql.c, _line_=2248, _sfunc_=0xbfa87d3c, _sfile_=0xbfa87d40, _slevel_=0xbfa87d44, _sframep_=0xbfa87d48) at dbug.c:712 #1

mysql thread resource control?

Hello list, Is it possible to limit the mysql thread resource? Say, when there is a heavy-load query, it will not use 99% of the cpu time and afect other system processes. Idea? -- Patrick Hsieh [EMAIL PROTECTED] GPG public key http://pahud.net/pubkeys/pahudatpahud.gpg

USING INDEX

Hello mysql, Why sum() influences use of indexes for the table ac (tblAccountActivity) mysql EXPLAIN - SELECT - c.CustomerID, c.CompanyName, - c.ContactFirstName, c.ContactLastName, c.BillAddress1, - c.MobilPhone, c.WorkPhone, c.HomePhone, - sum(ac.Credit),

Re: New Setup

Hi, After installing mySQL, you ran mysql_install_db.sh script ? Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From:

Mysql users setup.

Hello all! I am just starting out with learning mysql and I have run into some speed bumps that are mostly my configuration. I have set up mysql running on a Mac OS X box with php running a particular software package called phpESP. Works great (a bit slow, but great). Now, in order to

RE: innodb problem (with JDBC/transactions)

Hi, We are currently facing the same problem (Deadlock found when trying to get lock; Try restarting transaction) in our production environnement. We are using InnoDB tables (mysqk 3.23.48-max) with Jboss 2.4.4 and JDBC driver mm.mysql-2.0.11-bin.jar / RedHat 7.1. Could you please tell me how to

RE: Mysql users setup.

Look in db mysql.user to see what users can do what. GRANT ALL ON *.* TO user@% IDENTIFIED BY password; Simon -Original Message- From: Unix Newbie [mailto:[EMAIL PROTECTED]] Sent: 24 April 2002 10:15 To: [EMAIL PROTECTED] Subject: Mysql users setup. Hello all! I am just

Max Numero de tablas.....

Hola y de antemano gracias. Bueno me es de suma importancia conocer el maximo numero de tablas que puede soportar mysql si lo tiene... Gracias William. _ MSN Photos es la manera más sencilla de compartir e imprimir sus fotos:

RE: Mysql users setup.

Thanks for the quick reply Simon! I checked in the file, and just as you said the info was there. No, I actually solved the problem myself shortly after setting up phpMyAdmin from sourceforge.net Top notch little software package there(free too)! For newbies like me, it works out great,

RE: table lock - which connection id own's it

Hi! Lopez == Lopez David E-r9374c [EMAIL PROTECTED] writes: cut Lopez If no row is returned, then the following happens: Lopez 1) lock table ... Lopez 2) select ... Lopez 3) if no row is returned, Lopez 4)insert ... Lopez 5)use LAST_INSERT_ID() to get the value of the key

Re: 3.23.50 client needs IP addresses

rob, Tuesday, April 23, 2002, 11:46:00 PM, you wrote: rDescription: r mysql client from 3.23.50 won't connect to older servers running on remote hosts unless you specify the host as an IP address: r ERROR 2005: Unknown MySQL Server Host 'xxx' (2) Submitter-Id: submitter ID Originator:

Re: New Setup

Ian, Wednesday, April 24, 2002, 5:04:15 AM, you wrote: IP Using the commands you have offered... Egor Your 'root' user doesn't have GRANT privilege ... Egor Egor You should change Grant_priv to 'Y' Egor You can do this using UPDATE statement: Egor UPDATE user SET Grant_priv='Y' WHERE

Deadlock errors with BDB tables

Hi, I'm trying to run two separate programs which connect to a single MySQL database and attempt to perform transactions on its BDB tables. I'm running MySQL 3.23.49a Max on Windows (NT4). The two programs in question are both Windows Services written in Perl (5.6.1), and they are using

Re: 3.23.50 client needs IP addresses

[EMAIL PROTECTED] writes: Description: mysql client from 3.23.50 won't connect to older servers running on remote hosts unless you specify the host as an IP address: ERROR 2005: Unknown MySQL Server Host 'xxx' (2) Submitter-Id:submitter ID Originator: Rob Steele Organization:

Re: Max Numero de tablas.....

On Wed, 24 Apr 2002, Robinson Silva wrote: Bueno me es de suma importancia conocer el maximo numero de tablas que puede soportar mysql si lo tiene... William, assuming you use the MyIsam table type this depends of your operating system. A table consists of 3 files. When the number of your

Re: compile problem with 3.23.50

[EMAIL PROTECTED] writes: Description: I get the following error: c++ -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME=\/usr\ - DDATADIR=\/var/lib/mysql\ -DSHAREDIR=\/usr/share/mysql\ -DHAVE_CONFIG_H -I../bdb/build_unix

Re: problem with libmysqlclient_r.so

Andrey Kotrekhov writes: Hi! % g++ -v Using builtin specs. gcc version 2.95.3 20010315 (release) [FreeBSD] And libstdc++ is include in compiller How can I see version of libstdc++ ? In /usr/src/contrib/libstdc++/Makefile.in I see VERSION = 2.10.0 INTERFACE = 3 Is there right?

temporary tables...

Hello, Is there a way of checking if a temporary table exists? I've been using show tables like '%tablename%' to see if an ordinary table exists.. but show table wont display temporary tables so this wont work.. any suggestions? // Leif Högberg And so the spam filter will let this through: SQL

Re: Erwin Vs Mysql ....

Try MyODBC from the downloads page at www.mysql.com. Erwin works fine for reverse engineering databases, on forward engineering I do have to make some patchs by hand to script before I can generate a model. Maybe I need to learn to use Erwin better. Also if you have a support contract please

Re: compile problem with 3.23.50

On Wed, Apr 24, 2002 at 02:27:40PM +0300, Sinisa Milivojevic wrote: mysqld.cc:2428: at this point in file /usr/include/tcpd.h:119: too few arguments to function `int hosts_access(request _info *)' mysqld.cc:2429: at this point in file /usr/include/tcpd.h:153: too few arguments to

uppercase for first letter

sql,query Hi, How could I turn the first letter of each entry to Uppercase letter? the UCASE turns each and every letter and all I need is the first one to be changed JAri Mäkelä - Before posting, please check:

Unable to get lock on tables for 4.0.1

I have encountered a problem with MySQL 4.0.0 and 4.0.1 in which I am unable to bet a lock on a table with any userid except root. Here is my environment: Sun 450 Solaris 2.8 MyISAM tables Any ideas on how this problem could be solved? Thanks, Nick Gilliam

Re: REPLACE() wildcards

Gavin, Tuesday, April 23, 2002, 7:24:14 PM, you wrote: GM When using the REPLACE() function in a query, are there any wildcards GM allowed? If so what are they? Nope. GM Also are regular expressions only usable for matching or can one also do a GM regular expression substitute in some way?

Re: Re: MySQL start

Samuel, Tuesday, April 23, 2002, 8:55:00 PM, you wrote: SM Victoria Reznichenko Samuel, Tuesday, April 23, 2002, 4:04:20 PM, you wrote: SM file serwer.err: SM 020422 19:16:29 mysqld started SM 020422 19:16:32 /usr/libexec/mysqld: Table 'mysql.host' doesn't exist SM 020422 19:16:32

MySql-PHP-Zlib-LIBJPEG-GD

Greetings all, Special greetings to Nathan,Andrew and Jan for previous help. I have some new problems ( big surprise! ) some of which will seem stupid for sure but i'm using the excuse of being a newbie..so i should be forgiven :-). 1.Like i said before I am running Apache,PHP and MySql on a

Re: uppercase for first letter

If you can't do it within MySQL (I don't know the answer to that one) you might be able to dump the information to a text file and process it using awk and then reload it. Awk is perfect for this kind of thing. There is a Windows version, if that is your OS. On Wednesday 24 April 2002 08:49

Re: uppercase for first letter

Use the application that you are using to save the information into the database to verify that the first letter of each entry is uppercase. I know for a fact that this can be done with perl, VB, c/c++, php, asp, javascript, and java. I have found that sometimes it is better to let the

average function in mysql

hi, can any one tell me if there is any function to get the average of some values in the mysql database. tnx plz mail to [EMAIL PROTECTED] bobbie __ Do You Yahoo!? Yahoo! Games - play chess, backgammon, pool and more http://games.yahoo.com/

RE: uppercase for first letter

* Jari Mäkelä How could I turn the first letter of each entry to Uppercase letter? the UCASE turns each and every letter and all I need is the first one to be changed You can use a combination of UCASE(), MID() and CONCAT(): SELECT CONCAT(UCASE(MID(name,1,1)),MID(name,2)) AS name FROM

Re: MySql-PHP-Zlib-LIBJPEG-GD

Hi Jumac, Jumac wrote: Greetings all, Special greetings to Nathan,Andrew and Jan for previous help. I have some new problems ( big surprise! ) some of which will seem stupid for sure but i'm using the excuse of being a newbie..so i should be forgiven :-). 1.Like i said before I am

RE: average function in mysql

* bob nt can any one tell me if there is any function to get the average of some values in the mysql database. Yes, the AVG() function: URL: http://www.mysql.com/doc/G/r/Group_by_functions.html -- Roger - Before posting,

Fw: MySql-PHP-Zlib-LIBJPEG-GD

Do you use phpadmin? If not download it. The first task is pretty simple with that. Download from www.phpwizard.net - Joseph Jude www.cephire.com - Original Message - From: Jumac To: [EMAIL PROTECTED] Sent: Thursday, April 25, 2002 3:36 AM

query returns a BLOB for no reason....

I am hoping someone can shed light on this for me. We have a fairly simple query that is pulling data from numeric fields and concatenating the field contents into a single results column. The problem is the resulting data is reported to be BLOB instead of the expected concatenated

last_insert_id() query

Hi, I have a big problem with last_insert_id() query. I am adding records to a table with about half a million records in it. The insert takes well under a second. I then call last_insert_id as I need to make a link to another table. The last_insert_id takes around 2 minutes!!! Yes

Fw: user problem

I have mysql installed on a linux platform. I have no problem running every thing as root. When I try to run mysql as a user other than root, I entered command use mysql. I get error 1044:access denied for user:localhost to database 'mysql'. is there a file that I need to change the

RE: user problem

If you are ruing as user mysql do chown -R root /usr/local/mysql chown -R mysql /usr/local/mysql/var chgrp -R mysql /usr/local/mysql Change to sute tast (or what you database is) Simon -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 24 April 2002 13:51

Re: Fw: user problem

Create a mysql user using phpMyAdmin or using the best way you find! I thing that using phpMyAdmin is the most user-friendly way to do it! mysql will ask you to give permisions on that user. Give any permission you would like and that's all! On Wed, 24 Apr 2002 [EMAIL PROTECTED] wrote:

Re: average function in mysql

bob, Wednesday, April 24, 2002, 4:28:12 PM, you wrote: bn can any one tell me if there is any function to get bn the average of some values in the mysql database. Sure, take a look at AVG() function: http://www.mysql.com/doc/G/r/Group_by_functions.html bn tnx bn plz mail to [EMAIL

Re: Unable to get lock on tables for 4.0.1

Nick, Wednesday, April 24, 2002, 3:59:26 PM, you wrote: NG I have encountered a problem with MySQL 4.0.0 and 4.0.1 in which I am NG unable to bet a lock on a table with any userid except root. NG Here is my environment: NG Sun 450 NG Solaris 2.8 NG MyISAM tables NG Any ideas on how this

Problem installing Msql-Mysql module

I've installed MySQL 2.23.49 on Solaris 2.7. I've downloaded the binary installation (mysql-3.23.49-sun-solaris2.7-sparc). I'm using gcc 2.95.3 and make 3.78.1, both downloaded from SunFreeware site (gcc-2.95.3-sol7-sparc-local and make-3.78.1-sol7-sparc-local). I've installed the modules

temporary tables

Hi, Does it make sense to use temporary tables as a substitute for Views? Where do I look in the docs for info? Thanks. Mysql. Andrew Hazen, O.C.P. E-Commerce Developer Jatech Solutions Inc. www.jatech.ca Specializing in OSCOMMERCE applications and PHP/MySQL programming.

connection delphi 6 / ADO with the mysql

I am needing to do a connection delphi 6 / ADO with the mysql that is in a linux Freebsd of the qmail. Does anybody know as I can make that? Thankful, Marcos Birro Calixto [EMAIL PROTECTED] Webmaster - WebDeveloper - Delphi UIN: 9151558

QUICK QUESTION: Referencing MySQL

What year was the web page http://www.mysql.com/doc/S/t/Standards.html created/updated. Exact month and day would be helpful if it is available. I am referencing this page in an assignment and a year would be useful. Your thoughts. Thanks lots David Ayliffe ICQ# 125646758 Query, table,

configure probleem

I try to install mysql on a sparc 250 / solaris 7. I have problem when I come at the configure step : I don't have a configure program on my computer. With a find, I find one on the /usr/local/share/libtool/libltdl directory but when I try to use it, I receive a message : can not find sources in

Mysql benchmark

There are tools for benchmark on win32 via ODBC ? I would like to test sql query in my VB6 application. Thank you. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

MySql installation - DB dies

Having followed instructions from various sources and installed from source (twice) and binary (once), I still get the following problem. --- [root mysql]# /usr/local/mysql/bin/safe_mysqld [1] 16168 [root mysql]# Starting mysqld daemon with databases from /usr/local/mysql/var

undefined function: mysql_connect()

Hello, i'm trying to use PHP4 and MySQL and i'm getting undefined function: mysql_connect() both PHP and MySQL are working on their own, but i have something missing form the PHP setup where it doesn't recognise MySQL. I'd really appreciate any help.

MySQL using Cygwin DLL on Windows?

Hi, all: I read the document, it says MySQL Server runs as a native Windows application and You will need VC++ 6.0 compiler for MySQL Windows source distribution. But we I try to download Windows binary package, it says Since mysqlc contains Cygwin runtime DLLs, we also offer you the Cygwin

Re: undefined function: mysql_connect()

TK Hello, i'm trying to use PHP4 and MySQL and i'm getting undefined function: TK mysql_connect() This question belongs on a/the PHP mailing list, but the answer is that you need to compiled PHP --with-mysql. Please read the PHP installation instructions in the very handy manual at

Problem installation.

Hello: My name is Gerardo Hernandez, in last time I triying installation MySQL in one machine with IBM/AIX 4.3.3.10, but when running createUser.sh show me message below: Could not load program mysql: Dependent module libmysqlclient.a could not be loaded. Could not load module

Re: MySql installation - DB dies - SOLVED

Opps sorry. Found the problem. Not starting as proper user. Thanks. D. -- On Wed, 24 April 2002, D Okonkwo wrote: Having followed instructions from various sources and installed from source (twice) and binary (once), I still get the following problem. --- [root

Re: MySQL with Delphi 5.0

Hi, Did you use dbexpmysql.dll(not dbexpmys.dll) ? Alexander Burbello wrote: I tryed to use Delphi 6.0 and dbExpress, but I didn't got. What component and what property I have to set for use correct?? Regards Alexander -- Mensagem Original -- Hi, Haroldo Is it first

Re: MySql installation - DB dies

D, Wednesday, April 24, 2002, 6:16:31 PM, you wrote: DO Having followed instructions from various sources and installed from source (twice) and binary (once), I still get the following problem. DO --- DO [root mysql]# /usr/local/mysql/bin/safe_mysqld DO [1] 16168 DO [root

Re: undefined function: mysql_connect()

Tewfic, Wednesday, April 24, 2002, 6:14:58 PM, you wrote: TK Hello, i'm trying to use PHP4 and MySQL and i'm getting undefined function: TK mysql_connect() TK both PHP and MySQL are working on their own, but i have something missing TK form the PHP setup where it doesn't recognise MySQL. It

need help for REPLICATION

Hello, I am new in mysql, and I am trying to set an reclication. I followed the instruction in the manual but steel I have a problem. The problem is that even the replication thread works on my slave it is not doing eny updates. The master.info file is updating every minute and there is not

Multiple MySQL servers same computer

Is there any way to be a slave to multiple masters from a single instance of a mysql server? If not, I suppose we can run multiple instances of mysql server, each with its own data directory and reading its own my.cnf file ( which I dont think would be too hard to do on a linux pc BUT) How

mysqlgui and DNS

I'm having a couple of problems running mysqlgui on Windows XP Pro. 1) Intermittent 1 - 2 second delays on connecting and executing queries 2) 30 second delay on connecting and occasionally when executing queries when a dial-up connection is present The problems appear to be related to DNS

Re: mysqlgui and DNS

John Derrick writes: I'm having a couple of problems running mysqlgui on Windows XP Pro. 1) Intermittent 1 - 2 second delays on connecting and executing queries 2) 30 second delay on connecting and occasionally when executing queries when a dial-up connection is present [skip] Is

sql command to examine blob data?

What sql function can I use to examine blob in a table. I need to display part of the blob in hex values. Shouldn't the following sql command work : select hex(substring(col1,1,10)) from table tbl1; Thanks - Before posting,

question

Hello, I am trying to transfer tables/data from one server to another, say server A to B. mysqldmup helps me to dump table structure and data from server A. Wonder what command I should use to load those dump result into server B. Both server A and B are using the same version of MySQL. Any

RE: I thought MySQL Supported Relationships

At 06:04 PM 23/04/2002 -0700, you wrote: http://www.google.com/search?hl=enq=Views+Mysql ... MySQL Manual | 1.7.4.6 Views ... It is planned to implement views in MySQL Server around Version 4.1. Views are mostly useful for letting users access a set of

Re: Unable to get lock on tables for 4.0.1

Egor Egorov wrote: Nick, Wednesday, April 24, 2002, 3:59:26 PM, you wrote: NG I have encountered a problem with MySQL 4.0.0 and 4.0.1 in which I am NG unable to bet a lock on a table with any userid except root. NG Here is my environment: NG Sun 450 NG Solaris 2.8 NG MyISAM tables NG Any

Re: question

Easy, =) mysqldump database name -ppassword | mysql database name -h 192.168.1.1 -ppassword That will dump the database and remotely insert in to the other server. -Jason On Wed, 2002-04-24 at 13:46, Andrew Chan wrote: Hello, I am trying to transfer tables/data from one server to

mysqlgui

To whom it may concern, Where can i find the documentation for mysqlgui? thanks bd - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To

Re: mysqlgui and DNS

Thanks for the reply. Using the IP address in the host field does not fix the problem, however. The delay in problem 1 changes from 1 - 2 seconds to 10 seconds. No impact on problem 2. Do I need to change the parameters to the server? - Original Message - From: Sinisa Milivojevic [EMAIL

Re: question

Basically these two servers are not connected to each other. Also I am using win2k. I believe the syntax that you give me is in Unix. So I am thinking I should use the dump text file sorry not providing enough info... Thanks thought. Andrew - Original Message - From: Jason Yates

replication

Hi, Setting an replication for the first time, I get the following error message in my slave: 020424 13:59:28 Slave: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'FIRST' at position 4 020424 13:59:29 Slave: did not get the expected error running query from

OSX Mysqladmin and Cron

I set up a script to rotate my logs for mysql and cron fires it off perfectly the logs are rotated but when the shell script gets to the last line which is... mysqladmin -u usernam -pPassword flush-logs it will not execute it - my file that logs the execution of the cron script says it doesn't

 character

Does anyone know if there is a way to preserve the  trademark character when importing it into to MySQL? Using Lasso 5 I can add it through a form submission and retrieve it in tact, so there must be a way... I am using LOAD DATA to import my text file... --

delta between rows?

To Mysql Team how can I generate a list of deltas between columns in different rows for the entire table? what I need is an sql command that does something like this: for N =0 to i do : select colA of current rowN - colA of pervious row(N-1) from tab1; ColA = floating point number. Thanks

RE: Erwin Vs Mysql ....

Ken, Thanks for your help. I got it working. For now I needed to reverse engineer the database. The trickier part was the username and password. I initially gave mysql login name. But actually you have to give either DB owner or root. Unfortunately we do not have support contract. Somebody

C API Question

In the MYSQL struct in the C API, how does one access the MYSQL_FIELD data? for example, and MYSQL struct has MYSQL_FIELD *fields; as a member variable. However, when I try to access any of the variables within fields for example, mysql.fields[0].name, I get a segmentation fault. Does anyone

Re: last_insert_id() query

Don't include a from clause with the last_insert_id(), or you will get a full table scan. The last_insert_id will only give you the insert id for the last record inserted. mysql mailing list user wrote: Hi, I have a big problem with last_insert_id() query. I am adding records to a table

Re: New Setup

At 12:04 PM 24/04/2002 +1000, you wrote: Using the commands you have offered... Egor Your 'root' user doesn't have GRANT privilege ... Egor Egor You should change Grant_priv to 'Y' Egor You can do this using UPDATE statement: Egor UPDATE user SET Grant_priv='Y' WHERE user='root'; I get

RE: OSX Mysqladmin and Cron

make sure the directory where mysqladmin lives is in your $PATH in that script, i.e. add $PATH=$PATH:/usr/local/bin (or where ever it is...) in the beginning of your script where environment variables are set. -Don -Original Message- From: Dion Wickander [mailto:[EMAIL PROTECTED]]

Re: OSX Mysqladmin and Cron

Don't put quotes around your password. Dion Wickander wrote: I set up a script to rotate my logs for mysql and cron fires it off perfectly the logs are rotated but when the shell script gets to the last line which is... mysqladmin -u usernam -pPassword flush-logs it will not execute it - my

Re: OSX Mysqladmin and Cron

Thanks!!! for the advice it works perfectly now on 4/24/02 2:19 PM, Don Vu at [EMAIL PROTECTED] wrote: make sure the directory where mysqladmin lives is in your $PATH in that script, i.e. add $PATH=$PATH:/usr/local/bin (or where ever it is...) in the beginning of your script where

Fw: user problem

Hi! kennonward == kennonward [EMAIL PROTECTED] writes: kennonward I have mysql installed on a linux platform. I have no problem running every thing as root. When I try to run mysql as a user other than root, I entered command use mysql. I get error 1044:access denied for

Mysq[-Max] 3.23.50, .51 with autoextend.... where are they?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hey, At various places on the MySQL web site there's mention of 3.23.50 and 3.23.51, and the new autoextend feature. However, the most recent on the download page is 3.23.49a. Was .50/.51 not released because of bugs or something? - -- -

Re: MySQL 3.23.44 not using indexes

I haven't found the problem, but I seem to have found the solution. If I dump the data and re-import it (causing the index files to be re-created from scratch), the indexes work fine. I think this problem started when I upgraded from MySQL 3.22.30 to 3.23.44 and converted the tables from

Re: Mysq[-Max] 3.23.50, .51 with autoextend.... where are they?

On Wed, Apr 24, 2002 at 03:49:17PM -0500, JW wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hey, At various places on the MySQL web site there's mention of 3.23.50 and 3.23.51, and the new autoextend feature. However, the most recent on the download page is 3.23.49a. Was

problem with max

i write a program using MyIsam,and i want uses Innodb. the query: select max(date_comp) as mdate from pieces on MyIsam mdate is a date. on InnoDB mdate is string. win2000 delphi6 zeosdbo it's normal? - Before posting,

Re:  character

Hi, because you must use the optional command for fields or lines : Eg. load data infile 'yourfile' into table your_table fields terminated by '\your_delimiter_char_for_fields' lines terminated by '\r\n'; _ G.NET SOFTWARE COMPANY Permanent

Re:  character

At 12:23 AM +0300 4/25/02, Gelu wrote: Hi, because you must use the optional command for fields or lines : Eg. load data infile 'yourfile' into table your_table fields terminated by '\your_delimiter_char_for_fields' lines terminated by '\r\n'; I do. So how does that have anything to do with

variant type

Subject: variant type From: deco [EMAIL PROTECTED] === i need to have a table column holding multiple numeric values (double, int, float, etc)... I was thinking of using a variant type for this. Does Mysql support this? -

Multi Line SQL Statements

I have a dumb Question... When I try to enter a Multiple line SQL statement like: create table ZIPSTA2 (zip char(5), state char(2)) ; create table ZIPSTATES (state char(2), zip char(5)); I get this error: [root@localhost:3306] ERROR 1064: You have an error in your SQL syntax near '; create

Re: Multi Line SQL Statements

Michael ... Works for me ... at the console: mysql create table zipsta2 (zip char(5), state char(2)); Query OK, 0 rows affected (0.06 sec) mysql create table zipstates (state char(2), zip char (5)); Query OK, 0 rows affected (0.06 sec) Put the same query in a script piped into MySQL with same

Re: replication

On Wed, Apr 24, 2002 at 02:32:52PM -0400, vlady wrote: Hi, Setting an replication for the first time, I get the following error message in my slave: 020424 13:59:28 Slave: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'FIRST' at position 4 020424 13:59:29

Re: Multi Line SQL Statements

It's The MySQL Control Center program. I can take and save the sql statements from Mycc to a text file and call MySql c:\sql.txt and it runs fine... wierd Gerald R. Jensen wrote: Michael ... Works for me ... at the console: mysql create table zipsta2 (zip char(5), state char(2));

Re: replication

oops I meant MySql c:\sql.txt Jeremy Zawodny wrote: On Wed, Apr 24, 2002 at 02:32:52PM -0400, vlady wrote: Hi, Setting an replication for the first time, I get the following error message in my slave: 020424 13:59:28 Slave: connected to master '[EMAIL PROTECTED]:3306',

Default current date

How can i set the default values of a datetime field in a mysql table as the current date. I am trying alter table copy_tbl add create_date datetime default now() but it does not work. Please help. Regards, Harpreet Kaur _ MSN

PHP and MySQL help please !

+ PHP Installed and going - I can write to files, retrieve flatfiles + Apache running servers outpages nop probes Trying to talk to SQL using PHP. -- html body h1Go to SQL now/h1 ? echo looking; @ $db =

RE: PHP and MySQL help please !

Further to this, I removed the @ symbol and got:- Fatal Error: Call to undefined function: mysql_connect() in /var/www/html/results.php @ $db = mysql_pconnect(localhost, user, password); $db = mysql_pconnect(localhost, user, password); Ideas ? Why is it now a undefined function ? Andrew

  1   2   >