Hello Mark,
You can locate a point, whether inside or outside a polygon area using the
query below:
SELECT contains(geomfromtext(@poly),geomfromtext(@p));
where @poly,@p are variables.
Eg: set @p='Point(3 2)';
set @poly= 'Polygon((0 0,0 3,3 0,0 0),(1 1,1 2,2 1,1
Thanks, but according to the documentation the Contains() function is
the same as the MBRContains() function which only tests if the point
is inside the minimum bounding rectangle of the polygon, not the
actual polygon.
See the following:
Hi,
Problem is like this. There is table with 'table_name-1' where, when I
am executing the query like ' select * from table_name-1;' it is showing
only 432 records but acctually there are 539 records in the table. when I
select individual records from the table it is showing (able to view
Gabriel PREDA schrieb:
Try:
ALTER TABLE `tbl_name` DISABLE KEYS;
-- now insert in the TXT file
ALTER TABLE `tbl_name` ENABLE KEYS;
I think this is what you were looking for !
That would have been a possibility. I did it this way now:
...
echo set sql_log_bin=0; set foreign_key_checks=0;
mysqldump -u [user] -h [host] -p [database] [table] fixme.sql
This is for one table.
As I need it for all my tables in all my databases, I'd have to write a
script for that.
And as --tab uses less space, I prefer --tab option for mysqldump.
--
MySQL General Mailing List
For list archives:
Peter Lauri schrieb:
Best group member,
I have a problem. I was going to use FULL TEXT search for my Thai client. It
is working smooth with English text and wordings, the indexing and search
works fine.
The problem with Thai text is that words are not separated with a white
space as in English
Chris White schrieb:
Normally I try to be as descriptive as possible with subject lines but.. not
quite sure what else to call it.
So basically, I was given ALL access by our sysadmin to a particular database.
Now, somehow I was able to create a database and use it! It's my
understanding
[EMAIL PROTECTED] schrieb:
anyone know if there's any known issue with replication from InnoDB tables to
MyISAM tables?
I just switched a slave (mysql) to replicate from a different master that uses
InnoDB and now I'm seeing weird problems on the slave. Table corruption, apps
that can't
Oops, the version numbers were 4.1.18-nt and 4.1.19-standard. I have tried
it now on the latest 4.1.20 version and still have the same problem.
Does anyone have any ideas? Is this a bug?
Cheers,
Bill
-Original Message-
From: William Bronsema
Sent: Thursday, July 20, 2006 10:18 AM
Hello everbody,
I have a table in my MySQL 5.0.22 Server with this columns.
+--+--+--+-+-+---+
| Field| Type | Null | Key | Default | Extra |
Hi there,
I'm the lead developer on Aubit4GL (http://aubit4gl.sourceforge.net) which is
a 4gl compiler used for writing database centric applications based on the
original Informix-4GL language..
I'm just wondering what the appetite is like out there for a mysql compatible
version (we've got a
Hello,
Have you taken a look at MySQL Forge?
http://forge.mysql.com/
Great place check out other projects or users working on projects who may be
interested in what your working on.
Thanks,
Jimmy Guerrero
Sr Product Manager
MySQL, Inc
-Original Message-
From: Mike Aubury
On Thursday 20 July 2006 12:48 pm, Bing Du wrote:
Hello everyone,
mysqlupdate research set publications='lng text in a file' where
uid=319;
You already have the data in a storage system ( a file on the filesystem
).
That said, use what you have, store the location to the file, then
At 02:48 PM 7/20/2006, you wrote:
Hello everyone,
Without scripting, can this be done from mysql command line? The
'publications' field is mediumtext in table 'research'. Since
'publication' is pretty long, I want to save it in a file on the file
system. But I don't know how, or if that's
Dear MySQL users,
Starting MySQL 5.1 (1), we’re simplifying life when it comes to the
number of builds for each platform. We will be building only one binary
package for each platform (2): the binary known in MySQL 5.0 as “max”.
The assumption is that users prefer one binary with all options
At 08:10 AM 7/21/2006, Michael Sutter wrote:
Hello everbody,
I have a table in my MySQL 5.0.22 Server with this columns.
+--+--+--+-+-+---+
| Field| Type | Null | Key | Default | Extra |
Michael M. schrieb:
I'm attempting to take a brand new mysql server build on gentoo and set up
replication.
I'm using
GRANT REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO
'repl'@192.168.1.0/255.255.255.0 IDENTIFIED BY 'secret';
I'm not sure if this is correct syntax.
Use the specific IP
I'm new to MySQL mailing lists. Is there a more appropriate list for
this type of question?
thanks
-nikita
Nikita Tovstoles wrote:
Hi,
I'm running into lost of DB deadlocks would really appreciate answers
to the questions below which will help me diagnose the problem. I am
running MySQL 5
Dear All,
I need to write a query that searches last names between the ranges of m
through z.
Is there a way to do this in the query?
Thank You,
--
Paul Nowosielski
Webmaster
office: 303.440.0666 ext 219
cel: 303.827.4257
--
MySQL General Mailing List
For list archives:
I'm trying to upgrade from MySQL 4.1 to MySQL 5.0.
A query that works in MySQL 4.1 does not work in MySQL 5.0 and I'm at a loss
as to how to proceed.
SELECT tab_a.item1, tab_b.item2, tab_c.item3, tab_d.item4, tab_e.item5,
tab_f.item6 FROM db.tab_a, db.tab_e, db.tab_f LEFT JOIN db.tab_b ON
At 12:47 PM -0500 7/21/06, Stephen P. Fracek, Jr. wrote:
I'm trying to upgrade from MySQL 4.1 to MySQL 5.0.
A query that works in MySQL 4.1 does not work in MySQL 5.0 and I'm at a loss
as to how to proceed.
SELECT tab_a.item1, tab_b.item2, tab_c.item3, tab_d.item4, tab_e.item5,
tab_f.item6
Stephen P. Fracek, Jr. wrote:
I'm trying to upgrade from MySQL 4.1 to MySQL 5.0.
A query that works in MySQL 4.1 does not work in MySQL 5.0 and I'm at a loss
as to how to proceed.
SELECT tab_a.item1, tab_b.item2, tab_c.item3, tab_d.item4, tab_e.item5,
tab_f.item6 FROM db.tab_a, db.tab_e,
I have the solution:
SELECT DISTINCT email_address FROM mailing_list WHERE last_name = 'm' AND
last_name = 'z'
Thank you,
--
Paul Nowosielski
Webmaster
On Friday 21 July 2006 11:03, Paul Nowosielski wrote:
Dear All,
I need to write a query that searches last names between the ranges of
Not quite...
mysql select 'zebra' = 'm' AND 'zebra' = 'z';
+---+
| 'zebra' = 'm' AND 'zebra' = 'z' |
+---+
| 0 |
+---+
1 row in set (0.00 sec)
mysql select 'seal' = 'm'
On 2006-07-21 1:01 PM, Gerald L. Clark [EMAIL PROTECTED]
wrote:
It is a join precedence issue. Use INNER Join instead of a comma.
Thanks Gerald.
Paul DuBois' polite suggestion to read the manual helped. Upon re-reading
the section about the change in precedence with
the comma operator and
Its working fine for me:
mysql SELECT DISTINCT email_address FROM mailing_list WHERE marketing_list
LIKE 'Y' AND last_name = 'm' AND last_name = 'z';
26371 rows in set (1.00 sec)
Thank You,
--
Paul Nowosielski
Webmaster
On Friday 21 July 2006 12:46, Tim Lucia wrote:
Not quite...
mysql
Hi All,
I'm going throught some tutorial about uploading and displaying
images files. But the display script isn't working. Here's what I have:
Table setup is:
CREATE TABLE `image` (
`ImageId` int(10) NOT NULL auto_increment,
`Image` longblob,
`FileType` varchar(32) default NULL,
PRIMARY
I'm going throught some tutorial about uploading and displaying
images files. But the display script isn't working. Here's what I have:
I think you may want to bring this to a php based list, not a mysql one.
--
-
Scott Haneda
At 04:22 PM 7/21/2006 Friday, Scott Haneda wrote:
I'm going throught some tutorial about uploading and displaying
images files. But the display script isn't working. Here's what I have:
I think you may want to bring this to a php based list, not a mysql one.
Yes, it's cross-posted. I
Do anyone know of any tools to automatically generate SQL tables,
and C++ or Objective C code for object persistence.
What I want is code that takes for example code like this:
class MyClass {
Persistent int key;
/* rest omitted */
};
And generates an SQL table declaration from it.
(In
While this is offtopic, just a side note:
You probably want to store your images on disk with the filename in
the database rather than the actual image binary data in the db.
Filesystems are very good at storing and retreiving chunks of binary.
Databases do it because... well... I'm not really
Hi,
My table looks like this:
ipv4addr (INT, PK)
status (INT)
status: 0 = free 1 = used
I'm trying to get free IP addresses by only giving CIDR (0 to 32) or
netmask (0.0.0.0 to 255.255.255.255).
The output should be one of them:
1. start IP
2. start IP CIDR
3. start IP Netmask
4. start IP end
I've getting something wrong in transaction in Mysql 5.0.22 on windows that
i don't know way it's happen.
I've got a script in php which starts a transaction and when if fails and
rollbacks, the autoincrement do not back.
e.g.
If in transaction some field auto increment gets the value 4 and
In the last episode (Jul 22), Joπo CΓndido de Souza Neto said:
I've getting something wrong in transaction in Mysql 5.0.22 on
windows that i don't know way it's happen.
I've got a script in php which starts a transaction and when if fails
and rollbacks, the autoincrement do not back.
e.g.
35 matches
Mail list logo