Re: confirm unsubscribe to mysql@lists.mysql.com

to make it easier to help you. > > --- Enclosed is a copy of the request I received. > > Received: (qmail 22886 invoked by uid 48); 28 Jun 2005 > 14:19:37 - Date: 28 Jun 2005 14:19:37 - > Message-ID: <[EMAIL PROTECTED]> > To: > [EMAIL PROTECTED] > Subject:

substituting a certain word in all the tinytext rows in a table using SQL command

Dear friend, Is it possible to substitute, using SQL command, a certain word with another word in all the field in all the rows (tinytext) within a certain table? Thanks in advance -- symbulos - ethical services for your organisation website www.symbulos.com -- MySQL General Mailing List

Re: How to extract only the first few lines from a longtext field

Thanks for the very useful suggestions! I was thinking of adding a simple check to search for the first "full stop" after the count of words. It sounded sensible in the case where people want to have a full sententences, not interrupted in the middle. -- MySQL General Mailing List For list ar

Re: How to extract only the first few lines from a longtext field

ny character, whilst the problem of solution (1) is that it could potentially break a word in the middle. Is there a method which uses word counting? -- symbulos - ethical services for your organisation website www.symbulos.com -- MySQL General Mailing List For list archives: http://lists.mysql

How to extract only the first few lines from a longtext field

Dear friends, how do you extract with a query only the first few lines from a blob field? For instance: you have an article stored in the field. You would like to visualise the first few lines before reading it all. Thanks in advance. -- symbulos - ethical services for your organisation

importing, exporting data in IIF format (for example quickbooks)

Dear friends, one of our customer is asking to integrate a mysql application with an application called Quickbooks (accounting package, www.quickbooks.co.uk). Apparrently the application can only import export files in the format IIF. Has anybody any expereince in importing, exporting to this f

again on encryption function, with bug 7846 question

://bugs.mysql.com/bug.php?id=7846 has been fixed. -- symbulos partners -.- symbulos - ethical services for your organisation http://www.symbulos.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: functions md5, crypt

On Monday 21 Mar 2005 16:32, Michael Stassen wrote: > Which is the first hit if you enter "md5 crypt" in the manual's search box. I use the manual offline, because my connection is too slow. I wonder why the encryption-function chapter is not in my manual. -- symbulos par

functions md5, crypt

Dear friends, where is the description of the functions md5 in the manual? where is the description of the function crypt()? are there are good alternatives? -- symbulos partners -.- symbulos - ethical services for your organisation http://www.symbulos.com -- MySQL General Mailing List For

Re: A complex normalisation problem in MySQL 4.0.20 (innodb engine)

which means filling the column with 0 when it is not the default). What do you think? > > Answer those questions and you will solve your problem. > > Shawn Green > Database Administrator > Unimin Corporation - Spruce Pine -- symbulos partners -.- symbulos - ethical services for

A complex normalisation problem in MySQL 4.0.20 (innodb engine)

lot of problems in updating the tables. -- symbulos partners -.- symbulos - ethical services for your organisation http://www.symbulos.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

myodbc on mandrake

Dear friends, I cannot locat the odbc driver for mysql in mandrake. Does anyone have an idea about the whereabouts of the thing? thanks in advance -- symbulos partners -.- symbulos - ethical services for your organisation http://www.symbulos.com -- MySQL General Mailing List For list

Recursive category table problem (whatever you define it). Help!

problem of assigning a different status (main, sub, sub-sub and so on) depending on the type of item to each category I put in the list. Help! -- symbulos partners -.- symbulos - ethical services for your organisation http://www.symbulos.com -- MySQL General Mailing List For list arch

Re: FULLTEXT index on InnoDB tables (looking for a workaround)

you solve the rollback problem?) The latter consumes less disk space, performance wise is better. Do you see any other drawback / advantage? -- symbulos partners -.- symbulos - ethical services for your organisation http://www.symbulos.com -- MySQL General Mailing List For list a

Re: FULLTEXT index on InnoDB tables (looking for a workaround)

we are using InnoDB is because there s full support - for foreign keys, - for joint queries - for rollback on commit Does anybody know any other way of indexing the table in a way, which would allow full text search? -- symbulos partners -.- symbulos - ethical services for your organ

FULLTEXT index on InnoDB tables

Dear friends, I would need to index FULLTEXT two columns in a InnoDB table. How do you solve the problem? -- symbulos partners -.- symbulos - ethical services for your organisation http://www.symbulos.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

InnoDB engine as default for an entire database

Dear friend, is it possible to select the InnoDB engine as default for an entire database? What we want is to create all InnoDB tables, without using the declaration type=innodb. -- symbulos partners -.- symbulos - ethical services for your organisation http://www.symbulos.com -- MySQL