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 that
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 wa
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
>Subje
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 m
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 Solar
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 acces
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
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
--
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 d
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 m
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 master:Can'
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
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 also
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 Hodgkinso
"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
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.
I
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 o
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 mysq
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-
-
Befor
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? Do
>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
('D
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
> --
>
>
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
> create/edi
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 a
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
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 process
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
>
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 Everyb
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
Hi Jason!
Give this a try for the required table you want to produce below...
SELECT Name, Income, Out, (Income - Out) AS Balance
FROM ;
Sam.
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, February 26, 2001 1:45 PM
Subject: MySQL question
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 ModAuthMy
[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:
> Nam
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
On 26.02.2001 13:36:20 Christian Hammers wrote:
> Hello
>
> 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.
-
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 `
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
ÇãÁ¤¼ö 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 answe
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 check:
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 mysql
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 !!
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
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 g
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:
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
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, 20
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
--
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 r
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 admini
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 texi2
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+ o
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
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
> '/var/lib/mysql/my
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
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:
>
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 "--password
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. T
Hi,
Check out MysqlGUI at www.mysql.com
I think it's the best.
But there are a lot of other GUI's.
--
Best Regards / Beste Gru?e
Denis Mettler
http://www.denis-mettler.de
--
Unix is an operating system, OS/2 is half an operating system, Windows
is a shell, and DOS is a boot partition virus.
--
On Mon, Feb 26, 2001 at 10:53:16AM +0100, Joakim Svensson wrote:
>
> 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?
You probably need to ask elsewhere. MySQL doesn't have
>Description:
When I tried to run configure, I got stuck, couldn't find right answer
in your documents. Followed are the last lines on the screen.
loading cache ./config.cache
checking for a BSD compatible install... ./install-sh -c
checking for bison... no
checking for byacc... no
checki
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
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 Menze
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.
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 di
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 PR
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
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:
http:/
Try phpmyadmin in www.phpwizard.com
>From: "Denis Mettler" <[EMAIL PROTECTED]>
>To: "j.urban" <[EMAIL PROTECTED]>
>CC: <[EMAIL PROTECTED]>
>Subject: Hi,AW: LOOKING FOR A FRONTEND FOR MYSQL
>Date: Mon, 26 Feb 2001 17:13:55 +0100
>
>Hi,
>
>Check out MysqlGUI at www.mysql.com
>I think it's the best
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
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 possib
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 _one
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
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
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.
>
> 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 vio
> 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.
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 di
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 si
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
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 -
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 = "tbl
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 ea
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 thread,
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:
http://
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 do
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 descrip
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 username.
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 [
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 d
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 do
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
> a
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 s
-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 set
From: lmfitzg
To: [EMAIL PROTECTED]
Subject: [50 character or so descriptive subject here (for reference)]
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:
>Organization:
>MySQL support: [none | licence | email support | extended email support
]
>Synopsis:
>Severity: <[
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
--
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
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:
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, an
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
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 chec
I'm using 3.22.23 :/
I think I may have to implement my own auto_increment to capture deleted
id's.
Thanx.
John
-Original Message-
From: Atle Veka [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 26, 2001 1:53 PM
To: John Tsangaris
Cc: [EMAIL PROTECTED]
Subject: Re: auto_increment
1 - 100 of 159 matches
Mail list logo
