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:
http://dev.mysql.com/doc/refman/5.0/en/functions-that-test
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 1
Your udf is executing in a threaded environment so you have the option
of creating a datastrucutre to store options in that will persist
across udf executions. However since you won't be deallocating this
structure ever it's essentially leaked memory.
What are you doing with udfs that you want to
Hi Peter,
Definitely using OR will slow up the performance of FULL TEXT searching.
Instead of using OR, you can try using UNION statement.
Hope this will be a fix for your issue.
Thanks,
ViSolve MySQL Support Team.
- Original Message -
From: "Peter Lauri" <[EMAIL PROTECTED]>
To: "'J
Hello Thomas
You have an error in your SQL syntax.
Please try this :
CREATE TABLE test.user
( user_id INT UNSIGNED NOT NULL AUTO_INCREMENT, PRIMARY KEY(user_id),
email text CHARACTER SET 'latin1' COLLATE 'latin1_swedish_ci',
firstname text CHARACTER SET 'latin1' COLLATE 'latin1_swedish_ci');
T
At 06:20 PM 7/20/2006, Martin Jespersen wrote:
As long as backticks are used around fieldnames, spaces and/or reserved
words are fine, tho it does tend to create more work for the user ;)
Correct. But how many people want to create more work for themselves? A
show of hands please!
Mike
mo
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've tried various combinations of removing the quotes, tried not using a
passwor
I'd like to test whether a point is truly inside a polygon, not just
insude the minimum bounding rectangle. Is there a way to do this in
MySQL with the spatial extensions? I love mysql but I'm forced to
consider migrating to postgresql (ugh!) because it has built in
support for testing spatial rel
/var/lib/mysql/
is a common location. If you're on unix try the following command:
find /var -name "mysql"
On 7/20/06, Martin Jespersen <[EMAIL PROTECTED]> wrote:
You can usually find the database files under the "var" subdirectory
under your installation, unless another datadir was specified
As long as backticks are used around fieldnames, spaces and/or reserved
words are fine, tho it does tend to create more work for the user ;)
mos wrote:
At 12:02 PM 7/20/2006, you wrote:
I've got a table of people who registered for a convention. Each
person has a registration date, kept in a
You can usually find the database files under the "var" subdirectory
under your installation, unless another datadir was specified at
compiletime.
;) Martin
Joko Siswanto wrote:
Dear All
if myqsl service can't start, where can i found the file and back up it?
[under windows and linux]
Thank
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 InnoDB, SERIALIZABLE mode.
Let's say we have:
1.TX1 START //assume autocommit is off
2.TX1 read on TableA
3.TX1 update on TableA
4.TX
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 ev
On Thursday 20 July 2006 12:48 pm, Bing Du wrote:
> Hello everyone,
> mysql>update 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 g
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 even possible, to grab the
content fro
At 12:02 PM 7/20/2006, you wrote:
I've got a table of people who registered for a convention. Each person
has a registration date, kept in a standard date field. How do I select
for people who registered in a particular month or year? The obvious
tests like:
Select * from Capclave2005reg
W
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 !
--
Gabriel PREDA
Senior Web Developer
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http:/
Barry, I think you've got too many quotes in your SQL - the db is
trying to find the year from the string 'date paid'. You want to use
it as a column name, so drop the quotes:
Select * from Capclave2005reg
Where Year(Date Paid) = 2004;
If you've really got a space in your column name, try enclo
I've got a table of people who registered for a convention. Each person
has a registration date, kept in a standard date field. How do I select
for people who registered in a particular month or year? The obvious tests
like:
Select * from Capclave2005reg
Where Year('Date Paid') = 2004;
ret
Joko Siswanto wrote:
Dear All
if myqsl service can't start, where can i found the file and back up it?
[under windows and linux]
Thanks,
Joko Siswanto
What file are you looking for?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.
Dear All
if myqsl service can't start, where can i found the file and back up it?
[under windows and linux]
Thanks,
Joko Siswanto
Why can the Thai and Chinese not use regular sentences and word delimiter :)
So I have to stick to my LIKE thing, just to erase the FULL TEXT index I
assume.
-Original Message-
From: Neculai Macarie [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 20, 2006 10:50 PM
To: mysql@lists.mysql.com
That is what I am doing right now, but it is not that fast if this system
would grow, and also it is not "ranking" the searches.
Right now I do something like this:
$searchwords = explode(" ", $searchstring);
foreach($searchwords AS $value) {
$Query.= "OR lajlaj LIKE '%$value%'"
}
If there ar
Peter Lauri wrote:
> 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 FULLTEXT parser determines where words start and end by looking for
certain delim
don't know about indexing, but try to search: LIKE '%sentences%'
JC
On Thu, 20 Jul 2006, Peter Lauri wrote:
> 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 f
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 and other languages. I
On Thursday 20 July 2006 07:19 am, Nicholas Vettese wrote:
> img_idINTNOT NULL auto_increment PRIMARY KEY,
> user_id INTNOT NULL,
> location VARCHAR(255) NOT NULL,
> imgtype VARCHAR(20) NOT NULL,
> img_tag VARCHAR(50) NOT NULL,
> img_rate VARCHAR(20) NOT NULL,
good
> img_comments
Ok, MysqlCC is deprecated.
I do not like this decision but... it is the thruth...
I'm trying MysqlBrowser.
It start connection with my server but it writes in the status bar:
Access violation at address 005BC7B4 in module 'MySQLQueryBrowser.exe'
Readof address 0
What does it means?
It t
On Thursday 20 July 2006 04:10 am, Dominik Klein wrote:
> Hello
>
> When I re-insert dumped data with "mysql < file.sql", I can simply put
> "set foreign_key_checks=0;" at the beginning of the file and this works
> fine.
So do it that way
> So if there's any other well-known solution for per-tabl
Use "old-passwords" on the server or upgrade your client library.
Regards
Dominik
[localhost] ERROR 1251: Client does not support authentication protocol
requested by server; consider upgrading MySQL client
You have something similar about mysql client last week but what about
MysqlCC?
--
M
I am looking to create a database that holds the location of images on my
server. I was wondering if anyone could help me understand if I am doing it
correctly, and if I either need to add, change or remove something from the
current table code.
img_idINTNOT NULL auto_increment PRIMARY
Hello,
I am encountering a strange issue when using the STD function. On my local
development machine (MYSQL version 4.18-nt) I can run the following basic
SELECT query with no problems:
SELECT STD(`LAPSETIME`),UKEY FROM 4b3f91f64a19529a84dff4982c8a6bc5 GROUP BY
UKEY
When I test this query on m
Hi,
i used MysqlCC for a long time with mysql 4.0 on my remote server...
Now i've installed mysql 5.0 on my PC and i'd like to use MysqlCC but it
doesn't work.
It responds:
[localhost] ERROR 1251: Client does not support authentication protocol
requested by server; consider upgrading MySQL clie
On 20 Jul 2006 at 16:56, Vitaliy Okulov wrote:
> , Deniss.
>
> 20 2006 ., 15:59:10:
>
> > Hi All
>
> > While I am doing portupgrade -vr mysql on freebsd server
>
> > than mysql socket"/tmp/mysql.sock" is invisible on, so mysql cant be start
>
> > How I can create mysql socket.
> > How I can
Здравствуйте, Deniss.
Вы писали 20 июля 2006 г., 15:59:10:
> Hi All
> While I am doing portupgrade -vr mysql on freebsd server
> than mysql socket"/tmp/mysql.sock" is invisible on, so mysql cant be start
> How I can create mysql socket.
> How I can start mysql
> thanks
MySQL server will
Hi All
While I am doing portupgrade -vr mysql on freebsd server
than mysql socket"/tmp/mysql.sock" is invisible on, so mysql cant be start
How I can create mysql socket.
How I can start mysql
thanks
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 connect etc.
thanks,
Jeff
--
Hello
When I re-insert dumped data with "mysql < file.sql", I can simply put
"set foreign_key_checks=0;" at the beginning of the file and this works
fine.
How can I achieve this when inserting a text file that is read with
mysqlimport?
I tried to put the mentioned sql-statement in the txt-
Hi Thomas
I try to configure replication from master to one slave for a database
with various table types (InnoDB, MyISAM) without stopping the master.
Therefore I make a mysqldump on the slave from master with this options:
mysqldump
-h master-db \
-udummyuser \
-pd
Hola.
With mySQL 4.0.27 I'm trying to create this table
--
CREATE TABLE `test`.`user` (
`user_id` INT UNSIGNED NOT NULL AUTO_INCREMENT ,
`email` TEXT CHARACTER SET COLLATE NULL ,
`firstname` TEXT CHARACTER SET COLLATE NOT NULL ,
)
--
but I get this error:
--
#1064 - You have an
Can you do a "show processlist" from the MySQL client? This might
help you to figure out if it is a specific query that's gumming up
the works.
Douglas Sims
[EMAIL PROTECTED]
On Jul 19, 2006, at 6:35 PM, Robinson, Eric wrote:
Our MySQL-based medical application has been running fine f
Robinson, Eric wrote:
Our MySQL-based medical application has been running fine for 3 years.
Last week, mysqld-nt started jumping up to 100% CPU and staying there
until someone restarts the service. mysqlcheck found no errors in the
database. I dumped it to disk and read it back in to create a fr
42 matches
Mail list logo
