Jeremy Zawodny wrote:
>> Perhaps, but it's not listed here:
>>
>> http://www.mysql.com/doc/manual.php?search_query=handler&depth=0
>
>
> I *think* that only searches the 3.23.xx docs. I just found the same
> thing. :-(
Sure. We do not want to confuse people with manual of incomplete and
Jeremy Zawodny wrote:
> On Sat, Jul 07, 2001 at 07:22:19AM -0700, Ken Sommers wrote:
>
>> Does it make any sense to create an index on the primary key?
>
> Primary Keys are automatically indexed. In fact, you might say that a
> primary key is just a special type of index (it is).
There are som
Michael Collins wrote:
> I could not get the backup to work using the mysql client program. The
> table is a MyISAM type and I have a version (3.23.36) that should
> support the BACKUP TABLE SQL command.
>
> First I created a directory called "dbbackup" and then used the following:
>
> mysql>
citizen wrote:
>
> $ rpm --test -i MySQL-bench-3.23.39-1.i386.rpm
> error: failed dependencies:
> MySQL-DBI-perl-bin is needed by MySQL-bench-3.23.39-1
>
> Where is the "MySQL-DBI-perl-bin" RPM?
ftp://ftp.mysql.com/RPMS/i386 fox example is one place for it.
--
For technical support co
tj marlin wrote:
> you can postpone this problem for a very long time by using an unsigned
> bigint (0 - 2**64-1)
> note i said postpone, not eliminate.
Have you done calculations, how long it takes to reuse all id-s? I have
done :). I bet that auto_increment field will be still young, fresh
On Sat, Jul 07, 2001 at 10:25:45PM -0800, Chris Lott wrote:
>
> The Mysql/Msql book I have from O'Reilly is definitely showing its
> age. I know there are books in the MySQL FAQ, butI am looking for
> recommendations. Any books that stand out as better than others?
Yeah, the O'Reilly folks told
PHP - PHP Essentials by Julie Mooloni is the best book & inexpensive too.
MYSQL - by Paul Dubois - Techmedia is also great.
Nothing can beat the official manuals.
elearn.
php.linuxcampus.net:
C::O::M::I::N::G:S::O::O::N:
The Mysql/Msql book I have from O'Reilly is definitely showing its age. I
know there are books in the MySQL FAQ, butI am looking for recommendations.
Any books that stand out as better than others?
I'm also looking for a good PHP book that is a bit more advanced than the
Beginning PHP book (from
mytop - a `top' clone for MySQL
http://public.yahoo.com/~jzawodn/mytop/
About
mytop is a console-based (non-gui) tool for monitoring the threads
and overall performance of MySQL 3.22.x, 3.23.x, and 4.x servers. It
runs on most Unix systems which have Perl, DBI, and Term::ReadKey
install
Use an index.
--
Jonah Klimack wrote:
>
> Hi
>
> I want to enforce unique records in one of my
> tables.
>
> The table goes like this:
>
> ID INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
> customerID INT UNSIGNED,
> categoryname VARCHAR(20)
>
> With customer ID pointing to a custome
Hi
I want to enforce unique records in one of my
tables.
The table goes like this:
ID INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
customerID INT UNSIGNED,
categoryname VARCHAR(20)
With customer ID pointing to a customers table.
I suddenly realized that one customer could input
the same "category
indexing the entire large text column really drags performance down, and
consumes big hunks of disk space. mysql has a good regexp facility. rtfm
At 10:52 PM 7/6/01 -0700, you wrote:
>Hi Everyone,
>
>I'm writing a script using perl for a search function. I have a large
>text column that I want
there is a way:
delete the column
add the column
then the auto increment will start from 1 up to the number of records.
be careful! if there are records in other tables which refer the records
in this table - the one being modified - those records WILL NOT BE UPDATED.
and now your database i
my only comment on this is that although you appear to have two different
problems - you don't!
pick a single solution to both cases; then when your solution needs
modification, you only have one set of code to change.
this obviously is computer science; only tenuously related to mysql.
At 02
actually you are already using mysql.
what you need to do is specify a database to use.
to see the available databases, type
show databases;
then type
use
note, no ";"
if none of the existing databases are appropriate you must create a
database. but this is another chapter.
they can't access them! are you sure about that?
indeed, if a user is logged on to the web host, he is acting in the
environment imposed by the operating system on the user session. in this
case, the other databases - given that the correct permissions are
established - can not be accessed.
b
$ rpm --test -i MySQL-bench-3.23.39-1.i386.rpm
error: failed dependencies:
MySQL-DBI-perl-bin is needed by MySQL-bench-3.23.39-1
Where is the "MySQL-DBI-perl-bin" RPM?
Thank you.
-
Before posting, please check:
I could not get the backup to work using the mysql client program.
The table is a MyISAM type and I have a version (3.23.36) that should
support the BACKUP TABLE SQL command.
First I created a directory called "dbbackup" and then used the following:
mysql> BACKUP TABLE Example.Import_Web TO '/
$ rpm --test -i MySQL-bench-3.23.39-1.i386.rpm
error: failed dependencies:
MySQL-DBI-perl-bin is needed by MySQL-bench-3.23.39-1
Where is the "MySQL-DBI-perl-bin" RPM?
Thank you.
-
Before posting, please check:
http:/
Brian P Austin wrote:
> Has anyone seen any documentation for using mysqld as a library.
> I am building an "embedded device" on a machZ chipset, and I would really
> like to be able to use mysql for some internal querying of our data
> collection.
> I can get it to run (barely) as is, but need
Richard Gibbs wrote:
> sorry if this is the wrong list
>
> I am a beginner user of mysql, but a few pl I know are very active in
> scripting using mirc, especially gaming using tcp/ip connections to game
> servers to find out various details.
>
> I would like to know how/if I can connect to a m
Thank goodness this is the position. If the capability of
reordering the auto_increment existed, we could potentially
have all of our databases broken by some inadvertant finger trouble.
As you mentioned, there are better ways to handle this perceived
"problem", which appears that the auto_incre
On 07-Jul-01 Michael Collins wrote:
> I understand that any ASCII character can be stored within any of the
> non-numeric type fields. Does this mean just characters 1-255?
>
> What happens if I try to import a non-ASCII character, let say, into
> a VARCHAR field? Is it discarded or will I sim
Michael Collins wrote:
> I understand that any ASCII character can be stored within any of the
> non-numeric type fields. Does this mean just characters 1-255?
No, MySQL supports also multibyte character sets used in Asian countries. This means
much wider range than 256.
> What happens if I
Kif wrote:
> Hi
> ANy idea how i can get my auto_increment fields to renumber themselves after
>deletion of records so that they all get re-ordered and run consecutively from 1 to
>whatever without any numbers missing ?
> Please help if you know how to do this
I think we never will implemen
Hi
ANy idea how i can get my auto_increment fields to renumber themselves after deletion
of records so that they all get re-ordered and run consecutively from 1 to whatever
without any numbers missing ?
Please help if you know how to do this
Thanks
Keith White
On 07-Jul-01 MikeBlezien wrote:
> Our Mysql server was shutdown with the mysqladmin -u XXX -p XXX shutdown
>
> and for some reason we can not restart it and can't make any connections to
> the
> Mysql server. This is on a FreeBSD server. what is the correct procedure to
> restart the Mysql serv
On Sat, Jul 07, 2001 at 10:36:08AM -0700, Michael Collins wrote:
>
> The MySQL manual mentions that the option file should be located at:
> DATADIR/my.cnf for Server-specific options. If I create two separate
> my.cnf files and locate them in the appropriate DATADIR for each of
> these, will there
On Sat, Jul 07, 2001 at 07:22:19AM -0700, Ken Sommers wrote:
>
> Does it make any sense to create an index on the primary key?
Primary Keys are automatically indexed. In fact, you might say that a
primary key is just a special type of index (it is).
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTE
My comments are bellow:
>Pretty much was Siomara says is the way I think, except that I would have
>made the extra table for the two addresses.
SIO: If you are sure that two addresses are enough for your business then I
really don't see the reason to put in an extra table. Keeping it simple
At 10:56 PM +0200 7/7/01, Werner Stuerenburg wrote:
>Hm. I use php and that has a fuction addslashes which does the
>job - it adds slashes for all critical characters. So it
>transforms " to \" - is that what you need?
I am working with a CGI type application that has recently added
MySQL to it
I'm working on two projects for which I'm trying to build in
functionality to localize or internationalize later.
For one project, a large chunk of text would be translated into an
unknown number of languages. For this I'm allowing the text to be a
'text' field in a record, with other fields
I understand that any ASCII character can be stored within any of the
non-numeric type fields. Does this mean just characters 1-255?
What happens if I try to import a non-ASCII character, let say, into
a VARCHAR field? Is it discarded or will I simply not be able to get
into a MySQL field in t
I'm using the procedures outline in my Mini-HOWTO at
< http://users.talstar.com/forager/MySQL-HOWTO.html > and have been for
several versions now without incident. The most important bit is the variable
settings right before running ./configure.
This is interesting info about gcc. I'll see how
Our Mysql server was shutdown with the mysqladmin -u XXX -p XXX shutdown
and for some reason we can not restart it and can't make any connections to the
Mysql server. This is on a FreeBSD server. what is the correct procedure to
restart the Mysql server??
thanks,
Mike(mickalo)Blezien
=-=-=-=-
Hello,
I am new to SQL and just learning.
I have a table of clients and a table of targets. I have a clients_targets
table holding the keys for relating.
I am having troble trying to select clients that are in more than one
target.
Eg. Select c.First_Name, ... From clients as c, clients_targ
I am having trouble reading the ID Field (auto incremented primary key) back
after creating a new record in an update. The new record is created OK but
the ID is not available to me. I have found related advice in the archives
at http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:73847 and
http://list
Bradley Jenkins wrote:
> i get this error when starting MySQL
>
> ERROR 2002: Can't connect to local MySQL server through socket
> '/var/lib/mysql/mysql.sock' (111)
>
> /var/lib/mysql/mysql.sock exists with srwxrwxrwx and user mysql.
There is a possibility that this socket file belonged to RP
I have a need to have two MySQL installations operable on the same
Mac OS X server (which is much the same as a configuration for Linux
or BSD). One is a complete binary installation to a custom location
and the other a complete source installation to the standard
installation location of /usr
I am running MySQL on a LINUX System. I am having trouble starting the
server as a non root user. I set up a non user account and changed the
permissions on the necessary files but I still can't start the server unless
I do it as root. It just hangs there until I abort it. If I installed th
Hung Hing Fai wrote:
>> Description:
>
> mysqld segmentation fault on starting
>
>> How-To-Repeat:
>
> # mysqld
> Segmentation Fault
> # ldd mysqld
> ldd: mysqld: execution failed due to signal 11
>
> Configure command: ./configure --prefix=/usr/local/mysql '-
On Wed, Jul 04, 2001 at 12:01:19AM -0500, ryc wrote:
> It sounds like you are asking for comments reguarding your choice of
> vb/mysql... If that is the case, sure it can be done. The only problem I can
> see if you plan on having end users use this program, they would have to
> install and config
Hi everybody
I am still having problem.. please help
I am able to connect to my remote mysql server
but fail to create, user any database ...
I let you know step by step.. what I have done
1. First I have connected to my remote server through
Telnet.
After becoming root...
I had supplied
Hello,
a purely "calculated field" ;(one that is calculated from present values in
the row), doesn' t need to be stored at all, just calculate it when someone
needs to see the calculated value.
In other words.. you don't have to store it if you can calculate it from the
present existing field valu
Hi everybody
I am still having problem.. please help
I am able to connect to my remote mysql server
but fail to create, user any database ...
I let you know step by step.. what I have done
1. First I have connected to my remote server through
Telnet.
After becoming root...
I had supplied
HI,
Does it make any sense to create an index on the primary key?
Ken
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Fournier Jocelyn [Presence-PC]" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Friday, July 06, 2001 3:49 PM
Subject: Re: Perhaps a stupid question about
Tim Bunce writes:
>
> Perhaps, but it's not listed here:
>
> http://www.mysql.com/doc/manual.php?search_query=handler&depth=0
>
> Tim.
>
Apologies to you both, this has been done in 4.0 branch
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Miliv
Why does it matter? They can't access them, so what harm is there?
> I am sure that it has been asked before. I am running a
> hosting company
> and I am running mysql on a win2k server.
> We don't want any customer to see other db's of any other customer, we
> just want them to see their
"MikeBlezien" <[EMAIL PROTECTED]> writes:
>
>
> I assume this is the correct one to download then:
> mysql-3.23.39-pc-linux-gnu-i686.tar.gz
>
>
> Mike(mickalo)Blezien
>
Yes.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/
I am sure that it has been asked before. I am running a hosting company
and I am running mysql on a win2k server.
We don't want any customer to see other db's of any other customer, we
just want them to see their own db's only. But even if you connect with a
username who has access to only
Hi,
I have come accross my problem with the port forwarding... Thanks to the
help I got.
I needed the flag -n (that tells ssh not to listen on stdin).
So doing the following is working... assuming that you have privileges
without passphrase between the server and the client...
ssh -l username
For those of you Solaris users who are compiling from source:
If you get "checking return type of sprintf... configure: error: can
not run test program while cross compiling" such as in posts:
http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:75993
http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:7635
SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
SEND-PR: will all comments (text enclosed in `<' and `>').
SEND-PR:
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: mysqld segmentation fault on starting
>Description:
mysqld segmentat
Hi
You should use the following construction:
SELECT LAST_INSERT_ID ();
This will return the last auto-increment value for the current connection.
There is also an API function, and in PHP: mysql_insert_id or something like
this.
-Original Message-
From: Jason Brunk [mailto:[EMAIL PRO
54 matches
Mail list logo
