Hello,
I have a MySQL account that only accepts connections from localhost for
security reasons. I wish to use a local Windows GUI client with the remote
MySQL database.
I setup SecureCRT (my Windows SSH client) to forward local port to
remote port 3306. I try telnetting to localhost a
As per section 7.3 of the manual (Column Types):
--snip--
BLOB/TEXT: A BLOB or TEXT column with a maximum length of 65535 (2^16 - 1)
characters.
MEDIUMBLOB/MEDIUMTEXT: A BLOB or TEXT column with a maximum length of
16777215 (2^24 - 1) characters.
LONGBLOB/LONGTEXT: A BLOB or TEXT column with
Sir,
I am having a database on Red Hat 6 server.
I am trying to establish a copy of this database on the Red Hat 7
server.
I created a user called eyetex on linux 7.
Then i logged in as "su" and went to the mysql prompt,
Then i gave the following command
grant all privileges on eyetex.* to eyetex
I got a problem in converting the Jan 21 2001 format to 2001-01-21
I always got a null as result when i do date_format('Jan 21
2001','%Y-%m-%d')
can anyone help me with this
-
Before posting, please check:
http://www.mysql.c
Hi all,
I tried to unzip and untar the MySQL source file mysql-3.23.30-gamma.tar.gz with the
following command
gunzip -dc mysql-3.23.30-gamma.tar.gz | gtar vxf -
But I got the following erroe message, what i can do to solve it? Thanks
choi
<>
gtar: mysql-3.23.30-gamma/libmysql/libmysql.c:
Sergei Golubchik a écrit :
>
> Hi!
>
> On Jan 12, João Gouveia wrote:
> > Hi,
> >
> > I believe i've found a problem in MySql. Here are some test's i've made in
> > 3.22.27 x86( also tested on v3.22.32 - latest stable, although i didn't
> > debug it, just tested to see if crashes ).
>
> Confirm
> OK, I am really stuck sorry to have to post this. I have searched through the
> documentation and maybe I am just searching with the wrong words on the MySQL
> site. I am wanting to reorder the fields I have in a table - not the data in the
>fields (I
> have lots of info on this) but the act
I have table with 100 records
++--+--+-+-+
| Field | Type | Null | Key | Default | Extra |
++--+--+-+-+
| decID | int(11)
Hi
Check out the syntax for Alter Table in the on-line docs
At 10:41 15/01/2001 +0100, Carsten H. Pedersen wrote:
> > OK, I am really stuck sorry to have to post this. I have searched
> through the
> > documentation and maybe I am just searching with the wrong words on the
> MySQL
> > site. I a
Hi!
I have 2 questions!
1.What is more eficient to keep some images into a table or to keep their names in the
table and images separated in a directory?
2.How can I join to big tables and verify if there are any duplicates (i have tried
just to view the data from those tables with something
what is the problem?
mysql> select * from TABLENAME where NASIDENTIFIER =
'xxx.xxx.xxx.xxx';
ERROR 1030: Got error -1 from table handler
mysql>
thank you
Jesus M Diaz <[EMAIL PROTECTED]>
Telia Iberia, S.A.
Planificación y Diseño de Red
Tfno: +34 91 623 2909
Fax: +34 91 623 2911
---
Dear Ladies and Gentlemen,
I intend to develop an J2EE-Application using JRun as Applicationserver with
MySql as database.
Since MySql supports no transaction management, there is a problem to
deploy Entity Enterprise Java Beans, because the applicationserver
needs to set a transaction isolatio
Hi everybody: here is a new version of moodss.
Check it out! (or at least the screenshots at
http://jfontain.free.fr/moodss3.gif or
http://jfontain.free.fr/moodss4.gif :).
Notes:
- I am working on allowing moodss modules to be written in Perl
instead of Tcl: please let me know if you are inte
hi
I want to know how to backup and restore databases in mysql.
thanks for help
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To requ
hi
i have a problem and i hope somebody can help me.
I use mysql-2.23.25 ( for windows).
I have my database in (c:) and i want to backup it in (d:) .
thanks and regards
-
Before posting, please check:
http://www.mysql.com/
Hi!
On Jan 15, Nicolas GREGOIRE wrote:
>
>
> Sergei Golubchik a Ucrit :
> >
> > Hi!
> >
> > On Jan 12, JoUo Gouveia wrote:
> > > Hi,
> > >
> > > I believe i've found a problem in MySql. Here are some test's i've made in
> > > 3.22.27 x86( also tested on v3.22.32 - latest stable, although i didn't
>Description:
In certain cases the select fails (ie (a) does not return required rows, or (b)
returns non-wanted rows (cannot repeat (b)))
The problem seems to be related to negative values in decimal type fields and in query
against those fields.
the problem is applicable to several 3.22.* ver
>Description:
Trying to upgrade mysql from v3.22.32 to latest version 3.23.30,
configured and compiled fine on the system. Ran the test suite and
it discovered an error. Would like to know if this is a known bug
(ignore?) Or what can be done to fix things.
>How-
Steve Costaras writes:
>
> >Description:
> Trying to upgrade mysql from v3.22.32 to latest version 3.23.30,
> configured and compiled fine on the system. Ran the test suite and
> it discovered an error. Would like to know if this is a known bug
> (ignore?) Or wha
Kyle Cronan writes:
> I have read through the archives and am still unclear on a few things:
>
> o Does libmysqlclient_r only correct the timeout problem? Or does it
>provide thread safe versions of calls like mysql_query()? I do not
>need to use timeouts.
>
> o I will definat
Philip Mak writes:
> Hello,
>
> I have a MySQL account that only accepts connections from localhost for
> security reasons. I wish to use a local Windows GUI client with the remote
> MySQL database.
>
> I setup SecureCRT (my Windows SSH client) to forward local port to
> remote port
Hi all,
I have a table with a text field (let's call it 'A') - in this field are
descriptions of various things. I also have another table with a varchar
field (let's call this 'B').
What I need to do is to take the text field for each record in table A and
split it into seperate words. I need t
-Hello
This depends on what OS you installed MySQL in.
Did you install it on :
Linux?
BSDI
FreeBSD?
Windows 98?
If you installed it using Linux did you install using RPM?
If you installed it using FreeBSD did you isntall it using ports?
On Mon, 15 Jan 2001, Ujwol wrote:
> >%_Hi,
> I
root writes:
> >Description:
>
> In certain cases the select fails (ie (a) does not return required rows, or (b)
>returns non-wanted rows (cannot repeat (b)))
> The problem seems to be related to negative values in decimal type fields and in
>query against those fields.
> the problem is
There is mysql loaded on 2 machines. On 1 machine if I am running my java code than it
is running perfectly fine but if same code I am running on other machine than it is
giving following error message.
jdbc:mysql://132.147.160.222:3306/abc
path = null
erorr = java.sql.SQLException: mysql excep
Hi!
> "Peter" == Peter Zaitsev <[EMAIL PROTECTED]> writes:
Peter> Hello bugs,
Peter> Linux. Mysql 3.23.30 (also checked with 3.23.25). Problem appears with
Peter> repear table as well as myisamchk.
Peter> The problem is quite strange. Then repair table or myisamchk repears
Peter> the table
i'm sorry to have to ask for the 3rd time the same question but i'm
quite sure there is an answer, whether yes or no!
is it possible at installation time or at configuration time, to state a
limit for the size of the databases created.
ie.
if i give one database per user i dont want any user to
Hello,
Has anybody had any trouble creating a HEAP table in the .INI file with
version 3.23.29a or above?
I recently upgraded to 3.23.29a from 3.23.23 and found that the .INI file
wasn't being fully processed. The error it gave was that it couldn't
allocate space for the table in memory. Found
From: "Issam W. Alameh" <[EMAIL PROTECTED]>
Sent: Monday, January 15, 2001 3:46 AM
> I am using an auto_increment field, every time I delete from the table,
the
> counter goes back, is there any way to keep the incrementation regardless
of
> the number reached after delete
This is the way auto_
Hi all,
I have TWO copies of mysql running on one box. Not just two ports, but
two completely different distributions. The first copy is running on the
default port. The second copy is running on port 3400.
I'm trying to use DBI to connect to the second copy (3400), but I just
can't get it to
Hi
I'm currently running a FreeBSD4.2-Stable server with
Apache1.3.14/PHP4.0.4pl1 and MySQL 3.23.27-Beta.
The problem is that MySQL is crashing constantly, sometimes several times
each minute. I've been through all the "What to do if mysql keeps crashing"
steps in the MySQL-documentation, but n
Adam Rubin wrote:
>
> Hi all,
>
> I have TWO copies of mysql running on one box. Not just two ports, but
> two completely different distributions. The first copy is running on the
> default port. The second copy is running on port 3400.
>
> I'm trying to use DBI to connect to the second copy
Has anybody tested the above (with MySQL of course :-) in a production
environment?
If yes, what do you have to say?
PS: thank you for this great mailing list!
--
Jean-Luc Fontaine mailto:[EMAIL PROTECTED] http://www.winealley.com
Luke Andrew Cassady-Dorion wrote:
>
> i've been running mysql on a redhat linux machine for about two months w/o
> need for a restart. unfortunately this morning, the machine started acting
> really odd and i decided to perform a restart. when restarting, the system
> actually froze and i was for
Nicolai Gylling writes:
> Hi
>
> I'm currently running a FreeBSD4.2-Stable server with
> Apache1.3.14/PHP4.0.4pl1 and MySQL 3.23.27-Beta.
>
> The problem is that MySQL is crashing constantly, sometimes several times
> each minute. I've been through all the "What to do if mysql keeps cras
What's the priviledge for the username?
I think the privilidege has to explicitly say that it can connect from the
IP address of the server machine, not just localhost
JuanE
> Hello,
>
> I have a MySQL account that only accepts connections from localhost for
> security reasons. I wish to u
Amit Desai wrote:
>
> Sir,
>
> I am having a database on Red Hat 6 server.
> I am trying to establish a copy of this database on the Red Hat 7
> server.
> I created a user called eyetex on linux 7.
> Then i logged in as "su" and went to the mysql prompt,
> Then i gave the following command
> gra
[EMAIL PROTECTED] wrote:
>
> Hi all,
>
> I tried to unzip and untar the MySQL source file mysql-3.23.30-gamma.tar.gz with the
>following command
>
> gunzip -dc mysql-3.23.30-gamma.tar.gz | gtar vxf -
>
> But I got the following erroe message, what i can do to solve it? Thanks
>
> choi
>
>
SELECT concat(last_name,", ",first_name) as name from members
results in a column that is much wider than necessary. Adding trim() to
the concat() nor to the components makes any difference.
Can the column width be specified?
--
"Money is the material shape of the principle that men who wish t
Please forgive me. I have searched all over for help with this problem
to no avail. I have just installed from RPM mysql 3.23.22-6 on a RedHat
7.0 system. I keep getting the message mysqladmin: cannot connect to
server at 'localhost' failed
error; Can't connect to local MySql server through soc
Obviously the faster the better, but 60,000 page views a day is nothing. I
run a dual P2 450, Raid 5 HD array with 512 megs of RAM, which is a pretty
sizable server (nothing massive) and I get about 45,000 "hits" a day and
the CPU PEAKS at about 2-3%.
PHP/MySQL are pretty scalable. You have
Use the "timestamp" datatype instead of date.
At 05:19 PM 1/13/2001 -0500, you wrote:
>Hello,
>
>Is there a way to have a field of type DATE get the current date as its
>default?
>
>Something like ...
>
>mydatefield DATE DEFAULT curdate()
>
>...which does not work. But that's the idea.
---
The efficiency of your SQL will be an extrmely important factor. Spend AMPLE time
planning the structure of your database and make sure to optimize yor production SQL
code.
I have a server with 8 processors and 2 gigs of ram sitting on it and 2 or 3 bad join
statements made it work like an old
On the site Adoption.com we have been using a mysql database to set up
families who want to adopt. We have since redesigned our site and the old
code is not working for us. I am trying to design a section of code in ASP
to connect to the database and return a random record. Here is what I
Go buy Paul DuBois' book on MySQL it's a good explanation of both MySQL and
RDMS.
At 03:43 PM 1/13/2001 -0800, [EMAIL PROTECTED] wrote:
>I am a new user to MySQL.
>
>I am having a hard time understanding relational databases.
>
>Can anyone recommended any resources which helps explain
>relationa
You can use MySQL dump. However, copying the files SHOULD work as long as
they are the same version (major version) and you stop the MySQL service
before copying.
Scott
At 06:09 PM 1/13/2001 -0600, John W Cunningham wrote:
>Hello all,
>
>I have a few databases running on a Win2k MySQL server
Greetings,
I want to replace an Access database that kills a LAN with a lean and
mean MySQL/Delphi application.
The "sysadmin" of the site in question told me that they are not
running a "normal" NT but a Terminal Server, which sounds like
something very sick to me. ;)
His exact words were "Ter
Sounds to me like your indexes got corrupted. You can try fixing them with
the table fixer thing. But since you have such small data, just drop them
all, and recreate them.
At 01:09 AM 1/14/2001 -0800, David Young wrote:
>Ok, here's the scoop. After 3 days of research, noone has been able to
Yes MySQL comes empty. You have to make tables.
At 05:36 AM 1/14/2001 -0800, jim.brown wrote:
>I installed MySQL on Win98 and acessed it from a SmartArrays program
>which uses ODBC with this connection string:
>
>DSN=sample-MySQL;DRIVER={MySQL}
>
>This worked. When I asked for the the list of ta
On Mon, Jan 15, 2001 at 10:39:15AM -0600, Gerald L. Clark wrote:
> Rick Pasotto wrote:
> >
> > SELECT concat(last_name,", ",first_name) as name from members
> >
> > results in a column that is much wider than necessary. Adding trim() to
> > the concat() nor to the components makes any difference
If you're sure you have PERL installed just use rpm -i name.rpm --no-deps
At 04:25 PM 1/14/2001 +0100, Martin Borg wrote:
>I am trying to install Mysql 3.23.7 on a Red Hat 6.0 Server system. When
>I try to install the binary rpm-distribution i get an error saying that
>bin/usr/perl5 is needed. Th
From when I installed the mysql 3.23.30gamma I have mysql reporting these
warnings:
10115 17:51:22 Aborted connection 2886 to db: 'db_name' user: 'user' host:
`www.host'
(Got an error reading communication packets)
010115 17:51:36 Aborted connection 3754 to db: 'db_name' user: 'user'
host:
Keep in mind as well that datafiles for anything earlier than 3.23 are
rarely compatible between different architectures...you'll need to do a
mysqldump unless you're myisam tables in 3.23.x
regards,
P
On Mon, 15 Jan 2001, Scott
Baker wrote:
> You can use MySQL dump. However, copying the file
To simplify
SELECT Field1, Field2, Field3 ORDER BY Rand() LIMIT 1;
At 10:01 AM 1/15/2001 -0700, Alan Halls wrote:
> On the site Adoption.com we have been using a mysql database to
> set up
>families who want to adopt. We have since redesigned our site and the old
>code is not working fo
New to 3.23 is showing your priviledges when you describe a table. This
throws off the length of my screen. Without altering the source, is there
any way to remove this "feature"?
Thanks
Aaron
-
Before posting, please check:
Hi!
Background:
I have a moderately-sized (0.9G) database which serves as a backend to a
search engine. The search engine is kind of slow, because it has to run
multiple database queries for each user request (don't ask me why). In
order to speed things up, I am thinking of copying the entire d
Stefan,
Your friend has the right idea; proceed with extreme caution. I have heard
(from colleagues that work on this product) that Terminal server(TS) is a
very different animal from the standard or enterprise NT. In fact they have
spent many long nights troubleshooting it. Often there are lots o
Thanks for the fast reply, Neil.
This is exactly the answer I did not want to hear. Now I am afraid
that I have to ask for an "official" statement (Monty, Sinisa?)
If it helps, I can dig out my Licence serial number ...
Stefan
--
Stefan Schmiedl
EDV-Beratung, Programmierung, Schulung
Loreleystr
Rick Pasotto wrote:
>
> On Mon, Jan 15, 2001 at 10:39:15AM -0600, Gerald L. Clark wrote:
> > Rick Pasotto wrote:
> > >
> > > SELECT concat(last_name,", ",first_name) as name from members
> > >
> > > results in a column that is much wider than necessary. Adding trim() to
> > > the concat() nor to
Hello,
We are programming the Control Panel of an Internet Data Center. They are going to
install MySQL for each
user in ther domain and they will assign a port to each installation of MySQL. If it
possible to access the specific intallation of each user in a different port with PHP.
How ca
Thanks for your input Scott. My tables currently do not have indexes. Would
adding indexes to the tables fix the problem. Or do I need to drop the
tables and create them again with indexes. I tried to use the check command:
CHECK TABLE test_table FAST QUICK;
but it returned this error.
ERROR 10
Appreciate everyone's help...using the MEDIUMBLOB should suffice my
needs...actually I try to keep images under 50kb, so I thought the BLOB
would work. It did until I began using images over ~40kb. It would nice to
know if it is an OS reporting limitation or with mySQL.
Thanks Ben
Gerald E Buck
Hello,
What is your favorite Windows MySQL GUI client? I'm developing a database
driven website and I'm looking for a program that I can use to maintain
the database.
One of my special requirements is that I need a client that can edit text
blobs. So far the clients I've seen display the text b
A RAM disk might work under the Linux 2.4 kernel. The subject was discussed on
Slashdot..
http://slashdot.org/askslashdot/00/09/19/0528207.shtml
...but what are you running this on? Is the DB server only serving the database?
Would be interested to know what you find out.
Donal
On Mon, 15
Hello Michael,
We used to handle around that much traffic a few months back. Our setup
consists of a MySQL backend with a mod_perl/PHP Apache front end. All our
pages have dynamic content and are built on the fly.
Right now we have a dedicated server with DellHost (D-3200) and it doesn't
eve
From: Anthony Cooke <[EMAIL PROTECTED]>
Date: Mon, 15 Jan 2001 10:33:05 -0400
To: Arthur Radulescu <[EMAIL PROTECTED]>
Subject: Re: 2 questions!
Two answers!
1. Answer: Read "Chapter 12.6: Other optimization tips". In essence let
the file system cache image files, store only the file name.
Could you describe what exactly software connects to MySQL in your case?
Maciek
> -Original Message-
> From: Denis Gasparin [mailto:[EMAIL PROTECTED]]
> Sent: Monday, January 15, 2001 6:00 PM
> To: [EMAIL PROTECTED]
> Subject: What does this mean ?
>
>
> From when I installed the mysq
I would like to log connections to a file (e.g. the connection info
provided using the --log option) but I don't want every query logged as
well, or at the very least would like them to go to a different file. Is
there any way to do this?
Jamie
---
>I got a problem in converting the Jan 21 2001 format to 2001-01-21
>I always got a null as result when i do date_format('Jan 21
>2001','%Y-%m-%d')
>
>can anyone help me with this
Sir, off the top of my head, I don't think there's a function for
this. Date_format() converts from MySQL format to
I currently have my database on a ramfs (supported by kernel 2.4.0) on a production
environment.
I have also used ramdisks, although they seem to have a 512Mb limit, even though you
can make more than one (before using ramfs I had 2 ramdisks).
Bye,
Enea
-Messaggio originale-
Da: [EMAIL
my.anse.de
Scott
At 01:08 PM 1/15/2001 -0500, Philip Mak wrote:
>Hello,
>
>What is your favorite Windows MySQL GUI client? I'm developing a database
>driven website and I'm looking for a program that I can use to maintain
>the database.
>
>One of my special requirements is that I need a client t
Although it is not strictly speaking Windows MySQL GUI client, I'd like to
recommend PHPGen (http://opensource.aventus.org/phpgen/phpgen.html) .
It meets all your criteria, but it's not a client, but rather PHP client
program generator. If you happen to have PHP with your webserver, give it a
try
While I'm much more a Perl devotee than PHP, I've been using phpMyAdmin
and am fairly happy with it. If you happen to have PHP available, I'd
give it a try.
On Mon, 15 Jan 2001, Philip Mak wrote:
> Hello,
>
> What is your favorite Windows MySQL GUI client? I'm developing a database
> driven web
Yury,
Can we see the code and queries in question? It may be a better solution to
clean up the queries(and code), perhaps change multiple queries into one
query ...
Indexing the tables would undoubtedly help as well. If they already are
indexed, when is the last time they were re-indexed and clea
The urSQL Utility from http://www.urbanresearch.com/ursql allows you to
easily edit text columns in a multiline text box.
On Mon, 15 Jan 2001, Philip Mak wrote:
> Hello,
>
> What is your favorite Windows MySQL GUI client? I'm developing a database
> driven website and I'm looking for a program
I've been very happy with mascon (scibit.com). Payware with a limited free
version that I think covers all your requirements. I felt it was worth the
price for the real thing. Their support is excellent, as is the incredible
frequency of releaseing updates with significant new features.
Jamie
"Yury V. Bukhman" wrote:
[...]
> Question:
> what is the best way to put an entire database into RAM? I thought of
> using HEAP tables, but they seem to have some limitations, e.g. not
> allowing text column type. Is it possible to just copy an entire data
> directory into RAM? Are there operat
I am beening bombarded by emails...can you please take me off your list
Thank you
Frank
[EMAIL PROTECTED]
I have a table with 2 fields which I, every fifteen minutes, load new data
into. The data is not formatted by me. It comes from an external source, so
when the data is added to the table, the ID doesn´t come in the right order.
The table looks like this:
+-+--+
| ID | headline
Go look at an example in the documentation on how to create an index and
create one on the ID column.
On 15 Jan 2001 20:57:55 +0100, Tobias Talltorp wrote:
> I have a table with 2 fields which I, every fifteen minutes, load new data
> into. The data is not formatted by me. It comes from an exter
I've noticed that most of the really cool new features in MySQL use myisam
tables. My tables are from an earlier version, and are only ISAM.
2 Questions:
1) How do you convert the tables?
2) Will my data be changed or corrupted by doing #1?
Aaron
-
I just downloaded and installed the following files:
MySQL-3.22.32-1.i386.rpm
MySQL-client-3.22.32-1.i386.rpm
MySQL-shared-3.22.32-1.i386.rpm
After installation I ran the mysql__install_db script.
mysqld will not start. The error log is as follows:
/usr/sbin/mysqld: can't create/write to file '
I've just done this myself, and had no problems whatsoever. I upgraded
from 3.22 to 3.23...
1. Compile mysql 3.23
2. Shutdown mysql 3.22 server
3. (Carefully) do a make install of 3.23, ensuring your data files in
~mysql/var are not over-written
4. Restart mysql server (3.23)
5. Go through each t
I would like to set a default value in DATE type column to Date(), but it
doesn't work. Is there a way to do it through column format?
If not, what should I enter in the VB code below (place where I need help
will have )
Private Sub okButton_Click()
Dim db As Database
Dim r
I don't use DBI, but when I connect via 'localhost', the client does not
use an IP
port, but rather uses the MySQL socket file. You must be sure to have
the
second instance of your MySQL server come up with its own socket file,
and
connect to that socket instead of the default one.
The other sol
Aaron,
I sugest that you use this app,
http://www.ocsny.com/main/index.ocs?url=mysqlbackup and then use the dumped
files on the new server to rebuild you db you could quite conceivably br up
within 2 hours...
Cheers,
Mikel
Aaron Schlesinger wrote:
> I've noticed that most of the reall
Any idea why I get this error when I try to create this table on a clean
3.23.30 install on a BSDI box.
This was the output from a mysqldump from version 2.22.32 on a working
database. It will not allow me to recreate my database on the new version.
mysql> CREATE TABLE pp_additional_features (
In the last episode (Jan 15), Aaron Schlesinger said:
> I've noticed that most of the really cool new features in MySQL use
> myisam tables. My tables are from an earlier version, and are only
> ISAM.
>
> 2 Questions:
>
> 1) How do you convert the tables?
Run mysql_convert_table_format, which w
See section 7.39 of the manual. 'when' is a reserved word in 3.23.
--
"There cannot be a crisis today. My schedule is already full."
--Henry Kissinger
> -Original Message-
> From: Alan Halls [mailto:[EMAIL PROTECTED]]
> Sent: Monday, January 15, 2001 15:15
> To: [EMAIL PROTECTED]
Use the timestamp datatype, not date.
At 02:43 PM 1/15/2001 -0600, Apolinaras \"Apollo\" Sinkevicius wrote:
>I would like to set a default value in DATE type column to Date(), but it
>doesn't work. Is there a way to do it through column format?
>If not, what should I enter in the VB code below (
The column type "FLOAT" seems to be flaky in MySQL 2.23.24-beta. I wouldn't mind if it
was a rounding issue but the value 66.66 becomes 66.69 and 77.77 becomes
77.75!
To reproduce the problem follow the steps below:
Step 1: Creat Table
create table TestAmt
(
id int(8) not nu
* Petras Virzintas <[EMAIL PROTECTED]> wrote on 15.01.01 23:55:
> The column type "FLOAT" seems to be flaky in MySQL 2.23.24-beta. I
> wouldn't mind if it was a rounding issue but the value 66.66 becomes
> 66.69 and 77.77 becomes 77.75!
Sounds to me like a typical binary rounding
MySQL only supports constant default values. You'll have to insert
the date explicitly when you create the record if you want to simulate
initialization to now().
Timestamps will update themselves whenever any other field in the
record changes, unless you explictly tell them not to. So they are
I need to know whether the primary key field already has a index on it or we
need to create one.
-Rekha
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the
In the last episode (Jan 15), Rekha Das said:
> I need to know whether the primary key field already has a index on
> it or we need to create one.
In mysql, a "Primary key" is simply implemented by putting a UNIQUE NOT
NULL index on the field. So no, you don't need to explicitly add an
index.
-
Primary key by definition is a unique index.
At 02:33 PM 1/15/2001 -0800, Rekha Das wrote:
>I need to know whether the primary key field already has a index on it or we
>need to create one.
-
Scott Baker - Webster Internet - Network Technician
503.266.8253 -
I have two tables named a and b having around 2000 records each. I have
written a query to retrieve records from these two tables. I have a left
outer join in my query.
My problem is that my query is very slow. It takes around 2 minutes to fetch
all the records. What can I do to make it fast ?
--
does anyone have further thoughts on this? based on some suggestions i
received, i have tried:
- running as root (mysqld --user=root)
- creating a new user and giving it ownership of the whole mysql/*
directory
- reinstalling
- making sure that the user starting mysql always has rwx permissio
Hello,
I've just installed and am running MySQL for a web site that was recently
moved to this box. The previous webmaster did a mysqldump of a database we
need and it has a .sql extension. I've read in the manual where you can
import from a text file but can't seem to find how to import a .sql
Ok, since my quries aren't responding, I've been told to drop the table, create the
table again, and then import the data. The only index on the table is the primary key.
Will it help to add an index for every column to optimize the table? I have queries
that pull data from different columns on
1 - 100 of 139 matches
Mail list logo
