- Original Message -
From: Hervey Liu herve...@buffalo.edu
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
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,
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
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
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
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
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
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
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
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
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 new here as I switched from
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 set-up permission for that database in
order
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
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
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
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
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
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,
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
* 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-02
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),
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
.
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 the near past; check the list archives
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
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
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])
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
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 Business undergradute course at Aston University.
Sunit As part of my final year I am producing an on-li
28 matches
Mail list logo