mysqldump generates invalid SQL for "db" table

r (User) then the mysql client creates the "db" table happily. >How-To-Repeat: mysqldump --all-databases --opt > foo.sql mysql < foo.sql >Fix: Ensure a space character seperates the KEY name and parenthesis. >Submitter-Id: >Originator:

mySQL Gui problem

password. Is there something I'm doing wrong? Hope you can help.... Neil Craig Technical Support Consultant QEDI (Pty) Ltd Tel: (011) 266 6947 Fax: (011) 266 5080 Cell: 083 601 4686 E-mail: [EMAIL PROTECTED] - Before posting, p

Query multiple tables

AttractionDescription Then I have TableName AccommodationAttractions Field1AccommodationAttractions Field2 AccommodationID Field3 AttractionID What query do I need to get AccommodationName and what attractions it has from AccommodationAttractions Thanks Neil -- MySQL

Error in statement

tionOverviewID)='ENG') AND ((AccommodationOverview.AccommodationID)<>'1')) Any ideas ? Neil On 7/6/06, Ed Reed <[EMAIL PROTECTED]> wrote: Anyone have an idea on this? Upgrade. Or at least stop repeating the question. Jochem -- MySQL General Mailing Lis

Access mySQL database across Internet

the database from the other datacenter across the Internet ? Thanks Neil _ Be one of the first to try Windows Live Mail. http://ideas.live.com/programpage.aspx?versionId=5d21c51a-b161-4314-9b0e-4911fb2b2e6d

RE: Access mySQL database across Internet

What would you assume to be high traffic ? 1000 hits per day or more ? > Date: Thu, 10 Aug 2006 13:05:11 -0500> From: [EMAIL PROTECTED]> To: [EMAIL > PROTECTED]> Subject: Re: Access mySQL database across Internet> CC: > mysql@lists.mysql.com> > Neil, in theory, t

RE: Access mySQL database across Internet

; pretty normal "stuff". That > averages out to a hit every 32 seconds or> > so during the course of an 8 to > 5 business day, a hit every 86 seconds> > or so in a full day. No problems > at that level.> >> > When you get to 1000 hits / minute, then you

RE: Access mySQL database across Internet

> On Fri, 11 Aug 2006 15:02:12 +, Neil Tompkins wrote> > > At the moment our mysql server hosted by an ISP, is updated every > > second > by a program running on our local Internet connection from > > our own office > network. We have seen no performance issue

RE: Access mySQL database across Internet

ase. Not really a lot of time saved but for a> high-volume > site it can make a difference; also may help if you are> experiencing network > latency.> > Is establishing a connection what you feel is slow? Or the > transfer> of data between your servers is what's s

Return list where no data exists

Hi, I've two tables. What query do I need to use to get a list of all records from table A where table B doesn't contain a a mathing record. For example TableA ID Name TableB Date ID Name Thanks Neil _ Be one of

RE: Return list where no data exists

Using this query seems to hang my computer and mySQL server reported the queries had been LOCKED. > Date: Mon, 21 Aug 2006 11:09:35 +0200> From: [EMAIL PROTECTED]> To: [EMAIL > PROTECTED]> CC: mysql@lists.mysql.com> Subject: Re: Return list where no data > exists> >

Search Engine type search

On my website I'm looking to add a search box. I have a number of different database fields. Does anyone have any recommendations about how I can perform a search engine type search including the text fields. Regards Neil ___

RE: Search Engine type search

INDEX, but for some reason it is not showing above ? Any ideas Neil > Date: Tue, 22 Aug 2006 11:54:43 +0100> From: [EMAIL PROTECTED]> To: [EMAIL > PROTECTED]> CC: mysql@lists.mysql.com> Subject: Re: Search Engine type > search> > Neil Tompkins wrote:> > I ha

RE: Search Engine type search

to. Thanks Neil > Date: Wed, 23 Aug 2006 12:34:10 +1000> From: [EMAIL PROTECTED]> To: [EMAIL > PROTECTED]> CC: mysql@lists.mysql.com> Subject: Re: Search Engine type > search> > Neil Tompkins wrote:> > I followed the instructions, but when doing > a sea

RE: Search Engine type search

OK, I appear to be getting somewhere with the FULL TEXT search. Does anyone have any good resources about producing search engine type results ? for example if some enters a search phrase like londn how would I suggest the word london ? > From: [EMAIL PROTECTED]> To: [EMAIL PROTECTED]; [EMA

Batch Update of records

Hi I've am updating a database with about 20,000 records. What is the best way to perform these updates. Can I use batch updating ? Thanks Neil _ Be one of the first to try Windows Live Mail. http://ideas.liv

RE: Search Engine type search

pen-source spell checkers> > (http://www.thefreecountry.com/sourcecode/spellcheckers.shtml, et al). I> > don't know what language you are using, so I can't go further than that.> > > Regards,> > Jerry Schwartz> Global Information Incorporated> 195 Farmington > A

Show differences between two tables

Hi I've two tables TableA FieldID Enabled TableB FieldID Enabled What query would I need to show what FieldIDs which are the same, but the enabled field status is different ?Thanks, Neil _ Be one of the first to try Wi

Difficult query

owing : Area1 Name Area2 Name Thanks for any help Neil _ Be one of the first to try Windows Live Mail. http://ideas.live.com/programpage.aspx?versionId=5d21c51a-b161-4314-9b0e-4911fb2b2e6d

Slow Access When Inserting Records

s what the problem might be ? Thanks, Neil _ Be one of the first to try Windows Live Mail. http://ideas.live.com/programpage.aspx?versionId=5d21c51a-b161-4314-9b0e-4911fb2b2e6d

RE: Slow Access When Inserting Records

Hi, The difference is noticeable (sometimes 15 seconds), as it is being performed on a webpage. The slow server is running at 100mb and ping times to the database server are 1ms or less. Could the problem with be IIS ? Thanks Neil > Date: Sun, 8 Oct 2006 17:17:07 -0500> To:

RE: Slow Access When Inserting Records

Hi, I've tested the exact same ASP pages on my local computer, and the pages load very quickly. Therefore there must be a problem with dedicated windows server. Any ideas what the problem might be ? Thanks,Neil > Date: Sun, 8 Oct 2006 17:17:07 -0500> To: mysql@lists.mysql.com>

FW: Slow Access When Inserting Records

e ASP pages on my local computer, and the pages load very quickly. Therefore there must be a problem with dedicated windows server. Any ideas what the problem might be ?Thanks,Neil > Date: Sun, 8 Oct 2006 17:17:07 -0500> To: mysql@lists.mysql.com> From: [EMAIL > PROTECTED]> Subj

mySQL Administrator 1.1.9 warning message

mySQL Administrator to backup my database and what unexpected behaviour can I expect ? Thanks Neil -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Can I use mySQL Administrator on server version 3.23.58

mySQL Administrator to backup my database and what unexpected behaviour can I expect ? Thanks Neil -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

best method to backup this mysql data

Hi I have a mySQL database running on linux. Can anyone recommend the best method to backup this data from a Windows XP machine on a scheduled basis ? My database server version at the moment is 3.23. Thanks Neil Neil Tompkins -- MySQL General Mailing List For list archives: http

Re: best method to backup this mysql data

At the moment I'm using mysql version 3.23. Can you recommend any free software that can automate the backup process From: Mladen Adamovic <[EMAIL PROTECTED]> To: Neil Tompkins <[EMAIL PROTECTED]>, mysql@lists.mysql.com Subject: Re: best method to backup this mysql data

mysql on Windows

Is anyone running mySQL on Windows 2003 server platform. Are there any known problems ? Cheers Neil -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysql on Windows

Apart from this are there any other known issues. When trialing mySQL on my XP machine, I noticed all the tables were created in lower case ? Is this normal ? Cheers Neil From: Mark Leith <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: Neil Tompkins <[EMAIL PROTECTED]&g

Distinct Query Problem

of products for all suppliers for a particular product. However I want to be able to show the lowest price product from just the lowest priced supplier. Any ideas ? Thanks, Neil

Re: Distinct Query Problem

Hi I'm having trouble trying to figure this out. Any help/example would be grateful. Thanks Neil On Sun, Dec 21, 2008 at 4:30 PM, Baron Schwartz wrote: > On Fri, Dec 19, 2008 at 1:03 PM, Tompkins Neil > wrote: > > > of products for all suppliers for a particular prod

Re: Distinct Query Problem

Hi, If anyone could point me in the right direction, I'd be most grateful. Thanks ! Neil On Mon, Dec 22, 2008 at 9:55 AM, Tompkins Neil wrote: > Hi > > I'm having trouble trying to figure this out. Any help/example would be > grateful. > > Thanks > Neil > &

Re: Distinct Query Problem

OK, I've made further progress by changing GROUP BY ProductTB.ProductID, MasterTB.MasterID to GROUP BY MasterTB.MasterID. However ProductTB.Supplier is showing the incorrect Supplier. Why is this ? Thanks Neil On Mon, Dec 22, 2008 at 11:45 AM, Tompkins Neil < neil.tompk...@google

Re: Distinct Query Problem

each supplier. This is link using the LookupTB. Let me know what other information you require. Thanks Neil On Tue, Dec 23, 2008 at 4:19 AM, Raghani, Sonal (IE10) < sonal.ragh...@honeywell.com> wrote: > Hi, > > The problem statement needs to be elaborated. Please give the

mysql not able to import mysqldump file

am getting this error: Illegal double '1.79769313486232e+308' value found during parsing Any ideas how to fix this? Thanks, Neil -- Neil Aggarwal, (832)245-7314, www.JAMMConsulting.com Eliminate junk email and reclaim your inbox. Visit http://www.spammilter.com for details.

RE: mysql not able to import mysqldump file

Double.MAX_VALUE constant over JDBC. There should not be this inconsistency between what mysqldump creates and what the server can handle since the platform and version are exactly the same. Having said that, there is an easy fix so it is not a big deal. Thanks, Neil -- Neil Aggarwal

RE: mysql not able to import mysqldump file

Martin: Both tables have double for the column. Neil -- Neil Aggarwal, (832)245-7314, www.JAMMConsulting.com Eliminate junk email and reclaim your inbox. Visit http://www.spammilter.com for details. > -Original Message- > From: Martin Gainty [mailto:mgai...@hotma

Logging SQL queries

Hi, We've developed a new extranet system and feel that we need to record all queries performed. What is the best / recommended way to achieve this. Thanks Neil

Re: Logging SQL queries

Hi The purpose is really for auditing and constant performance analysis ? I could save each query in my own user generated table. But thought maybe best to use mysql's built in feature. Neil On Wed, May 27, 2009 at 5:22 PM, Baron Schwartz wrote: > Neil, > > What is the purpo

mysql 5.0.67

ct if I try to perform a replace function on the field data I get Microsoft VBScript runtime error '800a005e' Invalid use of Null: 'replace' Any ideas what the problem might be ? Cheers Neil

Re: Logging SQL queries

d the queries which are executed by the users. What do you think ? or do you think this would not be necessary. Cheers Neil On Thu, May 28, 2009 at 7:14 PM, Baron Schwartz wrote: > For this purpose, I'd suggest using the slow query log (and a log > analysis tool such as mk-query-di

Re: mysql 5.0.67

Hi After further investigation it would appear that I needed to update the mySQL ODBC connnecter to the latest version. Thanks Neil On Wed, Jun 3, 2009 at 6:43 PM, Gavin Towey wrote: > Niel, > > I don't use ASP, but it sounds more like a syntax error in your sc

Re: ssl questions

Hi I wondered how you are getting on with installing SSL for mysql 5.1 server. We are looking to install it too. Do you have any pointers/recommendations ? Regards Neil On Tue, Sep 8, 2009 at 11:36 PM, qt4x11 wrote: > I'm trying to set up my mysql 5.1 server to work over ssl, I

Re: ssl questions

-basics.html -- Muhammad Subair On Thu, Oct 8, 2009 at 6:03 PM, Tompkins Neil > wrote: Hi I wondered how you are getting on with installing SSL for mysql 5.1 server. We are looking to install it too. Do you have any pointers/ recommendations ? Regards Neil On Tue, Sep 8, 2009 at 11:36 PM, qt4

MySQL GUI Tools

What are the best MySQL GUI tools available at the moment, for example SQLyog. Thanks Neil

Re: MySQL GUI Tools

Thanks for all the feedback. Going to download all of these and see which best suits our needs. Neil On Thu, Oct 15, 2009 at 2:56 AM, Ye Yuan wrote: > Hi Neil, > You can try toad for mysql. It is free. > > -- > Thanks, > YY >

Difference between MySQL Connector/ODBC 3.51 and ODBC 5.1

/bug.php?id=44935. Basically all my queries fail to return any string/varchar values. Thanks for any help. Regards, Neil

Re: Difference between MySQL Connector/ODBC 3.51 and ODBC 5.1

your thoughts on this ? Regards, Neil On Fri, Oct 23, 2009 at 3:18 PM, Jerry Schwartz wrote: > The key difference for me was the ability to handle UTF-8. > > Regards, > > Jerry Schwartz > The Infoshop by Global Information Incorporated > 195 Farmington Ave. > Farmingt

Re: Difference between MySQL Connector/ODBC 3.51 and ODBC 5.1

Thanks for the response Jerry. I suppose my main question is it possible/recommended to run ODBC 3.51 which version 5 of MySQL - or is it highly recommended to use ODBC 5.1 ? Regards Neil On Fri, Oct 23, 2009 at 7:24 PM, Jerry Schwartz wrote: > The UTF-8 issue was the only thing that rea

CONNECTION_ID() and Threads

Hi, With regards the CONNECTION_ID() variable in MySQL, is this based on a per user basis. Or can multiple users use the same connection_id ? Thanks, Neil

Re: CONNECTION_ID() and Threads

dvice regarding this ? Regards Neil On Wed, Nov 4, 2009 at 3:27 PM, Michael Dykman wrote: > Typically, a thread works on a single connection exclusively.. > otherwise it is impossible to do anything transactional. However, I > have seen applications, in auto-commit mode use disti

Re: CONNECTION_ID() and Threads

RecordsetTest.close set RecordsetTest = nothing* ** * Conn.close set Conn = nothing* But my question regarding the CONNECTION_ID is why we are connecting using the same ID from two different computers. I'm using a MySQL ODBC 5.1 Driver connection. Thanks Neil On Wed, Nov 4, 2009 at 3:41

ODBC MySQL Password as plain text

Hi The MySQL ODBC connection password is stored as plain text in the Windows registry. What is the best way to overcome this issue - to ensure the password is saved securely Thanks, Neil

Re: MySQL being hacked with commands through URL

Hi First things first - prevent access apart from r...@localhost to the users table Neil On Wed, Nov 18, 2009 at 5:50 PM, Gary Smith wrote: > James Coffman wrote: > >> Hello all, >> >>My website has been hacked using a url such as: >> >> -1

Fwd: ODBC MySQL Password as plain text

Following my previous email. I've now configured my database connection using a ODBC DNSLESS SSL connection. However the problem still remains, the password is stored in the ASP file in plain text. Does anyone have any recommendations on how to overcome this issue ? Cheers

Re: Fwd: ODBC MySQL Password as plain text

Hi Jay, This was my thought. Maybe encrypt the pasword in the DNSless connection and have a key somewhere within a external file. However if someone found the key in this file they could still access it. Any other thoughts on how to overcome this ? Cheers Neil On Thu, Nov 19, 2009 at 12:40

Re: Fwd: ODBC MySQL Password as plain text

I wondered if anyone else had any thoughts on this issue ? Cheers Neil On Thu, Nov 19, 2009 at 12:40 PM, Jay Ess wrote: > Tompkins Neil wrote: > >> Following my previous email. I've now configured my database connection >> using a ODBC DNSLESS SSL connection. However th

Re: Fwd: ODBC MySQL Password as plain text

can unlock it. The problem remains though - that if the web server is hacked, the hacker can still navigation there way to the file containing the key to unlock the password. Does that make any sense ? Cheers Neil On Fri, Nov 20, 2009 at 3:18 PM, Don Cohen wrote: > Tompkins Neil writes: >

How to concatenate a constant to an int?

Hello: This seems like it should be simple, but I am having trouble figuring it out. I have a table contact which has: nameString contact_id int Lets assume the contact table has this row: name: Neil Aggarwal contact_id: 1 I want to create a

RE: How to concatenate a constant to an int?

pect p on c.contact_id = p.prospect_id left join client l on p.prospect_id = l.client_id Any ideas how to do this? Thanks Neil -- Neil Aggarwal, (281)846-8957, http://UnmeteredVPS.net Host Joomla!, Wordpress, phpBB, or vBulletin for $25/mo Unmetered bandwidth = no overage charges, 7

Is a view efficient in joins?

efficient at making joins? Are the joins executed every time the view is used or is the data cached somehow? The other approach is for me to create a table to hold the summary data and write application code that periodically updates it. Which alternative would be best? Thanks, Neil

RE: Is a view efficient in joins?

the summary table is actually a good one in > many instances, > especially if it's not vital that it contain the most up-to-date data. I think I will go that direction. It will be OK for the summary data to be delayed by a short interval. Thanks, Neil -- Neil Aggarw

RE: MySQL On ipv6

Pramod: > I want to know whether MySQL Server runs on ipv6 machine. Apparently, IPv6 is going to be a version 6 feature: http://bugs.mysql.com/bug.php?id=8836 Neil -- Neil Aggarwal, (281)846-8957, http://UnmeteredVPS.net Host your MySQL driven app on a CentOS VPS for $25/mo Unmete

RE: Innodb buffer pool size filling up

u see any more info in the logs? Neil -- Neil Aggarwal, (281)846-8957, http://UnmeteredVPS.net Host your MySQL database on a CentOS VPS for $25/mo Unmetered bandwidth = no overage charges, 7 day free trial -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To un

RE: Join on a where clause.

That is not the case for you. I think you are going to have to do this in your application code. I hope this helps, Neil -- Neil Aggarwal, (281)846-8957, http://UnmeteredVPS.net Host your MySQL database on a CentOS VPS for $25/mo Unmetered bandwidth = no overage charges, 7 day free trial

RE: Select from remote server from stored procedure

an/5.0/en/federated-use.html Once you do that, you are accessing it like a local table. I hope this helps. Neil -- Neil Aggarwal, (281)846-8957, http://UnmeteredVPS.net Host your MySQL database on a CentOS VPS for $25/mo Unmetered bandwidth = no overage charges, 7 day free trial -- MySQ

RE: Join on a where clause.

Joerg: > A matching column is called an "equijoin" > However, that is not mandatory / the only form. > As long as the problem can be solved using ranges (or multiple ranges) > which do not overlap, the join should solve it. I just learned something. Thanks for the info!

RE: Select from remote server from stored procedure

he remote database 2. Tell the remote server to create a binary log 3. Tell the local server to be a slave of the remote 4. Start the slave It should take less than 1 hour to set it up. I have done it many times. It is probably not as hard as you are thinking it will be. Neil

RE: Missing Entries

delete from user where Password=''; flush privileges; quit; It removes those accounts. Neil -- Neil Aggarwal, (281)846-8957, http://UnmeteredVPS.net Host your MySQL database on a CentOS VPS for $25/mo Unmetered bandwidth = no overage charges, 7 day free trial -- MySQL

RE: Missing Entries

would do that firt, but it is good to be clear. Thanks, Neil -- Neil Aggarwal, (281)846-8957, http://UnmeteredVPS.net Host your MySQL database on a CentOS VPS for $25/mo Unmetered bandwidth = no overage charges, 7 day free trial -- MySQL General Mailing List For list archives: http

RE: Help saving MySQL

do to hurt MySQL? I am not against what Micheal is proposing. I already sent my letter to the EC. I am asking this for my own edification. Thanks, Neil -- Neil Aggarwal, (281)846-8957, http://UnmeteredVPS.net Host your MySQL database on a CentOS VPS for $25/mo Unmetered bandwidth = no o

RE: Help saving MySQL

all amount of the worldwide earnings from on the product he created. Neil -- Neil Aggarwal, (281)846-8957, http://UnmeteredVPS.net Host your MySQL database on a CentOS VPS for $25/mo Unmetered bandwidth = no overage charges, 7 day free trial -- MySQL General Mailing List For li

RE: How to not lock anything?

you should go with it. Neil -- Neil Aggarwal, (281)846-8957, http://UnmeteredVPS.net Host your MySQL database on a CentOS virtual server for $25/mo Unmetered bandwidth = no overage charges, 7 day free trial -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

RE: How to not lock anything?

be faster to clear the table, insert your data, and then put the indexes back. Try those to see if they help. Neil -- Neil Aggarwal, (281)846-8957, http://UnmeteredVPS.net Host your MySQL database on a CentOS virtual server for $25/mo Unmetered bandwidth = no overage charges, 7 day free tr

RE: CSV pain and suffering with punctuation and non-ASCII characters

I don't know if there is an off the shelf tool to do what you want. Maybe someone has one. Neil -- Neil Aggarwal, (281)846-8957, http://UnmeteredVPS.net Host your MySQL database on a CentOS virtual server for $25/mo Unmetered bandwidth = no overage charges, 7 day free trial -- MySQ

RE: Help Save MySQL

y owns it. Neil -- Neil Aggarwal, (281)846-8957, http://UnmeteredVPS.net Host your MySQL database on a CentOS virtual server for $25/mo Unmetered bandwidth = no overage charges, 7 day free trial -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

RE: mysql load balancing

rs) to talk to either database in case one fails. That is not necessary but it adds a extra layer of proctection. Neil -- Neil Aggarwal, (281)846-8957, http://UnmeteredVPS.net Host your MySQL database on a CentOS virtual server for $25/mo Unmetered bandwidth = no overage charges, 7 day free

Connection timeout supported ? MySQL ODBC 5.5

Hi Can anyone confirm if there are any connection time out values I can specify in my application (ASP (VBScript) for the MySQL ODBC connection. Cheers Neil

RE: Can't open file error number 24

> problem, Suddenly we noticed an error stating " Can't open file error > number 24". If I recall correctly, error 24 means the disk partition is full. Neil -- Neil Aggarwal, (281)846-8957, http://UnmeteredVPS.net MySQL pre-installed on a virtual private server

Record old passwords ?

word2, Password3 and Password4 to record the old passwords. Is this a preferred method - or does anyone else have any recommendations ? Thanks, Neil

Re: Record old passwords ?

query. I don't envisage that we will need to record the last 20 passwords as a example in the future - so if I need to expand in the future it should not be too involved. Cheers Neil On Tue, Jan 19, 2010 at 1:11 AM, Carlos Proal wrote: > On 1/18/2010 6:52 PM, Colin Streicher wrote:

Re: Record old passwords ?

ng back to there original password. How would I overcome this problem ? Any thoughts or recommendations ? Cheers Neil On Tue, Jan 19, 2010 at 9:14 AM, Tompkins Neil wrote: > Hi > > Thanks for all the replies. For your information, we are going to store > passwords using SHA256. I th

Re: Record old passwords ?

Yes, I was thinking something along these lines e.g can only change password once a day ? Also, what do operating systems like Windows etc do in this respect ? Cheers Neil On Tue, Jan 19, 2010 at 2:53 PM, David Lazo wrote: > I would say make it more difficult for the user add another fi

Re: Record old passwords ?

Hi Thanks for all the responses. In the end I opted for a separate UserPasswords table, which records all old passwords. When a user changes their password, this table is checked. NB All passwords are stored in SHA256. Thanks again for your advice. Regards Neil On Wed, Jan 20, 2010 at 12:08

Displaying date/time

using MySQL. Thanks, Neil

Re: Displaying date/time

Hi That is kind of what I'm looking for. However I'd like to be able to display the difference between date 1 and date 2 like 1d 2h 29min ago Thanks Neil On Fri, Mar 5, 2010 at 3:32 PM, prabhat kumar wrote: > Might be this will help you: > there is a table called message wi

Re: Displaying date/time

Hi Thanks for the positive reply. Your stored procedure kind of works but doesn't give me the desired results. However I will base my requirements on this. Thanks again Neil On Mon, Mar 8, 2010 at 2:42 PM, Price, Randall wrote: > Here is a MySQL stored procedure that I have used t

Re: Displaying date/time

I'm still trying with this. Can anyone else offer any support or examples ? Thanks, Neil On Mon, Mar 8, 2010 at 6:02 PM, Tompkins Neil wrote: > Hi > > Thanks for the positive reply. Your stored procedure kind of works but > doesn't give me the desired results.

MySQL Storage Engine

ELECT statements containing a number of INNER JOINS should be execute from a Stored procedure or purely from the webpage ? Cheers Neil

Re: MySQL Storage Engine

Hi How do you mean "executed on slave" ? Neil On Thu, Mar 18, 2010 at 9:32 AM, Krishna Chandra Prajapati < prajapat...@gmail.com> wrote: > Hi Neil, > > Recommend : Innodb storage engine > > Even, i would suggest inner join select query (if report query might

Re: MySQL Storage Engine

Thanks for the useful information. Can you let me know any other things I need to consider ? Regards Neil On Thu, Mar 18, 2010 at 9:50 AM, Krishna Chandra Prajapati < prajapat...@gmail.com> wrote: > Hi Neil, > > Many times we need to generate reports (weekly, montly, yearly) fro

Re: MySQL Encryption

Hi What sort of information are you looking to encrypt ? If it is for user passwords I'd recommend SHA256 which is one way encryption. Or are you looking to encrypt more sensitive information like card holder data ? Regards Neil On Fri, Mar 19, 2010 at 4:22 PM, Jim wrote: > Thanks

Re: MySQL Storage Engine

Thanks for all the responses and useful information. Cheers Neil On Thu, Mar 18, 2010 at 6:35 PM, mos wrote: > At 04:18 AM 3/18/2010, Tompkins Neil wrote: > >> Hi >> >> I'm currently looking to develop an on line web application - which is >> going >> t

Populating dataset

bookings how would I know to automatically insert a missing date like 2010-03-29 between the date range I search ? Thanks, Neil

When to use Stored Procedures

Hi, I've used mainly of the older versions of MySQL. However am looking to port a application across to MySQL 5. My question is when would one decide to use a Stored Procedure over a query written at the application level ? Cheers Neil

Fulltext Match BOOLEAN MODE not searching integers

Widget result. My query is as follows : SELECT Name MATCH (Name) AGAINST ('51*') as Relevance FROM Products WHERE MATCH (Name) AGAINST ('51*' IN BOOLEAN MODE) ORDER BY Relevance DESC Any ideas what the problem might be ? Thanks, Neil

Re: Fulltext Match BOOLEAN MODE not searching integers

Hi Mark I did infact change the value of ft_min_word_len to 1. Rebuild the indexes using REPAIR table name. But it didn't appear to have any affect. Cheers Neil On Wed, Mar 31, 2010 at 5:29 PM, Mark Goodge wrote: > On 31/03/2010 16:52, Tompkins Neil wrote: > >> Hi

Re: Fulltext Match BOOLEAN MODE not searching integers

Hi I found by using the REPAIR command it is now working. Thanks, Neil On Wed, Mar 31, 2010 at 5:38 PM, Tompkins Neil wrote: > Hi Mark > > I did infact change the value of ft_min_word_len to 1. Rebuild the indexes > using REPAIR table name. But it didn't appear to have any a

Can't drop index

ld that holds the id of a record in the person table: Field: client_manager_person_id_oid Type: varchar(256) Null: YES Key: MUL Default: NULL Extra: When I look at the person table, I do not see an index that would refer back to this table. Any ideas why I can't drop this inde

RE: Can't drop index

Krishna: > Just check it up that any active transaction is still there in innodb > internal data dictionary. Acutally I figured it out. There was a constraint on that column as well. Once I dropped the constraint, I was able to drop the index. Thanks for the help, Neil -- Neil Ag

  1   2   3   4   5   6   7   8   9   >