One point to add, that might be of interest is that the primary key and
foreign key for two of related tables is a VARCHAR(255), and my MySQL
version is '5.6.12-log'
On Fri, Jan 22, 2016 at 8:47 PM, Lisa Smith wrote:
> Hi Neil,
>
> When you say you delete the current databa
database works fine, but seems to crash when I shut the PC down.
On Fri, Jan 22, 2016 at 8:47 PM, Lisa Smith wrote:
> Hi Neil,
>
> When you say you delete the current database, do you mean the database
> files only? Are you doing a complete restore?
>
> On Fri, Jan 22, 2016 at 1:23
My disk drive has about 3 gb free space. The sequence of events is
1. Create database
2. Restore the data
3. Use the database, SELECT data etc
4. Shut down PC
5. When I restart PC I get this error
Hi,
Hoping someone can help me identify why I keep having to restore my
database. You can see below, that my machine shut down normally, yet when
I restarted the machine back up, I'm getting the error
'mysql\innodb_table_stats.ibd. Cannot open tablespace' and am having to
delete the current datab
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
n I'm trying to save my number to, as BIGINT(20)
unsigned, but still get this error.
Any ideas why ?
Cheers
Neil
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
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
&
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
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
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
don't see the Triggers under each action.
The only way these can be edited is to drop and create it again.
Thanks
Neil
?
Thanks,
Neil
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
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
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
keys like
1
1|2013-05-29
2|2013-05-29
2
3
1|2|2
etc
Is this the best approach, or should I have a individual field in the audit
table for all primary keys. At the moment I think the max number of
primary keys on any given table is 3
Thanks
Neil
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
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
#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
ite in the trigger the inserts
to the Innodb table, it works fine.
Any ideas why. I'm running MySQL 5.6.
Thanks
Neil
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 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
>>
>>
; 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,
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
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
is my best approach to add some sort of look-up table with the
translation...?
Thanks
Neil
ers; apart from
MySQL Cluster being much better solution for automatic failover including
IP failover.
Regards, Neil
On Mon, Apr 29, 2013 at 8:47 AM, Andrew Morgan wrote:
> Hi Neil,
>
> I hate just sending people off to white papers but you might get some
> good insights by takin
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
g the
countries_id ? Or is it sufficient to access using a join ?
Thanks
Neil
ns I need to be
aware of.
Thanks
Neil
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
Claudio
This is the solution i decided to go for as provided in a previous response.
Thanks
Neil
On 23 Nov 2012, at 00:41, Claudio Nanni wrote:
> On 11/22/2012 04:10 PM, Ben Mildren wrote:
>> SELECT id FROM mytable WHERE type IN(x,y,z) GROUP BY id;
> Ben you were almost there ;)
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
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
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;
>
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
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:
>
>> >
>&
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
; 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:
>>
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:
>
>>
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
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
Thanks for your very detailed response Mark. Most helpful.
On Wed, Apr 25, 2012 at 10:14 AM, Mark Goodge wrote:
> On 24/04/2012 17:24, Tompkins Neil wrote:
>
>> How about if I want to only return postal codes that are like W1U 8JE
>> not W13 0SU.
>>
>> Because in
inguish digits from letters, but won't help you isolate them.
>
>> -Original Message-
>> From: Tompkins Neil [mailto:neil.tompk...@googlemail.com]
>> Sent: Tuesday, April 24, 2012 9:11 AM
>> To: [MySQL]
>> Subject: Postal code searching
>>
>> Hi
>>
How about if I want to only return postal codes that are like W1U 8JE
not W13 0SU.
Because in this example I have W1 as the postal code and W13 is the other
postal code
On Tue, Apr 24, 2012 at 5:18 PM, Gary Smith wrote:
> On 24/04/2012 17:16, Gary Smith wrote:
>
>> http://dev.mysql.com/doc/**r
es like
W1
WC1
WC2
NW1
Now, if I know the postal code W1J 7BX what is the best way using a MySQL
query to get the abbreviated postal codes W1. Same if I have the postal
code WC1H 8EJ, how do I get the abbreviated postal codes WC1
Can I use any matching patterns ?
Thanks,
Neil
12121
However in my SELECT statement if I use SELECT DISTINCT (field_name), I
only get back one record.
Thanks,
Neil
hem, no?
>
> If you don't know the answers, and don't have access to domain experts to
> help you, I would design for the most general case, and factor out exceptions
> as they prove to be so. "Pre-optimization" for exceptions almost always turns
> out to be a
y day I have
a record in a huge single table ???
Thanks for any help and input.
Best,
Neil
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:
>>>
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 anyon
Does anyone know why Chinese characters are not displaying correctly in a
replicated database on a slave machine ? I'm just getting square boxes.
Thanks
Neil
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
--
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
But how do I calculate such size ?
On Wed, Oct 12, 2011 at 2:38 PM, Reindl Harald wrote:
> as big as you largest query
>
> Am 12.10.2011 15:30, schrieb Tompkins Neil:
> > Do you have any recommendations as to what size this should be increased
> to
> > ?
> >
> &
*From:* Johnny Withers
> *To:* Neil Tompkins
> *Cc:* [MySQL]
> *Sent:* Monday, October 10, 2011 4:13 PM
> *Subject:* Re: Fwd: Large insert query gives MySQL server gone away
>
> Max packet size?
>
> On Oct 10, 2011 6:12 PM, "Neil Tompkins"
> wrote:
>
&
refix of a combined index may be used; so afaik a separate index
> on any full prefix is a waste of diskspace and cycles.
>
> The net conclusion, Neil, is that you actually have to know what you're
> doing :-) Take the time to read the online documentation on mysql.com,
> it's p
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
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
> 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
ize,
> only the number and depth of the indexes.
>
> No, it is not that unusual to have the index file bigger. Just make sure
> that every index you have is justified by the queries you are making against
> the table.
>
> - md
>
>
> On Fri, Oct 7, 2011 at 4:26
he difference between an
>>>> index on (field_a, field_b) and an index on (field_b, field_a)?
>>>>
>>>>
>>>> On 10/06/2011 07:43 PM, Nuno Tavares wrote:
>>>>
>>>>> Neil, whenever you see multiple fields you'd lik
to run against the
> system and construct indexes which support them.
>
> - md
>
> On Thu, Oct 6, 2011 at 2:35 PM, Neil Tompkins <
> neil.tompk...@googlemail.com> wrote:
>
>> Maybe that was a bad example. If the query was name = 'Red' what index
>>
cord in the
> that database (the test itself being expensive as infix finding is
> iterative). Perhaps you should consider this approach instead:
> http://dev.mysql.com/doc/refman/5.5/en/fulltext-natural-language.html
>
> On Thu, Oct 6, 2011 at 10:59 AM, Tompkins Neil
> wrote
ble
WHERE score > 10
AND name Like '%Red%'
ORDER BY score DESC
How many indexes should be created for these two queries ?
Thanks,
Neil
iPad
>
> On Oct 5, 2011, at 4:01 AM, Tompkins Neil
> wrote:
>
> > Following my mail below, if anyone can help optimise the query further
> that
> > would be a great help.
> >
> > -- Forwarded message --
> > From: Tompkins Neil
> >
Following my mail below, if anyone can help optimise the query further that
would be a great help.
-- Forwarded message --
From: Tompkins Neil
Date: Wed, Oct 5, 2011 at 9:48 AM
Subject: Re: Slow query - please help
To: Johnny Withers
Cc: "mysql@lists.mysql.com"
I ju
ndex condition; Using where'
'3', 'DEPENDENT SUBQUERY', 'hotels', 'ref',
'IDX_country_code,IDX_language_code', 'IDX_country_code', '7', 'const',
'9982', '100.00', 'Using index condition; Usin
27;IDX_language_code', NULL, NULL,
NULL, '163102', '100.00', 'Using where'
'2', 'DEPENDENT SUBQUERY', 'hotels', 'ref',
'UNQ_folder_url,IDX_enabled,IDX_language_code', 'IDX_enabled', '1', 'c
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 definitio
`),
KEY `IDX_latitude` (`latitude`),
KEY `IDX_longitude` (`longitude`),
KEY `IDX_name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
On Fri, Sep 30, 2011 at 6:08 PM, mark carson wrote:
> Hi
>
> You need version of mysql and table/key/index layout in o
x27;
ORDER BY cities.name ASC , cities.city_id ASC
Previously the table format was Innodb with foreign keys and the query was
pretty much instant. Now I've changed the table format to MyISAM and
obviously removed the foreign keys and the query takes forever to execute
using the same data. Can anyone help and tell me where I've gone wrong.
Thanks
Neil
gt;>
>> 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 innodb this time
>> >
>> > Am 29.09.2011 19:15, schrieb Tompkins Neil:
>&g
Hi
Does anyone know when the production release of MySQL 5.6 will be out ?
Thanks
Neil
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;
>> > so mysql is currently the wrong database for your project
>> > sad but true, you can not have fulltext-search and innodb this time
>> >
>> > Am 29.09.2011 19:15, schrieb Tompkins Neil:
>> >> We've succesfully used FULLTEXT searching on a
search and innodb this time
>
> Am 29.09.2011 19:15, schrieb Tompkins Neil:
>> We've succesfully used FULLTEXT searching on another application that does
>> not need Innodb tables. In addition for
>> the FULLTEXT searching we use things like "IN BOOLEAN MODE"
:
> you do not need any replication or myisam for
> select * from table where field like '%input%';
>
> for most workloads this is enough and you have not the problem
> with stop-words, minimum input length and so on
>
> Am 29.09.2011 19:07, schrieb Tompkins N
Yes, unless I can set-up some sort of replication between the two tables.
On Thu, Sep 29, 2011 at 6:05 PM, Reindl Harald wrote:
> please do NOT post off-list!
>
> so your only workaround is like '%whatever%' currently
>
> Am 29.09.2011 19:04, schrieb Tompkins Neil:
>
Hi
I've a Innodb and MyISAM table in the SAME database that I wish to replicate
the data between the two because I need to use FULLTEXT searching on
the MyISAM table. Is this possible ? If so how do I do it.
Thanks
Neil
Thanks for the response. This is what I was after. Although, I am looking
to find out the email addresses used to login from the same IP ?
On Wed, Mar 2, 2011 at 2:49 PM, Jerry Schwartz wrote:
>
> >-Original Message-
> >From: Tompkins Neil [mailto:neil.tompk...@googlema
Hi
I've the following basic table
login_id
email_address
ip_address
I want to extract all records from this table in which a user has used the
same IP address but different email address to login ?
Thanks,
Neil
Thanks, but how can I pass the current users value from the other query ?
On Thu, Feb 3, 2011 at 4:22 PM, Simcha Younger wrote:
> On Thu, 3 Feb 2011 13:55:36 +
> Tompkins Neil wrote:
>
> > SELECT DISTINCT(away_teams_id) AS teams_id
> > FROM fixtu
Hi Travis,
That query kind of gives me the desired result. However, if is showing
me 1, 18, 11, 23, 3, 2010-11-14 17:18:17 record and not 2, 11, 10, 3, 6,
2010-12-20 22:17:13, which is when they changed teams. Any thoughts ?
Cheers
Neil
On Thu, Feb 3, 2011 at 10:32 PM, Travis Ard wrote
27;
for the part of the statement that I've marked as *bold* and how I can over
come this problem ?
Cheers
Neil
ean ? Any
ideas on how I can achieve this using MySQL ?
Cheers
Neil
27;where clause'
Any ideas how to overcome this problem ?
Cheers
Neil
itions_id
WHERE home_teams_id = 27
AND worlds_id = 1 AND status = 'approved'
Cheers
Neil
-- Forwarded message --
From: Tompkins Neil
Date: Tue, Oct 19, 2010 at 2:01 PM
Subject: If within If ?
To: "[MySQL]"
Hi,
I've the following query :
SELECT IFNUL
'
However, I want to check the value of competitions.competition_type and if
it is 'cup' I want to divide the value of gate_receipts by 2. How is the
best way to achieve this ?
Regards
Neil
ms_id
Cheers
Neil
MySQL Administrator 1.2.15 is fails with the same problem. Do anyone have
any other suggestions ?
-- Forwarded message --
From: Tompkins Neil
Date: Fri, Oct 15, 2010 at 11:21 AM
Subject: Re: Backing up MySQL using PHPMyAdmin problem with UTF-8
To: Michael Dykman
Cc: "[
o your dump at the console. PHP does
> not deal with UTF very well.
>
> - michael dykman
>
>
> On Thu, Oct 14, 2010 at 5:48 AM, Tompkins Neil
> wrote:
> > Hi,
> >
> > I'm using PHP MyAdmin to backup my MySQL database. The database is of
> > ty
Based on my reply below, do you recommend I continue to have these indexes ?
-- Forwarded message --
From: Tompkins Neil
Date: Wed, Oct 13, 2010 at 8:22 PM
Subject: Re: Primary key not unique on InnoDB table
To: Travis Ard
Cc: "[MySQL]"
Hi Travis,
Thanks for you
d do your dump at the console. PHP does
> not deal with UTF very well.
>
> - michael dykman
>
>
> On Thu, Oct 14, 2010 at 5:48 AM, Tompkins Neil
> wrote:
> > Hi,
> >
> > I'm using PHP MyAdmin to backup my MySQL database. The database is of
> > type Inn
k/set ?
Cheers
Neil
Hi Travis,
Thanks for your response. The fields which have indexes on, can be used on
every other search, which is why I thought about creating them. Would you
recommend against this ?
Cheers
Neil
On Wed, Oct 13, 2010 at 6:48 PM, Travis Ard wrote:
> I couldn't help but notice
Shawn it is fine. I thought my primary key was just 1 field.
On Wed, Oct 13, 2010 at 4:44 PM, Shawn Green (MySQL) <
shawn.l.gr...@oracle.com> wrote:
> On 10/13/2010 11:37 AM, Tompkins Neil wrote:
>
>> Shawn, sorry my error, I didn't realise I had two fields as the primar
Of course, sorry totally stupid should I recognised that.
Thanks
Neil
On Wed, Oct 13, 2010 at 3:46 PM, Krishna Chandra Prajapati <
prajapat...@gmail.com> wrote:
> Hi Neil,
>
> Yes, primary key is always unique.
>
> In your case, you are using composite key (player
ent. Am I completely
> wrong?
>
> --
> João Cândido de Souza Neto
>
> "Tompkins Neil" escreveu na mensagem
> news:aanlkti=xnjcaiq7bmoxg-q+4nowdhv8uaj9dcqrol...@mail.gmail.com...
> Sorry Joao, I thought that was pretty standard to have a primary key with
> auto_increme
1 - 100 of 823 matches
Mail list logo
