Hi,
How do I query multiple tables. For example I have
TableName Accommodation
Field1 AccommodationID
Field2 AccommodationName
I also have
TableName Attractions
Field1AttractionID
Field2 AttractionName
Field3 AttractionDescripti
I've the following SQL statement which I created in MS Access. My table
layout is the same in mySQL but it says I have an error and the query
doesn't run
SELECT AccommodationOverview.Title,
AccommodationOverview.AccommodationOverviewID,
AccommodationOverview.AccommodationID, Areas.Name
FROM
Hi
We have a mysql database hosted with a IIS server on the same network
accessible over the Internet. Now we want to set-up a new website with
another ISP therefore located in a different datacenter.
Has anyone had any experience of this. What performance issues would I get if
I access t
ntrol to your remote server.> > Some ISPs
> prohibit connections like this, so check with yours - would> be disappointing
> for sure to build it all then get a call saying> "cease and desist; read our
> acceptable use policy".> > Dan> > > On 8/10/06
; 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
> 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
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
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 the first to
Hi Neil,> what you need is a LEFT JOIN:> SELECT a.*> FROM TableA a>
> LEFT JOIN TableB b ON a.ID = b.ID (assuming ID is what you relate the>
> tables on )> WHERE b.ID IS NULL;> > should
> hopefully do what you want.> >
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
_
Be o
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
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
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
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.live.com/programpage.as
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
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 Windows Live
Hi
I've the following tables
(holds a list of companies)
TableName:Company
CompanyID (int)
CompanyName (varchar)
(holds a list of areas)
TableName:Area
AreaID (int)
AreaName (varchar)
(holds a list of what areas are near to what companies),
TableName:AreaCompanys
CompanyID (int)
AreaID
Hi,
We have a mySQL database running version 3.23.58 on a linux machine.
This database is accessed from both a Windows IIS web server and a linuz zeus
web server. On the linux server I'm not sure of what driver etc is installed,
however the access time to save a record is far quicker than t
mysql@lists.mysql.com> From: [EMAIL
> PROTECTED]> Subject: Re: Slow Access When Inserting Records> > At 01:56 PM
> 10/8/2006, Neil Tompkins wrote:> >Hi,> >> >We have a mySQL database running
> version 3.23.58 on a linux machine.> >> >This databas
; From: [EMAIL
> PROTECTED]> Subject: Re: Slow Access When Inserting Records> > At 01:56 PM
> 10/8/2006, Neil Tompkins wrote:> >Hi,> >> >We have a mySQL database running
> version 3.23.58 on a linux machine.> >> >This database is accessed from both
ect: Re: Slow Access When Inserting Records> > At 01:56 PM
> 10/8/2006, Neil Tompkins wrote:> >Hi,> >> >We have a mySQL database running
> version 3.23.58 on a linux machine.> >> >This database is accessed from both
> a Windows IIS web server and a linu
I am running mySQL database version 3.23.58, but I'm using mySQL
Administrator 1.1.9 for scheduled backups. When connecting to the database I
get a message saying that this version of database is not supported and I
might get unexpected behaviour.
Am I OK to use this version of mySQL Administr
I am running mySQL database version 3.23.58, but I'm using mySQL
Administrator 1.1.9 for scheduled backups. When connecting to the database I
get a message saying that this version of database is not supported and I
might get unexpected behaviour.
Am I OK to use this version of mySQL Administr
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
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
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]
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
We are looking to install on windows.
Sent from my iPod
On 11 Oct 2009, at 18:02, muhammad subair wrote:
Hi,
Maybe, first you can check MySQL documentation [0], [1]
[0] http://dev.mysql.com/doc/refman/5.0/en/secure-using-ssl.html
[1] http://dev.mysql.com/doc/refman/5.0/en/secure-basics.htm
How many indexes are recommended per table ??
On 7 Jul 2010, at 06:06, "Octavian Rasnita" > wrote:
Hi,
MySQL can use a single index in a query as you've seen in the result
of explain.
Of course it is better to have an index made of 2 or more columns
because it will match better the quer
also needs to be updated when your data changes.
On Thu, Jul 8, 2010 at 11:25 PM, Neil Tompkins > wrote:
How many indexes are recommended per table ??
On 7 Jul 2010, at 06:06, "Octavian Rasnita" > wrote:
Hi,
MySQL can use a single index in a query as you've seen in th
Thanks for the useful information. This is the answer I was. Looking
for.
Neil
On 22 Jul 2010, at 22:25, "Jerry Schwartz" wrote:
From: Tompkins Neil [mailto:neil.tompk...@googlemail.com]
Sent: Thursday, July 22, 2010 4:50 PM
To: Jerry Schwartz
Cc: Shawn Green (MySQL); mysql@lists.mysql.com
Carl you don't wish go offer so sample code ?
On 19 Aug 2010, at 19:18, "Carl" wrote:
I have written this in both C and Java. It is very complex as, in
real
life, you want to balance home and away, sequence the games so that
the home
or away games are spread throughout the schedule, accom
Hi
I've a soccer application consisting of managers, teams players and
fixtures/results. Basically each manager will get points for each game
which will depend on the result.
What would be the best table design bearing in mind that a manager can
move to a different club.
My thought was
Thanks for all the useful information. I'm going to ensure the
relevant fields are indexed and our db is optimised.
On 4 Sep 2010, at 16:10, Arthur Fuller wrote:
100% agreed.
Arthur
The other exception is also where financial data is being stored. If
you
have, say, a database containi
Thanks for your reply. So should we create individual indexes on each
field or a multiple column index ??
On 3 Oct 2010, at 16:44, Joerg Bruehe wrote:
Hi Neil, all!
Tompkins Neil wrote:
So if you have individual indexes for example field_1, field_2 and
field_3
etc and then perform a s
Following on from my previous email I have columns containing numbers
which are then used in SUM and MIN/ MAX functions should these be
indexed too ?
On 3 Oct 2010, at 16:44, Joerg Bruehe wrote:
Hi Neil, all!
Tompkins Neil wrote:
So if you have individual indexes for example field_1, fie
Neil
On Mon, Oct 4, 2010 at 3:38 PM, Joerg Bruehe
wrote:
Hi!
Neil Tompkins wrote:
Thanks for your reply. So should we create individual indexes on
each
field or a multiple column index ??
This question cannot be answered without checking and measuring your
installation. The decision wh
Hi Shawn
Thanks for your response. In your experience do you think I should
still retain the data used to generate the computed totals ? Or just
compute the totals and disregard the data used ?
Regards
Neil
On 8 Oct 2010, at 19:46, "Shawn Green (MySQL)"
wrote:
Hi Neil,
On 10/5/2010
But I could create an additional myisam table to overcome my problem providing
I can get the data to synchronise between the two tables
On 29 Sep 2011, at 18:16, Reindl Harald wrote:
> so mysql is currently the wrong database for your project
> sad but true, you can not have fulltext-search and
I'm not sure it would work in my environment of IIS and MySQL ?
On 29 Sep 2011, at 20:10, mos wrote:
> Derek is right. The Sphynx search engine is much faster than MyISAM's full
> text search engine. It will work on InnoDb tables so you don't have to export
> the data to MyISAM.
>
> Mike
>
>
Am thinking now that it might be best to use MySQL 5.6 as this is a new project
still in development and we will have the new FullText Search with Innodb
On 29 Sep 2011, at 18:43, Andrew Moore wrote:
> Hey Neil, I read your question too quickly and jumped to the conclusion you
> weren't sure M
Can anyone help me ?
Begin forwarded message:
> From: Tompkins Neil
> Date: 30 September 2011 20:23:47 GMT+01:00
> To: mark carson
> Cc: "[MySQL]"
> Subject: Re: Slow query - please help
>
> I downloaded version mysql-5.6.2-m5-win32.msi and he table definitions are
> below, let me know if
Maybe that was a bad example. If the query was name = 'Red' what index should
I create ?
Should I create a index of all columns used in each query or have a index on
individual column ?
On 6 Oct 2011, at 17:28, Michael Dykman wrote:
> For the first query, the obvious index on score will give
;>> Just remember that idx_a(field_a,field_b) is not the same, and is not
>>>>> considered for use, the same way as idx_b(field_b,field_a).
>>>>>
>>>>> -NT
>>>>>
>>>>>
>>>>> Em 07-10-2011 00:22, Michae
> optimal. You need at look at the queries you intend to run against the
> system and construct indexes which support them.
>
> - md
>
> On Thu, Oct 6, 2011 at 2:35 PM, Neil Tompkins
> wrote:
> Maybe that was a bad example. If the query was name = 'Red'
> As per the subject we've a large insert query that gives up the error MySQL
> server has gone away when we try to execute it. Any ideas why ?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Just to clarify having key indexes of (a,b) or (b,a) have no difference ?
On 11 Oct 2011, at 09:36, Johan De Meersman wrote:
> - Original Message -
>> From: "Alex Schaft"
>>
>> If you have a table with columns A & B, and might do a where on A or
>> B, or an order by A, B, would single
In this instance would you create four indexes key(a) key(b) key(a,b) key (b,a)
? Or is the decision based on the query response time ?
On 11 Oct 2011, at 13:40, Rik Wasmus wrote:
>> Next question. If you have the two separate indexes and then do two
>> queries, one for a and one for b. If you
Try the MySQL workbench software
On 14 Oct 2011, at 19:12, AndrewMcHorney wrote:
> Hello
>
> I just downloaded the MySql server software. I am now looking for software
> that is gui based and will allow me to easily define a database, create
> tables and to do updates of records within the t
We are running MySQL 5.1.46 with master to master replication with 3 other
servers for 3 different websites in 3 different parts of the world.
My question is how often should we be looking to upgrade our MySQL version
considering we can't really afford any downtime.
Thanks
Neil
--
MySQL Genera
MySQL workbench
On 21 Nov 2011, at 13:36, Chris Tate-Davies
wrote:
> What are you using to view the data?
>
>
>
> On Mon, 2011-11-21 at 08:22 -0500, h...@tbbs.net wrote:
>> ;>>> 2011/11/20 20:27 +, Tompkins Neil
>> Does anyone know why Chinese characters are not displaying correctly
two dbs should be the same have
> you
> checked that they actually are set to the same?
>
>
>
>
> On Monday, November 21, 2011 9:20:10 PM Neil Tompkins wrote:
>> MySQL workbench
>>
>> On 21 Nov 2011, at 13:36, Chris Tate-Davies
> wrote:
>>>
Hi
I am trying to get some background information with regards the design. I have
a fair idea but would like advice from anyone that has previously worked on
similar projects.
On 20 Feb 2012, at 17:22, Jan Steinman wrote:
> Where are your domain experts? You *are* consulting with them, no
At the moment im concentrating on london postal codes but future would be us
zip codes too
On 24 Apr 2012, at 18:09, Rick James wrote:
> Please be more precise about the rules. In the US, "12345-6789" would become
> "12345". This would follow a different rule.
>
> Is your rule "stop after t
Hi,
Is there such a way in a MySQL query to extract the text "this is a test"
from the following strings as a example
http://www.domain.com/"; class="link">this is a
test
http://www.domain.com/"; title="this is a test"
class="link">link
Thanks
Neil
Hi,
I'm struggling with what I think is a basic select but can't think how to
do it : My data is
id,type
1000,5
1001,5
1002,2
1001,2
1003,2
1005,2
1006,1
>From this I what to get a distinct list of id where the type equals 2 and 5
Any ideas ?
Neil
Basically I only what to return the IDs that have both types.
On Thu, Nov 22, 2012 at 2:39 PM, marek gutowski wrote:
> SELECT DISTINCT id FROM table WHERE type IN ('2','5')
>
> should work
>
>
> On 22 November 2012 14:30, Neil Tompkins wrote:
>
>>
; U can remove the type field it will work
> On Nov 22, 2012 8:21 PM, "Neil Tompkins"
> wrote:
>
>> Basically I only what to return the IDs that have both types.
>>
>>
>> On Thu, Nov 22, 2012 at 2:39 PM, marek gutowski > >wrote:
>>
ave to go the JOIN route
>
> select distinct a.id from mytable a
> inner join mytable b on (a.id=b.id)
> where a.type= 2 and b.type = 5;
>
> - michael dykman
>
> On Thu, Nov 22, 2012 at 9:30 AM, Neil Tompkins
> wrote:
> > Hi,
> >
> > I'm strugglin
think of.
>
> On 2012-11-22 10:01 AM, "Neil Tompkins"
> wrote:
>
> Michael,
>
> Thanks this kind of works if I'm checking two types. But what about if I
> have 5 types ?
>
> On Thu, Nov 22, 2012 at 2:53 PM, Michael Dykman wrote:
>
>> >
>&
By unique you mean that no id and type would be duplicated like
1,1
1,1
Yes it isn't possible for duplicate id and type in more than 1 row
On Thu, Nov 22, 2012 at 4:46 PM, Michael Dykman wrote:
> Assuming that (id,type) is unique in the source data, that is a pretty
> elegant method:
>
> > se
When trying this query I get
FUNCTION id does not exist
On Thu, Nov 22, 2012 at 4:46 PM, Michael Dykman wrote:
> select id from
> > (select distinct id, count(*)
> > from my_table
> > where type in (2,5)
> > group by id
> > having count(*) = 2)a;
>
Ignore that it does work fine. Sorry
On Thu, Nov 22, 2012 at 4:46 PM, Michael Dykman wrote:
> Assuming that (id,type) is unique in the source data, that is a pretty
> elegant method:
>
> > select id from
> > (select distinct id, count(*)
> > from my_table
> > where type in (2,5)
> > group by id
Doing a EXPLAIN on the SELECT statement it is using "Using where; Using
temporary; Using filesort" with 14000 rows of data. How best to improve
this; when I already have indexed on id and type
On Thu, Nov 22, 2012 at 4:46 PM, Michael Dykman wrote:
> Assuming that (id,type) is unique in the so
from code I can't imagine counting the parameters in the code
> being so hard.
>
> Cheers
>
> Claudio
>
>
>>
>> On 22 November 2012 15:01, Neil Tompkins
>> wrote:
>>> Michael,
>>>
>>> Thanks this kind of works if I&#
Hi,
I've the following data
total, supplier_id, product_name, supplier_code
125,2,iPod,xyz123
100,1,iPod,abc123
145,3,iPod,1213113
245,4,iPod,12345
What query do I need to get the lowest total in this case 100 for
supplier_id 1 ?
Thanks
Neil
Hi,
I've used in the past MySQL Community Server 5.x. Everything is fine,
however I'm now wanting to implement a new High Availability solution and
am considering MySQL Cluster. However, I heard that MySQL Cluster doesn't
support store procedures ? Are there any other restrictions I need to be
Hi
I'm creating the following basic tables
COUNTRIES
countries_id
name
REGIONS
region_id
countries_id
name
CITIES
cities_id
region_id
Using joins I can obtain which country each city belongs too. However,
should I consider putting a foreign key in the CITIES table referencing the
countries_i
rance
?
Same with regions/states and cities and districts ?
On Sun, Apr 21, 2013 at 9:28 AM, Denis Jedig wrote:
> Neil,
>
> Am 21.04.2013 08:47, schrieb Neil Tompkins:
>
> Using joins I can obtain which country each city belongs too. However,
>> should I consider putting a
mor...@oracle.com
> @andrewmorgan
> www.clusterdb.com
>
> > -Original Message-
> > From: Neil Tompkins [mailto:neil.tompk...@googlemail.com]
> > Sent: 27 April 2013 23:28
> > To: [MySQL]
> > Subject: Fwd: MySQL Cluster or MySQL Cloud
> >
> > > If deplo
Hi,
I've the following database structure of 4 tables for geographical
information
CREATE TABLE IF NOT EXISTS `mydb`.`country` (
`country_id` INT NOT NULL ,
`country_code` CHAR(2) NOT NULL ,
`name` VARCHAR(255) NOT NULL ,
PRIMARY KEY (`country_id`) ,
UNIQUE INDEX `country_code_U
s the PRIMARY KEY, and make it ASCII, not UTF8.
> That would turn the 4-byte id into a 2-byte string.
>
> I gather you are using an new-enough NDB so that FOREIGN KEYs are
> implemented?
>
> > -Original Message-
> > From: Neil Tompkins [mailto:neil.tompk...@googlemai
Hi,
I've just created some tables that I designed using the MySQL Workbench
Model. However, the database type BOOLEAN which was in my models has been
converted to TINYINT(1); I'm currently running MySQL Version 5.6.2-m5 on
Windows 2008 server.
Any ideas why this has been removed ?
Neil
; synonym type which infact behaves unlike a boolean
should."
Has BOOL, BOOLEAN been taken out of MySQL 5.6 ?
On Wed, May 22, 2013 at 6:01 PM, Ian Simpson wrote:
> BOOLEAN is a synonym for TINYINT(1) in MySQL:
>
> http://dev.mysql.com/doc/refman/5.6/en/numeric-type-overview.html
Hi Shawn
I plan in installing the latest MySQL version tomorrow. Does MySQL not
support Bool eg true and false
Neil
On 22 May 2013, at 19:05, shawn green wrote:
> Hello Neil,
>
> On 5/22/2013 1:05 PM, Neil Tompkins wrote:
>> Hi, Like the link states
>>
>>
Hi,
Using Workbench with MySQL 5.6 how do I edit a existing Trigger. Do I need
to DROP the Trigger and create a new one ? If that is the case how can you
run start command in a live environment ?
Thanks
Neil
Hi,
I've a trigger that writes some data to a temporary table; and at the end
of the trigger writes all the temporary table data in one insert to our
normal Innodb table.
However, for some reason the trigger isn't copying the table from the
temporary table to the Innodb table. If I write in the
#x27;, 1,'RoomsToSell',1,2,
NOW());
On Wed, May 29, 2013 at 2:49 PM, Ananda Kumar wrote:
> can you please share the code of the trigger. Any kind of error your
> getting
>
>
> On Wed, May 29, 2013 at 6:49 PM, Neil Tompkins <
> neil.tompk...@googlemail.com> w
ability', 1,'RoomsToSell',4,4, NOW());
SELECT * FROM tempHotelRateAvailability;
On Wed, May 29, 2013 at 2:57 PM, Ananda Kumar wrote:
> did u check if data is getting inserted into tempHotelRateAvailability
>
>
> On Wed, May 29, 2013 at 7:21 PM, Neil Tompkins <
> n
ot get inserted from temp table
> to innodb table
>
>
> On Wed, May 29, 2013 at 7:29 PM, Neil Tompkins <
> neil.tompk...@googlemail.com> wrote:
>
>> I took the following lines of code slightly modified and it returned some
>> data using a normal
Hi,
I've created a Audit table which tracks any changed fields for multiple
tables. In my Audit table I'm using a UUID for the primary key. However I
need to have a reference back to the primary key(s) of the table audited.
At the moment I've a VARCHAR field which stores primary keys like
1
1|
Any advice anyone ?
-- Forwarded message --
From: Neil Tompkins
Date: Thu, May 30, 2013 at 8:27 AM
Subject: Audit Table storage for Primary Key(s)
To: "[MySQL]"
Hi,
I've created a Audit table which tracks any changed fields for multiple
tables. In my Audit ta
have currently 54 tables, of which probably 30 will
be audited. So a INT PK wouldn't work because of the number of updates we
are applying.
On Fri, May 31, 2013 at 9:58 AM, Carsten Pedersen wrote:
> On 30-05-2013 09:27, Neil Tompkins wrote:
>
>> Hi,
>>
>> I've
ss for the amount of space you'll be using for
> your data and index; (2) Please do the math of just how many inserts you
> can do per second over the next 1.000 years if you use a longint
> auto-increment field for your PK.
>
> / Carsten
>
> On 31-05-2013 11:14, Neil T
Hi,
I have a number of INSERT and UPDATE statements in a MySQL Stored
Procedure, that works in the form of START TRANSACTION followed by COMMIT.
Also I am handling any EXCEPTION.
However, after calling COMMIT, how can I get the number of Rows that were
affected either INSERTED or UPDATTED ?
Tha
Hi,
I've created a Trigger and want to edit it. Using MySQL Workbench, I can
Alter the table, and click Triggers and select the trigger action I want to
edit (on my local database, MySQL running on same PC)
However, if I try the exact same procedure on a Trigger on a remote
database, I don't see
I have the following four MySQL tables
Region
RegionId
City
CityId
RegionId
Hotel
HotelId
CityId
HotelRegion
HotelId
RegionId
I'm struggling to write a UPDATE statement to update the City table's
RegionId field from data in the HotelRegion table.
Basically how can I update the City table with
I have installed MySQL 5.6.13 on our Windows 2003 server and need to
configure the service so that no external access is possible from a remote
IP addresses.
On the server it's self, the MySQL service will need to be accessed by IIS
hosting a ASP.NET application and web services.
I know that this
Hi
If I have a update statement like
UPDATE MY_TABLE
SET FieldName1 = Now(), FieldName2 = :MyVariable
WHERE FieldName3 = 'Y'
How can I only update the FieldName2 field if the value of MyVariable is
NOT NULL ?
Thanks
Neil
passed for each field is NOT
NULL.
Therefore, I felt this needs to be done at database level in the stored
procedure. How can I accomplish this.
Thanks
Neil
On Mon, Oct 28, 2013 at 6:17 PM, Shawn Green wrote:
> Hello Neil,
>
> On 10/28/2013 2:06 PM, Neil Tompkins wrote:
>
>> Hi
&
Shawn
What I need is that if I pass say 10 parameters/variables to a query, I
only want to update the column/field if the value passed is NOT NULL.
On Wed, Oct 30, 2013 at 3:41 AM, Shawn Green wrote:
> Hi,
>
> On 10/29/2013 9:52 PM, h...@tbbs.net wrote:
>
>> 2013/10/29 11:35 -0400, Shawn Green
Hi,
I'm using MySQL 5.6.17 on Amazon Web Services RDS and when calling SELECT
UUID_SHORT() I'm getting a number bigger than 9223372036854775807. For
example the number I get is
12057145185130250250
The problem is in my table I have a column as BIGINT(20) unsigned, but when
storing a number 12057
Personally I think people, myself included are using other resources like
stackoverflow to get answers to my MySQL questions.
> On 24 Nov 2014, at 17:27, Michael Dykman wrote:
>
> Please gentlemen,
>
> It is a valid question if a somewhat hackneyed one.
>
> MySQL continues to live on in many
Hi
I'm looking to design a hotel reservation/availability system to be used
online. Has anyone had any experience with regards table / database design ?
Thanks
Neil
_
100’s of Music vouchers to be won with MSN Music
https://www.mus
Hi
I've the following process/queries which I want to speed up, for a product
inventory/warehouse which we have a number of items available to sell each day
For Each Company
For Each Product
For Next 7 Days
CheckQuantityUpdateQuantity
Next Day
Next Product
Nex
Hi,
I have a table of records all of which have a timestamp against them like
2007-10-25 10:10:19, and category like red, blue etc and a unique key.
Using a SELECT statement is it possible to retrieve the count and number of
records for each day e.g 2007-10-25 for all red, and all blue etc
Hi,
How do I achieve a SQL statement to order my results based on two calculated
fields for example :
SELECT COUNT(ProductsPurchases.ProductID) as varProductCount, Products.Name,
Products.ProductReview
FROM ProductsPurchasesINNER JOIN Products ON Products.ProductID =
ProductsPurchases.Produc
Hi
I want to order by the totalled fields varProductCount and
Products.ProductReviewDESC
Neil
> Date: Thu, 20 Mar 2008 11:36:30 +0100> From: [EMAIL PROTECTED]> To:
> mysql@lists.mysql.com> Subject: Re: ORDER BY calculated field> > Neil
> Tompkins schrieb:> >
ian
> Mendel schrieb:> > Neil Tompkins schrieb:> >> Hi> >> > >> I want to order by
> the totalled fields varProductCount and > >> Products.ProductReviewDESC> > >
> > just put them together, separated with comma, like it is writt
=
ProductsPurchases.ProductIDGROUP BY Products.ProductID ORDER BY varProductCount
DESC
> Date: Thu, 20 Mar 2008 13:08:51 +0100> From: [EMAIL PROTECTED]> CC:
> mysql@lists.mysql.com> Subject: Re: ORDER BY calculated field> > Neil
> Tompkins schrieb:> > Thanks Sebastian, but I now get the
1 - 100 of 151 matches
Mail list logo
