full text search

field.) So should I consider fulltext searching? Do I have to build an index first and how often is it updated etc? -- zzapper Success for Techies and Vim,Zsh tips http://SuccessTheory.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Calling MySQL often risk of performance problems?

systems for smaller client websites etc where speed is not the top criteria. What are your views/experience. -- zzapper Success for Techies and Vim,Zsh tips http://SuccessTheory.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Comparing Numbers in Text Fields

Hi, Recently had a few problems with comparing numbers stored in text mysql fields char(2), which I solved by chnging the field to int(1) Now my question is why do you sometimes appear to get away with this? -- zzapper Success for Techies and Vim,Zsh tips http://SuccessTheory.com/ -- MySQL

Re: Comparing Numbers in Text Fields

On Wed, 12 Oct 2005 13:27:52 +0200, wrote: zzapper wrote: Hi, Recently had a few problems with comparing numbers stored in text mysql fields char(2), which I solved by chnging the field to int(1) Now my question is why do you sometimes appear to get away with this? My guess

Re: Avoiding complex mysql selects

On Tue, 12 Jul 2005 18:34:38 -0400, wrote: H, how about using full text indexing? It will be a lot easier to implement and a lot quicker. Can you give more details? -- zzapper vim -c :%s%s*%Cyrnfr)fcbafbe[Oenz(Zbbyranne%|:%s)[[()])-)Ig|norm Vg? http://www.rayninfo.co.uk/tips/ vim, zsh

Re: Conditions in selects

AND sale_end,'no','yes') another example SELECT IF(STRCMP('test','test1'),'no','yes'); - 'no' -- zzapper vim -c :%s%s*%Cyrnfr)fcbafbe[Oenz(Zbbyranne%|:%s)[[()])-)Ig|norm Vg? http://www.rayninfo.co.uk/tips/ vim, zsh success tips -- MySQL General Mailing List For list archives: http

Re: Avoiding complex mysql selects

searching in boolean mode, can't be used on InnoDB tables, etc. O gosh my learning curve Thanks -- zzapper vim -c :%s%s*%Cyrnfr)fcbafbe[Oenz(Zbbyranne%|:%s)[[()])-)Ig|norm Vg? http://www.rayninfo.co.uk/tips/ vim, zsh success tips -- MySQL General Mailing List For list archives: http

myisam or innodb (chestnut)

. Is myisam still dominant for web applications? -- zzapper vim -c :%s%s*%Cyrnfr)fcbafbe[Oenz(Zbbyranne%|:%s)[[()])-)Ig|norm Vg? http://www.rayninfo.co.uk/tips/ vim, zsh success tips -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Avoiding complex mysql selects

and ( ( (synopsis like '%$key1%') or (titlelike '%$key1%') or (keywords like '%$key1%') ) and ( (synopsis like '%$key2%') or (titlelike '%$key2%') or (keywords like '%$key2%') ) ) __SQL__; } -- zzapper vim -c :%s%s*%Cyrnfr)fcbafbe[Oenz(Zbbyranne%|:%s)[[()])-)Ig|norm Vg

Re: Records which link to other records in same table

would it be useful to have a couple identifier? to simplify the above -- zzapper vim -c :%s%s*%Cyrnfr)fcbafbe[Oenz(Zbbyranne%|:%s)[[()])-)Ig|norm Vg? http://www.rayninfo.co.uk/tips/ vim, zsh success tips -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Update query to set random data

got any other useful queries in this line? -- zzapper vim -c :%s%s*%Cyrnfr)fcbafbe[Oenz(Zbbyranne%|:%s)[[()])-)Ig|norm Vg? http://www.rayninfo.co.uk/tips/ vim, zsh success tips -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Records which link to other records in same table

/mother/children fields and the recordid of other records I'm fogging on this, your advice pls -- zzapper vim -c :%s%s*%Cyrnfr)fcbafbe[Oenz(Zbbyranne%|:%s)[[()])-)Ig|norm Vg? http://www.rayninfo.co.uk/tips/ vim, zsh success tips -- MySQL General Mailing List For list archives: http

Re: Using MySQL to store/archive code/html etc?

index.html etc. I feel the question of whether I should be using VCS is another issue, probably should be! I 'm searching for another level of retrieval sophistication. Sad that a database does not appear ideal. Welcome any lateral ideas -- zzapper vim -c :%s%s*%Cyrnfr)fcbafbe[Oenz(Zbbyranne%|:%s

Using MySQL to store/archive code/html etc?

time going thru CD backups etc than it would take to start again. I've postulated using MySql as a store for such pages. but is a database suitable for storing, searching for and retrieving such information.??? Your eminent opinions and experiences desired!! -- zzapper vim -c :%s%s*%Cyrnfr

Re: Cleaning muck out of data fields

row in set (0.09 sec) mysql select '10.95 tiitti'+0 from dual; +--+ | '10.95 tiitti'+0 | +--+ |10.95 | +--+ 1 row in set (0.02 sec) Mathais Can I write the clean value back? , (i will give it a try) -- zzapper vim -c :%s%s*%Cyrnfr

Re: query to lowercase database columns names

`01_lLcode` `p01_lcode` varchar(255) default NULL, etc eg VIM commands :%s#^[^ ]\+#change p\L :%s# p`# `p# This worked very well -- zzapper vim -c :%s%s*%Cyrnfr)fcbafbe[Oenz(Zbbyranne%|:%s)[[()])-)Ig|norm Vg? http://www.rayninfo.co.uk/tips/ vim, zsh success tips -- MySQL General Mailing List

Cleaning muck out of data fields

have the same problem if I try to Locate I cant AFAIK say locate first digit. Comments/Ideas? Q2) Can I match mucky non-alphanumerics ? -- zzapper vim -c :%s%s*%Cyrnfr)fcbafbe[Oenz(Zbbyranne%|:%s)[[()])-)Ig|norm Vg? http://www.rayninfo.co.uk/tips/ vim, zsh success tips -- MySQL General Mailing

Re: query to lowercase database columns names

.* to someprefix_ Is it not possible to write such a query, or is this best done by Perl or PHP script? -- zzapper vim -c :%s%s*%Cyrnfr)fcbafbe[Oenz(Zbbyranne%|:%s)[[()])-)Ig|norm Vg? http://www.rayninfo.co.uk/tips/ vim, zsh success tips -- MySQL General Mailing List For list archives: http

Re: query to lowercase database columns names

Mathias Yes of course I can use Perl to generate a multiple MySQL Alter script rather than actually doing it via say Perl:DBI::MySQL -- zzapper vim -c :%s%s*%Cyrnfr)fcbafbe[Oenz(Zbbyranne%|:%s)[[()])-)Ig|norm Vg? http://www.rayninfo.co.uk/tips/ vim, zsh success tips -- MySQL General Mailing

Re: Data Design : Numeric or keyword lookup values?

. Charles Walmsley Charles, The data-entry needs to be controlled whether numeric or keyword, usually by drop-down. I will come to some conlusion with my present complex, where I will designing my database from scratch. -- zzapper vim -c :%s%s*%Cyrnfr)fcbafbe[Oenz(Zbbyranne%|:%s)[[()])-)Ig|norm Vg

query to lowercase database columns names

Hi, Is there a query which will alter a table to rename all the columns to lowercase eg Price to price, Quantity to quantity -- zzapper vim -c :%s%s*%Cyrnfr)fcbafbe[Oenz(Zbbyranne%|:%s)[[()])-)Ig|norm Vg? http://www.rayninfo.co.uk/tips/ vim, zsh success tips -- MySQL General Mailing List

Data Design : Numeric or keyword lookup values?

-- zzapper vim -c :%s%s*%Cyrnfr)fcbafbe[Oenz(Zbbyranne%|:%s)[[()])-)Ig|norm Vg? http://www.rayninfo.co.uk/tips/ vim, zsh success tips -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Multi Table Delete in 3.23.47

On Wed, 27 Apr 2005 09:50:37 +0100, wrote: zzapper wrote: On Tue, 26 Apr 2005 23:22:46 +0100, wrote: Hi, The following query runs fine in recent versions of mysql 4.1x etc delete from t2 using tbl_User as t1,tbl_UserTopic as t2 where (t1.txtemail='[EMAIL PROTECTED]') and (t1.intID = t2

Re: Multi Table Delete in 3.23.47

Hi, Final whinge: I wish the mysql website made it a little clearer which features are recent additions, I suggested color coding. BTW regards multi table deletes there's something nasty there between 4.0 and 4.1 -- zzapper vim -c :%s%s*%Cyrnfr)fcbafbe[Oenz(Zbbyranne%|:%s)[[()])-)Ig|norm Vg

Re: Multi Table Delete in 3.23.47

out which bit the doc refered to. BTW Whinge is a rather a mild term in the UK, -- zzapper vim -c :%s%s*%Cyrnfr)fcbafbe[Oenz(Zbbyranne%|:%s)[[()])-)Ig|norm Vg? http://www.rayninfo.co.uk/tips/ vim, zsh success tips -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Multi Table Delete in 3.23.47

change in syntax which will make the query work in 3.23.47? -- zzapper vim -c :%s%s*%Cyrnfr)fcbafbe[Oenz(Zbbyranne%|:%s)[[()])-)Ig|norm Vg? http://www.rayninfo.co.uk/tips/ vim, zsh success tips -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Multi Table Delete in 3.23.47

in the manuals to why this might be. Is there any change in syntax which will make the query work in 3.23.47? I mean how did you do this before 4.x?? -- zzapper vim -c :%s%s*%Cyrnfr)fcbafbe[Oenz(Zbbyranne%|:%s)[[()])-)Ig|norm Vg? http://www.rayninfo.co.uk/tips/ vim, zsh success tips -- MySQL General

General substring update query required

Hi, I want to replace every occurence of a string with another. The following query works fine (appears to anyway) update tbl_websitepages set page_content=replace (page_content,'develop','bucket'); But is there any way to get any Regexp into the substitution? -- MySQL General Mailing List

Repairing Data packing with zeros

Hi, I needed to repair some data that had been entered inconsistently, I was in a rush so I did it manually via SqlYOG. (too much of a rush to consider how to do it quickly!) The bad data in one column propertyID was of kind \w\w\w\d eg ONE1 \w\w\w\d\d eg ABC23 \w\w\w\d\d\d eg FGH123 when

Re: Repairing Data packing with zeros

On Fri, 25 Mar 2005 12:03:26 -0500, wrote: zzapper wrote: ONE1- ONE0001 ABC23 - ABC0023 FGH123 - FGH0123 What Update Query should/could I have used? Something like this perhaps? UPDATE table_name SET propertyID = CONCAT(LEFT(propertyID, 3), LPAD(SUBSTRING(propertyID, 4), 4, '0

Why are my tables read only?

Hi, After upgrading to mysql 4.1.10nt I am being told that some of my tables are read-only I cannot find where or how you might specify that a table is read/write to whatever -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Upgrading to MySQL 4.1X Win32 Horror

:\ C:\mysql\bin\mysql -u root -p mysql mysql SOURCE C:\mysql\scripts\mysql_fix_privilege_tables.sql Just ran this made no difference! YUK YUK YUK zzapper (vim, cygwin, wiki zsh) -- vim -c :%s%s*%CyrnfrTfcbafbeROenzSZbbyranne%|:%s)[R-T]) )Ig|:norm G1VGg? http://www.vim.org/tips/tip.php?tip_id

Re: Is there a Library of complex queries/inserts/queries?

://en.wikibooks.org/wiki/Appendix mysql statement examples zzapper (vim, cygwin, wiki zsh) -- vim -c :%s%s*%CyrnfrTfcbafbeROenzSZbbyranne%|:%s)[R-T]) )Ig|:norm G1VGg? http://www.vim.org/tips/tip.php?tip_id=305 Best of Vim Tips -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: Filtering non-ascii characters from mysql data, null, tab etc

On Fri, 11 Feb 2005 18:41:38 -0500, wrote: zzapper wrote: On Fri, 11 Feb 2005 12:46:29 +0100 (CET), wrote: Tom adapting your script, create table test (txt varchar(255)) Type=MyISAM; insert into test values('Some Text\nand some more'); update test set txt = replace(txt,'\n

Is there a Library of complex queries/inserts/queries?

Hi, Sometimes an example is worth a 1000 words. Does anyone know of a website with lists of mysql statement examples? ie a list of queries, a list of updates, list of inserts from simple examples to joins regexps etc zzapper (vim, cygwin, wiki zsh) -- vim -c :%s%s

Re: Filtering non-ascii characters from mysql data, null, tab etc

character (they all seem to display as a hollow box) was a \r thanx zzapper (vim, cygwin, wiki zsh) -- vim -c :%s%s*%CyrnfrTfcbafbeROenzSZbbyranne%|:%s)[R-T]) )Ig|:norm G1VGg? http://www.vim.org/tips/tip.php?tip_id=305 Best of Vim Tips -- MySQL General Mailing List For list archives: http

Re: Filtering non-ascii characters from mysql data, null, tab etc

character (they all seem to display as a hollow box) was a \r thanx zzapper (vim, cygwin, wiki zsh) -- vim -c :%s%s*%CyrnfrTfcbafbeROenzSZbbyranne%|:%s)[R-T]) )Ig|:norm G1VGg? http://www.vim.org/tips/tip.php?tip_id=305 Best of Vim Tips -- MySQL General Mailing List For list archives: http

Filtering non-ascii characters from mysql data, null, tab etc

null characters. Secondly I'd be interested in a general filter for non-ascii. cheers zzapper (vim, cygwin, wiki zsh) -- vim -c :%s%s*%CyrnfrTfcbafbeROenzSZbbyranne%|:%s)[R-T]) )Ig|:norm G1VGg? http://www.vim.org/tips/tip.php?tip_id=305 Best of Vim Tips -- MySQL General Mailing List For list

Re: Filtering non-ascii characters from mysql data, null, tab etc

script!) zzapper (vim, cygwin, wiki zsh) -- vim -c :%s%s*%CyrnfrTfcbafbeROenzSZbbyranne%|:%s)[R-T]) )Ig|:norm G1VGg? http://www.vim.org/tips/tip.php?tip_id=305 Best of Vim Tips -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Perl Script to transform a MySql insert into an update

Hi, Does anyone have a Perl Script (or other) to transform a MySql insert into an update (or vice-versa)??? zzapper (vim, cygwin, wiki zsh) -- vim -c :%s%s*%CyrnfrTfcbafbeROenzSZbbyranne%|:%s)[R-T]) )Ig|:norm G1VGg? http://www.vim.org/tips/tip.php?tip_id=305 Best of Vim Tips -- MySQL

Re: Perl Script to transform a MySql insert into an update

into an update statement # zzapper [EMAIL PROTECTED] # NB does not handle any commas in strings etc $insert_str=q|(fred,joe) values ('$fred','$joe')|; $_=$insert_str; s#^\s*\(([^)]+)\)##; $set_str=$1; s#values\s+\(([^)]+)\)##; $values_str=$1; @set_array=split(/,/,$set_str); @values_array=split

A query to swap the data in two fields

Hi, I want to swap the data in two fields eg t1.beds to t1.beds2 and t2.beds2 to t1.beds Do i need to temporarily store one of the fields (thinking like a programmer)? Can you suggest what query I need here pls? zzapper (vim, cygwin, wiki zsh) -- vim -c :%s%s

Re: A query to swap the data in two fields

On Thu, 23 Sep 2004 11:03:08 +0100, wrote: Hi, I want to swap the data in two fields eg t1.beds to t1.beds2 and t2.beds2 to t1.beds do I need to store one of the fields temporarily? Hey chums you normally get me an answer in minutes, is my question too easy? zzapper (vim, cygwin, wiki

Re: A query to swap the data in two fields

normally get me an answer in minutes, is my question too easy? zzapper (vim, cygwin, wiki zsh) -- zzapper, Gee, have you paid your bill yet?g The only thing I've been able to come up with is: update table1 a, table1 b set a.beds1=b.beds2, a.beds2=b.beds1 where a.rcd_id=b.rcd_id You need

Re: Understanding Joins : Baffled

'; Thanks very much for your help, I still struggle to think database, but my understanding will now (hopefully) leapfrog. It's always a struggle when you are at such a low level of your learning curve that you cannot easily formulate your pleas for help!! zzapper (vim, cygwin, wiki zsh) -- vim -c

Is it possible to have Undeletable Records?

field Record Read only, but is there anyway to specify at the data level? zzapper (vim, cygwin, wiki zsh) -- vim -c :%s%s*%CyrnfrTfcbafbeROenzSZbbyranne%|:%s)[R-T]) )Ig|:norm G1VGg? http://www.vim.org/tips/tip.php?tip_id=305 Best of Vim Tips -- MySQL General Mailing List For list archives

Understanding Joins : Baffled

ON dev.IDurl1 = url.intID WHERE intDevID = #intDevID# But that only Joins one record. and I cant understand how I would access the results of the query Baffled help!!! zzapper (vim, cygwin, wiki zsh) -- vim -c :%s%s*%CyrnfrTfcbafbeROenzSZbbyranne%|:%s)[R-T]) )Ig|:norm G1VGg? http

Re: Understanding Joins : Baffled

KEY (`intDevID`)) TYPE=MyISAM zzapper (vim, cygwin, wiki zsh) -- vim -c :%s%s*%CyrnfrTfcbafbeROenzSZbbyranne%|:%s)[R-T]) )Ig|:norm G1VGg? http://www.vim.org/tips/tip.php?tip_id=305 Best of Vim Tips -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Re: Using REGEXP

ON t1.txtDevPostCode LIKE concat(sc.short_code, '%') and this query would use indexes on txtDevPostCode and short_code. Thnx to all for this mysql primer, will let you know how it goes, but have been dragged off to another crisis zzapper (vim, cygwin, wiki zsh) -- vim -c :%s

Re: Using REGEXP

that the length of a short postcode is 5 chars How would you solve this problem (The list of short Area Postcodes is generated by an earlier query) zzapper (vim, cygwin, wiki zsh) -- vim -c :%s/^/WhfgTNabgureRIvzSUnpxre/|:%s/[R-T]/ /Ig|:normal ggVGg? http://www.vim.org/tips/tip.php?tip_id=305 Best

Using REGEXP

of short postcodes OX14 1,OX14 2 etc whereas t1.postcode contains full postcodes OX14 5RA (If qryRadius.shortpostcode wasn't a list I'd be able to use LIKE) How can I write a Where clause that gets round this MySql 4.018 zzapper (vim, cygwin, wiki zsh) -- vim -c :%s/^/WhfgTNabgureRIvzSUnpxre

Using REGEXP

of short postcodes OX14 1,OX14 2 etc whereas t1.postcode contains full postcodes OX14 5RA (If qryRadius.shortpostcode wasn't a list I'd be able to use LIKE) How can I write a Where clause that gets round this MySql 4.018 zzapper (vim, cygwin, wiki zsh) -- vim -c :%s/^/WhfgTNabgureRIvzSUnpxre

Re: Using REGEXP

On Tue, 29 Jun 2004 15:13:10 -0400, wrote: zzapper: I could be reading it wrong, but it looks like you're looking for the result of your REGEXP in a list. REGEXP returns only a 0 or 1, not the expression resulting from performing a REGEXP. Wes On Jun 29, 2004, at 9:25 AM, zzapper wrote

Re: Mysql for Family History (genealogy)

(right now, only in CVS). Don't know if it's specifically MySQL or not. The current release of GRAMPS stores its information in an XML file. I'm looking for something a little simpler. I just thought somebody might have designed a mysql datastructure. zzapper (vim, cygwin, wiki zsh) -- vim

What is your mysql debugging strategy?

INNER JOIN tbl_projectstatus AS ps ON sp.ProjectStatus = ps.ProjectStatus LEFT JOIN tbl_invoice ON sp.SubProjectID = tbl_invoice.SubProjectID WHERE (tbl_invoice.SubProjectID Is Null) AND (sp.ProjectID=1) AND (sp.Deleted=0) AND (ps.Invoice=1) ORDER BY sp.OrderBy DESC zzapper (vim, cygwin, wiki zsh

Mysql for Family History (genealogy)

Hi, Anyone designed a MySql database for family history? Any ideas,recommendations, problems ? zzapper (vim, cygwin, wiki zsh) -- vim -c :%s/^/WhfgTNabgureRIvzSUnpxre/|:%s/[R-T]/ /Ig|:normal ggVGg? http://www.vim.org/tips/tip.php?tip_id=305 Best of Vim Tips -- MySQL General Mailing List

Re: storing

Liz, You can do this, but I'd rather store them as a script eg with mysqldump zzapper (vim, cygwin, wiki zsh) -- vim -c :%s/^/WhfgTNabgureRIvzSUnpxre/|:%s/[R-T]/ /Ig|:normal ggVGg? http://www.vim.org/tips/tip.php?tip_id=305 Best of Vim Tips -- MySQL General Mailing List For list archives

Re: What is your mysql debugging strategy?

. THis would output the problem to the page. Dead simple and quick. Rich Joshua J. Kugler wrote: On Tuesday 27 April 2004 04:26 am, zzapper said something like: Even though I solved the following problem myself, I'd like to know what debugging strategy people use to solve problems when they get

Sub-select Inner Joins

= sp.ProjectID WHERE ut.reportDisplay = 1 zzapper (vim, cygwin, wiki zsh) -- vim -c :%s/^/WhfgTNabgureRIvzSUnpxre/|:%s/[R-T]/ /Ig|:normal ggVGg? http://www.vim.org/tips/tip.php?tip_id=305 Best of Vim Tips -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: Complicated Inner Joins

#) ) AS pr ON sp.SubProjectID = pr.SubProjectID) ON ut.Unit = pr.Unit ) INNER JOIN tbl_RateTypeCategoryCharge AS rt ON pr.RateTypeCategoryChargeID = rt.RateTypeCategoryChargeID ) ON p.ProjectID = sp.ProjectID WHERE ut.reportDisplay = 1 zzapper (vim, cygwin, wiki zsh

Complicated Inner Joins

= i.ProjectID) LEFT JOIN tbl_subproject ON i.SubProjectID = tbl_subproject.SubProjectID WHERE i.InvoiceStatus Not IN('Show All') AND i.ProjectID =-1 AND i.Deleted = 0 Order BY si.Orderby ,i.InvoiceNumber zzapper (vim, cygwin, wiki zsh) -- vim -c :%s/^/WhfgTNabgureRIvzSUnpxre/|:%s/[R-T]/ /Ig|:normal

Re: Complicated Inner Joins

zzapper (vim, cygwin, wiki zsh) -- vim -c :%s/^/WhfgTNabgureRIvzSUnpxre/|:%s/[R-T]/ /Ig|:normal ggVGg? http://www.vim.org/tips/tip.php?tip_id=305 Best of Vim Tips -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Table/Column Name Completion

Hi Ya I believe the Dos Mysql Client has limited table name completion, but do any of the GUI Clients have this feature?? zzapper (vim cygwin zsh) -- vim -c :%s/^/WhfgTNabgureRIvzSUnpxre/|:%s/[R-T]/ /Ig|:normal ggVGg? http://www.vim.org/tips/tip.php?tip_id=305 Best of Vim Tips -- MySQL

Re: Please help with syntax for mysqldump

somebody email me the full syntax to use which comes after the mysql mysqldump -udavidrayner -pdavidrayner eeetic eeetic.sql mysqldump -udavidrayner -pdavidrayner -A all.sql zzapper (vim cygwin zsh) -- vim -c :%s/^/WhfgTNabgureRIvzSUnpxre/|:%s/[R-T]/ /Ig|:normal ggVGg? http://www.vim.org

Re: Please help with syntax for mysqldump

On Tue, 13 Jan 2004 14:07:38 +, Matthew Stuart [EMAIL PROTECTED] wrote: Similarly. SELECT intDEVID,txtDEVPOSTCODE INTO OUTFILE c:/aaa/dump.sql from ytbl_development; (dump.sql file must NOT already exist) zzapper (vim cygwin zsh) -- vim -c :%s/^/WhfgTNabgureRIvzSUnpxre/|:%s/[R-T

Automatic Updating of Timestamp

to automatically mark INSERT or UPDATE operations with the current date and time. If you have multiple TIMESTAMP columns, only the first one is updated automatically. zzapper (vim cygwin zsh) -- vim -c :%s/^/WhfgTNabgureRIvzSUnpxre/|:%s/[R-T]/ /Ig|:normal ggVGg? http://www.vim.org/tips/tip.php?tip_id=305

Converting an Access Table to MySQL

) ; } #-# zzapper (vim cygwin zsh) -- vim -c :%s/^/WhfgTNabgureRIvzSUnpxre/|:%s/[R-T]/ /Ig|:normal ggVGg? http://www.vim.org/tips/tip.php?tip_id=305 Best of Vim Tips -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: Converting an Access Table to MySQL

there's a better way; thanx. The only advantage of my script is that I could do a fairly complex query to transform the data if that were necessary zzapper (vim cygwin zsh) -- vim -c :%s/^/WhfgTNabgureRIvzSUnpxre/|:%s/[R-T]/ /Ig|:normal ggVGg? http://www.vim.org/tips/tip.php?tip_id=305 Best of Vim

Re: Converting an Access Table to MySQL

www.mysqlfront.de I'm not sure it's stable yet zzapper (vim cygwin zsh) -- vim -c :%s/^/WhfgTNabgureRIvzSUnpxre/|:%s/[R-T]/ /Ig|:normal ggVGg? http://www.vim.org/tips/tip.php?tip_id=305 Best of Vim Tips -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: MySQL Control Center!!!

to the URL. try gmane.comp.db.mysql.mycc (but I don't think there's any doc) zzapper (vim cygwin zsh) -- vim -c :%s/^/WhfgTNabgureRIvzSUnpxre/|:%s/[R-T]/ /Ig|:normal ggVGg? http://www.vim.org/tips/tip.php?tip_id=305 Best of Vim Tips -- MySQL General Mailing List For list archives: http

Re: Problem With Creating Table

, last_post_member_name VARCHAR(79) NOT NULL); Caroline, Maybe you should be putting long sql statements into an external script eg $ mysql -D mydb -u test -ptest create_table.sql zzapper (vim cygwin zsh) -- vim -c :%s/^/WhfgTNabgureRIvzSUnpxre/|:%s/[R-T]/ /Ig|:normal ggVGg? http://www.vim.org/tips/tip.php

Re: Comparing strings containing possible quotes

On Mon, 08 Dec 2003 19:07:43 +, zzapper [EMAIL PROTECTED] wrote: Hi Ya, I have a typical select as follows SELECT * FROM ytbl_development AS t1 WHERE (t1.txtDevName LIKE '%#form.searchtext#%') B) Now I can filter any quotes from form.searchtext easy enough, but how do I filter

Re: Comparing strings containing possible quotes

the quotes (which is what I want) BUT IS THAT A FEATURE OF LIKE??? zzapper -- vim -c :%s/^/WhfgTNabgureRIvzSUnpxre/|:%s/[R-T]/ /Ig|:normal ggVGg? http://www.vim.org/tips/tip.php?tip_id=305 Best of Vim Tips -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: Comparing strings containing possible quotes

previously wanted to do a regexp on the input string but this not seem to be permitted zzapper -- vim -c :%s/^/WhfgTNabgureRIvzSUnpxre/|:%s/[R-T]/ /Ig|:normal ggVGg? http://www.vim.org/tips/tip.php?tip_id=305 Best of Vim Tips -- MySQL General Mailing List For list archives: http

Comparing strings containing possible quotes

this. zzapper -- vim -c :%s/^/WhfgTNabgureRIvzSUnpxre/|:%s/[R-T]/ /Ig|:normal ggVGg? http://www.vim.org/tips/tip.php?tip_id=305 Best of Vim Tips -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

How do test unique values in a MySql column?

Hi Y'All I need to test if any values in a column are the same (or are unique) eg (my made up syntax Unique) SELECT * from tbl_addresses WHERE txtName is UNIQUE; How should this be done??? zzapper -- vim -c :%s/^/WhfgTNabgureRIvzSUnpxre/|:%s/[R-T]/ /Ig|:normal ggVGg? http://www.vim.org

mysqlfront versus mysqlcc

I currently use the excellent mysqlfront which is sadly no longer supported. I've tried mysqlcc but it seems non-intuitive, and missing loads of features. It also has a problem working with old versions of mysql 3.23.47 Or have I missed something, does anyone recommend mysqlcc??? zzapper

How can I become an Expert MySql User?

zzapper -- vim -c :%s/^/WhfgTNabgureRIvzSUnpxre/|:%s/[R-T]/ /Ig|:normal ggVGg? http://www.vim.org/tips/tip.php?tip_id=305 Best of Vim Tips -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Why is there no REGEXP()?

to need some kind of inner query. can U help? zzapper -- vim -c :%s/^/WhfgTNabgureRIvzSUnpxre/|:%s/[R-T]/ /Ig|:normal ggVGg? http://www.vim.org/tips/tip.php?tip_id=305 Best of Vim Tips -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Why is there no REGEXP()?

of REGEXP doesnt exist AFAIK , what work arounds exist, or how would you do it? BTW the QuotedValueList contains Short Postcodes of type AA11 or A11 or AA1 zzapper -- vim -c :%s/^/WhfgTNabgureRIvzSUnpxre/|:%s/[R-T]/ /Ig|:normal ggVGg? http://www.vim.org/tips/tip.php?tip_id=305 Best of Vim Tips