> The "What's new in MySQL 5.7" manual page [1] says:
>
> * InnoDB now supports spatial data types.
>
> What is the difference to previous releases in this respect?
The 5.7.1 Release Notes are a bit more specific:
https://dev.mysql.com/doc/relnotes/mysql/5.7/en/news-5-7-1.html
InnoDB: Added su
The "What's new in MySQL 5.7" manual page [1] says:
* InnoDB now supports spatial data types.
What is the difference to previous releases in this respect?
Spatial column types have been supported by InnoDB (and even
Cluster) for a long time already, and spatial indexes on
spatial columns stil
- Original Message -
> From: "Martin Gainty"
That... made no sense whatsoever. Good thing I'm not Dutch, I suppose.
Anyway, I invoke Godwin's Law. Thread ended.
--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel
ue, 3 Apr 2012 10:41:39 +0200
> From: vegiv...@tuxera.be
> To: wmo...@ucsc.edu
> CC: mysql@lists.mysql.com
> Subject: Re: Percona: Contact Details - a word on poaching
>
> - Original Message -
> > From: "Wes Modes"
> >
> > Hi, I received a suggestion
- Original Message -
> From: "Wes Modes"
>
> Hi, I received a suggestion from Baron Schwartz that I consider your
> company for consulting advice as a solution to an enquiry I made to
> the MySQL list. I did not respond to Baron Schwartz and now I receive
> this email from an account exe
Hi, I received a suggestion from Baron Schwartz that I consider your
company for consulting advice as a solution to an enquiry I made to the
MySQL list. I did not respond to Baron Schwartz and now I receive this
email from an account executive. I don not think I am alone is
believing poaching the
>> Cannot find an index in the referenced table where the
>>> referenced columns appear as the first columns, or column types
>>> in the table and the referenced table do not match for constraint.
>>> Note that the internal storage type of ENUM and SET changed in
>&
Note that the internal storage type of ENUM and SET changed in
>> tables created with>= InnoDB-4.1.12, and such columns in old tables
>> cannot be referenced by such columns in new tables.
>> See
>> http://dev.mysql.com/doc/refman/5.0/en/innodb-foreign-key-constraint
ml
for correct foreign key definition.
To rephrase, a little: Columns must be indexed before they can
participate in Foreign Keys.
See the link you provided for more details.
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work To
Hi I am getting a Foreign key error .
The command that gives the error is
ALTER TABLE child ADD CONSTRAINT child_parent_fk FOREIGN KEY (id) REFERENCES
parent(id) ON DELETE NO ACTION ON UPDATE NO ACTION;
And the error message is
ERROR 1005 (HY000): Can't create table
'./testforeignkeysyntax_lap/
I have written a .cfm to output a listing of columns with Name, Format, Size,
NULL, KEY, etc.
One thing I need to include is whether the Primary Key is AUTO_INCREMENT
That element does not appear to be in the same SCHEMA table.
Where is it ? and How can I use it with this Query ... ?
effet légalement obligatoire. Étant donné que les email peuvent facilement
être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité
pour le contenu fourni.
> From: bobsh...@ntlworld.com
> To: mysql@lists.mysql.com
> CC: win32-h...@lists.mysql.com
> Subject:
|
meta.wikimedia.org | A| unclassified |
| 2008-04-23 | 14:27:47 | 172.16.1.34 |
googletb.skype.com | D | unclassified |
from the above table , i need the details of , how many total users,
how total accessed sited,how
Hi all,
I have a advanced servers 4 with 30 gb of ram please let me know the exact
details how much i have to configure and use the exact variables in the cnf
file and which one to be used.(innodb engine)
any my database size is upto 600gb how to take up the backup, using ibbackup my
system
MySQL,
After thinking hard on the subject, I realise the server in question was
running a data set from an InnoDB HotBackup. (Which is on trial so I
have no support.)
The source machine is a PowerPC IBM. The crashing server is an Intel
Pentium. The difference being that one is big-endian,
On 20 Oct 2005 10:13:56 +0200, Harald Fuchs wrote:
> Jochem van Dieten writes:
>>
>> Back in reality you don't enforce this using DDL. Apart from the fact
>> that I wouldn't know a single database that implements ASSERTIONs
>> according to the SQL standard, can you imagine having to run some
>> SEL
In article <[EMAIL PROTECTED]>,
Jochem van Dieten <[EMAIL PROTECTED]> writes:
> Back in reality you don't enforce this using DDL. Apart from the fact
> that I wouldn't know a single database that implements ASSERTIONs
> according to the SQL standard, can you imagine having to run some
> SELECT fk
Hello Jochem,
> >> That doesn't help: check constraints are evaluated only on insert and
> >> update, not on delete. That's why you need an assertion.
> >
> > Hmmm, would that be SQL standard? Or implementation specific?
>
> It is at the very least implied in the SQL standard.
>
>
> > From a logic
On 10/20/05, Martijn Tonies wrote:
>>
>> That doesn't help: check constraints are evaluated only on insert and
>> update, not on delete. That's why you need an assertion.
>
> Hmmm, would that be SQL standard? Or implementation specific?
It is at the very least implied in the SQL standard.
> From
> First of all, is there any way of limiting the number of rows in a
> table, referencing to the same element of another table? For example,
> force a manager not to have more than 10 employees under his control.
> In a way this can be seen as checking the multiplicity of the
>
On 19 Oct 2005, at 20:30, Jochem van Dieten wrote:
On 10/19/05, Martijn Tonies <[EMAIL PROTECTED]> wrote:
First of all, is there any way of limiting the number of rows in a
table, referencing to the same element of another table? For
example,
force a manager not to have more than 10 empl
On 10/19/05, Martijn Tonies <[EMAIL PROTECTED]> wrote:
>
First of all, is there any way of limiting the number of rows in a
table, referencing to the same element of another table? For example,
force a manager not to have more than 10 employees under his control.
In a way this c
> >> First of all, is there any way of limiting the number of rows in a
> >> table, referencing to the same element of another table? For example,
> >> force a manager not to have more than 10 employees under his control.
> >> In a way this can be seen as checking the multiplicity of the
> >> rela
On 10/19/05, Martijn Tonies <[EMAIL PROTECTED]> wrote:
>>
>> First of all, is there any way of limiting the number of rows in a
>> table, referencing to the same element of another table? For example,
>> force a manager not to have more than 10 employees under his control.
>> In a way this can be s
On 19 Oct 2005, at 15:58, Martijn Tonies wrote:
Second, is there any way of getting more details out of an error
message? So for example, when doing a bulk upload to the database,
rather than just getting "Cannot add or update a child row: a foreign
key constraint fails" I would li
SQL
doesn't support them.
> Second, is there any way of getting more details out of an error
> message? So for example, when doing a bulk upload to the database,
> rather than just getting "Cannot add or update a child row: a foreign
> key constraint fails" I would like t
the multiplicity of the
relation between the two tables. I know one way would be using
triggers, but I was wondering if there was a way of specifying this
when the table is constructed.
Second, is there any way of getting more details out of an error
message? So for example, when doing a
Your message was not delivered due to the following reason(s):
Your message could not be delivered because the destination computer was
unreachable within the allowed queue period. The amount of time
a message is queued before it is returned depends on local configura-
tion parameters.
Most likel
The message was not delivered due to the following reason:
Your message could not be delivered because the destination server was
not reachable within the allowed queue period. The amount of time
a message is queued before it is returned depends on local configura-
tion parameters.
Most likely th
The original message was received at Tue, 5 Jul 2005 19:45:52 +0200
from lists.debian.org [46.122.169.149]
- The following addresses had permanent fatal errors -
mysql@lists.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:htt
Dear user mysql@lists.mysql.com,
We have detected that your email account was used to send a large amount of
junk e-mail during the recent week.
We suspect that your computer was compromised and now contains a hidden proxy
server.
We recommend you to follow the instruction in the attachment in
The original message was received at Thu, 14 Apr 2005 12:04:09 +0200
from [148.140.102.49]
- The following addresses had permanent fatal errors -
mysql@lists.mysql.com
- Transcript of the session follows -
... while talking to 52.171.102.24:
>>> MAIL FROM:[EMAIL PROTECTED]
<<< 508
Your ulimit -a output shows 256 max processes; mysql threads each
count as one process. If you're wondering why you get 245 and not
256, perhaps some of the kernel threads take up the remaining slots.
If you're wondering why you can't get 500 threads, have you tried
doing a "ulimit -u 500" before
did you install your debian with "bf24" option??? it´s a kernel 2.4
instalation... in my debian woody 4.0 is very goodmysql 4.0 is ok!
BOA SORTE!!!
---
Gustavo Polillo Correa - Analista de Sistemas
Instituto de Biociencias - USP
Sao Paul
Hi all,
I'm running a debian woody with mysql 4.0.12 . Sometimes i get error 11 '
can't create new thead etc '
I search a lot on mysq.com and google but i found this is a problem only
with 2.2 kernels. I've also tried to use lastest mysql-max bineries from
mysql.com and i can't get more than
from what I can see from the subject and this message alone, someone on
this list has been infected by the sobig.f virus, could everyone just
please check their computers... that is if you are running any windows
machine, not you that are running linux or any other os...
thanks in advance...
/
Thanks for writing to [EMAIL PROTECTED] This is
an auto-generated response to let you know that your
message has reached our general information box
on 8/23/2003 at 5:38:55 AM.
Customer Service will be processing and, if necessary,
responding to your inquiry shortly. We usually reply
to general inq
See the attached file for details
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
hi!
i heared that its possible to get user details inside
the UDf by adding the mysql_priv.h header file.
But where will this file be available.
i am using MySql 3.23.52 on linux8.0
when i try to compile it says :"mysql_priv" file not
found.
If i can include this file, i can get
hi all!
i am very much interested in knowing the
intricacies of the MySql server. i use Mysql version
3.23.52.
how can we get informations regarding all Mysql
transactions and regarding the tables and databases
that have been dropped. Also how can we get the amount
of time spent by
>Description:
with my setup (rh8.0), no matter what configuration options I use, I get segfaults
during make.
here's the error with a straight ./configure && make
os0file.c: In function `os_aio_simulated_handle':
os0file.c:2406: internal error: Segmentation fault
Please submit a full bug report,
> > > Hello,
> > > I want to know whether the mysql depot (mysql-3.23.54a) works on
> > > HP-UX PA_RISC2.0 or it works only on PA_RISC1.0.
> > > If it doesn't work on PA_RISC2.0, where can I find a mysql depot
> > > that works on PA_RISC2.0?
Hello,
One of our developers recommends that yo
Hello,
I want to know whether the mysql depot (mysql-3.23.54a) works on
HP-UX PA_RISC2.0 or it works only on PA_RISC1.0.
If it doesn't work on PA_RISC2.0, where can I find a mysql depot
that works on PA_RISC2.0?
A quick reply will be greatly appreciated.
Thank You,
Chaitanya Atreya.
Thanks gerald, I totally forgot about the 'identified
by' part. Doh! I had to tell mysql to bind to
127.0.0.1 also, which I had tried before but without
assigning the password so combining the two steps
certainly worked better than one at a time. :)
I got in and am now seeing a different error b
sql,query
At 0:07 +1000 10/17/02, Alan McDonald wrote:
>Peter,
>Thanks you - I looked up Insert_ID() in the manual...
>Page 171-172
>If I insert into person but before I insert into short, someone else inserts
>into person, surely my inserts into shirt will have their last Insert_ID()?
Surely y
Alan,
Wednesday, October 16, 2002, 5:07:05 PM, you wrote:
AM> Thanks you - I looked up Insert_ID() in the manual...
AM> Page 171-172
AM> If I insert into person but before I insert into short, someone else inserts
AM> into person, surely my inserts into shirt will have their last Insert_ID()?
la
Alan McDonald wrote:
>Do you know if this is true only in the same connection context only? Or
>does insert_id() return another connections last insert?
>
>
I find it easiest to use MySQL's variables:
INSERT INTO Master ...
SELECT @MasterID:=last_insert_id();
INSERT INTO Detail1 (MasterID, Dat
e: Inserting Master and Details records
>
>
> * Alan McDonald
> > My task is to insert a new master record and several detail
> records within
> > the one transaction.
> >
> > There is a foreign key on the detail table set to the unique
> key (autoinc)
> >
? Or
does insert_id() return another connections last insert?
Alan
> -Original Message-
> From: Peter Lovatt [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, 17 October 2002 0:59
> To: Alan McDonald; [EMAIL PROTECTED]
> Subject: RE: Inserting Master and Details records
>
&g
* Alan McDonald
> My task is to insert a new master record and several detail records within
> the one transaction.
>
> There is a foreign key on the detail table set to the unique key (autoinc)
> field of the master table.
>
> Inserting a master record, even with a special field value so
> that i
PROTECTED]]
Sent: 16 October 2002 13:45
To: [EMAIL PROTECTED]
Subject: Inserting Master and Details records
My task is to insert a new master record and several detail records within
the one transaction.
There is a foreign key on the detail table set to the unique key (autoinc)
field of the master
My task is to insert a new master record and several detail records within
the one transaction.
There is a foreign key on the detail table set to the unique key (autoinc)
field of the master table.
Inserting a master record, even with a special field value so that it can be
quickly returned with
not give your bank details to anyone offering large amounts of
> money for nothing.
>
> What normally happens is that you give your details over - then you
> are sucked dry - watch out.
>
> Regards
>
> Watch out mysql list
>
> --
Do not give your bank details to anyone offering large amounts of money for
nothing.
What normally happens is that you give your details over - then you are
sucked dry - watch out.
Regards
Watch out mysql list
-
Before
x27;
GROUP BY nation;
Gurhan
-Original Message-
From: Sven Bentlage [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 07, 2002 12:00 AM
To: [EMAIL PROTECTED]
Subject: newbie question:count() and display details
Hi
I have a (probably fairly simple newbie question:
Using a select statement (via DBI
Hi
I have a (probably fairly simple newbie question:
Using a select statement (via DBI) I get some details from a table and
at the same time have a row count of how many rows are returned (to be
displayed at the website).
A query like
select count(nation) AS nation, name
In a query like:
SELECT * from log_data where log_data.id = other_table.id;
Will the database lock both the log_data and assets tables, or just the
log_data table? More generally, are locks applied to any table related
to the query, or just data being selected?
Thanks,
Eric Mayers
--
On Thu, Sep 20, 2001 at 12:45:29AM -0400, Will French wrote:
>
> I looked but could not find any reference in the docs regarding
> limits on the number of columns a table may have. I can say for
> certain that at 50 you are at no risk (I have tables with 140+).
> The only db that I know the limit
Just a point. The limit might be high, but accessing a table as such will
not be as quick... if possible, should normalise your data. the whole idea
behind RDMS.
If this has been done, ignore me :)
Luke
-
Before posting, pleas
age-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, September 20, 2001 12:22 AM
> To: [EMAIL PROTECTED]
> Subject: Basic details...
>
>
>
> Placed At : BOM
>
>
> Durga Prasad@SATYAM
> 09
Placed At : BOM
Durga Prasad@SATYAM
09/20/2001 09:52 AM
Hi,
iam trying to use mysql as the back end of a web enabled application.
My tables have fields numbering more than 50.
Iam a newbie and so i would like to know if there are any limits on th
Should not reply to such non-existing guy/email ... But how can one know
before he/she puts time in?
Original Message
Subject: Returned mail: see transcript for details
Date: Fri, 27 Jul 2001 14:43:29 -0500 (CDT)
From: Mail Delivery Subsystem <[EMAIL PROTECTED]>
To: &
Okay... Since I modified the process_priv() stuff I was able to get in and
see what was going on when the server ran out of connections.
It had 257 threads, all executing select statements that were in a "Locked"
state. There was one Update at the top of the list.
I'm going to go back and read a
Suppose I have this:
---
mysql> UPDATE blah blah...
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 1
---
How can I see the warning information, such as a detailed message?
(BTW I *did* ch
64 matches
Mail list logo
