On Fri, Jun 5, 2009 at 9:09 AM, Aaron Fischer wrote:
> So I build the query in the order that I want it displayed. That is display
> 221593, then 221591, then CC3762, etc. However, when the query is executed
> it looks like it automatically sorts the codes in ascending order, so I get
> 221591, t
Aaron-
to reorder results of a column specify
FIELD(ColumnName,1stPosition,2ndPosition) e.g.
mysql>use information_schema;
mysql> select ordinal_position,TABLE_CATALOG,TABLE_SCHEMA,TABLE_NAME,COLUMN_NAME
from COLUMNS WHERE ORDINAL_POSITION=23 OR ORDINAL_POSITION=18 ORDER BY
FIELD(ORDINAL_POSI
I have a query that I build dynamically, here is an example:
select from (table1 as t1 left join table2 as t2 on t1.id = t2.id)
left join table3 as t3 on t1.id = t3.id where t1.id in ('221593',
'221591', 'CC3762', 'CC0059')
So I build the query in the order that I want it displayed. That i
Curdate() returns a datetime, which you are pushing into a date field.
It is truncating the time part. Just truncate it and you should be
fine :)
Walter
On Fri, Jun 5, 2009 at 5:56 AM, Keith Edmunds wrote:
> I'm very new to triggers, so I suspect I've done something naive.
>
> When a row is inser
I'm very new to triggers, so I suspect I've done something naive.
When a row is inserted into a table, I want populate a 'date' column with
the date 45 days hence. I've created a trigger:
CREATE TRIGGER `test`.`setExpiryDate` BEFORE INSERT ON `test`.`mysql_auth`
FOR EACH ROW SET NEW.expires =
Mind sharing ? :-) I don't really have the issue, but it sounds like a
useful trick.
On Fri, Jun 5, 2009 at 11:44 AM, Moon's Father wrote:
> Ok. I have already gotten the answer.
>
> On Wed, Jun 3, 2009 at 4:15 PM, Moon's Father >wrote:
>
> > Hi.
> >I want to know which lock method is used w
Hi.
Here is the introduction.
http://www.oracle.com/technology/oramag/oracle/05-sep/o55security.html
I want to know whether MySQL has the same function as Oracle's?
Any reply is appreciated.
--
David Yeung,
MySQL Senior Support Engineer,
Sun Gold Partner.
My Blog:http://yueliangdao0608.cublog
Ok. I have already gotten the answer.
On Wed, Jun 3, 2009 at 4:15 PM, Moon's Father wrote:
> Hi.
>I want to know which lock method is used within MySQL?
> For example, if I query the following statements within MySQL client.
> mysql> begin;
> Query OK, 0 rows affected (0.00 sec)
>
> mysql> se
Dear MySQL users,
MySQL Community Server 5.1.35, a new version of the popular Open
Source Database Management System, has been released. MySQL 5.1.35 is
recommended for use on production systems.
For an overview of what's new in MySQL 5.1, please see
http://dev.mysql.com/doc/refman/5.1/en/my
Is it possible to do load balancing with 3 servers which also cluster
and fail over (High Availibity) with MySQL? Can somebody give me the how
to or URL to setup?
Willy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mys
10 matches
Mail list logo
