amp,
'00' ), or, as far as I can tell, you will probably be better off just
using string functions.
Wes
On Jul 14, 2004, at 10:25 AM, J S wrote:
Hi,
What SQL function do I need to convert timestamp 200406011403 into
&q
While in PHP you can try something like this...
$date_added = $row['date_added'];
$date = date("M d, Y", strtotime($date_added));
echo $date;
H and i do work in PHP as well, I believe, if you want to add the hour and
seconds. Check out the 'date&
In MySQL you can do that with: DATE_FORMAT
DATE_FORMAT (column_name,'%Y-%m-%d %H:%i')
-Mensaje original-
De: J S [mailto:[EMAIL PROTECTED]
Enviado el: Miércoles, 14 de Julio de 2004 08:26 a.m.
Para: [EMAIL PROTECTED]
Asunto: sql function for timestamp
Hi,
What SQL function
Hi,
What SQL function do I need to convert timestamp 200406011403 into
"2004-06-01 14:03" ?
Thanks,
JS.
_
Stay in touch with absent friends - get MSN Messenger
http://www.msn.co.uk/messenger
--
MySQL General Mailing Lis
Hello , I hope you could help me. I have a small difference in te result of this query
QUERY
SELECT `an0300_polizas_desgloce`.cuenta,
`an0200_polizas`.fecha,
sum(`an0300_polizas_desgloce`.debito),
sum(`an0300_polizas_desgloce`.credito),
(sum(`an0300_polizas_desgloce`.debito)-sum(`an0300_pol
D_COND_TIMEDWAIT -DHAVE_POSIX1003_4a_MUTEX -c `test
-f 'my_thr_init.c' || echo './'`my_thr_init.c
my_thr_init.c: In function `my_thread_global_init':
my_thr_init.c:60: `pthread_destructor_t' undeclared (first use in this
function)
my_thr_init.c:60: (Each undeclared identifi
Ron McKeever wrote:
I am storing ips in a mysql 4.0.17 db as int. I am Converting them using
a perl script with inet_aton to create a four-byte string.
My goal:
Is to return the ip as a normal dotted ip for the user to see after a select
statement is done
via a php web page. The ip is entered in as
I am storing ips in a mysql 4.0.17 db as int. I am Converting them using
a perl script with inet_aton to create a four-byte string.
My goal:
Is to return the ip as a normal dotted ip for the user to see after a select
statement is done
via a php web page. The ip is entered in as a dotted ip on the
Everyone can thank Harold Fuchs for contributing this one:
exp(sum(log(coalesce(*the field you want to multiply*,1)))
The coalesce() function is there to guard against trying to calculate the
logarithm of a null value and may be optional depending on your
circumstances.
Shawn Green
Database
No there is not. Two options could be to either create an UDF or use a
programming language.
-Original Message-
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: 5/25/04 1:25 PM
Subject: is there a PRODUCT() or MULTIPLY() aggregate function?
Is there an aggregate function that
Is there an aggregate function that multiplies column values just like SUM()
adds them?
For instance, if "SELECT value FROM data" returns three values 2, 3, and 4,
then "SELECT PRODUCT(value) FROM data" would return 24, which is 2 * 3 * 4.
Thanks!
---
Fyodor Golos
Stockworm, Inc.
=GR.DB_ESTABLISHMENT_ID
GROUP BY
ES.DB_ESTABLISHMENT_ID
HAVING
AVG(DB_GRADE) > 2
ORDER BY
AVG(GRADE)
**
Now I am having a problem with the order by clause. How can I have the AVG
function in the ORDER BY clause or how can I sort by average grade?
As others h
Pretty simple, declare an alias in your query and use it in the ORDER BY, i.e.:
SELECT DB_ESTABLISHMENT_NAME, AVG(DB_GRADE) AS AVGGRADEFROM ESTABLISHMENTS ES LEFT OUTER JOIN GRADES GR ONES.DB_ESTABLISHMENT_ID=GR.DB_ESTABLISHMENT_IDGROUP BY ES.DB_ESTABLISHMENT_IDHAVING AVG(DB_GRADE) > 2ORDER B
ISHMENTS ES LEFT OUTER JOIN GRADES GR ON
> ES.DB_ESTABLISHMENT_ID=GR.DB_ESTABLISHMENT_ID
>
> GROUP BY
> ES.DB_ESTABLISHMENT_ID
>
> HAVING
> AVG(DB_GRADE) > 2
>
> ORDER BY
> AVG(GRADE)
> **
>
> Now I am having a problem wit
***
>
> Now I am having a problem with the order by clause. How can I have
> the AVG function in the ORDER BY clause or how can I sort by average
> grade?
I THINK you need to alias your column to do this:
SELECT
DB_ESTABLISHMENT_NAME,
AVG(DB_GRADE) AS AVG_GRADE
Thank you all for your replies. Everything works now!!
Julien.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
What kind of problem are you having? You can use the ordinal postion.
ORDER BY 2 [ASC|DESC]. 2 represents the second column.
-Original Message-
From: Julien Martin
To: '[EMAIL PROTECTED]'
Sent: 5/5/04 12:41 PM
Subject: AVG function in order by clause
Hello,
Thanks a lot for t
ES.DB_ESTABLISHMENT_ID
HAVING
AVG(DB_GRADE) > 2
ORDER BY
AVG(GRADE)
**
Now I am having a problem with the order by clause. How can I have the AVG
function in the ORDER BY clause or how can I sort by average grade?
Thanks in advance,
Julien Mar
Chip Wiegand wrote:
John,
Yep, looking at phpinfo.php shows no support for mysql. This is very
strange. I know these things don't just happen by themselves. I also know
there are only two people with the password to the server, myself and my
boss (and he knows nothing about the server to begin
I
hope not.
--
Chip
> On Monday 03 May 2004 09:20 am, Chip Wiegand said something like:
> > I have a web server that uses mysql-4.1.0/apache-2.4.6/php-4.3.4 on
> > freebsd-5.1.
> > It has been working fine for the past few years, now all of a sudden
today
> > I get an
on
> freebsd-5.1.
> It has been working fine for the past few years, now all of a sudden today
> I get an undefined function error. This is from httpd-error.log -
>
> PHP Fatal error: Call to undefined function: mysql_connect() in
> /...
>
> This is the connection function I am
the past few years, now all of a sudden
today
> > I get an undefined function error. This is from httpd-error.log -
> >
> > PHP Fatal error: Call to undefined function: mysql_connect() in
> > /...
>
> I know you say that "nothing changed" but something
I have a web server that uses mysql-4.1.0/apache-2.4.6/php-4.3.4 on
freebsd-5.1.
It has been working fine for the past few years, now all of a sudden today
I get an undefined function error. This is from httpd-error.log -
PHP Fatal error: Call to undefined function: mysql_connect() in
This will do it...
SELECT id, group_concat(distinct buddy_id)
FROM buddies
GROUP BY id
Ed
-Original Message-
Hi,
When using aggregate functions, I know you can retrieve the MAX, MIN,
SUM, etc from all the values in your specific group from the GROUP BY.
Is there any function to
At 14:44 +0100 4/20/04, Andy Hall wrote:
Hi,
When using aggregate functions, I know you can retrieve the MAX,
MIN, SUM, etc from all the values in your specific group from the
GROUP BY.
Is there any function to simply return a list of the values in the group?
GROUP_CONCAT()?
Supported in
Never mind, I found the GROUP_CONCAT function but I am still using v. 3.23.37 so thats
that.
Looks like I'll be using PHP, unless anyone has a workaround of some kind?
Thanks
Hi,
When using aggregate functions, I know you can retrieve the MAX, MIN, SUM, etc from
all the values in your specific group from the GROUP BY.
Is there any function to simply return a list of the values in the group?
e.g.
SELECT id, LIST(buddy_id)
FROM buddies
GROUP BY id
which would
>
> From: "Gordon" <[EMAIL PROTECTED]>
> Date: 2004/04/13 Tue PM 06:45:17 GMT
> To: <[EMAIL PROTECTED]>
> Subject: MySQL function
>
>
> Has anyone out there written a Credit Card Validation routine as a
> user-definable function (UDF)?
>
>
Has anyone out there written a Credit Card Validation routine as a
user-definable function (UDF)?
We now have a requirement to collect credit card data through our Web
Site.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
"Qiang.zhou" <[EMAIL PROTECTED]> wrote:
> Dear All;
>
> At oracle8i i can write this sql:
> select decode(a.id,null,'NULL',2,"God',3,'Norma','Animal') from user
>
> Then i want know ,how to write this at mysql4.1
Use IF() or CASE to rewrite your query:
http://www.mysql.com/doc/en/Co
Dear All;
At oracle8i i can write this sql:
select decode(a.id,null,'NULL',2,"God',3,'Norma','Animal') from user
Then i want know ,how to write this at mysql4.1
Thanks
Hi,
(B
(BI have a table with the sales of each product by month (in the format
(Bmm).
(BFor example: (table name: ventas)
(B
(Bsale_date prod_idsales
(B200301 A20
(B200302 A16
(B200303 A18
(B200301 B12
(
> Problem tested using both version 4.0.18 and 4.1.1
>
> This query gets first byte of utf8 character, not two bytes
>
> If I use
>
> SELECT LEFT(FieldName, 2) AS FirstLetter, COUNT(*) FROM TableName GROUP BY
> FirstLetter
>
>
> gets right utf8 characters but others wrong
>
> for example;
>
AIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, March 13, 2004 5:34 AM
Subject: re: utf8 - left function
> > Hi,
> >
> > I need this query;
> >
> > SELECT LEFT(FieldName, 1) AS FirstLetter, COUNT(*) FROM TableName
> > GROUP BY FirstLetter
>
> Hi,
>
> I need this query;
>
> SELECT LEFT(FieldName, 1) AS FirstLetter, COUNT(*) FROM TableName
> GROUP BY FirstLetter
>
> my datas in utf8 format. I can't get first characters of the datas in
> utf8 format but others is ok.
>
> Any suggestion?
>
> Thank you
It works for me. I'm using the
Hi,
I need this query;
SELECT LEFT(FieldName, 1) AS FirstLetter, COUNT(*) FROM TableName GROUP BY FirstLetter
my datas in utf8 format. I can't get first characters of the datas in utf8 format but
others is ok.
Any suggestion?
Thank you
Michael Stassen said:
>
> Gabriel Alessandria wrote:
>
>> I am a user of Microsoft Sql Server and use very much the function
>> Datediff (interval, fecha1, fecha2) to extract differences between two
>> dates, in years, days, months, hours, etc
>>
>> I am a
Gabriel Alessandria wrote:
I am a user of Microsoft Sql Server and use very much the function Datediff
(interval, fecha1, fecha2) to extract differences between two dates, in
years, days, months, hours, etc
I am a beginner with MySql and i can't see the way to do this function ..
How
I am a user of Microsoft Sql Server and use very much the function Datediff
(interval, fecha1, fecha2) to extract differences between two dates, in
years, days, months, hours, etc
I am a beginner with MySql and i can't see the way to do this function ..
How can I extract for example differen
rning multiple rows in only one col to an aggregate function.
Thanks and bye,
Bernhard
- Original Message -
From: "Victoria Reznichenko" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 19, 2004 2:34 PM
Subject: Re: Subselect in aggregate function in My
work.
> Is it wrong by my design or is it MySQL design not to pass a subselect
> to an aggregate function?
>
If I've got you right you need:
SELECT AVG(anz) FROM (SELECT COUNT(time) anz FROM table GROUP BY time) as
table1;
--
For technical support contracts, goto https:
function?
Best wishes,
Bernhard
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
To make it simple, is it possible to make function having many undecided parameters
with MySQL 5.0 stored procedure/function?
For example,
add(3)
add(3,5)
add(3,5,1,4,9)
add(3,5,1,4,9,8,6,7,2)
In C, we use pointer to handle this,
but I don't know how to code this at stored function C
Dear all
How can I make a user defined function (written in C/C++) what returns a
row or rowset / result set (like "show open tables")
for example select udf(1,'par2') what returns
C1 | C2 | C3
+--+-
1 | 2 | A
2 | 3 | B
3 | 4 | C
Thanks Gergő
x(t2.weird, '-', -1)
)
where
t1.key =
and
t1.id = t2.id;
-- Nathan Christiansen
> -Original Message-
> From: Nathan Christiansen
> Sent: Thursday, January 29, 2004 3:49 PM
> To: [EMAIL PROTECTED]
> Subject: MySQL outer join with substring_
I am having a terrible time trying to understand the outer join syntax
for MySQL (Our sever version is: 3.23.56).
I have three tables I want to join two of which by inner joins and the
other by an outer join.
Here are my example tables:
table1:
+--+--+
| id | key |
+--+--+
| 4
#'
and year(theDate) = '#session.year#'
Can the day() function be used in this way in the WHERE statement?
Yes, but only from version 4.1.1
Use DayOfMonth() or preferably Extract() (which is the method from the SQL
standard) per the manual.
Is there a better way to achieve this?
Loos
On Wed, 21 Jan 2004, Yves Arsenault wrote:
> Thanks for your response,
>
> I'm using ColdFusion along side of MySQL to server dynamic content to some
> websites.
>
> When I run the page that this code is in, I get an SQL syntax error:
> Syntax error or access violation: You have an error in your S
Yves Arsenault wrote:
SELECT *
FROM events
WHERE day(theDate) = '#dayVal#' and month(theDate) = '#session.month#'
and year(theDate) = '#session.year#'
Can the day() function be used in this way in the WHERE statement?
Yes, but only from version 4.1.1
Use DayO
7; and month(theDate) = '9' and year(theDate) = '2003''
The right values are displayed from ColdFusion server, but I keep getting
the syntax error.
Yves
At 10:35 2004-01-21, you wrote:
function can b used, but value parameter seems syntactically wrong, check
that.
'#s
function can b used, but value parameter seems syntactically wrong, check
that.
'#session.month#' to '$month'
which is the language,u r using anyway?
- Original Message -
From: "Yves Arsenault" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
th(theDate) = '#session.month#' and
year(theDate) = '#session.year#'
Can the day() function be used in this way in the WHERE statement?
Is there a better way to achieve this?
Thanks,
Yves
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
anks for report! It's a known bug:
http://bugs.mysql.com/bug.php?id=2182
>
> Thanks
> Emery
> - Original Message -
> From: "Victoria Reznichenko" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Monday, January 12, 2004 12:36
> Sub
CTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, January 12, 2004 12:36
Subject: Re: Problem with LPAD() function
> "Director General: NEFACOMP" <[EMAIL PROTECTED]> wrote:
>
> > I think there is a bug in LPAD() function.
> >
> > Just try to run this quer
Server Host '"Ì' (11001)
It seems that MySQL Server Host identified by C API function
as '"Ì'. I have given my MySQL server host nams as 'MySERVER'.
Is this error message means what i write above? or anything else?
If so, How could I resol
from mysql_init function of MySQL in libmysql.lib library file.
i.e., MYSQL* mysql_init(MYSQL *mysql), here actually this function require
a parameter
of MYSQL type NULL pointer and return back the MYSQL handle.
>From COBOL, If I pass a NULL pointer to this function, it wouldn'
"Director General: NEFACOMP" <[EMAIL PROTECTED]> wrote:
> I think there is a bug in LPAD() function.
>
> Just try to run this query:
> SELECT LPAD(12, 3, '0');
> This will correctly return 012 as expected.
>
> But when I run
>
I think there is a bug in LPAD() function.
Just try to run this query:
SELECT LPAD(12, 3, '0');
This will correctly return 012 as expected.
But when I run
SELECT LPAD(512, 3, '0');
It doesn't return 512, instead it returns special characters.
On Jan 4, 2004, at 7:09 PM, Arun Natarajan wrote:
Is there an equivalent to the nvl() function of Oracle available in
MySql. I
am currently using version 4.1 alpha and am trying to execute the
following
query:
Select count(nvl(col1,1)) as col1 from table1 group by col1;
In MySQL, the function
What does nvl do? Here is a list of the functions from the MySQL manual:
http://www.mysql.com/doc/en/Function_Index.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello All,
Is there an equivalent to the nvl() function of Oracle available in MySql. I
am currently using version 4.1 alpha and am trying to execute the following
query:
>>Select count(nvl(col1,1)) as col1 from table1 group by col1;
Also, I tried to create a user defined function as belo
shiva shankar wrote:
Hi,
I USE THIS FUNCTION TO INSERT VALUES TO DIFFERENT
VALUES OF MY DATABASE..
void InsertValues(const string &tableName, const
string &values)
{
char ValuesToStore[255];
long datasize;
char *EncodedData;
char *query;
strcpy(ValuesToStore, valu
Hi,
I USE THIS FUNCTION TO INSERT VALUES TO DIFFERENT
VALUES OF MY DATABASE..
void InsertValues(const string &tableName, const
string &values)
{
char ValuesToStore[255];
long datasize;
char *EncodedData;
char *query;
strcpy(ValuesToStore, values.c_str());
EncodedData =
UPDATE table SET d='complete' WHERE a=0 AND b=0 and c=0;
-Original Message-
From: Larry Brown [mailto:[EMAIL PROTECTED]
Sent: Monday, December 08, 2003 3:58 PM
To: MySQL List
Subject: if function?
Is there a way to write an if statement in mysql to affect the following?...
if
Is there a way to write an if statement in mysql to affect the following?...
if field a=0,b=0,c=0 then update d='complete'
where the table consists of...
a int(1),
b int(1),
c int(1),
d char(8)
|a |b |c |d |
|1 |0 |0 |null |
|1 |1 |0 |nul
Hi
I am using MySQL for certain queries and i need to find out RANK of the
columns also. ORACLE provided a function RANK() by which it can be
retrieved.
Is there any similar function in MySQL by which same thing can be done.
Thanks
Prakash Kamani
--
MySQL General Mailing List
For list
The IF function works pretty much like Oracle's decode. But I recommend
using CASE..WHEN for compatibility between the two.
Check out:
http://www.mysql.com/doc/en/Control_flow_functions.html
> -Original Message-
> From: Jonathan Rosenberg [mailto:[EMAIL PROTECTED]
> S
I use the following function in Oracle
SELECT decode(status,'A','Active','L','Active','Former') FROM Table
What it means is: if table column status = A, return "Active", if status=L, return
"Active", else return "Fo
Trying to solve a phpmysql array problem.
Let's say I have a table in mysql format
Column1 Column2
dog brown
cat white
cat black
cat mixed
pig black
pig brown
What kind of (query, array function, loop, etc...)
should I use to produce an
Hi all:
Trying to solve a phpmysql array problem.
Let's say I have a table in mysql format
Column1 Column2
dog brown
cat white
cat black
cat mixed
pig black
pig brown
What kind of (query, array function, loop, etc...)
should I u
Matt
- Original Message -
From: "George Chelidze"
Sent: Monday, October 27, 2003 9:18 AM
Subject: CREATE FUNCTION problem
Hello, I have created new udf function which converts time from NTP
format to timestamp. I compile it with the following command:
gcc -Wall -shared -o n
Hi George,
I think the MySQL-Max RPM is dynamically linked (all -max binaries
actually) if you want to give it a try.
Hope that helps.
Matt
- Original Message -
From: "George Chelidze"
Sent: Monday, October 27, 2003 9:18 AM
Subject: CREATE FUNCTION problem
> Hello, I
Hello, I have created new udf function which converts time from NTP
format to timestamp. I compile it with the following command:
gcc -Wall -shared -o ntp2timestamp.so ntp2timestamp.cc
with no errors.
Then I copy this file to /usr/local/mysql (libmysql* files are located
here and /etc
Hello Steve,
Steve Vernon wrote on 22.10.2003 16:47
I suppose I could return the month as a number, and then output the text
from that, but this seems a bit tacky!
I think that's the most reliable way, imagine you move to a new server
or install your software somewhere else . . . I got
22, 2003 4:47 PM
Subject: date_format function - German
> I have read and searched the internet, but I cannot find much on getting
> mysql to return German and other languages months. Is there codes you use?
>
> I really would prefer to use the English MySQL (if there is such a one)
Hello,
I have read and searched the internet, but I cannot find much on getting
mysql to return German and other languages months. Is there codes you use?
I really would prefer to use the English MySQL (if there is such a one) as I
don't know much German, and need the error messages in English!
Hi, everyone
I am new to MYSQL. I got a question in using UDF. Each time I have modified my
UDF function, the MySQL server restart itself automatically. I don't know if
it should be like this or I must do something wrong.
It happened like below:
1) I midify my UDF function and add it t
Thanks all, it helped me a lot
Manisha
- Original Message -
From: "Director General: NEFACOMP" <[EMAIL PROTECTED]>
To: "Nitin" <[EMAIL PROTECTED]>; "Manisha Sathe"
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, October 16,
t;
Sent: Thursday, October 16, 2003 16:13
Subject: Re: PASSWORD() function problem
> all encryption functions are one way only
>
> Nitin
>
> - Original Message -
> From: "Manisha Sathe" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
>
"Manisha Sathe" <[EMAIL PROTECTED]> wrote:
> thanks all, it works (i just increase it to 20)
Please, don't use PASSWORD() function in your own application, use MD5() or SHA1()
instead.
> but one more thing, now if i want to get this password (e.g for option
> for
PASSWORD() is a one-way function (I was confirming just).
Though, it has worked for you, please consider the advice of Paul in his
previous Email when he recommended you read about PASSWORD() at the URL:
http://www.mysql.com/doc/en/Miscellaneous_functions.html
Thanks
Emery
- Original Message
all encryption functions are one way only
Nitin
- Original Message -
From: "Manisha Sathe" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, October 16, 2003 6:46 PM
Subject: Re: PASSWORD() function problem
> thanks all, it works (i just increase
: "Manisha Sathe" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, October 15, 2003 11:05 PM
Subject: Re: PASSWORD() function problem
> At 17:26 +0800 10/15/03, Manisha Sathe wrote:
> >Hi,
> >
> >I inserted one record thr PHPMyAdmin - mem_pass f
At 17:26 +0800 10/15/03, Manisha Sathe wrote:
Hi,
I inserted one record thr PHPMyAdmin - mem_pass field of member
table set to xyz using function 'PASSWORD'
Then trying to select the same - select * from member where mem_pass
= PASSWORD('xyz') - then it is not getting sel
On Wed, 15 Oct 2003 17:26:23 +0800
"Manisha Sathe" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I inserted one record thr PHPMyAdmin - mem_pass field of member table set to xyz
> using function 'PASSWORD'
>
> Then trying to select the same - select * f
Hi,
I inserted one record thr PHPMyAdmin - mem_pass field of member table set to xyz
using function 'PASSWORD'
Then trying to select the same - select * from member where mem_pass = PASSWORD('xyz')
- then it is not getting selected
I do not know why I am not getting the
ups, i knew i had to copy that line properly.
what i added to the lex.h was this
{ "GETUPDATE",SYM(FUNC_ARG1),0,CREATE_FUNC(create_func_getupdate)}
i copied the line from the abs function. in fact, as you may see, all my
function is nothing but a copy of the abs fun
ups, i knew i had to copy that line properly.
what i added to the lex.h was this
{ "GETUPDATE",SYM(FUNC_ARG1),0,CREATE_FUNC(create_func_getupdate)}
i copied the line from the abs function. in fact, as you may see, all my
function is nothing but a copy of the abs function w
Hi!
On Sep 08, Gustavo Castro wrote:
> Hello,
> i?m using the 3.23.57 version and i?ve declared a native function, but when
> i call it (SELECT GETUPDATE(1);) i
> get this line
>
> ERROR 1064: You have an error in you SQL syntax near '(1)' at line 1;
>
> I
Hello,
i´m using the 3.23.57 version and i´ve declared a native function, but when
i call it (SELECT GETUPDATE(1);) i
get this line
ERROR 1064: You have an error in you SQL syntax near '(1)' at line 1;
I think i´ve followed all the steps right:
1)added the line in lex.h
{
Hi,
>SELECT TD.project_id, P.project_manager
>FROM time_daily TD
>INNER JOIN projects P ON P.project_id = TD.time_project_id
>WHERE TD.time_user_id = 'xpt' AND (
>SUM( TD.time_hours_worked ) <> '0.00'
an Paul Dibois said:
You cannot use aggregate functions like SUM() in the WHERE clause.
And He i
> SUM( TD.time_hours_worked ) <> '0.00'
> )
>
> And I keep getting the # errno.- Invalid use of group function -
>
> I don't want to pull out any rows where the SUM of time_hours_worked is
> '0.00'...
>
> I would be most grateful if
N P.project_id = TD.time_project_id
WHERE TD.time_user_id = 'xpt'
AND hours <> 0
GROUP BY TD.project_id, P.project_manager;
That would output the sum also. But you don't need to use it in your API.
>>
>>And I keep getting the # errno.- Invalid use of grou
Hi all,
Upon testing the "ENCRYPT" function of MySQL, [ eg. SELECT ENCRYPT("MyPass") ] I keep on getting "NULL" values. I read the online documentation on the site,
and they mentioned something about a specific "crypt" function that has to be on
me_project_id
> WHERE TD.time_user_id = 'xpt' AND (
> SUM( TD.time_hours_worked ) <> '0.00'
> )
>
> And I keep getting the # errno.- Invalid use of group function -
>
> I don't want to pull out any rows where the SUM of time_hours_worked
SUM( TD.time_hours_worked ) <> '0.00'
> )
>
> And I keep getting the # errno.- Invalid use of group function -
>
You need a GROUP BY clause if you use the SUM()-function with fields that
you don't sum up.
Just adding GROUP BY TD.project_id might work.
Re
) <> '0.00'
)
And I keep getting the # errno.....- Invalid use of group function -
I don't want to pull out any rows where the SUM of time_hours_worked is
'0.00'...
I would be most grateful if anyone has any suggestions
You cannot use aggregate functions li
ep getting the # errno.....- Invalid use of group function -
I don't want to pull out any rows where the SUM of time_hours_worked is
'0.00'...
I would be most grateful if anyone has any suggestions
Many thanks!
Cory
--
Cory Hicks <[EMAIL PROTECTED]>
TRI Internat
Dear MySQL users,
Is it possible to configure MySQL in such a way that the function dayname()
will return the name of the day my local language. (In my case polish).
thank you very much for help,
regards,
Lukasz
Hi All,
Has the MBREquals function been implemented in the latest 4.1.1-alpha
build. I am finding problems with that command. It says that problem is
there in sql syntax. If it has been implemented. Can you please help me
in the syntax of the command.
I am finding the same problems with the
401 - 500 of 951 matches
Mail list logo