same functionality as the mssql stored
procedures.
[I eagerly look forward to mySQL stored procedures - my server is going
way to fast :-) ]
This UML generation also creates a script to populate the database
server with the "stored procedures" using "create function" calls
Hi
I hope I am not being lazy here. I want to use the SQL date_add
function on a value from one of my column values but I can't seem to
figure out the syntax.
This works:
select "2002-10-08 09:35:10" + interval 7 hour;
but how do I change "2002-10-08 09:35:10" to
Daya,
Friday, September 28, 2001, 10:36:30 AM, you wrote:
DKD> Can anybody tell me is it possible in the my sql to set the function as
DKD> default value, for example can i set the now() function for the date column
DKD> field.
No, you can't:
http://www.mysql.com/doc/en/CRE
Hi,
Can anybody tell me is it possible in the my sql to set the function as
default value, for example can i set the now() function for the date column
field.
Thanks in advance.
Regards
Daya Krishan Dubey
Core Solucomm Ltd
423 B, Hamilton court
DLF phase IV
Gurgaon, India
Ph# 91-124-6392896/7
McIrvin,
Thursday, September 19, 2002, 2:41:35 AM, you wrote:
M> No,, I dumped the table and put it on a different server and tried it there.
Could you send a dump of the table to test it?
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by
No,, I dumped the table and put it on a different server and tried it there.
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "McIrvin" <[EMAIL PROTECTED]>
Sent: Wednesday, September 18, 2002 6:37 PM
Subject: Re: count function
Thanks but no change.
--=C
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "McIrvin" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, September 18, 2002 5:41 PM
Subject: Re: count function issue
> At 17:26 -0500 9/1
te entries, were trying to count the duplicates to determine the most
>popular search terms.
>
>The problem arises where you do a query like
>
>SELECT * FROM 'terms' WHERE term='test'
>
>And count the number of rows returned (with php or whatever) the issue is
popular search terms.
The problem arises where you do a query like
SELECT * FROM 'terms' WHERE term='test'
And count the number of rows returned (with php or whatever) the issue is
that the result from the count() function ends up being a little higher
sometimes but by no
At 16:50 -0500 9/18/02, McIrvin wrote:
>Doing queries to determine the number of times search terms are used on a
>web site.
>
>Here is a sample sql query.
>
>SELECT terms, count(*) AS count FROM searches GROUP BY terms HAVING
>count(*)>1 ORDER BY count DESC
>
>But the results seem to be inaccurat
Doing queries to determine the number of times search terms are used on a
web site.
Here is a sample sql query.
SELECT terms, count(*) AS count FROM searches GROUP BY terms HAVING
count(*)>1 ORDER BY count DESC
But the results seem to be inaccurate, by no more that 3.
Anyone run into anything
I was about to email bugs/lists back today to basically say I've found a
reasonable workaround.. I'll respond to your message though in case you see
something that needs attention ...
> strend() is a function we use a lot in the MySQL client code and is
> thus included in th
en Solaris 'csh'
Ben> uses said library, there's a clash between csh (and/or one of the libs it
Ben> uses) and MySQL's 'strend' function. 'strend' will not return proper values
Ben> under these circumstances, preventing me from even connecting to the s
Could you pls send me answer of my question
1.How to convert this "10-Sep-2003" in a -MM-DD sql format effeciently.Like it
should be 2003-09-10.
Thanks,
Abhi
-
Before posting, please check:
http://www.mysql.co
attempting to
implement the inline function get_hash_symbol().
specifically:
sql_lex.cc: In function `int find_keyword(LEX *, unsigned int,
bool)':
sql_lex.cc:168: implicit declaration of function `int
get_hash_symbol(...)'
sql_lex.cc:168: initial
Hi,
>From my experience with MySQL, i think you can create a function(UDF - you
can look in documentation at "9.2.2 Adding a New User-definable
Function".Also you can find samples in MySQL source distribution) to avoid
this conditional filtering and not to create/generate this SQL q
Hi,
suppose there is a database with lots of tables.
I want to add a function to this database to return the following SQL query:
SELECT SUM(IF(HOUR(start)>'02:00:00' AND
HOUR(stop)<='08:00:00',50*sessiontime,0)+IF(HOUR(start)>'08:00:00' AND
HOUR(stop)
Greetings!
MySql documents specifies user defined function made in
.dll/.so to be invoked in MySQL. Is there a way in which a function made in
java be invoked in MySQL.
Regards
-
Before posting
ugust 20, 2002 9:18 PM
Subject: Suggestion on New MySQL Function
> Through your MySQL documentation, I wasn't able to find a function that I
> think could be useful. If you DELETE a row with an INT AUTO_INCREMENT
field,
> it will still be able to add the next highest value to this
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August 20, 2002 1:18 PM
Subject: Suggestion on New MySQL Function
| Through your MySQL documentation, I wasn't able to find a function that I
| think could be useful. If you DELETE a row with an INT AUTO_INCREMENT
field,
| it will still be able to ad
Hello.
On Tue 2002-08-20 at 13:18:04 -0500, [EMAIL PROTECTED] wrote:
> Through your MySQL documentation, I wasn't able to find a function that I
> think could be useful. If you DELETE a row with an INT AUTO_INCREMENT field,
> it will still be able to add the next highest value to
Through your MySQL documentation, I wasn't able to find a function that I
think could be useful. If you DELETE a row with an INT AUTO_INCREMENT field,
it will still be able to add the next highest value to this column on an
INSERT (ex. If after INSERTing rows, you DELETE a row with a val
Ben,
> I am looking for a command to interpreter the timestamp field into a
> date time field much like the Convert function in MSSQL. Does anyone
> know of a built in function for this or will I be off on the road to
> building my own function?
Beginning with v4.0.2, CAST | CONVE
I am looking for a command to interpreter the timestamp field into a
date time field much like the Convert function in MSSQL. Does anyone
know of a built in function for this or will I be off on the road to
building my own function?
Thanks!
Best Regards,
Ben Turner
From: Andrea Forghieri [mailto:[EMAIL PROTECTED]]
Sent: 30. juli 2002 11:51
To: [EMAIL PROTECTED]
Subject: Bug in FLOOR() function
Dear Sirs,
please try this with Mysql 4.0.2
SELECT 25*9.54;
-> 238.5 (so far so good)
then
SELECT (25*9.54)+0.5;
-> 239.000 (still OK )
SEL
Dear Sirs,
please try this with Mysql 4.0.2
SELECT 25*9.54;
-> 238.5 (so far so good)
then
SELECT (25*9.54)+0.5;
-> 239.000 (still OK )
SELECT FLOOR((25*9.54)+0.5);
-> 238 (ouch !!)
Best Regards
Andrea Forghieri
Emmegi S.p.A.
#
Usefu
hello there,
Is there a way to select an increment function so it returns an index
which is increemented by one for each row and that could be used to do
some calculations with other fields?
Example:
select incr() as INDE, date_add(date_col, interval (INDE-1)*7 day)
from suchtable
where
this message is about a user defined function i wrote, which
is not working well. i don't know if this is the right list,
if not, i apologize, could someone point me to the correct one?
i have written a user defined function which translates an HTML
entity representation of a letter w
SA> ...etc or it is not possible and every one logged in to MySQL could
SA> >SA> simply use them like any other native function?
SA> >SA> Regards
SA> >
SA> >Take a look at:
SA> > http://www.mysql.com/doc/C/R/CREATE_FUNCTION.html
SA> >
SA> >
ssible and every one logged in to MySQL could
>SA> simply use them like any other native function?
>SA> Regards
>
>Take a look at:
> http://www.mysql.com/doc/C/R/CREATE_FUNCTION.html
>
>You must have INSERT and DELETE privileges on the database 'mysql&
se them like any other native function?
SA> Regards
Take a look at:
http://www.mysql.com/doc/C/R/CREATE_FUNCTION.html
You must have INSERT and DELETE privileges on the database 'mysql' to
create and drop functions.
--
For technical support contracts, goto https://order.m
; Sameh Attia wrote:
>>
>>> Hi,
>>>Can anybody help me figuring how to control granting users
>>> permissions to created functions in MySQL like we do for SELECT,
>>> INSERT, ...etc or it is not possible and every one logged in to
>>> MySQL
or it is not possible and every one logged in to MySQL
>> could simply use them like any other native function?
>> Regards
>>
>
Thanx Veysel for your concern; but unfortunately this did not help me.
Creating functions is independent of tables or databases privileges. Is
t
ould simply use them like any other native function?
> Regards
>
--
Your favorite stores, helpful shopping tools and great gift ideas.
Experience the convenience of buying online with Shop@Netscape!
http://shopnow.netscape.com/
---
Hi,
Can anybody help me figuring how to control granting users
permissions to created functions in MySQL like we do for SELECT, INSERT,
...etc or it is not possible and every one logged in to MySQL could
simply use them like any other native function?
Regards
--
Sameh Attia
Senior System
Hey all,
I'm having problems ! , my app was running fine until this morning.
I receive following error :
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Function sequence error
/clientenrollment.asp, line 67
the line 67 for that
PROTECTED]
Subject: function call
hi guyz
how do i call a phpfile into another phpfile
like i wanna call cat_disply.php from within article.php
so dat it displays all the categories WHERE im giving it a call
now i did this in c/c++
i CALLED files as i call functions
but is this possible
hi guyz
how do i call a phpfile into another phpfile
like i wanna call cat_disply.php from within article.php
so dat it displays all the categories WHERE im giving it a call
now i did this in c/c++
i CALLED files as i call functions
but is this possible in php ?
thnx a million
tob
of course, the safe way is to always reset the password when such a
thing happens.
-Original Message-
From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 14, 2002 10:48 AM
To: [EMAIL PROTECTED]
Subject: Re: Encrypting with PASSWORD() function
Walter,
Tuesday, May
Walter,
Tuesday, May 14, 2002, 4:59:15 PM, you wrote:
WDF> I am trying Mysql Password() function, to encrypt password in a a
WDF> user/password
WDF> table,
WDF> it works fine both ways; it is to say, when I submit a login
WDF> (user/password)
WDF> combination it fetches the
* Walter D. Funk
> I am trying Mysql Password() function, to encrypt password in a a
> user/password table,
> it works fine both ways; it is to say, when I submit a login
> (user/password) combination it fetches the pair ok.
> My question is, as I read in the documentation, that
At 10:59 -0300 5/14/02, Walter D. Funk wrote:
>Hi,
>
> I am trying Mysql Password() function, to encrypt password in a a
>user/password
>table,
> it works fine both ways; it is to say, when I submit a login
>(user/password)
>combination it fetches the pair ok.
> M
Hi Walter,
Walter D. Funk wrote:
>Hi,
>
> I am trying Mysql Password() function, to encrypt password in a a
>user/password
>table,
> it works fine both ways; it is to say, when I submit a login
>(user/password)
>combination it fetches the pair ok.
> My qu
Hi Walter
> My question is, as I read in the documentation, that the process is
> irreversible, how can I deal with the fact
> that a user can forget his password, if I will not be able to retrieve the
> original string, because what i can see is the encrypted data
The purpose of the encryp
Hi,
I am trying Mysql Password() function, to encrypt password in a a
user/password
table,
it works fine both ways; it is to say, when I submit a login
(user/password)
combination it fetches the pair ok.
My question is, as I read in the documentation, that the process is
irreversible, how
29.685196 |
> +---+
> 1 row in set (0.02 sec)
>
XXXXX
>
> > -Original Message-
> > From: Andrew Gould [mailto:[EMAIL PROTECTED]]
> > Sent: Saturday, May 11, 2002 7:51 AM
> > To: [EMAIL
Use the PASSWORD() MySQL builtin function as follows:
INSERT INTO Table
VALUES ('0', 'username', PASSWORD('password'), 'email')
This function is not part of the SQL standard. It is
used for storing passwords in the MySQL user table in
the mysql databa
You need to use PASSWORD() function..
INSERT INTO table VALUES('0', 'username', PASSWORD('passwd'), 'email');
See: http://mysql.com/doc/M/i/Miscellaneous_functions.html
Gurhan
-Original Message-
From: Jule [mailto:[EMAIL PROTECTED]]
Sent:
Hey guys and gals,
How do i add info to a table, and give a varchar(16) row the function of
password, so that it is encrypted? my query now is:
INSERT into table values('0', 'username', 'password', 'email')
thanks
Jule
--
|\/\_
At 23:41 +0200 5/12/02, Sabine Richter wrote:
>Hello Philip,
>
>that was my first choice, too.
>But no, error : Invalid use of group function
>
>and select col1, max(col2) from table;
>is error 1140: mixing of group cols with non groupü cols is illegal
>(That would ot
n Sun, 12 May 2002 23:41:05 +0200
Sabine Richter <[EMAIL PROTECTED]> wrote:
> Hello Philip,
>
> that was my first choice, too.
> But no, error : Invalid use of group function
>
> and select col1, max(col2) from table;
> is error 1140: mixing of group cols with no
Hello Philip,
that was my first choice, too.
But no, error : Invalid use of group function
and select col1, max(col2) from table;
is error 1140: mixing of group cols with non groupü cols is illegal
(That would other sql backends say too)
and other variants of the above like "select
I could be missing something, but what about:
select col1 from t1 where col2 = max(col2);
On Sun, 12 May 2002 23:04:14 +0200
Sabine Richter <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I just want to get the value of one column in the row where max of
> another col of this table is.
> With the poss
Hello,
I just want to get the value of one column in the row where max of
another col of this table is.
With the possibility of sub queries I would write:
select col1
from table t1
where col2 = (select max(col2)
from tab1e t2);
But how to do it without a sub query?
Just with 1 st
[mailto:[EMAIL PROTECTED]]
> Sent: Saturday, May 11, 2002 7:51 AM
> To: [EMAIL PROTECTED]
> Subject: geometric mean aggregate function
>
> Has anyone out there developed a costum, aggregate
> function for calculating the geometric mean of
> populations? If not, would anyone be intere
7;re calculated!
Matthew Walker
Senior Software Engineer
ePliant Marketing
-Original Message-
From: Andrew Gould [mailto:[EMAIL PROTECTED]]
Sent: Saturday, May 11, 2002 6:51 AM
To: [EMAIL PROTECTED]
Subject: geometric mean aggregate function
Has anyone out there developed a costum, aggregate
Has anyone out there developed a costum, aggregate
function for calculating the geometric mean of
populations? If not, would anyone be interested in
creating one?
My development experience/skills is limited to SQL and
simple Python scripts; so I had difficulty
understanding the documentation on
Are you using MySQL 4.x sumthing?
I thought that function was taken out and replaced with
mysql_real_connect()?
I may be wrong.
-Original Message-
From: Julie Meloni [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 24, 2002 10:35 AM
To: Tewfic Kidess
Cc: [EMAIL PROTECTED]
Subject: Re
Hello
I installed MySQL version 4.0.1 apha-nt on win2k.
I would like to know how to disable function described below:
"Word MySQL is present in more than half of rows, and as such, is
effectively treated as a stopword (that is, with seman
On Thursday, 25. April 2002 08:17, Andrew Rich wrote:
> 5. I have determined I was running a copy of PHP that did not have MYSQL
> support compiled in.
Yes, looks like this is an an very old version, without mysql-support.
> 6. Could someone suggest where i could get a PHP copy that supports MYS
> 1. I found I had a RPM Install of PHP and a compiled version. (Off my book
> cdrom)
:-(( happened to me 2
> 4. I want to start from scratch but don't want to have to re-format
nah. you've rpm -e'd the rpm. I had to build from scratch to compile mysql +
php in as I couldn't find an off-the-she
$db = mysql_connect(
Fatal Error: Call to undefined function: mysql_connect()
1. I found I had a RPM Install of PHP and a compiled version. (Off my book
cdrom)
2. How can you get rid of file that you have gunziped ? in reverse, ie
'remove the following files' instead of 'instal
Tewfic,
Wednesday, April 24, 2002, 6:14:58 PM, you wrote:
TK> Hello, i'm trying to use PHP4 and MySQL and i'm getting undefined function:
TK> mysql_connect()
TK> both PHP and MySQL are working on their own, but i have something missing
TK> form the PHP setup where it d
TK> Hello, i'm trying to use PHP4 and MySQL and i'm getting undefined function:
TK> mysql_connect()
This question belongs on a/the PHP mailing list, but the answer is that
you need to compiled PHP --with-mysql. Please read the PHP
installation instructions in the very hand
Hello, i'm trying to use PHP4 and MySQL and i'm getting undefined function:
mysql_connect()
both PHP and MySQL are working on their own, but i have something missing
form the PHP setup where it doesn't recognise MySQL.
I'd really
bob,
Wednesday, April 24, 2002, 4:28:12 PM, you wrote:
bn> can any one tell me if there is any function to get
bn> the average of some values in the mysql database.
Sure, take a look at AVG() function:
http://www.mysql.com/doc/G/r/Group_by_functions.html
bn> tnx
bn> plz ma
* bob nt
> can any one tell me if there is any function to get
> the average of some values in the mysql database.
Yes, the AVG() function:
http://www.mysql.com/doc/G/r/Group_by_functions.html >
--
Roger
-
Befor
hi,
can any one tell me if there is any function to get
the average of some values in the mysql database.
tnx
plz mail to [EMAIL PROTECTED]
bobbie
__
Do You Yahoo!?
Yahoo! Games - play chess, backgammon, pool and more
http://games.yahoo.com
Hello all ,
I am now trying to add a special function into MySQL as
a command.
Anyone who good at it , please give me
some precious suggestions , including the related document
or some webs which explains it .
thank u very much .
--
Best regards
This should work :
$SQL = "INSERT INTO orders (Customer_Id, Order_Date)".
"VALUES($CustID,Now())";
Xavier
-Message d'origine-
De : Alia Mikati [mailto:[EMAIL PROTECTED]]
Envoyé : vendredi 19 avril 2002 11:28
À : [EMAIL PROTECTED]
Objet
I never saw the function "date()", to insert current date use:
CURRENT_DATE();
regards,
Jan
- Original Message -
From: "Alia Mikati" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, April 19, 2002 11:27 AM
Subject: Date function
> Hel
Hello
I have the following SQL and I wanna insert the current date in one of
the table fields but it's not working. Can u tell me whats the problem?
(I'm using mysql and php)
Thx a lot
$SQL = "INSERT INTO orders (Customer_Id, Order_Date)".
"VALUES($CustID,date())";
-
]>;
<[EMAIL PROTECTED]>
Sent: Thursday, April 18, 2002 2:16 PM
Subject: Re: AW: User Define Function
No I have not :(((
And believe me I have tried several posibilities...
I have on one mysql server such a setup and
this works good.
So I have made a hardcopy on that server
and I
om: Elteto Zoltan <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Thursday, April 18, 2002 2:16 PM
Subject: Re: AW: User Define Function
No I have not :(((
And believe me I have tried several posibilities...
I have on one mysql se
ECTED]]
Gesendet: Donnerstag, 18. April 2002 13:17
An: Christian Rabe; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Betreff: Re: AW: User Define Function
No I have not :(((
And believe me I have tried several posibilities...
I have on one mysql server such a setup and
this works good.
So I have m
FUNCTION lookup RETURNS STRING SONAME "udf_example.so";
CREATE FUNCTION reverse_lookup RETURNS STRING SONAME "udf_example.so";
which said that everything is OK!!!
restart mysql
WITHOUT
--skip-grant-tables
so that the UDF initialisation to be OK ,too.
when
I try
select reverse_lo
I'm having the same problem (Invalid Argument) at the moment.
Did you find any solution ?
Thanx
-Ursprüngliche Nachricht-
Von: Elteto Zoltan [mailto:[EMAIL PROTECTED]]
Gesendet: Dienstag, 16. April 2002 11:32
An: [EMAIL PROTECTED]
Betreff: User Define Function
Hi all,
I ne
>
> SELECT id, MUL(val) FROM above_table GROUP BY id;
>
> I would get:
> ++---+
> | id| MUL(val)|
> ++---+
> | 1|200|
> | 2|250|
> ++---+
>
> **
> I know there is now function
)|
++---+
| 1|200|
| 2|250|
++---+
**
I know there is now function MUL(), but is there anything comparable ?
Thanx
(mysql,query)
-
Before posting, please check:
http
info set .
Try
$result=mysql_query("update info set .
or
$result=mysql_query("update info set .",$link);
Check the PHP Manual.
On Tue, 2002-04-16 at 05:40, bob nt wrote:
> i get an error like
>
> Fatal error: Call to a member function on a non-object
&
is the default folder for it, as I understand)
3) restart mysql
4) use mysql db
5) CREATE FUNCTION lookup RETURNS STRING SONAME "udf.so";
6) ERROR and this is bad for me:(
ERROR 1126: Can't open shared library 'udf.so' (errno: 22 udf.so: cannot
open shared obje
i get an error like
Fatal error: Call to a member function on a non-object
in the line
$result=$dbconn->Execute("update infotab set
infomessage='$file_name' WHERE info_id='$ypid'");
here $ file_name returns a file name like mirror.txt
or x.gif. & i
-Original Message-
From: Keith C. Ivey [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 12, 2002 11:40 AM
To: [EMAIL PROTECTED]
Subject: RE: Is there a function to sort the result (after using ORDER
BY)?
On 12 Apr 2002, at 17:54, SED wrote:
> However, I want to get the result
> and the
On 12 Apr 2002, at 17:54, SED wrote:
> However, I want to get the result
> and then sort the result by importance e.g.:
>
> result (date, name, impoartance):
>
> 20020102, John, 3;
> 20020101, Smith, 5;
> 20010101, Sigmund, 1;
> 2101, Sigmund, 8;
>
> now I want to sort the result by import
g it?
SED
-Original Message-
From: Andrew Hazen [mailto:[EMAIL PROTECTED]]
Sent: 12. apríl 2002 17:44
To: 'SED'
Subject: RE: Is there a function to sort the result (after using ORDER
BY)?
Just add the field to the Order by clause. It will be sorted first by
date, and then by im
Hi,
Not yet found anything to cover this on the online-docs so I'm aiming at
you :)
I need to sort the result afterwards e.g.:
SELECT name, date, importance FROM 'mytable' WHERE date>'myTime' ORDER
BY date DESC, name LIMIT 0,20;
...then I need to sort *only* the result by the 'importance', can
* 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
> "computer_d
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 colu
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&#x
[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
>
> 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_descr
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"
On 8 Apr 2002, at 18:18, Ari B Kahn wrote:
> OK. Now notice that insFreq has DOUBLED when used in conjunction with
> with delFreq!
> mysql> select t1.andersonStart_pos, sum(t2.insFreq), sum(t1.delFreq)
> from InsertionFreq t2, DeletionFreq t1 where (t2.andersonStart_pos =
> 1072) and (t1.ande
I have MySQL v. 3.23
The SUM function seems to be doubling one of my values when used in
conjunction with another SUM function.
Here I show that I have only 95 in insFreq:
mysql> select t2.andersonStart_pos, sum(t2.insFreq) from InsertionFreq
t2 where t2.andersonStart_pos = 1072 group by
Hello.
On Mon, Apr 08, 2002 at 11:24:56AM -0400, [EMAIL PROTECTED] wrote:
[...]
> still...I wonder why I got a 'Query OK, 1 row affected' message
[...]
> > insert into table (key, field) values (1, 'test'||CHAR(59)||' string');
> >
> > it seems to work initially...(Query OK, 1 row affected (
PROTECTED] wrote:
> Hi guys,
>
> Our java code blows up when we try to insert a string with a ';'
> inside of it. So we tried to do a work-around by replacing ';' with
> '||CHAR(59)||' to insert it, using the char function and the
> character's res
nevermind...instead of using '||' to concat the fields i needed to use the CONCAT()
function. So the syntax should have been:
insert into table (key, field) values (1, CONCAT('test',CHAR(59), ' string'));
still...I wonder why I got a 'Query OK
Hi guys,
Our java code blows up when we try to insert a string with a ';' inside of it. So we
tried to do a work-around by replacing ';' with '||CHAR(59)||' to insert it, using the
char function and the character's respecitve ascii value. So instead of:
in
At 21:36 -0700 4/7/02, Son Nguyen wrote:
>--- BD <[EMAIL PROTECTED]> wrote:
>> Son,
>>
>> At 09:48 PM 4/7/2002, you wrote:
>> >mysql> desc threads;
>>
>>+-+--+--+-+-++
>> >| Field | Type | Null | Key | Default | Extra
It's the race condition, I am talking about.
There won't be a race condition.
>
> > and retrieve the returned value
> >
> > or
> >
>
> > $last_thread_id = mysql_insert_id();
> > This function will not work properly if the auto-incrementing c
601 - 700 of 951 matches
Mail list logo
