RE: transaction support

Hi We have been running MySql since 1998 and have never had any data corruption We have servers running millions of queries a day and they are bullet proof. > > > Hi, > > > > I'm trying to get a software designer to write us some software using > > MySQL as the database server (he currently requ

gui front-end tool in Linux

Hi there!!! I am using Debian Woody. I am searching for a good front-end gui tool for mysql in Linux which will create UML out of the database schema, something like MS SQL. Are there any tools out there which can do it for me. Regards, R Karthick -- You are the one, the only one -- MySQL G

Re: transaction support

Hi, I have been using MySQL since 3.2x and now 4.0.1x in Windows NT and Windows 2000 IIS / .asp environment including MyODBC for more than 4 years now, and never lost any data. Setup problems have been solved by reading and following instruction in the manual, or asking in the support / newsgroups

Re: The Future of MySQL with .NET Plataform

Roger Baklund wrote: . . . one could check with the Oracle of Delphi...[2] ;) . . . I think that is the best possible answer the question. Chris W -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: transaction support

Bryan Koschmann - GKT wrote: [MySQL] 1: START TRANSACTION 2: WITHDRAW $50 from account 32146. 3: DEPOSIT $50 into account 12345. 4: LOG transfer (date/time/teller/etc...) for auditing. 5: COMMIT TRANSACTION if this failed at step 3 the transaction would be hung and even if rolled back by server ad

Re: transaction support

Bryan Koschmann - GKT <[EMAIL PROTECTED]> [2004:01:05:18:58:12-0800] scribed: > Here is the explanation I just received when asking for the difference > between transaction support: > > - > MySQL uses single-action implicit and explicit transactions, but they do > not > automatically rol

Re: transaction support

Well, I think this statement does it all, http://www.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&q=MySQL+toy+marston Subject: Re: Can MySQL table handle 3 million+ entries? Newsgroups: comp.lang.php Date: 2003-04-11 15:20:10 PST MySQL is NOT a toy database - it is far superior to many I have

RE: transaction support

On Mon, 5 Jan 2004, Craig Vincent wrote: > Although this doesn't answer your initial request...why are you wanting to > 'argue' with this guy over the database to use. If he won't code for the > application to use MySQL (which isn't all that hard in VB regardless of what > he says) then get

Re: FULLTEXT across two tables

I just tried SELECT DISTINCT and still the same problem -- returning all entries for a matching user_id in art for each user where the word 'kansas' is specified... any other thoughts? Thanks, lje On Saturday 03 January 2004 16:58, you wrote: > Hi Ladd, > > How about SELECT DISTINCT? > > > Hope

Re: transaction support

On Jan 5, 2004, at 9:37 PM, Bryan Koschmann - GKT wrote: -No explicit transactional support Wrong. InnoDB tables support transactions. -MySQL is still buggy Care to have him specify what bugs he is referring to? I've been using MySQL for 2 years now, and use Microsoft SQL Server for about 3 ye

RE: transaction support

Bryan, Although this doesn't answer your initial request...why are you wanting to 'argue' with this guy over the database to use. If he won't code for the application to use MySQL (which isn't all that hard in VB regardless of what he says) then get another coder...as simple as that. The

Re: transaction support

Bryan Koschmann - GKT wrote: Hi, I'm trying to get a software designer to write us some software using MySQL as the database server (he currently requires MS SQL). It is all windows based software (written in VB). So far his arguments against it are this (not my words): -No explicit transactiona

Re: mysql_escape_string ... when?

>hi >the mysql manual suggests that we use the >mysql_escape_string() function when generating dynamic >urls. is there any other situation when it is >required? and could someone explain when/why this >would be needed for urls...other than to make the >browser understand that character (such as '

transaction support

Hi, I'm trying to get a software designer to write us some software using MySQL as the database server (he currently requires MS SQL). It is all windows based software (written in VB). So far his arguments against it are this (not my words): -No explicit transactional support -MySQL is still bug

Pulling numbers out of a column for a query

I've found an odd problem in queries. I have a lot of data regarding vehicle speeds in a survey. All the data is in the form: xx/yy, for example 43/55 means that vehicle was clocked at 43 miles per hour in a 55 miles per hour zone. 80/55 means we have a serious speed demon, going 80 in a 55 z

Re: WEEKOFMONTH

At 20:27 -0500 1/5/04, Ken Kyler wrote: I need a WEEKOFMONTH function for a calendar query. Does anyone have such a function already? What are the semantics? -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com MySQL Users Conference: April 14-16, 2004 http://w

Re: mysql_escape_string ... when?

At 2:11 + 1/6/04, Abs wrote: hi the mysql manual suggests that we use the mysql_escape_string() function when generating dynamic urls. Hmm ... Where does the MySQL manual say this? is there any other situation when it is required? and could someone explain when/why this would be needed for ur

mysql_escape_string ... when?

hi the mysql manual suggests that we use the mysql_escape_string() function when generating dynamic urls. is there any other situation when it is required? and could someone explain when/why this would be needed for urls...other than to make the browser understand that character (such as ' # etc. i

WEEKOFMONTH

I need a WEEKOFMONTH function for a calendar query. Does anyone have such a function already? Ken -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Analysis with MySQL

Hello, How does one create OLAP databases/cubes in MySQL environment? Are there third party tools for such function? If yes, who are they? Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Mysql error

Hi all, Larry Brown tried to help me out with this one (much appreciated Larry), anyways, when I start up fedora I get this error from mysql that says it has timed out...it still works, but this error shows up in the mysql logs: 040104 18:38:37 mysqld started Cannot initialize InnoDB as 'innodb_d

Compile errors with Solaris 4.0.17

We're using Forte Developer 7 C 5.4 running on Solaris 9 (Sparc) and ran into a problem while compiling the mysql 4.0.17 source. While I understand their is a pre-built package for my platform, that package doesn't have built in support for SSL, which is the reason we need to re-compile the sour

Re: Deciding whether to convert to InnoDB

Very much so. That's why I'm trying to get as much juice out of the cpu as possible. Travis Dan Nelson wrote: In the last episode (Jan 05), Travis Reeder said: I'm sure this has been asked before, but I cannot find solid evidence as to whether switching would provide us with any benefits.

MYSQLDump loses connection on large dump.

Thanks in advance for any help. I'm using mysqldump to create snapshots of slave database servers. I am upgrading from 4.0.14 on Redhat 8 to 4.0.17 Fedora Core 2. I have a pair of 4.0.14 boxes MNR6 master --> MNR7 slave. I have a pair of 4.0.17 boxes MNRC master --> MNRD slave. In moving to the n

Insert with subquery fails with ERROR 1110 (42000): Column 'REQ_DESC' specified twice

Hello all I have a requirements table structured as (req_id, version_id, req_desc, comments). When a requirement comments is changed by the user, my application increases the version_id for the requirement and saves it as a new record. Sample records: 1,1,'Description 1', 'comments 1'; After upda

Re: Join sintax question

Douglas Sims wrote: Giulio wrote: HI all, I have two tables, let's say AudioTrack and Category Every AudioTrack record can belong to one or more ( or none ) Categories. I have created an intermediate table, AudioTracks_Categories containing only the IDs of AudioTrack and Category to keep track

Qualifying column names in join output?

In a siutation like this: mysql> create table t1 (one int, two int); Query OK, 0 rows affected (0.08 sec) mysql> create table t2 (one int, two int); Query OK, 0 rows affected (0.09 sec) mysql> insert into t1 values (1, 2); Query OK, 1 row affected (0.08 sec) mysql> i

Re: mediumtext crash on strings > 1MB?

On 5 Jan 2004 at 14:18, Chris Seidel wrote: > Thus I had to reset the max_allowed_packet size to allow for larger > packets by restarting the server with > > /usr/bin/safe_mysqld --defaults-file=/etc/my.cnf --set-variable > max_allowed_packet=10M >/dev/null 2>&1 & > > To do this I edited the mys

PHP/MySQL/Apache interaction problem

I really need some help/direction, so I'll try to explain this as best I can. I have a PHP script that involves three very long running queries (2-3 minutes each). The users of my website kick this off from their webpage, so it runs as "nobody" from inside Apache. In order to prevent a user f

Re: mediumtext crash on strings > 1MB?

Keith was right, the error on inserting large strings into mediumtext had to do with the variable max_allowed_packet. The defualt value can be seen by: mysql> show variables like "max_allowed_p%" and the default value was 1048576. Thus I had to reset the max_allowed_packet size to allow for large

Re: mediumtext crash on strings > 1MB?

Ah yes. From Perl I got the "server went away" error when inserting large entries. From the command line, I simply got "ERROR at line 1:" when I would construct the insert statment and place it in a text file to be run as: mysql -p -D myDBm < mybiginsert.sql I didn't realize there was a max_allowe

Re: how to drop more than one tables at once in a database?

Thanks for the pointers. I forgot to mention I had looked the on-line MySQL documents about 'drop table' before I posted my questions. Unfortunately, neither the previous discussions on the subject nor the document provided the anwsers I've been looking for. Enumerating all the tables to be dropp

Re: mediumtext crash on strings > 1MB?

On 5 Jan 2004 at 13:06, Chris Seidel wrote: > However, I found my inserts failing when some of my > strings exceeded 1 MB (e.g. a string of 1125921 bytes fails, while a > string of 1009684 bytes succeeds). What error are you getting? It sounds like you haven't changed max_allowed_packet from th

new clustering technology

:) OOPS- sent the last message too quick. I am putting together a linux/apache/mysql/PHP website and I need a step-by-step guide to scaling. specifically- how dop I go from one machine to two? from two to three or four? Can someone please help? and how does this new clustering technology map to

new clustering technology

: http://www.mysql.com/press/release_2003_30.html __ Do you Yahoo!? Find out what made the Top Yahoo! Searches of 2003 http://search.yahoo.com/top2003 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.m

Re: ERROR 1005 during add foreign key

On 5 Jan 2004, at 21:10, Sid Lane wrote: on mysql 4.0.14-standard (x86 Linux) when I try the following: alter table child_table add ( foreign key (column1, column2) references parent_table on delete cascade) ; on an existing innodb table I get: ERROR 1005: Can't create table './dbname/#sql-70f

It may be a bit off topic

Hi Our ISP has MySQL v3.x and we have a number of databases (mostly genealogical based) one feature of 3.x that I find quite limiting is the Fulltext feature, from reading the documentation it seems this has been greatly enhanced in v4, so a couple of questions 1 - Am I correct is Fulltext Search

Re: MySQL 4.x performance tuning

Reto Baumann wrote: Is there a way to see if the key buffer size was ever reached? It's not really an issue. You can determine how frequently it has the needed index data in memory, to judge the key buffer efficiency. Key read requests 3518220013 Key reads 94807 Key reads / Key

ERROR 1005 during add foreign key

on mysql 4.0.14-standard (x86 Linux) when I try the following: alter table child_table add ( foreign key (column1, column2) references parent_table on delete cascade) ; on an existing innodb table I get: ERROR 1005: Can't create table './dbname/#sql-70f5_b92.frm' (errno: 150) I know the scrip

Re: Inserting Dates

Ian O'Rourke wrote: I'm very new to MySql and I'm having problems inserting dates into my tables (via the Web using Coldfusion). The user can put the following in the field: 12/09/2003 But the data returned from the database is: 2012-09-20 03:00:00.0 INSERT INTO table (field) VALUES ('2003-12-09')

mediumtext crash on strings > 1MB?

Hello, I have a table in which one of the column types has been declared as mediumtext to hold blocks of text averaging 250k in size. A mediumtext datatype should be able to hold > 16 million characters. However, I found my inserts failing when some of my strings exceeded 1 MB (e.g. a string of 11

MySQL 4.x performance tuning

Hi all I have a MySQL installation running on a Pentium3 based system with 2GB RAM... The database primarily uses MyISAM tables with 60% SELECT statements. The database is used as a backend for a PHP web application. Do the following values make any sense? set-variable= key_buffer=200M set-

Re: Inserting Dates

Thanks a lot, time to look into my Coldfusion sting functions or Date_Format in MySQL. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Inserting Dates

Actually, you can insert the date with hyphens, also..so '2003-09-12' will work. and if you're not going to use the time, don't use a datetime datatype...just use date. On Mon, 2004-01-05 at 14:28, Donald Henson wrote: > On Mon, 2004-01-05 at 12:46, Ian O'Rourke wrote: > > I'm very new to MySql a

Re: Inserting Dates

On Mon, 2004-01-05 at 12:46, Ian O'Rourke wrote: > I'm very new to MySql and I'm having problems inserting dates into my tables > (via the Web using Coldfusion). The user can put the following in the field: > > 12/09/2003 > But the data returned from the database is: > > 2012-09-20 03:00:00.0 >

Re: What is the limit of the history command file under Linux

On 5 Jan 2004 at 18:20, Mechain Marc wrote: > Does anybody have an idea of the number of sql commands that can be > saved inside the sql history command file ? > > Is there a way to set this limit ? On my RH7.2 installation the history file is .bash_history and by default is limited to 1000 ent

Re: how to drop more than one tables at once in a database?

On 5 Jan 2004, at 19:58, Bing Du wrote: Greetings, Say, one database has a lot of tables. How can I drop some of them all at once assuming their names follow some pattern like tbl_*? Thanks in advance for any ideas, Take a look at a very similar thread here... http://lists.mysql.com/mysql/15

Re: Inserting Dates

Hi Ian reverse the order of your date, i.e., 2003/09/12 or use the date format function hth steve Ian O'Rourke wrote: I'm very new to MySql and I'm having problems inserting dates into my tables (via the Web using Coldfusion). The user can put the following in the field: 12/09/2003 But the da

Re: Best Method for Learning mysql

Marc Dver wrote: Based on the collective experiences of the members of this group, what are the best methods for learning mysql, both from the perspective of I attended the week-long Mysql training course, and it was excellent. -- MySQL General Mailing List For list archives: http://lists.m

URGENT PROPOSAL

FROM:Emma Ken 3/5 RIDER HAGGARD CLOSE JO,BURG-SOUTH AFRICA PHONE:[874]-762-864166 PHONE:(874)-762-864167 FAX :(874)-762-864168 RE: TRANSFER OF ($26,000.000.00 USD} TWENTY SIX MILLION DOLLARS Dear Sir, I want to transfer ($26,000.000.00 USD) Twenty six million United States Dollars from a Pri

how to drop more than one tables at once in a database?

Greetings, Say, one database has a lot of tables. How can I drop some of them all at once assuming their names follow some pattern like tbl_*? Thanks in advance for any ideas, Bing Du Engineering Computing Support Services 2240 Hoover Hall Iowa State University voice: 515-294-6405 email: [E

RE: Get counts of col=value with an GROUP BY clause?

From: Greg Owen [mailto:[EMAIL PROTECTED] > I'm trying to build a query to show counts of specific > columns by value. > There's probably a simple way to do this that I don't know > about, and if you could just point me to the function or part > of the manual to research before you start lau

Inserting Dates

I'm very new to MySql and I'm having problems inserting dates into my tables (via the Web using Coldfusion). The user can put the following in the field: 12/09/2003 But the data returned from the database is: 2012-09-20 03:00:00.0 So I'm a bit confused about what I need to do in the insert state

re: Unicode support in 4.0.17

Unicode and multiple character sets are not supported until version 4.10. See section 9 of the manual. 4.1.1 is still alpha but its quite stable if your server isn't in a production environment. _ Tired of slow downloads? Compare

Re: MySQL certification

On Mon, 5 Jan 2004, Douglas Sims wrote: > The test was a bit harder than I anticipated. I should have paid more > attention to column types and database name, among other things. But I > did pass - at least, the preliminary report said pass, but also said > that the exam will be reviewed and "If

Re: Re[2]: Enum default values

Ah ha! Thank you Aleksandar. That's a much better solution. In fact, now youv'e told me this, I looked in the Manual, and the scales where lifted from my eyes. You've saved me re-writing (and re-thinking) a large chunk of PHP. For anyone else's future reference it's all there in plain english

Unicode support in 4.0.17

I finally upgraded to 4.0.17 to be able to use the support for Unicode but I have problems running any of the examples I have seen to use th 'CHARACTER SET' option when creating tables. For example, even the following doesn't work: CREATE DATABASE db_name CHARACTER SET latin1 COLLATE latin1_s

Re: MySQL certification

On Mon, 2004-01-05 at 19:56, Douglas Sims wrote: > Thanks, Stefan. Mike's article was interesting. > > The test was a bit harder than I anticipated. I should have paid more > attention to column types and database name, among other things. But I > did pass Congratulations :-) > - at least,

Re: Binary Log replay utility?

I would greatly appreciate your notes if you are willing to post them. I'm currently preparing for the core exam. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Get counts of col=value with an GROUP BY clause?

On Mon, 5 Jan 2004, Greg Owen wrote: > I tried (you can laugh here) to do it this way, but failed miserably: > > mysql> select class,count(questnum),count(difficulty='0'), >count(difficulty='1'),count(difficulty='2'), >count(in_use='0'),count(in_use='1') from Questions >group by class;

Re: MySQL certification

Thanks, Stefan. Mike's article was interesting. The test was a bit harder than I anticipated. I should have paid more attention to column types and database name, among other things. But I did pass - at least, the preliminary report said pass, but also said that the exam will be reviewed and

RE: French characters ok with mysql in Windows, nok with mysql in Linux

Hello, etc/sysconfig/i18n contains: LANG="en_US.UTF-8" SUPPORTED="nl_BE.UTF-8:nl_BE:nl:en_US.UTF-8:en_US:en" SYSFONT="latarcyrheb-sun16" Is that ok? What concerns the 'driver connection url' : should I leave 'useUnicode=true&characterEncoding=UTF-8' in it? Greetings, Willy Dockx -Origin

RE: French characters ok with mysql in Windows, nok with mysql in Linux

Both are the same: Character-set : latin1 Character-sets : a long list Convert_Character_set : Is that like it should be? Greetings, Willy Dockx -Original Message- From: Oriol [mailto:[EMAIL PROTECTED] Sent: maandag 5 januari 2004 15:55 To: Willy Dockx Subject: Re: French characte

Get counts of col=value with an GROUP BY clause?

I'm trying to build a query to show counts of specific columns by value. There's probably a simple way to do this that I don't know about, and if you could just point me to the function or part of the manual to research before you start laughing, I'd greatly appreciate it. Given the following

AW: The Future of MySQL with .NET Plataform

Well, I am using MySQL with ASP.NET, using the managed provider from ByteFX Works like a dream ! Freddie -Ursprüngliche Nachricht- Von: Donald Henson [mailto:[EMAIL PROTECTED] Gesendet: Montag, 5. Januar 2004 16:34 An: MySQL List Betreff: Re: The Future of MySQL with .NET Plataform On

Re: Mysql 5.x versus 4.x

* Carlos J Souza > Mysql 5.x is more quick than 4.x ? This may seem like an easy question, but it is not. I suppose you know the current stable version is 4.0.x, version 5.x is a development version in an 'alpha' state. I have not tried version 5 myself, and I am not one of the developers. This i

Re[2]: Enum default values

Hi, > I will now have to supply a field list to the function in > addition. Ah well ;-) Maybe this help: insert into `property` values ('', 'Riverside View', default); Take care, Aleksandar -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

4.0.17-0.i386.rpm installation hangs

I am trying to install the 4.0.17-0.i386.rpm server package. I first installed the MySQL-shared-compat-4.0.17-0.i386.rpm which went fine. Then I tried the MySQL-client-4.0.17-0.i386.rpm which gave me a segmentation fault. Now, I am running: rpm -Uvh MySQL-server-4.0.17-0.i386.rpm Which see

Re: High load on not used server

# [EMAIL PROTECTED] / 2004-01-05 13:49:17 +0200: > I'm running MySQL 4.0.17 on FreeBSD machine. i have one process which rarely > uses Mysql DB, and few postfix processes which uses db for authorizaton. In > `top` i see that mysql process usually eats 40-50% +/-20. `mytop` show ~5 > sleeping proces

Re: Deciding whether to convert to InnoDB

In the last episode (Jan 05), Travis Reeder said: > I'm sure this has been asked before, but I cannot find solid evidence > as to whether switching would provide us with any benefits. > > We currently run MyIsam tables on 4.1.x and we are continuously > processing 24 hours/day and using about 20 t

What is the limit of the history command file under Linux

Does anybody have an idea of the number of sql commands that can be saved inside the sql history command file ? Is there a way to set this limit ? Thanks, Marc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTEC

compiling mysql with ssl

Hi! I have some trouble tring to compile Mysql 4.0.16 with de options: --with-vio & --with-openssl, I try with some recomedation about it but none successful. Compiling with: ./configure --with-vio --with-openssl=/path/to/openssl --with-openssl-includ e=/path/to/include/ssl.h --with-openssl-l

Very large update

Hello, We are considering moving to MySQL as our production database. We use of for testing and small tasks now, but to move to production we need to efficiently solve a few problems. The first, and probably the most critical, is that we need to be able to run an update that once a week updates

Re: FULLTEXT Search and Hyphens

Michael, have a look at the sources, especially myisam/ft_parser.c near line 108 and at myisam/ftdefs.h. It should not be difficult to hack the sources to make the hyphen a real character. This will solve your problem (but could create some new ones on others types of text input). Thomas On Wed

RE: Issue with DATE_FORMAT() call returning wrong year

I just saw thay in the online documentation. Sometimes it help to read the manual before posting. Sorry. [EMAIL PROTECTED] wrote: Try %Y instead of %X -Original Message- From: PAUL MENARD [mailto:[EMAIL PROTECTED] Sent: Monday, January 05, 2004 10:08 AM To: [EMAIL PROTECTED] Subject:

Re: Enum default values

Hi, > > This usually comes up when people expect an exception to be thrown when > they assign NULL to a NOT NULL column, but this is the same idea. From > the manual : Indeed. One of those weird MySQL things. Is this different on InnoDB? > >

Re: Enum default values

Martijn Tonies wrote: Hi, [snip] If you insert an invalid value into an ENUM (that is, a string not present in the list of allowed values), the empty string is inserted instead as a special error value. This string can be distinguished from a 'normal' empty string by the fact that this string h

RE: Issue with DATE_FORMAT() call returning wrong year

Try %Y instead of %X -Original Message- From: PAUL MENARD [mailto:[EMAIL PROTECTED] Sent: Monday, January 05, 2004 10:08 AM To: [EMAIL PROTECTED] Subject: Issue with DATE_FORMAT() call returning wrong year Hello all, I have a query that for some reason is now returning the incorrect ye

Re: Best Method for Learning mysql

On Mon, 5 Jan 2004, Marc Dver wrote: > Based on the collective experiences of the members of this group, what > are the best methods for learning mysql, both from the perspective of > certification and of learning enough to excel in the production > environment? My interests include both the spec

MySQL 5.0

Any time table for MySQL 5.0 go production? We need its stored procedure feature. Thanks, Bing Du Engineering Computing Support Services 2240 Hoover Hall Iowa State University voice: 515-294-6405 email: [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com

Issue with DATE_FORMAT() call returning wrong year

Hello all, I have a query that for some reason is now returning the incorrect year. First here is my server configuration. Windows 2003 Advanced server MySQL version 4.0.15-nt Here is my SQL statement: SELECT DATE_FORMAT(E.DateTime, '%X-%m-%d %h:%i:%s %p' ) AS DateTime, E.SendCount AS Send

Best Method for Learning mysql

Based on the collective experiences of the members of this group, what are the best methods for learning mysql, both from the perspective of certification and of learning enough to excel in the production environment? My interests include both the specifics of mysql and the general concepts be

Re: The Future of MySQL with .NET Plataform

* Carlos J Souza > Please i need comments about future of MySQL with .NET Plataform > introduction. If find this question a little strange... afaik .NET is a development framework[1], while MySQL is of course a database server. The relation between the two is only indirect via some programming lan

Re: The Future of MySQL with .NET Plataform

On Mon, 2004-01-05 at 07:31, Carlos J Souza wrote: > Hello for all, > > Please i need comments about future of MySQL with .NET Plataform > introduction. > > Regards for all > > Carlos Souza I don't know if you're going to get an answer to that query. .NET is not a very popular subject around h

MySQL 4.1 Production Release

Hi All, Just a quick question, does anyone have a good estimate of when ver 4.1 will go production. Thanks Allen

Re: Perl DBD::mysql failed - Issued Solved.

Issue resolved. For anybody else who runs into this problem here is what I did. 1. went to ftp.suse.com and navigated to /pub/suse/9.0/suse/i586. 2. I downloaded zlib-devel-1.1.4-232.i586.rpm 3. rpm -Uvh zlib-devel-1.1.4-232.i586.rpm 4. then I did the perl Makefile.PL, make, make test

Re: The Future of MySQL with .NET Plataform

Carlos I will be away for Ms Trash .Net platform inet based programs will be the future. i use rpc on my programs as well standart programming .Net for me nothing more an microsoft way o destroy java Regards Luiz --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http:

RE: French characters ok with mysql in Windows, nok with mysql in Linux

Hello, Thank you for your quick response. I start with an empty database. So the data isn't exported. Then users enter data in a web-page. It is this data that can contain French characters and that is added by the java servlet to the database. I will look at the file /etc/sysconfig/i18n this ev

RE: The Future of MySQL with .NET Plataform

Hi Carlos, Could you please post once and only once, and wait for someone who has insight to respond, instead of spamming this list? Thank you, Joshua Thomas Network Operations Engineer PowerOne Media, Inc. tel: 518-687-6143 [EMAIL PROTECTED] --- In theory there is no difference between theory

re: Japanese in MySQL

MySQL doesn't support unicode until version 4.1.0. If this isn't a production server I suggest you upgrade to MySQL 4.1.1. Its still in the ALPHA stage but it is pretty stable. I use it every day and I don't have any problems with it. Good luck, Jeremy ___

The Future of MySQL with .NET Plataform

Hello for all, Please i need comments about future of MySQL with .NET Plataform introduction. Regards for all Carlos Souza -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: French characters ok with mysql in Windows, nok with mysql in Linux

From: "Willy Dockx" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, January 05, 2004 3:00 PM Subject: French characters ok with mysql in Windows, nok with mysql in Linux > Hello, > > I already posted this problem end of 2003, but probably, the champagne has > troubled the answers. > > The

innodb_buffer_pool_size / *_buffer_size relation

I've been trying to tune a MySQL installation a bit, and have a few questions regarding relations/interactions between InnoDB and MySQL when it comes to the various buffers... I wanted this mail to be more specific, but given the lack of info in the manual, I basically don't have much cannon fodder

Re: Table: NULL (yes or no)

Null means "no data entered". If Null is allowed and you don't specifically set a field to a value then it will be Null. If Null is not allowed then the field will be assigned its default value unless you specifically set it to something during an insert. -- MySQL General Mailing List For lis

Re: Enum default values

Hi, > [snip] > > If you insert an invalid value into an ENUM (that is, a string not > > present in the list of allowed values), the empty string is inserted > > instead as a special error value. This string can be distinguished > from > > a 'normal' empty string by the fact that this string has th

French characters ok with mysql in Windows, nok with mysql in Linux

Hello, I already posted this problem end of 2003, but probably, the champagne has troubled the answers. The solution of this problem is really important for me. Can anybody help? I have made a website using jboss, Hibernate, mysql 4.0.16 and mysql-connector-java-3.0.9. In development this is

Re: insert: auto increment field

This bug was fixed to 4.0.17, it happened when you inserted a negative value manually into an auto_increment column for more info see: http://bugs.mysql.com/bug.php?id=1366 On Mon, 5 Jan 2004, Donald Henson wrote: > Please post your table schema. As to why rather than zero, I'll > have to def

RE: Mysql 5.x versus 4.x

Download it and try it yourself. That's the only sure way to know. Joshua Thomas Network Operations Engineer PowerOne Media, Inc. tel: 518-687-6143 [EMAIL PROTECTED] --- In theory there is no difference between theory and practice. In practice there is. - Yogi Berra --- > -Original Mes

RE: Enum default values

[snip] > If you insert an invalid value into an ENUM (that is, a string not > present in the list of allowed values), the empty string is inserted > instead as a special error value. This string can be distinguished from > a 'normal' empty string by the fact that this string has the numerical > val

Re: struggling newbie - datetime or timestamp problem

On Mon, 5 Jan 2004, Matthew Stuart wrote: > I am trying to create a couple of columns (one createddate and one > updateddate) in a MySQL table that are DATETIME or TIMESTAMP values, > but I am having trouble understanding how it works. I want both columns > to auto add a date and time when a recor

  1   2   >