mysql to perfect these function?
- Original Message -
From: Paul DuBois [EMAIL PROTECTED]
To: Rhino [EMAIL PROTECTED]; wangxu [EMAIL PROTECTED]
Cc: mysql mysql@lists.mysql.com
Sent: Friday, January 20, 2006 3:20 PM
Subject:Re: question about CONTAINS SQL
At 8:29 -0500 1/19/06, Rhino wrote
- Original Message -
From: Paul DuBois [EMAIL PROTECTED]
To: Rhino [EMAIL PROTECTED]; wangxu [EMAIL PROTECTED]
Cc: mysql mysql@lists.mysql.com
Sent: Friday, January 20, 2006 2:20 AM
Subject: Re: question about CONTAINS SQL
At 8:29 -0500 1/19/06, Rhino wrote:
I am copying the rest
I am copying the rest of the list with this so that everyone may benefit
from the discussion.
If your routine modifies data, in other words if it does SQL Update, Insert
or Delete but your routine definition says only CONTAINS SQL, I would
expect your routine to fail at runtime. I can't say
|
+---+--+--+
| 79NK0001/0003 | 79NK0001 |1 |
| 79NK0001/0003 | 79NK0002 |1 |
| 79NK0001/0003 | 79NK0003 |1 |
+---+--+--+
3 rows in set (0.01 sec)
mysql delimiter //
mysql create procedure test()
- deterministic
- contains sql
- begin
- insert
At 8:29 -0500 1/19/06, Rhino wrote:
I am copying the rest of the list with this so that everyone may
benefit from the discussion.
If your routine modifies data, in other words if it does SQL Update,
Insert or Delete but your routine definition says only CONTAINS
SQL, I would expect your
about CONTAINS SQL
But what is INSERT OR UPDATE need?
- Original Message -
From: Rhino [EMAIL PROTECTED]
To: wangxu [EMAIL PROTECTED]; mysql@lists.mysql.com
Sent: Tuesday, January 17, 2006 9:49 PM
Re: question about CONTAINS SQL
- Original Message -
From: wangxu
- Original Message -
From: wangxu [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Tuesday, January 17, 2006 12:35 AM
Subject: question about CONTAINS SQL
I notice there are one section in the manual:
CONTAINS SQL indicates that the routine does not contain statements that
read
I notice there are one section in the manual:
CONTAINS SQL indicates that the routine does not contain statements that read
or write data.
And that the option is default.
It's true?
If i wouldn't do read or write in routine.What can i do yet?
up a
table that contains multiple character sets, since one of the fields
will invariably encounter a conversion. Is there an undocumented
option that functions as --binary-charset ? or are we just left
with no way to backup and restore a table with mysqldump anymore? I
suppose the same
coredumps on FreeBSD if the SQL query contains a regexp
expression
Severity: serious
Priority: high
Category: mysql
Class: sw-bug
Release: mysql-5.0.2-alpha (FreeBSD port: mysql-client-5.0.2)
C compiler:cc (GCC) 3.4.2 [FreeBSD] 20040728
C++ compiler: c++ (GCC) 3.4.2
but you could throw
together a substring loop that prints out the ascii value of each
character.
-Original Message-
From: Martin Gainty
To: [EMAIL PROTECTED]
Sent: 8/18/04 3:24 PM
Subject: contains?
is there way to interrogate what is inside a column specifically a
special
is there way to interrogate what is inside a column specifically a special
character?
thanks,
Martin Gainty
_
Express yourself instantly with MSN Messenger! Download today - it's FREE!
- Original Message -
From: Martin Gainty [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, August 18, 2004 4:24 PM
Subject: contains?
is there way to interrogate what is inside a column specifically a special
character?
thanks,
Try the LIKE operator. For example:
select
There is not a function equivalent to Oracle's dump but you could throw
together a substring loop that prints out the ascii value of each character.
-Original Message-
From: Martin Gainty
To: [EMAIL PROTECTED]
Sent: 8/18/04 3:24 PM
Subject: contains?
is there way to interrogate what
Zhang Yu [EMAIL PROTECTED] wrote:
I am migrating an old Access database to MySQL. After
migration, we'll keep using Access forms as front end,
and MySQL as database.
I experienced a strange problem when creating table
with a column name id #, which is used by many
queries in Access. My
At 20:43 -0700 4/17/04, Zhang Yu wrote:
Deal all,
I am migrating an old Access database to MySQL. After
migration, we'll keep using Access forms as front end,
and MySQL as database.
I experienced a strange problem when creating table
with a column name id #, which is used by many
queries in
At 20:43 -0700 4/17/04, Zhang Yu wrote:
Deal all,
I am migrating an old Access database to MySQL. After
migration, we'll keep using Access forms as front end,
and MySQL as database.
I experienced a strange problem when creating table
with a column name id #, which is used by many
queries in
Deal all,
I am migrating an old Access database to MySQL. After
migration, we'll keep using Access forms as front end,
and MySQL as database.
I experienced a strange problem when creating table
with a column name id #, which is used by many
queries in Access. My command is like this:
create
Dale Hans [EMAIL PROTECTED] wrote:
I have a field in the table, call it 'stuff', and it contains a list
of values that are comma separated. i.e. 'Books,DVDs,Video
Tapes,CDs'
I want to SELECT out all records that have an item. I know IN works
the other way, so is there something
I have a field in the table, call it 'stuff', and it contains a list
of values that are comma separated. i.e. 'Books,DVDs,Video
Tapes,CDs'
I want to SELECT out all records that have an item. I know IN works
the other way, so is there something that will get what I want like
this:
SELECT
I've finally set up replication for one of the MySQL servers I
administer, and it seems to be working. I'm puzzled, however, by
what I see in the general query log.
I'm using replicate-wild-do-table to restrict the replication to only
two of the databases on the master server (since I
If you're looking for Web application server alternatives that work
extremely well with MySQL, Blue World recently announced the Lasso
Professional 6.0.1 Update which includes the latest 3.23.54 build of
MySQL.
If interested, check out the following support article:
Hello Everyone,
I've only just started trying to use MySQL so please forgive my
ignorance if this sounds like a really basic question!
I am trying to search a text field within a table that contains
several keywords; for example the column might be called
computer_description
Hello Everyone,
I've only just started trying to use MySQL so please forgive my
ignorance if this sounds like a really basic question!
I am trying to search a text field within a table that contains
several keywords; for example the column might be called
computer_description
[EMAIL PROTECTED] wrote:
I am trying to search a text field within a table that contains
several keywords; for example the column might be called
computer_description and contain the values i-mac blue 256MB
500MHz Is there any way of putting together a query that says
SELECT * FROM table1 WHERE computer_description LIKE '%blue%'
HTH
Greg
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 12, 2002 11:10 AM
To: [EMAIL PROTECTED]
Subject: is there a MySQL 'field contains' function
Hello Everyone
At 10:09 AM 4/12/2002, you wrote:
Hello Everyone,
I've only just started trying to use MySQL so please forgive my
ignorance if this sounds like a really basic question!
I am trying to search a text field within a table that contains
several keywords; for example the column
* Bill
Hello Everyone,
I've only just started trying to use MySQL so please forgive my
ignorance if this sounds like a really basic question!
I am trying to search a text field within a table that contains
several keywords; for example the column might be called
Our brand new, fresh install of 3.23.46 won't let us set the password for the root
user because one seems to already be set. Even after wiping the ...mysql/data/mysql
directory clean and rerunning mysql_install_db, we still get an Enter password:
prompt when attempting to set the root user
Our brand new, fresh install of 3.23.46 won't let us set the
password for the root user because one seems to already be set.
Even after wiping the ...mysql/data/mysql directory clean and
rerunning mysql_install_db, we still get an Enter password:
prompt when attempting to set the root user
At 8:19 AM -0700 12/10/01, Chris Bolt wrote:
Our brand new, fresh install of 3.23.46 won't let us set the
password for the root user because one seems to already be set.
Even after wiping the ...mysql/data/mysql directory clean and
rerunning mysql_install_db, we still get an Enter password:
I am a newbie.
When I create a table, when one column contains a space, how can I
create it
correctly in mysql?
for example:
CREATE TABLE mytable(
name CHAR(60) NOT NULL,
this column CHAR(60) ///Here there is a
space?
);
When I use ' or , it does
Hi!
There was some confusion in the making of the
4.0.0 binaries. The Intel rpm contains InnoDB-.43
which does not support foreign keys, while the
source distribution and the Intel .tar.gz binary
contains .43b which supports foreign keys. Sorry
for the confusion!
Some things are broken in all
[EMAIL PROTECTED] writes:
an apostrophe
Description: If I try to INSERT data containing an apostrophe into a
Field defined as mediumtext it works ok. However, if I try to insert the
same data into a Field defined as varchar, the INSERT fails. And, it not
only doesn't work...it does
34 matches
Mail list logo