Hi:
It seems to me that there is no trigger function in MySQL but I am not sure.
Recently, I have a project which need the trigger function when MySQL database server
receive a alert information and wake up some procedure. Is there any other method to
do the same functionality of trigger
.
Gerald Jensen
- Original Message -
From: Steven Wu [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, August 08, 2003 12:49 PM
Subject: Is there trigger function in MySQL ?
Hi:
It seems to me that there is no trigger function in MySQL but I am not
sure.
Recently, I have a project
Estoy tomando el sol
.
q
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Estoy tomando el sol
.
q
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello all,
I need to compare a datetime field in my database with the current time
and return only the records that are 5 minutes old or older. Is there
any way to do it? Any function to it?
I use to_days() when I am doing the same thing but with days instead of
minutes.
Thanks in advance
Use UNIX_TIMESTAMP or TIME_TO_SEC
---Original Message-
--From: C.F. Scheidecker Antunes [mailto:[EMAIL PROTECTED]
--Sent: Thursday, July 24, 2003 1:43 PM
--Cc: 'MySQL Users'
--Subject: Function to extract difference in Minutes from DateTime
--variables
--
--Hello all,
--
--I need
MaFai [EMAIL PROTECTED] wrote:
I'm just wondering is there a function instead of update to overwrite data
that has expired??
Or can mysql automatically deletes records or rows that has expires just
like cookies delete themselves after expiring.
Nope. Write a script that deletes rows and add
Hi,
I'm just wondering is there a function instead of update to overwrite data
that has expired??
Or can mysql automatically deletes records or rows that has expires just
like cookies delete themselves after expiring.
Thanx for the info
Anthony
--
MySQL General Mailing List
For list
At 18:23 +0200 6/22/03, Anthony W. wrote:
Hi,
I'm just wondering is there a function instead of update to overwrite data
that has expired??
Or can mysql automatically deletes records or rows that has expires just
like cookies delete themselves after expiring.
Cookies don't delete themselves after
Hello, mysql,
I'm just wondering is there a function instead of update to overwrite data
that has expired??
Or can mysql automatically deletes records or rows that has expires just
like cookies delete themselves after expiring.
Best regards.
MaFai
[EMAIL PROTECTED]
2003-06-23
--
MySQL
Alright, I was messing around with some time functions in Mysql and ran
acrossed a wierd bug.
After I set starttime to now(), anytime I run another update query against
the row starttime changes to a new value.
Here is what I did when I noticed the bug.. Does anyone else have a
problem doing
You are absolutely correct.. I did set it to timestamp by mistake!
-//Lucas
On Tue, 17 Jun 2003, Jennifer Goodie wrote:
After I set starttime to now(), anytime I run another update query against
the row starttime changes to a new value.
If starttime is the timestamp data type, and the
On 17 Jun 2003 at 14:05, Lucas Heuman wrote:
After I set starttime to now(), anytime I run another update query
against the row starttime changes to a new value.
You don't give the structure of your table, but it appears that
you're using a TIMESTAMP column, which has automatic updating by
PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, 17 June, 2003 14:05
Subject: Now() and time function bug??
Alright, I was messing around with some time functions in Mysql and ran
acrossed a wierd bug.
After I set starttime to now(), anytime I run another update query against
the row starttime
After I set starttime to now(), anytime I run another update query against
the row starttime changes to a new value.
If starttime is the timestamp data type, and the first timestamp in the row,
it will automatically update every time you update the row. This is not a
bug, it is expected
Is it possible to convert the following query to run in MySQL? The query is
based on a table called ardata which contains the fields 'author',
'lname', and 'fname'. The 'author' field contains the authors first and
last name with a space in the middle. I want to convert the names over so
the
On 16-Jun-2003 Tom Johnson wrote:
Is it possible to convert the following query to run in MySQL? The query
is
based on a table called ardata which contains the fields 'author',
'lname', and 'fname'. The 'author' field contains the authors first and
last name with a space in the middle. I
Sorry... I clicked send before pasting. Here is the function I was talking about.
function approvesignup($lid){
global $prefix, $dbi, $signqid, $ev_title, $ev_location, $ev_descrip, $ev_datetime,
$ev_organizer, $ev_contact, $ev_children, $ev_number, $ev_cost, $ev_phone;
sql_query(INSERT
Is there any built-in funtion at all, that allows us to parse number
values from strings? This would be a huge aid in getting numeric sorting
of results;
something like:
select scene, take from movie_table
order by parseint(scene[,10]), scene,
--
sc:8 | tk:
sc:a9 | tk:
sc:9 |
Hi,
I was looking through the online manual, and on this page
(http://www.mysql.com/doc/en/Miscellaneous_functions.html), there is a
function called COMPRESS():
COMPRESS(string_to_compress)
compresses a string
mysql select length(compress(repeat(a,1000
is the COMPRESS() function?
Hi,
I was looking through the online manual, and on this page
(http://www.mysql.com/doc/en/Miscellaneous_functions.html), there is a
function called COMPRESS():
COMPRESS(string_to_compress)
compresses a string
mysql select length(compress(repeat(a,1000
Hi,
I have written a program that creates statments for me, and sometimes I end
with
SELECT..WHERE number IN(1)
instead of
SELECT... WHERE number IN(1,2,3,4)
would number IN(1) works,
for the moment i have no mean to test it, it is why i'm asking.
Regards,
Anthony
--
MySQL General
Yes
--Original Message-
Hi,
I have written a program that creates statments for me, and sometimes I
end
with
SELECT..WHERE number IN(1)
instead of
SELECT... WHERE number IN(1,2,3,4)
would number IN(1) works,
for the moment i have no mean to test it, it is why
First, a little rant: I don't know what it is about
the MySQL docs that make them so difficult for me to
read, but try as I may, I have the most difficult time
making heads or tails of anything in the official
MySQL documentation.
That being said, here's my question, the answer to
which I was NOT
This is not really a MySQL docs problem.
The manual gives the mysql syntax, but you are expected to already know SQL.
You need to get a book on SQL.
SELECT data.id, data.title
FROM data,archive
WHERE data.favorite=archive.favorite AND data.favorite='Y';
Bob Sawyer wrote:
First, a little rant: I
: gerald_clark [mailto:[EMAIL PROTECTED]
Sent: Monday, March 31, 2003 12:46 PM
To: [EMAIL PROTECTED]
Cc: MySQL List
Subject: Re: JOIN function in SELECT
This is not really a MySQL docs problem.
The manual gives the mysql syntax, but you are expected to
already know SQL.
You need to get a book
Attempting to compile the 4.1 mysql library I encounter a missing function:
ret = select(0, NULL, NULL, NULL, t) == -1 ?
__os_get_errno() : 0;
called from os_sleep()
Where is this function?
Thank You,
Martin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
In the windows distribution within the example mytest.c
there is a a call to pszT = mysql_stat( myData ) ;
which produces this error
myTest.obj : error LNK2001: unresolved external symbol [EMAIL PROTECTED]
Where is the mysql_stat function located?
Thank You,
Martin
- Original Message
I have a small question about the DATE function. This is what I want to do:
- User enters information into form and submits it to database
- When info is added to database the current date is stored ala 2003-03-26
- Now I want to take that date 2003-03-26 and tack on either 15 or 30 days
a small question about the DATE function. This is what I want to do:
- User enters information into form and submits it to database
- When info is added to database the current date is stored ala 2003-03-26
- Now I want to take that date 2003-03-26 and tack on either 15 or 30 days
on to it so
]
Subject: Re: DATE function question
I believe the following will work:
date_add([thedatefield],Interval 15 days)
I am almost sure I got the syntax right off the top of my head. Check
mysql.com for date functions if the above doesn't work.
Serge.
On Wed, 26 Mar 2003 10:16:18 -0500
Tom Ray
],Interval 15 day)
Mark
-Original Message-
From: Serge Paquin [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 26, 2003 10:35 AM
To: [EMAIL PROTECTED]
Subject: Re: DATE function question
I believe the following will work:
date_add([thedatefield],Interval 15 days)
I am almost
All,
I tried to use
SELECT MAX(COUNT(*))
FROM ...
GROUP BY ...
in MySQL. But an error occured: Invalid use of group function.
Is it necessary to create a temporary table to store the COUNT(*) results, and then
get the MAX from it?
Subject: embedded group function
All,
I tried to use
SELECT MAX(COUNT(*))
FROM ...
GROUP BY ...
in MySQL. But an error occured: Invalid use of group function.
Is it necessary to create a temporary table to store the COUNT(*) results,
and then get the MAX from it?
--
MySQL General
Any know what algorithm MySQL uses for its encode/decode functions??
Sean
Did you check the source?
Sean Biganski wrote:
Any know what algorithm MySQL uses for its encode/decode functions??
Sean
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hu,
SELECT MAX(COUNT(*))
That makes no sense. COUNT(*) will list the number of rows in your
table, whereas MAX(column) will list the hightest value of column in
your table, like that:
mysql SELECT COUNT(*) FROM t;
+--+
| COUNT(*) |
+--+
|4 |
+--+
1 row in set
Just wanted to let y'all know this worked awesome!
Thanks so much!
Renee :)
-Original Message-
From: Sqlcoders.com Programming Dept [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 04, 2003 11:20 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Count (*) function results needed
: Stitchin' [mailto:[EMAIL PROTECTED]
Sent: 05 March 2003 04:08
To: [EMAIL PROTECTED]
Subject: Count (*) function results needed in echo statement
I've got the following code in my php file:
/* Select all categories from designcatagories table */
$query = SELECT designcatagories.catcode
I've got the following code in my php file:
/* Select all categories from designcatagories table */
$query = SELECT designcatagories.catcode, designcatagories.catdesc,
count(*) FROM
designs,designcatagories where designs.catcode =
designcatagories.catcode
GROUP BY
-Original Message-
From: Stitchin' [mailto:[EMAIL PROTECTED]
Subject: Count (*) function results needed in echo statement
I've got the following code in my php file:
/* Select all categories from designcatagories table */
$query = SELECT designcatagories.catcode
At 23:08 -0500 3/4/03, Stitchin' wrote:
I've got the following code in my php file:
/* Select all categories from designcatagories table */
$query = SELECT designcatagories.catcode, designcatagories.catdesc,
count(*) FROM
designs,designcatagories where designs.catcode =
NULL
MAX(t1.id) MAX(t2.id)
NULLNULL
Fix:
unknown
Submitter-Id: [EMAIL PROTECTED]
Originator:Paul DeMarco
Organization:
MySQL support: none
Synopsis: invalid aggregate function value for 0 row results (from a full join)
Severity: non-critical
Priority: medium
i have made a simulation for horizontal aggregation in C++ but had a hard time
converting it to MySQL codes for me to create a function for MySQL?
how can i convert my C++ code inorder for it to be accepted and run in MySQL? thanks
how can i convert my C++ codes to become a new function for MySQL?
i am to embed a new feature for MySQL but i dont know if my code will work for mysql.
i have read that embedding would mean creating a new function for mysql.
MySQL is also written in C or C++ right? how can i convert my codes
On Wed, Feb 26, 2003 at 12:32:57AM -0800, DiAnNe iRiS aLeRta wrote:
i have made a simulation for horizontal aggregation in C++ but had a
hard time converting it to MySQL codes for me to create a function for
MySQL?
how can i convert my C++ code inorder for it to be accepted and run
I have a table with this structure :
username VARCHAR(32)
address VARCHAR(128)
datereg DATETIME // date of registration
classINT
How is the sql query for username who are their datereg was 30 days ago and class = 1?
thanks
__
At 18:30 -0800 2/26/03, Admin-Stress wrote:
I have a table with this structure :
username VARCHAR(32)
address VARCHAR(128)
datereg DATETIME // date of registration
classINT
How is the sql query for username who are their datereg was 30 days
ago and class = 1?
WHERE class = 1
On Monday 24 February 2003 20:22, Karl Stubsjoen wrote:
I am reporting a bug. The format number function fails when a query is
sorted. I have included an example page to look at (the error is
reproduced here):
http://www.meetscoresonline.com/test_format.asp
You'll see there are 2 result
Hello,
I am reporting a bug. The format number function fails when a query is
sorted. I have included an example page to look at (the error is reproduced
here):
http://www.meetscoresonline.com/test_format.asp
You'll see there are 2 result sets, the first is not ordered and the 2nd is
ordered
Greetings -
I have a simple CGI script written in Perl (using v5.8) that seemed
to work well under MySQL 3.23.49. However, after recently upgrading to
version 3.23.55 I am running into the following problem. Previously, I used
the rows() function to return the number of rows
Weird problem here running 3.23.55-Max. I'm (still) trying to get my IP
address DB working, but have run into a problem.
When I use the inet_aton function during an insert, I get a very
different value than if I use the function by itself on the CLI. Please
see below.
The IP address I am
Your INT in your table is a signed INT, which is going to have a maximum
value of 2^31, thus your IP address is causing the field to roll over. You
need to change your IP column to UNSIGNED INT. That should solve your
problem.
j- k-
On Tuesday 18 February 2003 12:33, Aaron Conaway
On Mon, Jan 27, 2003 at 10:04:07PM -0500, Carlin Anderson wrote:
I am running mysql 3.23, and want to know if I can set the default value
of a column to to_days(now()), or the equivelant. I have tried this,
and the default gets translated to 0.
You cannot.
--
Jeremy D. Zawodny | Perl,
On Tuesday 28 January 2003 05:04, Carlin Anderson wrote:
I am running mysql 3.23, and want to know if I can set the default value
of a column to to_days(now()), or the equivelant. I have tried this,
and the default gets translated to 0.
Nope. Default column value must be constant.
--
For
I am running mysql 3.23, and want to know if I can set the default value
of a column to to_days(now()), or the equivelant. I have tried this,
and the default gets translated to 0.
Thanks
Carlin
-
Before posting, please check:
Dear sir,
I am looking for a function which returns the column type in MySQL in C
API.
Is there one? I found in the document it describes the column types
like:
FIELD_TYPE_BLOB
FIELD_TYPE_DATE
FIELD_TYPE_VAR_STRING
... ...
Could you please get
I understand the SQL statement in MySQL to be SELECT sum(column name) FROM table;
but I would like to get a SUM of multiple columns. Is this possible??
Thanks,
Ryan
-
Before posting, please check:
* Stevens, Ryan
I understand the SQL statement in MySQL to be SELECT sum(column
name) FROM table; but I would like to get a SUM of multiple
columns. Is this possible??
Yes. You can add multiple columns inside the SUM() function:
SELECT SUM(col1+col2+col3) FROM table;
--
Roger
sql
SELECT SUM(colA+colB) FROM TABLE ?
Stevens, Ryan wrote:
I understand the SQL statement in MySQL to be SELECT sum(column name) FROM table;
but I would like to get a SUM of multiple columns. Is this possible??
Thanks,
Ryan
On Mon, 2003-01-13 at 14:11, Stevens, Ryan wrote:
I understand the SQL statement in MySQL to be
SELECT sum(column name) FROM table; but I would like to get a
SUM of multiple columns. Is this possible??
Yes, you may use:
SELECT sum(c1+c2) FROM table;
or even:
SELECT sum(table1.v +
Thank you very much! I am a first year software engineer so I'm still
learning :-)
I had a query that took 23 seconds, and now takes .01 sec.
Thanks again!
Rob Taft
-
Before posting, please check:
I have 2 tables, one with 1,000 entries, the other with 10,000 entries. I'll
call these table1 and table2. The query uses both tables:
SELECT something to select FROM table1 LEFT JOIN table2 ON (table1.ID =
table2.table1_ID) WHERE some condition;
table2.table1_ID is just an int that matches an
an explain on
your query to make sure it is utilizing indexes.
-Original Message-
From: Rob Taft [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 06, 2003 10:53 AM
To: [EMAIL PROTECTED]
Subject: LEFT JOIN function locking up when using large
database
I have 2 tables, one with 1,000 entries
]
To: [EMAIL PROTECTED]
Sent: Monday, January 06, 2003 7:53 PM
Subject: LEFT JOIN function locking up when using large database
I have 2 tables, one with 1,000 entries, the other with 10,000
entries. I'll
call these table1 and table2. The query uses both tables:
SELECT something to select FROM
Rob Taft wrote:
I have 2 tables, one with 1,000 entries, the other with 10,000 entries. I'll
call these table1 and table2. The query uses both tables:
SELECT something to select FROM table1 LEFT JOIN table2 ON (table1.ID =
table2.table1_ID) WHERE some condition;
Do you have indexes on
Remi,
n Fri, Jan 03, 2003 at 10:56:21AM -0500, Remi Lanteigne wrote:
I would like to know if there is a way of telling mysql to transfer the
value of the function now() in it's replication, as it is now (from what I
see in the binlog file) mysql passes the now() to the slave instead
I would like to know if there is a way of telling mysql to transfer the
value of the function now() in it's replication, as it is now (from what I
see in the binlog file) mysql passes the now() to the slave instead of the
value, this causes a difference in my 2 databases.
Thank you in advance
for TIMESTAMP columns, not your own
that include blah = now().
Looking at the sources, it seems to be used for the NOW function as well.
Anyway, I would consider it a bug if it wasn't used for the NOW function.
A. The slave sets the timestamp with set_time():
slave.cc:
switch(type_code
On 27 Dec 2002, at 1:04, Peter D Bethke wrote:
My table matchups has columns for team1_id, team2_id, team1_score and
team2_score.
I can write a simple calculation using the api I use (Lasso - similar in
function to php) and display the results programmatically in the html
output
Hello all,
I'm creating a db to track a contest involving sports teams and scores.
My table matchups has columns for team1_id, team2_id, team1_score and
team2_score.
I can write a simple calculation using the api I use (Lasso - similar in
function to php) and display the results
the now() function
to insert the current date/time into the datetime
column.
When using load data infile, only the varchar column
shows a value, but the datetime column shows a string
of zeros. I don't understand why using MySQL monitor
works for now() function, but I can't reproduce this
when
in getting that to work at this time.
If I use MySQL monitor, I can use the now() function
to insert the current date/time into the datetime
column.
When using load data infile, only the varchar column
shows a value, but the datetime column shows a string
of zeros. I don't understand why using
: now() function not working with load data infile
On Tuesday 24 December 2002 10:30, [EMAIL PROTECTED] wrote:
I've created a test table with two columns. The first
one is a varchar type for inputting first names. The
second column is datetime. The table will eventually
expand to include
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Thu, 19 Dec 2002 [EMAIL PROTECTED] wrote:
Description:
with the latest 4.1 tree (from today) the PASSWORD() function returns random
alpha-numeric text /[a-f0-9]/
45 characters in length (which is too long for a password string
Yes, that's intentional - we have changed this in 4.1, but it's not
documented in the manual yet. A quote from the developer working on that
code:
So, the PASSWORD() function is now not to be used for passwords? The
problem is that I have built at least a few applications that use
PASSWORD
Description:
with the latest 4.1 tree (from today) the PASSWORD() function returns random
alpha-numeric text /[a-f0-9]/
45 characters in length (which is too long for a password string). The string
always starts with a * (asterisk).
example
Description:
The password function does not work as intended with latest 4.1 tree
(today's). It returns a string of LENGTH() = 45 starting with a *
(asterisk) and 44 alphanumeric characters /[a-z0-9]/
How-To-Repeat:
Using latest 4.1 BK tree, SELECT PASSWORD('something');
Fix:
Not known
No. It is not what I want.
This is a normal aggregation.
The sum function will be called once for each
group (SalespersonNm) and it will return one row.
What I have asked is : if I have 10 rows, can I return 12?
It's rude, but that's the idea.
Thanks,
Felix
DL Neil wrote:
Felix
Victor Pendleton wrote:
Felix,
Can you please give an example of what you are attempting to do?
-Original Message-
From: Felix LUNGU [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 04, 2002 9:22 AM
To: [EMAIL PROTECTED]
Subject: Aggregating function which returns more
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Felix LUNGU
Sent: Thursday, December 05, 2002 12:27 AM
To: Victor Pendleton; [EMAIL PROTECTED]
Subject: Re: Aggregating function which returns more than one row
The idea is simple:
I want to implement
Is is it possible to write an aggregation function which returns
more than one row?
Thanks,
felix
Mysql sql query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
Felix,
Is is it possible to write an aggregation function which returns
more than one row?
Yes - if I have understood your requirement correctly.
It would have been helpful if you had given some idea of the
application/what you want to achieve. Here's an example from out of my
imagination
I am trying to format a TIMESTAMP column on output by using the
DATE_FORMAT() function:
Can someone tell me why this does not change the format - no error
message - just does not do anything?
$sql = SELECT * from arviContacts WHERE fid=$zz AND
DATE_FORMAT(date_rec,'%Y-%m-%d %T');
I have also
-
From: Nicole Lallande [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, November 30, 2002 11:38 PM
Subject: attempting to use DATE_FORMAT function in a SELECT STATEMENT
I am trying to format a TIMESTAMP column on output by using the
DATE_FORMAT() function:
Can someone tell me why
Hi guys, In mysql, I need to know the SELECT DATETIME(); returns a
value of
-MM-DD HH:MM:SS. Is this value in a form of string?? If I have a
column described as DATETIME data type I should be able to do:
INSERT INTO tablename VALUES (id#, 1997-10-10 24:45:32), right?
but if I do SELECT *
At 15:39 -0800 11/28/02, David Wu wrote:
Hi guys, In mysql, I need to know the SELECT DATETIME(); returns a value of
-MM-DD HH:MM:SS. Is this value in a form of string?? If I have a
column described as DATETIME data type I should be able to do:
INSERT INTO tablename VALUES (id#, 1997-10-10
I looked in mysql.h and saw
#ifdef USE_OLD_FUNCTIONS
..
mysql_connect(..)
etc.
#endif
, shouldn't it work then - even if they are
deprecated? Well, I'll try with mysql_real_connect.
Thanks.
/nikolajg
--- Ed Carp [EMAIL PROTECTED] wrote:
Iv'e been using gcc 2.96-10 to compile a database
Can someone please tell me what is wrong with this function? I can't for
the life of me see an error. But, for some reason I keep getting the
following error:
PARSE ERROR: parse error, unexpected $ in
d:\web.root\xx_db\inc\functions1.inc on line 28
function is:
function dtb_qry_tbl_dsp($qry
Hi
If this is the full code you are missing the final } to close the function
I find it helps to comment the closing brackets
HTH
Peter
function dtb_qry_tbl_dsp($qry, $qry1, $qry2)
{
$result = mysql_query($qry);
$result1 = mysql_query($qry1);
$result2 = mysql_query($qry2);
$i = 0
Hi MySQLs
Iv'e been using gcc 2.96-10 to compile a database
program (ver. 3.23.49 I guess) in c and everything
worked fine. It was compiled as a cc program. Lately
I've installed mysql 4.0.4 with developer and gcc 3.2
(default with Redhat 8.0) and simply want to compile
the same program, but get
with the 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 (or in
the case of mssql
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 current_date or feed
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
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/CREATE_TABLE.html
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
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 server
Ben on intel, and, worse, core-dumping under sparc. Can you take a peek at
Ben this? I'll provide more info
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 the libmysqlclient
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
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 inaccurate, by no
501 - 600 of 906 matches
Mail list logo