- 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
hello
i am a noob in general
i just want to double check
can someone perhaps send me a screen shot of how the following data will
look in a mysql table
;
CREATE TABLE logins (
success
enum('Y','N[banned]','N[password]','N[panic]','N[activation]','N[authorization]')
DEFAULT 'Y' NOT NULL,
wh
Hi,
My understanding is that the memory utilization of mysql can be calculated
roughly using the formula like:
(All global memory related server variables + max_connections * session
memory related server variables)
As I noticed that most global variables like key_buffer_size,
innodb_buffer_szie w
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
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 apply on 64-bit system
On Thu, 13 Mar 2008, Roberto Zarate <[EMAIL PROTECTED]> wrote:
i am a newbie in this mysql path...
what are the diferences between mysql 5.0, 5.1 and 6.0
I work mostly with Ms-SQL 2003.
any sugestion? any answer? any help would be nice!
I did a Google search for "mysql" and the top hit was
i am a newbie in this mysql path...
what are the diferences between mysql 5.0, 5.1 and 6.0
I work mostly with Ms-SQL 2003.
any sugestion? any answer? any help would be nice!
thx
Roberto Zarate Mendoza
lima-peru
511 9238-4883
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
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 out
R
AIL PROTECTED]
Sent: 05 May 2004 15:36
To: [EMAIL PROTECTED]
Subject: MySQL Control Center - One quick question...
One quick question here. I just installed the MySQL Control Center and
get the "host not allowed" connection error. So, do the database have
to exist on MySQL Server and
One quick question here. I just installed the MySQL Control Center and
get the "host not allowed" connection error. So, do the database have
to exist on MySQL Server and set-up permission for that database in
order for MySQL Control Center's connection to work??
I'm ne
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
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 and some tables are getting
Question: is there any way (short of packet spoofing) to use the `host`
record in the `mysql`.`users` table for Local or Clustered
connections...
Like, I want a user to login with [EMAIL PROTECTED] into my
application, and after determining what server their office data resides
on, I would create
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 th
Hello,
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 transportable to Unix and Linux?
Thanks
What year was the web page http://www.mysql.com/doc/S/t/Standards.html
created/updated.
Exact month and day would be helpful if it is available.
I am referencing this page in an assignment and a year would be useful.
Your thoughts.
Thanks lots
David Ayliffe
ICQ# 125646758
Query, table, dat
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
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-02
We need to do
: 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
Hi,
Assuming that a 'table' has been defined with MAX_ROWS high enough to allow
the table to be > 4Gbytes, does the same size limit apply to the index as
the data file, or is the index file subject to a different limit?
Thanks for a speedy response
Quentin Bennett
Transport Systems Division
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 l
OK quick question, Is there a limit to the amount of data the can be defined
when I create a field as a set. 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. if it is possible
thanks
Yes the server must be able to open the file. I dont know how you would
write a file path that accesses another machine heh.
ryan
> In order to add data to mysql, using LOAD INTO, am I right in thinking
> that this file has to be local to the machine. Therefore I have to ftp
> the file I want
In order to add data to mysql, using LOAD INTO, am I right in thinking
that this file has to be local to the machine. Therefore I have to ftp
the file I want inserted to the machine running the MySQL server;
Correct?
Thanks lots
David Ayliffe ([EMAIL PROTECTED])
---
lt;[EMAIL PROTECTED]>
> Cc: [EMAIL PROTECTED]
> Subject: Quick question
>
>
> Hi,
> >>>>> "Sunit" == Sunit Modi <[EMAIL PROTECTED]> writes:
>
> Sunit> Dear viewer, I am currently a final year student on an IT For
> Sunit>
28 matches
Mail list logo
