Select a Random record

Dear MySQL masters, Is there any way to display a random record from a table. If there are no direct SQL commands can you pls suggest a logic for doing the same. Details: There is a table of 200 records. The user must be able to select a record randomly. Once that record is displayed then

Re: Can't drop tables me too, please send help...

At 8:15 PM -0700 2/25/01, Geoff Coffey wrote: I just installed mysql 3.23 and then ran a script to create a database I had previously been using in an older version. I have a couple questions. First, how can I make a drop database statement not fail if the database doesn't exist. A book I was

Re: can create, cannot drop...?

but Rolf.. if i can create wouldn't that indicate permission to drop also? thanx At 10:01 AM +0800 2/26/01, Rolf Hopkins wrote: Suggestion: Check file permissions. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, February 25, 2001 12:33 Subject: can

MySQL performances?

Hi, does any one used MySQL in real environment with big databases and a big number of connections? If yes, what's the hardware config? Thanks -- - Before posting, please check: http://www.mysql.com/manual.php (the

RE: missing library libz.so

No this is on an Apache server... running on BSDI BSD/OS 4.01 thanks -Oorspronkelijk bericht- Van: Brady Orand [mailto:[EMAIL PROTECTED]] Verzonden: maandag 26 februari 2001 3:21 Aan: Rutger Beens; [EMAIL PROTECTED] Onderwerp: Re: missing library libz.so I'm assuming this is on

Re: Setting access rights

The "%" in the first command to User table spoils it all. It means logging from ffrom any host is valid . Remove that command. It'll work Cheers Donald - Original Message - From: David Hulka To: [EMAIL PROTECTED] Sent: Monday, February 26, 2001 1:28 AM Subject: Setting

Mail()

rtfm in all honour ,but I use PWS and win98... How do I get the mail() function to work... What do I need? Do I need anything diffrent if I'm uppgrading to win2000? /Joakim Svensson

Re: MySQL performances?

Mohamed Sadok MOUHA schrieb: Hi, does any one used MySQL in real environment with big databases and a big number of connections? If yes, what's the hardware config? http://iworld.compaq.de -- http://it97.dyn.dhs.org -- IrmundThum

can sorting be avoided

Hello, I have a table which keeps a list of of clients. When a new client is to be added to the list I want it to be added to the first row of the table so that I will have a list of clients with the most recent arrival at the top and the least recent at the bottom of the table. I know I can

set password

The documentation describes the use of "set password = password ('newpass') as: "PASSWORD = PASSWORD('some password') Set the password for the current user. Any non-anonymous user can change his own password!" Well, nice I thought, a user can change it's password without having access rights to

replication error message question

I have two mysql servers, setup to replicate each other. However, every so often, one or both starts logging; 010226 9:40:27 Slave thread: error connecting to master:Can't connect to MySQL server on '0' (11)(107), retry in 0 sec 010226 9:40:27 Slave thread: error connecting to

Re: can sorting be avoided

Edd, mySQL, like any other RDBMS, does (and can not) not insert data in a guaranteed order into a table. While mySQL might usually insert the most recent record "last" in a table, you should never rely upon the fact. Refusing to sort your data on the basis of system load sounds a little strange

MySQL, Linux and Hardware config

We plan to use MySQL in a database of more than 200 000 client. Every client has about 1000 bytes of information (stored in 40 fields). The number of simultaneos connections could reach 1000. With such environment, what di you requires as OS? Does Linux RH 6.2 is ok? Does MySQL is

Re: MySQL as spider database.

Vahan Yerkanian [EMAIL PROTECTED] writes: My task is to implement several custom word parsing/modification before writing the keywords into the database, as well as I just want to have my own code ;-) Ah, OK. You could always just hack the spidering part of ht://Dig? -- Dave Hodgkinson,

Re: Server Tuning

"Florian G. Pflug" [EMAIL PROTECTED] writes: Hi I am running Mysql on a Machine with two PIII-600, and 1 GB of RAM. The disks are connected via U2W-SCSI. I tried tuning mysql for maximal performance the last days, but I'm not exactly sure which parameters I should increase, und to what

LOOKING FOR A FRONTEND FOR MYSQL

Hi everyone, Is there a front-end available for Mysql. I am currently using Mascon as an administrative front-end, which is very good. However I need a front-end with less administrative features, something where-by users can create/edit/drop tables - therefore it has to be very easy to use.

ORDER BY optimisation

Hi list, I have some trouble trying to optimise SELECT queries that use ORDER BY condition. I have found out that each time the server is busy (100% CPU usage), it is due to queries that show up in 'mysqladmin processlist' report with 'Sorting result' state in 'Command' column. I am trying to

Re: MySQL Gui Won't connect

Christopher McClan writes: Hello, The staticly compiled mySQL gui, comes up with the following when I start mysqlgui : Can't connect to local mySQL server through socket (111) I'm doing this as root, I have set a password, and managed to create a databse (using mysqladmin),

tab-completition not working with libreadline4

Hello Since a few weeks tablename completition using tab is not working any longer. I build with bundled lbireadline and with my system libreadline (4.2) but neither work as I am used to. Any ideas? bye, -christian- -

Re: MySQL, Linux and Hardware config

Mohamed Sadok MOUHA a crit : We plan to use MySQL in a database of more than 200 000 client. Every client has about 1000 bytes of information (stored in 40 fields). The number of simultaneos connections could reach 1000. With such environment, what di you requires as OS? Does

Error in select .... from.... where... with BDB

Description: I made a table: CREATE TABLE parametry ( SYMBOL varchar(30) DEFAULT '' NOT NULL, WART blob DEFAULT '' NOT NULL, PRIMARY KEY (SYMBOL), UNIQUE SYMBOL (SYMBOL) ) type=BerkeleyDB; then I put some values in it: INSERT INTO parametry (SYMBOL, WART) VALUES

Re: MySQL performances?

Well what exactly do you consider big? Mohamed Sadok MOUHA wrote: Hi, does any one used MySQL in real environment with big databases and a big number of connections? If yes, what's the hardware config? Thanks --

Antwort: LOOKING FOR A FRONTEND FOR MYSQL

On 26.02.2001 12:54:02 MANGERA, Faizal wrote: Hi everyone, Is there a front-end available for Mysql. I am currently using Mascon as an administrative front-end, which is very good. However I need a front-end with less administrative features, something where-by users can

RE: Error in select .... from.... where... with BDB

It would seem that you are getting the character corresponding to the ASCII code 53 as the result of the first query. Try inserting the value for logo in your table without the quotes round the 53 and see if the results of the queries become consistent. IMHO this is a bug because the two queries

MySQL question to ask

Dear all, Sorry to ask question again, or maybe i am just a beginner. I wanna ask: If there are 2 records Name Income Out Data1 1000 700 Data2970500 If i want to have the output: Name Income Out Balance Data1

mysql process running

Hi Everybody, I am a web developer (Apache ,Perl Mysql) , I am facing a problem , i have a program that runs a query on a text field and displays results , but since the database is huge sometimes apache sends a timeout to the client(browser) but my problem is that when i check the

Re: MySQL question to ask

select Name,Income,Out,(Income-Out) as Balance from tblname On Mon, 26 Feb 2001 [EMAIL PROTECTED] wrote: Dear all, Sorry to ask question again, or maybe i am just a beginner. I wanna ask: If there are 2 records Name Income Out Data1 1000 700 Data2

RE: mysql process running

Hi there Kiran We had the same problme and we found that updating ModAuthMySQL solved the problem.. Hope this helps... Simon -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 26 February 2001 13:27 To: [EMAIL PROTECTED] Subject: mysql process running Hi

Re: mysql process running

As far as I know, this is on the wishlist, but has not been implemented - ie, a thread should die if the client disconnects. You'll probably need to run mysqladmin kill xxx, where is the offending thread id. regards, P On 26 Feb 2001 [EMAIL PROTECTED] wrote: Hi Everybody, I am a

Re: MySQL question to ask

Hi Jason! Give this a try for the required table you want to produce below... SELECT Name, Income, Out, (Income - Out) AS Balance FROM tablename; Sam. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, February 26, 2001 1:45 PM Subject: MySQL

RE: mysql process running

Oh... Isn't ModAuthMySQL used for HTTP authentication against a mysql database ? I can't see how that could influence queries running from within a mod_perl/CGI script... P On Mon, 26 Feb 2001, Simon Green wrote: Hi there Kiran We had the same problme and we found that updating

Re: MySQL question to ask

[EMAIL PROTECTED] a crit : Dear all, Sorry to ask question again, or maybe i am just a beginner. I wanna ask: If there are 2 records Name Income Out Data1 1000 700 Data2970500 If i want to have the output: Name

Re[2]: More Innobase questions (Was: RE: Innobase)

Hi! There were more questions about Innobase: Here is the comming question - can you speak some more about apace allocation consepts used in innobase. For example how would it like to work with huge number (10.000+ of the tables) and how space allocation The data dictionary is hashed, a huge

Re: More Link Probs

Alec Solway wrote: Hi, My problems with open64 and fopen64 have been solved by using a newer version of glibc, however now I get the following errors when trying to link the MySQL C Client API library with my program. /usr/lib/mysql/libmysqlclient.a(my_compress.o): In function

Re: MySQL question to ask

His balance is a running balance... Joseph, you will have to keep the running balance in some thing that you write to get the query.. you can't do a running sum in SQL directly. You can only use the examples people provided to get the net per line. Joseph Bueno wrote: [EMAIL PROTECTED] a

Re: Replication question!

wrote: Hi... I Have a Master(version 3.23.33) and one Slave(version 3.23.32) When I shutdown the slave, And make some change Master. then I restart the slave. But, Slave didn't catch the change on Master. bug or feature? thank you for advanced answer. 3.23.32 has a

XML interface to MySQL

Hi list, does anyone know of an XML interface to MySQL which would enable me to import or export data using the XML language definition? Many thanks for any hints! Kind regards, Claude Hoffmann - Before posting, please

Re: Can't find ./mysql/host.frm when starting mysqld

ben foo wrote: I have mysql-server-3.23.22.6 and mysql-3.23.22.6, packages installed on my PC during Linux RedHat 7.0 installation. The problem occurs when starting mysqld program : The command : mysql install db is OK but the command : safe mysqld starts the server mysqld witch

Re: where clausel with float

Helmut Ebelt wrote: I have some kind of floats(8,2) in my table and want to make an query ... Select * from tablename where floatthing = '21999.00'; 0 rows ! Select * from tablename where floatthing = 21999.00; 0 rows !! but there ARE result !! can anybody help me !! please

Newbie DATESTAMP problem

Hi All This is my first post of possibly many to this list. I am having a problem with trying to display time related content to a page. I initially setup the column with a 10 digit timestamp but found out that the date_sub function works with DATESTAMP data type. I only have 8 rows of test data

Re: cant connect except as root

Willie Strickland wrote: I have just installed MySQL for the first time on my RedHat linux 7.0 machine. I thought it all went fine and was working. However, now I realize that only root can start the client program mysql (or the server program for that matter, but I figure that is a good

Antwort: Error in select .... from.... where... with BDB

On 26.02.2001 14:19:40 TisSoft s.c. wrote: PRIMARY KEY (SYMBOL), UNIQUE SYMBOL (SYMBOL) What's the sense of this? PRIMARY is already UNIQUE, so you don't need to UNIQUE symbol again. - Before posting, please check:

Re: importing data from excel

On Thu, 4 Jan 2001, TEXLID_SUPPORT wrote: Could anyone please let me know how I can transfer data from excel to a mysql database? If it is possible. The data is stored in an excel file on my PC. And I want to transfer the contents (about 500 records with 20 fields) of this excel file to a

Re: can create, cannot drop...?

Actually, at the file system level, yes, you're right. But database level security, not necessarily. Check you have the right permissions for a start - Original Message - From: [EMAIL PROTECTED] To: "Rolf Hopkins" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, February 26, 2001

Berkeley DB and mysql

I recently tried to build mysql version 3.23.33, with support for Berkeley DB. I was using BDB version 3.2.9, and was unable to compile mysql with this version of BDB. Is this a known problem, an if so, what version of BDB should I use with mysql? Thanks in advance. Bill

RE: Random record

You have to have version 3.23 of mysql and then you can add ORDER BY RAND() to the end of your query. Alan -Original Message- From: joe [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 25, 2018 4:40 PM To: MySQL Subject: Random record Does anyone have any good ideas on how to pull a

Re: LOOKING FOR A FRONTEND FOR MYSQL

You might have a look at urSQL - www.urbanresearch.com/ursql On Mon, 26 Feb 2001, MANGERA, Faizal wrote: Hi everyone, Is there a front-end available for Mysql. I am currently using Mascon as an administrative front-end, which is very good. However I need a front-end with less

RE: Printed MySQL manual

On Mon, 19 Feb 2001, Don Read wrote: On 20-Feb-01 Denis L. Menezes wrote: Can anyone please advise how I can obtain a printed copy of the MYSQL manual? $ cd /usr/local/share/doc/mysql $ lpr manual.txt Denis, Don, The source of the manual is in texinfo format. Why not use texi2dvi to

Re[3]: More Innobase questions (Was: RE: Innobase)

Hello Heikki, Monday, February 26, 2001, 5:08:52 PM, you wrote: HT Hi! HT There were more questions about Innobase: Here is the comming question - can you speak some more about apace allocation consepts used in innobase. For example how would it like to work with huge number (10.000+ of the

Security annoucement mailing-list ?

Hi, is it possible to create (I don't think it already exists) a mailing-list just for security problems about MySQL. I'm very concerned about the security of my web sites, and I rely on MySQL to provide dynamic content. So, for the moment, I must subscribe to the general list and receive tons

Re: MySQL 3.23.32 / SuSE Linux 7.1 / php and normal user

On Wed, 21 Feb 2001, Hagen Hoepfner wrote: I can normaly use mysql if I am root. But if i'm logged in as normal user or try to connect to mysql via php i got the following error message: MySQL Connection Failed: Can't connect to local MySQL server through socket

Re: problem with blob

I am having exactly the same problem. Does anyone know what is causing this? Thanks Mike jenkins - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

Antwort: MySQL question to ask

On 26.02.2001 14:45:50 Dart wrote: Dear all, Sorry to ask question again, or maybe i am just a beginner. I wanna ask: If there are 2 records Name Income Out Data1 1000 700 Data2970500 If i want to have the output: Name

Problem starting MySQL

I've tried to install MySQL in all the different ways (binary, source and rpm) on my RH v6.2 but end up with the same result. After install I try to start safe_mysqld (safe_mysqld -user mysql ) but it shuts down immediately afterwards. I check out the error log and it tells me that

Re: can create, cannot drop...?

on 2/26/01 8:07 AM, Rolf Hopkins at [EMAIL PROTECTED] wrote: Actually, at the file system level, yes, you're right. But database level security, not necessarily. Check you have the right permissions for a start At least in my case, the drop _almost_ succeeds. The table files are deleted.

Re: missing library libz.so

Hi Rutger, The problem is you can't just drop the library anywhere. I am guessing from you message that you do not have root privleges on the server. I doubt that you will be able to add a shared library without root access. The second problem I see you may have is the the binary was compile

Re: Error while trying to run binary mySQL on FreeBSD4.0

Drew, the binary was compile for BSDi 4.2, if you have gcc 2.95 installed try compiling from source. You will have other problems though as there are many bugs with threads on 4.0 BSDi. Is there any way you can upgrade to 4.2? Ken - Ken

Re: Antwort: tab-completition not working with libreadline4

On Mon, Feb 26, 2001 at 03:02:41PM +0100, [EMAIL PROTECTED] wrote: Since a few weeks tablename completition using tab is not working any longer. Are you sure that the table information is actually read at start of mysql? Do a 'rehash' and see if it works then. Cool that helped, thank you.

mysql.server ignoring my.cnf?

I'm running mysql 3.23.33 on debian. I'm using /etc/init.d/mysql.server to start up and shut down mysql server. My configuration file is /etc/mysql/my.cnf. In that file, I've set my socket as follows: socket = /var/run/mysqld/mysqld.sock When mysql starts, it seems to ignore this

RE: Security annoucement mailing-list ?

Hi all I find the MySQL mail service very useful but he has a point hat due to the number of e-mails form this list it mite be an idler to split things up a bit? Simon Green ISE -Original Message- From: Nicolas GREGOIRE [mailto:[EMAIL PROTECTED]] Sent: 26 February 2001 15:34 To: [EMAIL

Re: Redhat 7 newbie.....

Thomas O'Neill wrote: I just installed Redhat 7.0 and MySql while i was at it. But the deamon is not running. I get the ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) when i try to use the client. Could someone please clue me in as to

using parameters

HI, Is it possible to do a select-statement like this: select * from @parameter ? Thanks, Marijke Find the best deals on the web at AltaVista Shopping! http://www.shopping.altavista.com - Before posting, please check:

Re: Berkeley DB and mysql

Bill Rossi wrote: I recently tried to build mysql version 3.23.33, with support for Berkeley DB. I was using BDB version 3.2.9, and was unable to compile mysql with this version of BDB. Is this a known problem, an if so, what version of BDB should I use with mysql? MySQL rolls its

LIMIT usage

Hi, I currently use a SELECT that looks like: SELECT field FROM some_table WHERE some_condition ORDER BY some_date DESC LIMIT 2000 in order to get the most recent records from some_table. Since it is not possible (yet) to optimise an ORDER BY ... DESC by using an index; is it

Re: Berkeley DB and mysql

Hi, I get an error at "make install" because mySQL did not correctly modify BDB's Makefile (which has been slightly changed). mySQL tries to modify the "install" target of the Makefile so that ist does only contain install: all instead of additional "install_xxx"'s. Previously there was

Re: Patching w/o the compiler was Re: Replication time patch

On Fri, Feb 23, 2001 at 03:35:06PM -0800, William R. Mussatto wrote: Your reply triggered a question? If you are on a win32 box and using the binary builds, what is the proceure for getting these patchs? Last time I checked the site is was still showing 3.23.33 as the current release?

GUI

Hi from the UK, Firstly just let me say how cool and NON microsoft MySQL is. It is a BRILLIANT PIECE OF SOFTWARE. Second - help!! I have just downloaded Win32 static binary of MySQLGUI 1.7.4-2 onto my (sadly) IBM PC and when I've unzipped it and run it, it asks for a password. (I may have

Re: Security annoucement mailing-list ?

On Mon, Feb 26, 2001 at 04:34:20PM +0100, Nicolas GREGOIRE wrote: is it possible to create (I don't think it already exists) a mailing-list just for security problems about MySQL. I'm very concerned about the security of my web sites, and I rely on MySQL to provide dynamic content. So,

Help Installing MySQL

I keep getting errors trying to install Mysql 3.23.33 on a Digital Unix 4.0d alpha box. I am using gnumake 3.79.1 and gcc 2.95.2. The error message is as follow: g++ -O3 -DDBUG_OFF -fno-implicit-templates -o mysqlbinlog mysqlbinlog.o mini_cli ent.o net_serv.o mini_client_errors.o violite.o

Re: Security annoucement mailing-list ?

I'd rather see them sent to the MySQL announcements list. It is already VERY low-traffic, and that seems like appropriate content. No sense creating another list just for the VERY occasional announcements when we already have one [mostly] for that purpose. It seems to be a good idea. My

mysql.server ignoring my.cnf?

I'm running mysql 3.23.33 on debian. I'm using /etc/init.d/mysql.server to start up and shut down mysql server. My configuration file is /etc/mysql/my.cnf. In that file, I've set my socket as follows: socket = /var/run/mysqld/mysqld.sock When mysql starts, it seems to ignore this

Replication

I would try running multiple MySQL servers on your backup host machine, where each one is a slave to its own respective master DB. I think that keeps maintenance of replication/recovery/restore scenarios much cleaner. If your Master DB A breaks, what you have to do to recover it from Slave A is

Re: LIMIT usage

On Mon, Feb 26, 2001 at 06:19:46PM +0100, Joseph Bueno wrote: Hi, I currently use a SELECT that looks like: SELECT field FROM some_table WHERE some_condition ORDER BY some_date DESC LIMIT 2000 in order to get the most recent records from some_table. Since it is not

mcrypt and encrypted field length

Please see my questions below - I asked the PHP list and no-one responded. Basically I'm new to "mcrypt" and I'm trying to use mcrypt and PHP with MySQL - I'd like to encrypt a 20-character field and store the result in a MySQL column, but I'm not sure 1. what data type to make the column -

clever head needed

Hi there! If any of you have tried the following with ASP/ADO and MySQL, please inform me of how you did it: I use ASP and adodb.recordset to connect to a MySQL-database. I use the following code to insert into the db: [CODE START] set rsGroup = server.CreateObject("adodb.recordset") sql =

a query which cannot be fast even theoretically?

Your table bb is not indexed in a way that helps this query. Creating an index on min_number may help somewhat. If your intervals DON'T overlap each other, there's probably a much better algorithm for you to use than an SQL join. (e.g., select each number from aa in sequence, form a query for

mysql.server ignoring my.cnf?

Tried /etc/my.cnf in place of /etc/mysql/my.cnf ? Cheers, Kent - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this

mysql.server ignoring my.cnf?

Sorry. Sent the last message before I was done If you have a stray $DATADIR/my.cnf or a $HOME/.my.cnf, their contents will override what you have set in /etc/my.cnf. Cheers, Kent - Before posting, please check:

Re: mysql.server ignoring my.cnf?

I tried /etc/my.cnf and got the same results. As far as $DATADIR or $HOME are concerned, I don't see them when I do 'printenv'. Is there another way to find out if those may be set, and by what? thanks. At 02:33 PM 2/26/01 -0500, Kent Hoover wrote: Sorry. Sent the last message before I was

HAVING clause malfunction; probable bug

2001 Feb 26 Problem: HAVING clause malfunction I get wrong results when using certain combinations of filtering conditions in the HAVING clause. I'm calculating the total number of nights (Nights) and the average number of nights (AvgNights) that travelers stay in hotels. Below are the

Database Permissions

Greetings, I'm having a little trouble understanding how the permissions work within mySQL. I have 3 current databases. The first is the default mysql database, and the other 2 are ones that I have created. I want to be able to grant access to each table individually based on

Re: Security annoucement mailing-list ?

Hi! On Feb 26, Nicolas GREGOIRE wrote: I'd rather see them sent to the MySQL announcements list. It is already VERY low-traffic, and that seems like appropriate content. No sense creating another list just for the VERY occasional announcements when we already have one [mostly] for

Re: MySQL, Linux and Hardware config

Check under ulimit to raise the number of file descriptors. ulimit -n # Linux has a global limit (4096 in debian' case) which may also be raised. However, as someone else has recommended, look at shortening the time you are actually connected. Connect, get data, disconnect, process

Compatable SQL for indexes

Hi, I am tring to find the most compatable way to write CREATE TABLE statments between mySQL and Postgress. Postgress has a CREATE INDEX as does mySQL, but I would like to be able to create Primary Keys and Indexes in the CREATE TABLE statment. The problem I am running into is that Postgress

Re: mysql.server ignoring my.cnf?

make sure that you set the sock parameter in both the [client] and [mysqld] sections of the configuration file. This is one of my favorite errors :-/ Best, Kyle On Monday 26 February 2001 12:04, Joel Gwynn wrote: I tried /etc/my.cnf and got the same results. As far as $DATADIR or $HOME

Re: mysql.server ignoring my.cnf?

While that is definitely the kind of pinheaded mistake that I'm used to making, that's not what's happening. I just looked at the file again and mysql.server is also ignoring things like the pid file and the log file :( thanks anyway At 12:51 PM 2/26/01 -0800, you wrote: make sure that you

RE: Join causing Error?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Maybe this will help: Break the query up into a variable so PHP can string it together better. Exec. the query, check the result, if good, check the results for rows, if results, display results, else, do nothing, if query faield, set err to 1 and

load large data files?

From: lmfitzg To: [EMAIL PROTECTED] Subject: [50 character or so descriptive subject here (for reference)] Description: precise description of the problem (multiple lines) How-To-Repeat: code/input/activities to reproduce the problem (multiple lines) Fix: how to correct or work around the

auto_increment

If I turn on auto increment and let it do it's thing and then later on delete a few of the entries (let's say 1, 2, 3) and the current high entry has an id of 45.. why does mysql continue with 46 instead of using up 1, 2, and 3 first? Is there a way to bypass this? John

Re: auto_increment

what version of mysql are you using? AFAIK, this behavior is only supported in 3.23.x Atle On Mon, 26 Feb 2001, John Tsangaris wrote: If I turn on auto increment and let it do it's thing and then later on delete a few of the entries (let's say 1, 2, 3) and the current high entry has an

Re: Patching w/o the compiler was Re: Replication time patch

Thanks that was the answer I was looking for. On our Linux side we can copile, but I'm doing development work at home on win2k and I don't have a current compiler (perl and java don't need C compilers). On Mon, 26 Feb 2001, Thimble Smith wrote: Date: Mon, 26 Feb 2001 12:43:13 -0500 From:

Re: auto_increment

On Mon, Feb 26, 2001 at 04:23:23PM -0800, John Tsangaris wrote: If I turn on auto increment and let it do it's thing and then later on delete a few of the entries (let's say 1, 2, 3) and the current high entry has an id of 45.. why does mysql continue with 46 instead of using up 1, 2, and 3

Re: auto_increment

John Tsangaris wrote: If I turn on auto increment and let it do it's thing and then later on delete a few of the entries (let's say 1, 2, 3) and the current high entry has an id of 45.. why does mysql continue with 46 instead of using up 1, 2, and 3 first? Is there a way to bypass this?

Re: mysql.server ignoring my.cnf?

Joel: I'll take another shot. Do you have spaces in your command? Remove them. Change : socket = /var/run/mysqld/mysqld.sock To: socket=/var/run/mysqld/mysqld.sock Cheers, Kent - Before posting, please

MySQL driver - ClassNotFoundException

Hi, I'm new to MySQL database. I downloaded MySQL database version 3.23.32 and I create a table in the database (database name is "test_data" and the table name is "data"). Then I download the driver MyODBC 2.50.36 for NT(full setup) and fill out the table. I wrote a servlet program (run on

please urgent

I have downloaded the leatest ver of php, php 4.04pl1, I am runing winnt 4.0, acording to the info for this ver of php this ver has all the odbc connetciones incluided, the ver 3.0 has a library called php3_oci80.dll wich is used for conections to oracle 8, where can I find all the librarys

RE: Database Permissions

Jason There are 5 layers to access control in MySQL that are checked to see if a query can be executed. Starting from the most generic these layers are: User -- Db (and Host) -- Tables_priv -- Columns_priv The first layer that is found to have adequate privileges will cause the query to

Help with a seg fault

bash-2.04# ./mysql.server stop Killing mysqld with pid 11564 010226 15:59:55 mysqld ended bash-2.04# ./mysql.server start bash-2.04# Starting mysqld daemon with databases from /usr/local/mysql/var /usr/local/mysql/bin/safe_mysqld: line 254: 11600 Segmentation fault $NOHUP_NICENESS

RE: auto_increment

Just curious, is there a specific business rule that requires you to have a contiguous list or do you just not like holes in the list? Cal http://www.calevans.com -Original Message- From: John Tsangaris [mailto:[EMAIL PROTECTED]] Sent: Monday, February 26, 2001 7:12 PM To: Atle Veka;

RE: auto_increment

I'm converting a product over to mysql from flat file. The guru of the perl/flat file asked about it (he's my senior) so I had to check into it because the flat-file system reused deleted numbers. If it's not worth the work to change it then I tell him it's not worth the work to change it. :)

  1   2   >