mysql and unicode ....

does mysql 32.23.51 support unicode thnx a million ... toby . _ Send and receive Hotmail on your mobile device: http://mobile.msn.com - Before pos

Re: MySQL stability on OS X

Clay, Thank you, this sounds very promissing! I will try this and let you know if it helps. This will take a few weeks because the vacation is here soon. /Aryan >Aryan, > >I faced a similar problem, as have a few other people on the list, it seems. >On the recommendation of another Mac OS X M

InnoDB foreign key corruption

Hi all, We are using MySQL v. 3.23.49 on both Windows 2K and Solaris 8 with InnoDB support. We have created many relational tables since InnoDB supports foreign keys. After some unidentified time, the foreign keys relating only one table corrupts but the other foreign keys remain valid. At the c

Re: Array-Like Columns...

On Tue, 18 Jun 2002, Brad W. Galiette wrote: > I am currently in the process of designing a database solution that requires > columns to have array-like capabilities. To provide the group with a better > notion of what I am trying to accomplish, please review the following > example. > As far a

The Character Set Used for Data and Sorting

Hello, MySQLman! I've got a question. I've installed standart MySQL binaries which are compiled with --with-extra-charsets=complex. The fact that I speak Russian means necessity for using --default-character-set koi8_ru (I need it for "order by" construction). I've red chapter in MySQL manu

RE: API++ Question

> Thanks, it's exactly what I'm looking for, suppose I've a lot of work, > becouse (for any interested) it's anexcellent option instead ADO and MyODB > but . the only matter it's a big time to establish a connection, after > that, everything is right. > > Somebody know's other option ? sql,d

mysql documentation & prompt

Hello, http://www.mysql.com/doc/m/y/mysql.html there is section how to set up own prompt for mysql. I tryed but doesn't working. (tested on 3.23.43 and 4.0.1-alpha) Is possible to set up own prompt in mysql ? Regards, Michal Dvoracek [EMAIL PROTECTED] sql, table, sele

Re: MySQL 4.0.1 & SSL config - a shot in the dark

[replying to my own thread yet again ... Sorry about that] Thought that anyone silently following my experiments on this may be interested to know: Using the /usr/local/ssl/apps/CA.sh script (part of the openssl installation) as follows: ./CA.sh -newca ./CA.sh -newreq ./CA.sh -sign Then copyin

RE: API++ Question

Thanks, it's exactly what I'm looking for, suppose I've a lot of work, becouse (for any interested) it's anexcellent option instead ADO and MyODB but . the only matter it's a big time to establish a connection, after that, everything is right. Somebody know's other option ? Regards !!!

more than one query in mysql

Hi all, can I write a few queries in mysql , separate with suppose ; and run them together? if I can, in what version can I do that? thanks, Inbal - Before posting, please check: http://www.mysql.com/manual.php (the

Re: Connection DB server by borland C++ Builder

You can use the following component. It includes packages for Builder4 & Builder5 http://sourceforge.net/projects/zeoslib - Original Message - From: "Yuna Yuana" <[EMAIL PROTECTED]> To: "Egor Egorov" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, June 18, 2002 7:39 PM Subject

RE: Remote MySQL administration problem . . .

Hi... > I'm trying to set up a MySQL database on a hired server, and the only > way they will let it work is to use localhost, which means I have to > admin the database from within PHP scripts, at least as far as I > understand it. Is there something other than phpMyAdmin that will let > me

RE: Remote MySQL administration problem . . .

Hi... > I'm trying to set up a MySQL database on a hired server, and the only way > they will let it work is to use localhost, which means I have to admin the > database from within PHP scripts, at least as far as I understand it. Is > there something other than phpMyAdmin that will let me do thi

Re: Don't even know where to start on this one

In the last episode (Jun 19), Chris Knipe said: > > > My PHP code also use persistent connections, and I don't think this is > the > > > problem, but basically, how more queries I throw at MySQL how more my PC > > > crawls down to a halt - even after the application with the queries > > > disconne

RE: Binary update log & how to disable ?

Maybe you have my.cnf file in your computer. That can be under /etc or you home directory. In that file there may be text like this. # Try number of CPU's*2 for thread_concurrency set-variable= thread_concurrency=8 set-variable= myisam_sort_buffer_size=64M log-bin server-id = 1 You

RE: INSERT using C API

Instead of using only mysql_query() you can use sprintf() and mysql_query() like this. sprintf(strquery, "INSERT INTO pending(mbmid, pw_name,pw_domain) VALUES('%s', '%s', '%s')", mbmID, Uname, Udomain); mysql_query(my_connection, strquery); -Original Message- From: rm [mailto:[EMAIL PRO

Connection DB server by borland C++ Builder

hello, I need source code for connection Data Base Server bby borland C++ Builder. help...help...help On Tue, 18 Jun 2002, Egor Egorov wrote: > Silmara, > Tuesday, June 18, 2002, 3:43:48 PM, you wrote: > > SCB> I'm using MySQL 4.0.1 and my question is "How can i do to create a new table

Re: Don't even know where to start on this one

> > My PHP code also use persistent connections, and I don't think this is the > > problem, but basically, how more queries I throw at MySQL how more my PC > > crawls down to a halt - even after the application with the queries > > disconnected from the database. I can understand that my system m

Re: Don't even know where to start on this one

In the last episode (Jun 19), Chris Knipe said: > Lo all, > > I don't know if this can be reproduced, whether it's just general coding > errors, or whether it's simply a Windows thing But I do my development > on a NT 4.0 system, and I've been starting to notice rather weird things > > M

Remote MySQL administration problem . . .

. . . Folk, Is there a good PHP product that allows for remote MySQL administration? I'm trying to use phpMyAdmin v2.2.26, but it keeps throwing up errors ab. functions not being available. I'm new to this venue, so I'm probably missing something, likely in great chunks, but I've yet to fin

FW: Question.

Please ignore the last email, I just found the link :) (need more coffee) --- Chris Kay Technical Support - Techex Communications Website: www.techex.com.au Email: [EMAIL PROTECTED] Telephone: 1300 88 111 2 - Fax: (02) 99

Question.

I posted a message about a query a few days ago and I had a few responses Subject was "Query" I have lost the reply's... Is there a web based arcives anywhere? --- Chris Kay Technical Support - Techex Communications Webs

Array-Like Columns...

I am currently in the process of designing a database solution that requires columns to have array-like capabilities. To provide the group with a better notion of what I am trying to accomplish, please review the following example. Let's say that in a particular calendar application, a user wish

Re: SQL Server design

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Bill Bernat wrote: | Okay, suppose I know all about SQL Server 2000 design and what is | and isn't good and I'm suddenly tasked with designing a MYSQL | database tomorrow. Are there any guidelines for design that I should | note? Obvious things are

Re: pointless question

On Fri, 2002-06-14 at 16:23, Ray wrote: > > in the manual: > |6.2.6.2 Storage requirements for date and time types > | > |Column type Storage required > |DATE 3 bytes > |DATETIME 8 bytes > |TIMESTAMP 4 bytes > |TIME 3 bytes > |YEAR 1 byte > > so, does datetime do more then date + time

INSERT using C API

Hello list, I'm new to C programming, and have used MySQL for only a short time; but I've got a situation where I need to update an existing table using a C function. I'm working on Redhat 7.1 using the MySQL rpm that came with the package. I've written the function so that it compiles, and ex

Re: API++ Question

There has been some work done on this by the folks at http://www.icarz.com/mysql/They have a dll that can be used to replace ADO for mysql. Haven't personally used it, but they say its faster.-Nick Efren Pedroza said: > Maybe I'm goin to ask something stupid, but I've to do it, MySQL++ API > can

SQL Server design

Okay, suppose I know all about SQL Server 2000 design and what is and isn't good and I'm suddenly tasked with designing a MYSQL database tomorrow. Are there any guidelines for design that I should note? Obvious things are don't count on transactional/relational integrity to be enforced by the

Re: INSERT using C API

On 18 Jun 2002 20:22:09 -0500 rm wrote: > Hello list, > > I'm new to C programming, and have used MySQL for only a short time; but > I've got a situation where I need to update an existing table using a C > function. > > I'm working on Redhat 7.1 using the MySQL rpm that came with the > package

INSERT using C API

Hello list, I'm new to C programming, and have used MySQL for only a short time; but I've got a situation where I need to update an existing table using a C function. I'm working on Redhat 7.1 using the MySQL rpm that came with the package. I've written the function so that it compiles, and exe

Don't even know where to start on this one

Lo all, I don't know if this can be reproduced, whether it's just general coding errors, or whether it's simply a Windows thing But I do my development on a NT 4.0 system, and I've been starting to notice rather weird things I use various languages (Perl, PHP, Delphi, C, etc), all of whi

Re: MySQL 4.0.1 & SSL config - a shot in the dark

A little more information on this problem ... - Tonu's notes state that there are sample SSL keys & certs for testing purposes in the "SSL" directory of the mysql tarball. There is no SSL directory in the mysql-4.0.1-alpha.tar.gz file. Does anyone know which tarball he may be referring to? - In

Don't even know where to start on this one!!!

Lo all, I don't know if this can be reproduced, whether it's just general coding errors, or whether it's simply a Windows thing But I do my development on a NT 4.0 system, and I've been starting to notice rather weird things I use various languages (Perl, PHP, Delphi, C, etc), all of whi

Replication logging

I've got replication working between my two machines, however the err log gets a lot of these errors: --- 020618 20:41:18 Error reading packet from server: (server_errno=1159) 020618 20:42:18 Slave: Failed reading log event, reconnecting to retry, log 'db1-bin.002' posi

API++ Question

Maybe I'm goin to ask something stupid, but I've to do it, MySQL++ API can be used from VB 6.0 ? What I'm looking for is to access MySQL DB from an application maded in Visual Basic 6.0 SP5 without using MyODBC, is there some way to do it ? I'll appreciate any directions that you can give me or

Re: Alter table problem

Ferdek, I found the bug. If one specifies a non-latin1 character set in my.cnf, then the internal data type of a CHAR column is DATA_MYSQL inside InnoDB. In that case the foreign key check did not accept columns of different length. I have now fixed this to 3.23.52. But a note on programming st

RE: ORDER BY & BY ¿?

Thanks a lot... guess I missed this in the books :-/ > -Original Message- > From: Gurhan Ozen [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, June 18, 2002 8:10 PM > To: César Aracena; 'MySQL General' > Subject: Re: ORDER BY & BY ¿? > > SELECT * FROM tablename ORDER BY lastname, firstname; >

Re: ORDER BY & BY ¿?

On Tue, 18 Jun 2002 20:04:54 -0300 César Aracena wrote: > Hi all. > > > > Is there any possible way for me to arrange a SELECT query made to MySQL > in to orders? Like __. ORDER BY lastname THEN BY firstname? SELECT * FROM tablename ORDER BY lastname, firstname; -- Cliff Wells, Software En

Re: ORDER BY & BY ¿?

SELECT * FROM tablename ORDER BY lastname, firstname; Gurhan - Original Message - From: "César Aracena" <[EMAIL PROTECTED]> To: "'MySQL General'" <[EMAIL PROTECTED]> Sent: Tuesday, June 18, 2002 7:04 PM Subject: ORDER BY & BY ¿? Hi all. Is there any possible way for me to arrange a

ORDER BY & BY ¿?

Hi all. Is there any possible way for me to arrange a SELECT query made to MySQL in to orders? Like ……. ORDER BY lastname THEN BY firstname? Thanks in advance, Cesar Aracena CE / MCSE+I Neuquen, Argentina +54.299.6356688 +54.299.4466621

Re: Help: Can't connect to local MySQL server through socket '/tmp/mysql.sock'

--- Carlos Rubio <[EMAIL PROTECTED]> wrote: > I am geting the error: > Can't connect to local MySQL server through socket '/tmp/mysql.sock' on all > pages requiring the use of mysql. I got this error before too. Here is how I fixed it: (you probably have to do this as root) ln -s /var/tmp/mysql

Help: Can't connect to local MySQL server through socket '/tmp/mysql.sock'

Hi, I am geting the error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' on all pages requiring the use of mysql. I suspect that the file mysql.sock was deleted by mistake by one of our programers. I have find in the manual how to protect the file or changing the configu

Re: Nulls and unique indexes.

Doh! Blindsided by an Oracle DBA, the only spec I could get my hands on is an old draft thing and I have to admit from that it looks like the correct behaviour.. NULL <> NULL and all that.. Thanks, Jon On Tue, 18 Jun 2002 10:54:15 -0500 Gerald Clark <[EMAIL PROTECTED]> wrote: > That is correct

Re: LOAD DATA LOCAL INFILE in Alpha 3.23.49]

Hello, Below is a thread from March. Basically, I am having the same problem in v3.23.49 (release version, not Alpha). I also have Linux RedHat 7.2, same as Tom. I compiled MySQL from source using gcc v2.96 . Here are the details of my problem: The SQL command LOAD DATA LOCAL INFILE '/home

RE: Need help with a complex query

I don't know if it would be possible to use something like this, but maybe it's worth a try... SELECT Customers.*, SUM(IF(IFNULL(Orders_Items.productid, 0)='23',1,0)) BINGO FROM Customers LEFT JOIN Orders ON (Orders.customerid=Customer.CustomerID) LEFT JOIN Ordered_Items ON (Ordered_Items.orderi

Re: Mysql SELECT IF()

On 18 Jun 2002, at 17:36, João Paulo Vasconcellos wrote: > SELECT SUM( IF( STRCMP( active,'Y' ) = 0, 1, 0 ) ) as activeUsers > FROM usersTbl Since comparisons return 1 or 0, a simpler way of writing that query is SELECT SUM( active = 'Y' ) as activeUsers FROM usersTbl (although things are m

Re: Mysql SELECT IF()

You may try: SELECT SUM( IF( STRCMP( active,'Y' ) = 0, 1, 0 ) ) as activeUsers FROM usersTbl On Tuesday 18 June 2002 16:36, Walter D. Funk wrote: > Hi everybody! > > I need to count the ACTIVE users of my Mysql users table; where 'active' is > a flag showing this status, > using the followi

Monitoring

Hi all, I'm using InnoDB Tables, and I need to know which user has records locked. I'm trying to use innodb_monitor, but I didn't find some useful info. Can anyone help me? (Sory my poor english) and, to make the filter happy: sql query ___ Alvaro Online Mail (c

Re: Need help with a complex query

>>> Try - and I mean *try* :-) >>> >>> SELECT Customers.* FROM Customers, Subscriptions >>> LEFT JOIN Orders ON (Orders.customerid=Customer.CustomerID) >>> LEFT JOIN Ordered_Items ON (Ordered_Items.orderid=Orders.id && >>> (Ordered_Items.productid = '23')) >>> WHERE Customers.id=Subscriptions.cus

Re: Obvious mistake in query?

Thanks! Phoebe. on 18/6/02 19:32, Ryan Fox at [EMAIL PROTECTED] wrote: > On Tue, 2002-06-18 at 14:11, Phoebe Bright wrote: >> I am trying to list items in t1 (alias new) that are not in project so I >> tried the query suggested on an earlier mail: >> >> select new.projectdesc,project.projectn

FullText problems

Hello, I tried the FULLTEXT example from the manual (http://www.mysql.com/doc/F/u/Fulltext_Search.html) and run across some problems. On some search terms, I get a result set and others I do not. The query -> SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('database') returns a result,

problems with HPUX 11.11 build - gcc 3.x

>Description: gcc -DUNDEF_THREADS_HACK -DHAVE_CONFIG_H -DNO_KILL_INTR -I./../include -I./.. -I.. -D__STDC_EXT__ -I/opt/local/src/TCPw/tcp_wrappers_7.6/include -O3 -DDBUG_OFF -fomit-frame-pointer -O3 -fpic -DHAVE_BROKEN_PREAD -DDONT_USE_FINITE -DHA

Re: MySQL stability on OS X

Aryan, I faced a similar problem, as have a few other people on the list, it seems. On the recommendation of another Mac OS X MySQL user (the extremely helpful Tony Niesz), I compiled my own MySQL server (rather than using the one Apple distributes or the binary Marc Liyanage maintains). Prior to

Mysql SELECT IF()

Hi everybody! I need to count the ACTIVE users of my Mysql users table; where 'active' is a flag showing this status, using the following query it returns all the user in the table, and I need only those who have tha flag active set to 'Y' I know this could be done by using a where clause, but i

RE: HELP!!! major situation with mysql on windows 2000

The port of Cartesia does ship a lot of product. ;-) -Original Message- From: Norris, Joseph [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 18, 2002 1:02 PM To: 'Benjamin Pflugmann'; Norris, Joseph Cc: Mysql_List (E-mail) Subject: RE: HELP!!! major situation with mysql on windows 2000 T

Re: Obvious mistake in query?

On 18 Jun 2002, at 19:11, Phoebe Bright <[EMAIL PROTECTED]> wrote: > select new.projectdesc,project.projectname > from t1 as new > left join project on new.projectdesc=project.projectname > where project.projectname=NULL > > | projectdesc | projectname | > Number of Results: 0 You can't use =

Re: Obvious mistake in query?

You are testing nullity using equal, but you must use IS NULL to test against NULL values. http://www.mysql.com/doc/C/o/Comparison_Operators.html On Tuesday 18 June 2002 15:11, Phoebe Bright wrote: > I am trying to list items in t1 (alias new) that are not in project so I > tried the query

Re: MySQL 4.0.1 & SSL config - a shot in the dark

Hello, >From the sound of Tonu's original response, he's pretty busy right now ... If anyone else has an idea based on experience with SSL & MySQL, or just with openssl in general, can offer an opinion on this, I would be grateful. I've ordered a book on OpenSSL in an effort to learn more about

RE: HELP!!! major situation with mysql on windows 2000

Thanks to all - another coder showed me the error of my ways :>) I had a join without a where clause - a big no-no. I had to restart the server and repair my code and now I am back to normal. Thanks to all. -Original Message- From: Benjamin Pflugmann [mailto:[EMAIL PROTECTED]] Sent: Tu

Re: How to duplicate records

Don, Thank you very much. The only problem is that the primary index Code, Model and Year and what I need is to duplicate the Code, Model and Units for a different year, 2003, that does not exist. If I do the statement bellow it won't work. What I need is to insert Code, Model, Units for a speci

Re: Re: Re: Re: Re: how to prevent from Creating Large NumbersofTables ???

On Tue, 2002-06-18 at 19:53, Xuefer wrote: > cateogry.members a list of att_type_id, right? > and also displayOrder > i got it. it's nice :) :) > but is it a must to have attributes.id ? > unique id (product_id,att_type_id) is not enough ? The id field makes handling rows much easier. > to

Re: MAX_ROWS

On Tue, 2002-06-18 at 11:43, Aborla.net - webmaster wrote: > Hello, > > I created a table using: > "CREATE TABLE a (pa VARCHAR (255) NOT NULL, pi VARCHAR (255), PRIMARY KEY > (pa)) TYPE=HEAP MAX_ROWS=10" > > Then I inserted 16 recors. Later I done SELECT * FFROM a and mysql returned > 16 records

Re: HELP!!! major situation with mysql on windows 2000

Hi. On Tue 2002-06-18 at 10:28:41 -0700, [EMAIL PROTECTED] wrote: > Group, > > I have a system running on windoze 2000 with apache and perl that was > running just great until I mades some > changes to the sql and a join of two tables. Now I get a bunch of disk > activity and my pages take fore

Obvious mistake in query?

I am trying to list items in t1 (alias new) that are not in project so I tried the query suggested on an earlier mail: select new.projectdesc,project.projectname from t1 as new left join project on new.projectdesc=project.projectname where project.projectname=NULL | projectdesc | projectname |

RE: RE: Installing MySQL on Server W2000

Thanks for everything, exactly that you told me, GRANT command was the solution, I did it by MyCC (My SQL Control Center 0.8.4) it's easy to use. Thanks to all again !!! -Original Message- From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 18, 2002 10:35 AM To: [E

still having rep. problems

Never got any replies from the list with suggestions from my last post so I thought I would give another cry for help.To recap: Master Server - Win NT 4.0 mysql 3.23.49-nt-log dual pII 600 Slave Server - Win 2k mysql 4.0.1-alpha-max-nt p4 2.0 Procedure: Followed the manual to set up the slave mas

Re: Re: Re: Re: Re: how to prevent from Creating Large Numbers ofTables ???

cateogry.members a list of att_type_id, right? and also displayOrder i got it. it's nice :) but is it a must to have attributes.id ? unique id (product_id,att_type_id) is not enough ? to remove a product delete from attributes where product_id=$id delete from product where id=$id >On Tue, 2002-

Re: Alter table problem

Ferdek, what character set you have specified in my.cnf? I tested your script with latin1 (the default) and 3.23.52, and it seemed to work without errors. For example, for the table reklamacja you see below it created the 3 foreign key constraints. Can you provide a simple repeatable test case

HELP!!! major situation with mysql on windows 2000

Group, I have a system running on windoze 2000 with apache and perl that was running just great until I mades some changes to the sql and a join of two tables. Now I get a bunch of disk activity and my pages take forever to load I shut down the browser and still the activity - memory usage goes

Re: Re: Re: Re: how to prevent from Creating Large Numbers ofTables ???

On Tue, 2002-06-18 at 19:02, Xuefer wrote: > sorry, i can't quite get what u meant > dunno how to do as u said > > > You might want to associate the attributes with categories > > in a different table. This way you could put an attribute > > into multiple categories. You could also specify th

Re: Re[2]: heap tables

Victoria Reznichenko writes: > Hi! > > SM> Victoria Reznichenko writes: > >> I have a question about heap tables :) > >> > >> Why does MySQL allow to insert more rows in the table than is > >> specified in MAX_ROWS ? > > SM> Send a test case ... > > mysql> create table hp( > -> id int prim

Re: Re: Re: Re: how to prevent from Creating Large Numbers of Tables ???

sorry, i can't quite get what u meant dunno how to do as u said > You might want to associate the attributes with categories > in a different table. This way you could put an attribute > into multiple categories. You could also specify the displayORder > in the category table as well. > >O

Re: replication problems -- resolution

Just to let you know that when I installed 3.23.51 binary on both Debian Linux boxes, same problem, but when I re-installed the 3.23.49a binary on both boxes the problem went away. Uncertain why. Regards, Jeff Hill At 08:25 AM 18/06/2002 -0400, Jeff Hill wrote: >I'm having the same problems,

make err: ld: fatal: library -ldl: not found

I am having troubles running 'make' with mysql-3.23.49 on; SunOS 5.8 Generic_108528-12 sun4u sparc my configure looks something like this; setenv CFLAGS "-O3" setenv CXX gcc setenv CXXFLAGS="-O3 -felide-constructors -fno-exceptions -fno-rtti" ./configure --prefix=/lycra/homes/fike/bugz/mysql

Re: Nulls and unique indexes.

That is correct. Use NOT NULL in the definition to force unique keys. [EMAIL PROTECTED] wrote: >>Description: >> > If a null column is used in a unique index then mysql fails to throw a > key violation when multiple identical inserts (with nulls) are > performed. > >>How-To-Repeat: >> > create

RE: How to duplicate records

mabye an insert into...select will work, something like: INSERT INTO SELECT Code, Model, Units from where Year=2003 and ((Code = 'N200') or (Code='N205')); http://www.mysql.com/doc/I/N/INSERT_SELECT.html -Don -Original Message- From: Carlos Fernando Scheidecker Antunes [mailto:[EM

RE: create a new table in a tablespace...

It's not THAT much like Oracle. ;-) -Original Message- From: Silmara Cristina Basso [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 18, 2002 9:16 AM To: [EMAIL PROTECTED]; Egor Egorov Subject: Re: create a new table in a tablespace... If i had more than one tablespace, don't i control whe

Re: MySQL 3.23.51+ for AIX

Morris, Tuesday, June 18, 2002, 5:13:41 PM, you wrote: MF> Any word on when to expect a working binary MF> release of mysql for AIX 4.3.3? Our developers are working on this issue. MF> Morris Ford -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This em

Re: RE: Installing MySQL on Server W2000

Efren, Tuesday, June 18, 2002, 5:35:47 PM, you wrote: EP> I'm trying to connect trough MyODBC 2.5 and the error that I get is: "Access EP> denied", or "Can't connect to the server", both Pc's are in the same network EP> and have TCP/IP installed and working properly, also I try to connect using E

Re: How to duplicate records

Carlos, Tuesday, June 18, 2002, 5:24:48 PM, you wrote: CFSA> I've got some records of a Database that I would like to duplicate if CFSA> possible with an statement. CFSA> The table has Code, Model, Year, units. The primary key is Code, Model and CFSA> Year. What I need is to duplicate Code, Mode

Re: Interesting problem with Alter table and foreign keys on 3.23.51

Carl, Tuesday, June 18, 2002, 5:30:31 PM, you wrote: CM> Below is an example of a problem I'm having when issuing an alter table CM> command to create a foreign key in mysql version 3.23.51. I am running the CM> max version and the tables exist in the innodb table space. CM> Thoughts? Comments

How to unsubscribe to this mailing list?

Can anyone let me know how to unsubscribe to this mailing list? Thank you very much in advance. sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

Re: create a new table in a tablespace...

If i had more than one tablespace, don't i control where it will be stored ? - Original Message - From: Egor Egorov <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, June 18, 2002 11:06 AM Subject: Re: create a new table in a tablespace... > Silmara, > Tuesday, June 18, 2002,

MySQL stability on OS X

Hi, Is anyone using MySQL with PHP and Apache on Darwin/OS X as a dynamic content webserver with medium/high load? We have had al lot of MySQL crashes (once a week) on a 400Mhz G4 getting an average of 5 SQL queries per second and eventually had to move the database to an old Linux 160Mhz Pen

Re: Re: Re: how to prevent from Creating Large Numbers of Tables ???

On Tue, 2002-06-18 at 15:42, Xuefer wrote: > thx for replying > > it's really a new course for me > > option 1 will still make lots of tables > > does option 2 waste of space ? > cause 2 id with only 1 value How many tables are created and how much spaces is wasted depends on the data and

Re: Installing MySQL on Server W2000

Does the user (or do the users) you are trying to connect as from the Win98 machine(s) have the proper access set up in MySQL? - Original Message - From: "Efren Pedroza" <[EMAIL PROTECTED]> To: "MikeParton" <[EMAIL PROTECTED]>; "MySQL List1" <[EMAIL PROTECTED]> Sent: Tuesday, June 18, 2002

RE: Installing MySQL on Server W2000

I'm trying to connect trough MyODBC 2.5 and the error that I get is: "Access denied", or "Can't connect to the server", both Pc's are in the same network and have TCP/IP installed and working properly, also I try to connect using MyCC (DBA) downloaded from www.mysql.com and the same problem, that

How to duplicate records

Hello all, I've got some records of a Database that I would like to duplicate if possible with an statement. The table has Code, Model, Year, units. The primary key is Code, Model and Year. What I need is to duplicate Code, Model and units for a different year. Say I want to duplicate all recor

Interesting problem with Alter table and foreign keys on 3.23.51

Below is an example of a problem I'm having when issuing an alter table command to create a foreign key in mysql version 3.23.51. I am running the max version and the tables exist in the innodb table space. Thoughts? Comments? Criticism? Carl McNamee Systems Administrator Billing Concepts (21

make err: ld: fatal: library -ldl: not found?

This is my configure line; setenv CFLAGS "-O3" setenv CXX gcc setenv CXXFLAGS="-O3 -felide-constructors -fno-exceptions -fno-rtti" ./configure --prefix=/lycra/homes/fike/bugz/mysql --enable-assembler --with- mysqld-ldflags=-all-static Then I run gmake and the following error is reported. It se

MySQL 3.23.51+ for AIX

Any word on when to expect a working binary release of mysql for AIX 4.3.3? Morris Ford __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com --

Irix problems with persistent connections

Hi all, I'm using mysql version 3.23.49 on irix 6.5.16. The problem that i have occurs when i establish connections from a Winnt wokstation using php. I establish the connections to the database using p_connect. Sometimes the connections that are established using p_connect don't resp

Re: creating a full text index

RWilson, Monday, June 17, 2002, 9:04:19 PM, you wrote: R> I am trying to create a full text index on a column R> I input R> create FULLTEXT index [nameofindex] on [tablename] (columnname(15)); R> when I put this in at the console I get R> error on rename of databasename.myi file. R> can I get

Re: inoodb autoextend problem, solaris 2.7, 4.0.1-alpha-max

Anthony, Monday, June 17, 2002, 5:13:23 PM, you wrote: ARJB> I am trying to play with innodb tables in 4.0.1-alpha-max on ARJB> Solaris 2.7, but I am having a problem with setting up an ARJB> autoextend tablespace... as soon as I put :autoextend at the ARJB> end of my innodb_data_file_path lin

Re: create a new table in a tablespace...

Silmara, Tuesday, June 18, 2002, 3:43:48 PM, you wrote: SCB> I'm using MySQL 4.0.1 and my question is "How can i do to create a new table SCB> in a tablespace?". Tablespaces are used only for InnoDB tables. If you create InnoDB table, it will be stored in InnoDB tablespace. How to create InnoDB

INSERT to table from text file

Hello, I'm looking for a solution to INSERT data from a text file that is used for logging into a MySQL table. A hypothetical example... I have a server (any server, could be a RADIUS, a DNS or a MTA) that logs to a file in "/var/logs/log-file". Is there a way to take the raw data sent to the l

Re: getting totals with data

On Monday, June 17, 2002, at 05:44 PM, Galen Wright-Watson wrote: > Another option is to SELECT INTO a temporary table (or CREATE > TEMPORARY ... > SELECT), then query the temporary table for the total_hits. Would the overhead of generating a temporary table for this query be worthwhile? I'

How to compile a UDF under win32?

Hi, All. Please, tell my how to compile a UDF under win32. For example, udf_example.cc cl /GX /TP /nologo /c udf_example.cc link /nologo /dll /out:udf_example.so udf_example.obj It do not export the functions :-( dumpbin /export udf_example.so DUMPBIN : warning LNK4044: unrecognized opt

Help needed ..mysql replication on mirrored servers...

Hi, I will appreciate for any suggesstion on best plan... I am working on setting up a production environment with mirrored servers working on redhat 7.2. To balance the load, each servers have its own primary applications but all of them are mirrored. When the Ist server fails the

Re: MySQL on Cluster

Can you give some more information about this disc cluster? The term to me is vague. I am assuming that it's NOT a RAID array, but I'm also guessing that it's not a reference to a group of machines either. Can you explain some more? Later on, TRC - Original Message - From: "Frank" <[E

  1   2   >