Re: Table: NULL (yes or no)

- Original Message - From: Mike [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, January 05, 2004 10:53 AM Subject: Re: Table: NULL (yes or no) I create two tables. And when I do desc table_name; NULL value can be 'Yes' or 'No'. What the difference when NULL value is 'Yes' or

Deciding whether to convert to InnoDB

Hi, 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 tables heavily. The process is generally doing

Re: myISAM to innodb

vinay [EMAIL PROTECTED] wrote: hi, i have been using mysql-3.23.49a and now i want innodb support for the same version of the database, can any one tell how should i proceed. regards If you want to use InnoDB, you should install MySQL-Max binary:

Re: automatic replication

On Wed, 2003-12-31 at 03:41, Robert Mena wrote: Hi, I am currently using the replication function of my mysql server (3.23.58) to replicate one database. Since I host others I'd like to know if there is a way to automatically replicate a database. I.e as soon as a use issues a mysqladmin

Re: MySQL certification

Douglas, I'm scheduled to take the MySQL certification exam tomorrow morning, thus currently intently cramming with the MySQL reference manual and writing out study notes etc. I'm not too worried as I've been using MySQL for years (although preping for this has been a good exercise and

Mysql 5.x versus 4.x

Hello Friends, Mysql 5.x is more quick than 4.x ? 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]

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: Deciding whether to convert to InnoDB

Set up a load test system which is as near a replica of your production environment as possible. Capture an hour's worth of transactions. Load an copy of your database. Play the queries in and see how long it takes. Any advice without taking something like the above steps is pure speculation,

newbie FTP question

I have my website and MySQL db sitting locally on my PC. I need to get it to the remote server, I know how to get the website pages and images there, but am not sure how to transfer the data, tables and all from the database. Can somebody help me or point me to a tutorial? Thanks Mat --

Re: newbie FTP question

On Monday 05 January 2004 11:26, Matthew Stuart wrote: I have my website and MySQL db sitting locally on my PC. I need to get it to the remote server, I know how to get the website pages and images there, but am not sure how to transfer the data, tables and all from the database. Can somebody

High load on not used server

Hallo, 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 processes and 1 SHOW PROCESSLIST (it's me). So, who

Re: Data is not getting displayed

[EMAIL PROTECTED] wrote: I have a table having 3 field of text datatype. One of the field is Age_type where the data is either 0+ or 75. Its found that on executing the select statement, this particular column is showing blank in linux system, where as the same is showing the datain

DBD::MySQL and win32

hi listers where can i find/download such software? tks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Enum default values

Hi, I'm having problems with setting default values for an enum. It's for a booking system, and I'm keeping track of which day a property starts a booking period. It's useful to have the enum in day order therefore. Omitting the prompts, here's what's happening; * drop table property;

RE: Enum default values

[snip] insert into property values ('','Book-keeper\'s Cottage','Thu'); insert into property values ('','Inglenook Barn','Fri'); insert into property values ('','Maggie\'s House','Fri'); insert into property values ('','Riverside View',''); insert into property values ('','The Manse',''); insert

solution...... RE: :MySQL and win32

sorry guys, i was a bit quick. i found it @ http://search.cpan.org/~rudy/DBD-mysql-2.9003/lib/DBD/mysql.pm -Original Message- From: Tom Roos Sent: 05 January 2004 14:26 To: [EMAIL PROTECTED] Subject: DBD::MySQL and win32 hi listers where can i find/download such software? tks --

struggling newbie - datetime or timestamp problem

I have been sent a url for datetime explanations in the MySQL manual. I have learnt a few things, but I am also more confused than ever. 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

Re: Enum default values

Jay! Thanks for help with a 'proper' insert. ;-) Yes, the full statement works fine. (I assume this is something like the not setting default values from importing DATA files?) All a bit of a shame, as I'm executing the insert from a PHP script, and was trying to make the routine as generic

Re: Enum default values

Hi, [snip] insert into property values ('','Book-keeper\'s Cottage','Thu'); insert into property values ('','Inglenook Barn','Fri'); insert into property values ('','Maggie\'s House','Fri'); insert into property values ('','Riverside View',''); insert into property values ('','The

Temporary table rights

Someone can give me a hand with this: I'll be fighting with rights over tmp tables time ago, basically I want give full temporary tables management but not for other all tables, including select right. The only way to do that work was insert in tables_priv for each user a user/tmp_table_name

RE: Deciding whether to convert to InnoDB

Do you need foreign keys? Then the switch to InnoDB may be worthwhile. That's part of the reason I switched. I also had occasional table corruption with my myISAM tables; this also went away when I switched to InnoDB. Joshua Thomas Network Operations Engineer PowerOne Media, Inc. tel:

Re: Join sintax question

Il giorno 04/gen/04, alle 17:34, Douglas Sims ha scritto: Hi Giulio Hi Doug, I think you could do this by repeatedly left-joining the categories table as in this: SELECT AudioTrack.* FROM AudioTrack A LEFT JOIN AudioTracks_Categories C1 ON A.AudioTrack_id=C1.AudioTrack_id LEFT JOIN

RE: Enum default values

[snip] Yes, the DEFAULT doesn't apply. However, shouldn't MySQL raise an exception because '' isn't a valid value for this ENUM specification? [/snip] From http://www.mysql.com/doc/en/ENUM.html The value may also be the empty string () or NULL under certain circumstances: If you insert an

Re: insert: auto increment field

Please post your table schema. As to why bignbr rather than zero, I'll have to defer to the experts. Don Henson On Sun, 2004-01-04 at 16:52, Mike Mapsnac wrote: I use both metods and they works But when I make another insert I receive a message ERROR: 1062 Duplicate entry '2147483647' for

Re: struggling newbie - datetime or timestamp problem

Your easiest route would be to make createddate a DATETIME field and update it yourself when you insert a record. You can then make updateddate a TIMESTAMP and let MySQL set it to NOW() automatically for you by not specifying it in any of your insert or update queries. If you made them both

Re: Enum default values

[snip] Yes, the DEFAULT doesn't apply. However, shouldn't MySQL raise an exception because '' isn't a valid value for this ENUM specification? [/snip] From http://www.mysql.com/doc/en/ENUM.html The value may also be the empty string () or NULL under certain circumstances: If you

Re: struggling newbie - datetime or timestamp problem

Matthew Stuart [EMAIL PROTECTED] wrote on 05/01/2004 12:49:03: 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

Mysql 5.x versus 4.x

Hello Friends, Mysql 5.x is more quick than 4.x ? 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]

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: newbie FTP question

If you are using the MyISAM table type and have FTP access to the MySQL data folder then you can just upload the database folder to your server. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: struggling newbie - datetime or timestamp problem

Use your code to do this with. Create the table as listed, then on your app have your insert code reflect... $query = insert into all_articles values (null,now(),now(),'$text'); and update the table as listed ... $updateQuery = update all_articles set updateddate=now(),article='$text' where

REGEXP or LIKE

Hello, With your experience.. which runs better: REGEXP or LIKE? assuming you can express the query in both forms. I found that LIKE is twice faster than REGEXP using i.e: LIKE '%1068812942%' REGEXP '1068812942' -thanks, Eli -- MySQL General Mailing List For list archives:

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 record

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 value

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

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 bignbr rather than zero, I'll have

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

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 the

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 list

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

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 solution

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: 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

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

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

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

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

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: 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 here. If

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

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

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

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:

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

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

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

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 http://www.mysql.com/doc/en/constraint_NOT_NULL.html: Indeed. One of those weird MySQL things. Is this different on InnoDB? To be

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]

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

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

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

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

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

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 processes

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

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:

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

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

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

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

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=truecharacterEncoding=UTF-8' in it? Greetings, Willy Dockx -Original

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

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; You

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: 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, the

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

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

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 you

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

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

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

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:

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

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:

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

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...

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

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 So I'm

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 and

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]

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

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

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 cfquery ... INSERT INTO table (field) VALUES

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

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

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

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:

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

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 the

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

  1   2   >