- Original Message -
> From: "Hervey Liu"
>
> CREATE TABLE logins (
>success
> enum('Y','N[banned]','N[password]','N[panic]','N[activation]','N[authorization]')
> DEFAULT 'Y' NOT NULL,
>when datetime DEFAULT '-00-00 00:00:00' NOT NULL,
This is going to be an issu
Jenny Chen wrote:
Hi,
According to the reference manual, it was said that the combined lnnodb log
file size is less than 4G on 32-bit system. But I'm running on my 64-bit
solaris, I still got the error complaining the innodb log file >4G for my
64-bit MySQL. So I'm wondering is this 4G limit app
Rhino wrote:
Does anyone know what Column Type the result of the Year() function is?
In other words, if I execute:
select Year(Hiredate) as mycolname
from mytable;
is the result a smallint? a char()? a varchar()?
Unfortunately, the manual doesn't say and I can't think of a quick way to
figure it ou
At 03:24 PM 12/17/2004, you wrote:
Does anyone know what Column Type the result of the Year() function is?
In other words, if I execute:
select Year(Hiredate) as mycolname
from mytable;
is the result a smallint? a char()? a varchar()?
Unfortunately, the manual doesn't say and I can't think of a qui
Andrew E Filipowski wrote:
I am fairly new to MySql, I have a product that is offered from the company
I work for that uses db2, oracle, and SQL Server. Recently I had a customer
ask if we could run on MySQL. I decided to test it out with my mac powerbook
using tomcat and MySQL. The app is loading
Hi.
On Mon 2003-01-20 at 16:51:53 -0700, [EMAIL PROTECTED] wrote:
>
> Just a quick question. I am just starting to learn MySQL. I am on a
> windows XP pro computer but want to create scripts using php and cgi for
> all platforms. If I create a database using MySQL on windows, is the
> database t
Thanks... That's exactly what I was looking for. Simple and elegant.
Rob.
On Tue, 18 Dec 2001, Roger Baklund wrote:
> Asuming all dates are 20xx:
>
> mysql> select
> @d:='01-DEC-18',@d2:=concat('20',mid(@d,1,2),'-',field(mid(@d,4,3),
> 'JAN','FEB','MAR','APR','MAY','JUN','JUL','AUG','SEP','OC
* zxcv
> Our programming crew does not give us (Web Services) access to Oracle. We
> of course don't care kuz' mySQL suits us fine. But now we have run into a
> pickle. They are handing us text cdf files for import. One of the fields
> they are giving us is in the following condition:
>
> 02-SEP-0
: Saturday, 3 November 2001 11:47 p.m.
To: Quentin Bennett
Subject: RE: Quick Question - quick reply please!
I seem to remember some discussion about this,
and that the index *is* subject to filesystem limits
i.e., it can't be split.
It has been discussed rather extensively at some
time in
> OK quick question, Is there a limit to the amount of data the can
> be defined
> when I create a field as a set.
64. RTFM.
> I am looking to have about 39
> words in there
> at the moment I have them in another table and have an index pointing to
> them, but would like to move them to a set
10 matches
Mail list logo
