Did you try it?
What happened?
John Nielsen wrote:
>
> Hey everyone,
>
> This may have already come up a couple of times in the mailling list, but I
> I was wondering with mysql-3.22.32 if you can have two auto_increment's
> in one table, e.g.:
>
> +--+--+--+-+
Hello Sinisa,
Thursday, March 01, 2001, 3:42:46 PM, you wrote:
SM> > I'm not really shure if this is a bug or correct behavior, but still
SM> > it leads to toe problems in this case:
SM> >
SM> > insert into g02layers_stat_hits set counter=1, type=1, page_group=1;
SM> > ERROR 1062: Duplicat
> > Why not use a timestamp column to guarentee the order in which rows get
> > inserted into the table? You can then order on the timestamp column.
>
> Hmm, timestamp, ie. seconds as finest resolution, might be to broad
depending on
> the hits his site will get - imagine that 2+ users access the
Dear Sir
I am a regular user of MySql. I will be obliged if you help me.
1. The path of the data directory is
/var/lib/mysql
2. The database name is 'directory'
3. The permissions of directory are
drwxrwxrwx2 root root 4096 Mar 1 16:24 directory
4. All the files in the director
Marcos wrote:
>
> hi,
>
> i have a table like that:
>
> CREATE TABLE user ( login varchar(50), pass varchar(50), PRIMARY
> KEY(login));
>
> i have lot of info inserted already in that table. And i would like
> to add some more attributes. how can i do it, in order to maintain o
On 01.03.2001 12:35:55 Gorjan Todorovski wrote:
> So does mySQL support transactions or not? There are transaction safe tables
> but they are not actually implemented?
They are implemented, if you chose the right table type.
---
Michael,
IMHO, if you are looking for a desktop database, something built around a
.dbf file would be a more suitable choice. (My personal fav is FoxPro even
though it's a M$ product) MySQL, while it probably can be made to do this,
is not designed to do this.
Cal
http://www.calevans.com
-
hello friends
I downloaded the latest mysql(3.23.33) and installed on my win98 PC(intel,
PII 500, 128RAM) and dusing the installation, I got the following error :
An error occured during the move data process : -132
Component:
Filegroup:
File:
I proceeded by ckicking "OK" and then, after insta
hi,
i have a table like that:
CREATE TABLE user ( login varchar(50), pass varchar(50), PRIMARY
KEY(login));
i have lot of info inserted already in that table. And i would like
to add some more attributes. how can i do it, in order to maintain older
info?
drop the table.
On 01.03.2001 11:55:40 Ben Kennish wrote:
> "Warning: MySQL Connection Failed: Can't connect to local MySQL server
> through socket '/var/lib/mysql/mysql.sock' (111) in
> /var/www/html/index.php on line 5"
Are you sure that your MySQL installation creates the socket right there? If
I'm not mis
On 01.03.2001 11:56:59 Richard Ellerbrock wrote:
> Why not use a timestamp column to guarentee the order in which rows get
> inserted into the table? You can then order on the timestamp column.
Hmm, timestamp, ie. seconds as finest resolution, might be to broad depending on
the hits his site wi
I am confused.
I run a Slackware 7.0 system, with glibc (runtimes and source
libraries) upgraded to 2.1.3 from 2.1.2. Compiler is egcs 1.1.2 (gcc
2.91.66)
I have tested the following with this exact setup on 5 different
computers by now and I get random results:
mysql-3.23.32 source tarba
How do I set up a field called Minutes which has the (default) value, where
round((SessionTime+30)/60) = Minutes
Is it possible to set this up? In other databases (Alpha Five) I would have
used a Calculated Field attribute to achieve this.
Can MySql handle it.. ???
--
Daniel M O Higgins
Blaz Grapar wrote:
>
> Is there a boolean field type (Yes/No; True/False, 1/0) in MySQL or what is closest
>to the boolean type
ENUM("no","yes")
-
Before posting, please check:
http://www.mysql.com/manual.php (the manu
Dear support group of MySQL,
When I use MySQL for Windows with languages like Ukrainian, Rassian I can't use case
insensitive select, or operator like Upper.
Can you help me?
Becouse I understand that I mast recompile server, is'nt it?
Please give me ansver!!!
Sincerely,
Anatolii.
Peter Zaitsev writes:
> Hello mysql,
>
> Mysql 3.23.32 running on Linux.
>
> I've got a table with auto_increment command stuck, well this is no
> problem there is a record in this table with MAX_UINT value.
>
> I'm not really shure if this is a bug or correct behavior, but still
> i
Table_A: ID APPL
B BI
A BII
* *
* *
C BII
* *
D BI
Table_B: Cnty ID
USC
Aus A
Aus B
USD
* sign
How can I run mySQL in a Windows app in a non-server mode. That is how can I get the
app to start mySQL when the app starts and shut it down when the app is exited. Are
there any issue that might cause a problem?
Thanks for your help.
Best Regards,
Mike
Michael Gilman, PhD
Data Mining Technolog
Hi,
>> My apologies if this is an easy question. I've looked at the docs in the
>> privilege section and haven't found a mention of the max length of password
>> for MySQL. I want to set a fairly long one for each of my web servers that
>> will be hitting my database server. Incase it is importan
I think that my file permissions are set OK. Heres a list of my MySQL
folder...
total 1652
drwx--6 mysql27 4096 Mar 1 11:37 .
drwxr-xr-x 20 root root 4096 Feb 15 16:26 ..
-rw---1 mysql27244 Feb 26 16:56 .bash_history
drwx--2 my
Hi,
So does mySQL support transactions or not? There are transaction safe tables but they
are not actually implemented?
How people cope without transactions when there is a need for multiple UPDATEs or
INSERTs...and they need to be implemented as a whole atomic operation?
Thanx
---
It is in /var/lib/msql
Ben K
Tobias Wolff wrote:
>
> You have to edit your "php.ini" file, usually located in /usr/local/lib.
>
> There is an option called "mysql.default_socket". The value of this options
> is the path to the mysql socket file. Your systems seems to search the
> socket file
You have to edit your "php.ini" file, usually located in /usr/local/lib.
There is an option called "mysql.default_socket". The value of this options
is the path to the mysql socket file. Your systems seems to search the
socket file at "/var/lib/mysql/mysql.sock". It might be at a different
place,
- Original Message -
From: "Ben Kennish" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 01, 2001 11:55 AM
Subject: PHP and MySQL
> Who would've thought it would take 3 days to install MySQL, PHP and get
> them talking???!!
>
> I've installed PHP 4.0.4pl1 using an RPM f
On 28.02.2001 22:40:39 UzeV wrote:
> Hi,
>
> The webhosting company where I host my my site had upgraded their mysql to
> 3.23.32
> and now my program has an error, saying :
>
> Supplied argument is not a valid MySQL result resource in
>
> the error is in the line containing :
> while (
Why not use a timestamp column to guarentee the order in which rows get
inserted into the table? You can then order on the timestamp column.
Gerhard Schmidt wrote:
>
> --d6Gm4EdcadzBjdND
> Content-Type: text/plain; charset=iso-8859-1
> Content-Disposition: inline
> Content-Transfer-Encoding: quo
Who would've thought it would take 3 days to install MySQL, PHP and get
them talking???!!
I've installed PHP 4.0.4pl1 using an RPM from www.redhat.com
I've also installed MySQL (latest ver) server and client versions from
www.mysql.com using RPMs.
Now MySQL seems to be up and working (using 'my
Thank You for the help, the "having" didi the trick.
/Patrik
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-ma
On 01.03.2001 09:50:36 Blaz Grapar wrote:
> Is there a boolean field type (Yes/No; True/False, 1/0) in MySQL or what is
> closest to the boolean type
ShortInt: 0 == FALSE, <> 0 == TRUE
That's how I do it anyway.
Or maybe combine multiple bool fields to one and use binary logic.
---
On 01.03.2001 10:46:33 M. A. Ould-Beddi wrote:
> I know that in Oracle it is possible to select a number
> from DUAL and put it in a variable. Is it possible
??? What's DUAL?
-
Before posting, please check:
http://www.mys
You have an odd number of brackets in each case, you are missing a " ) "
> -Original Message-
> From: Kinney Baughman [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, February 28, 2001 11:18 PM
> To: [EMAIL PROTECTED]
> Subject: What's the syntax for using ENCODE()?
>
> Hi,
>
> I'm tr
On 01.03.2001 09:59:58 Patrik Nylund wrote:
> Hi everybody, I qould like to this query:
select userid,count(userid) as cnt from points where acq=6 AND cnt > 1 group by
userid limit 100
-
Before posting, please check:
htt
Hi,
I wounder why there is no support for Auto_increment fields in Heap
tables. I know there is a problem with the uniqueness of this columns
but some times the uniqueness of the column is only needes as long
as the heap table exists.
I´m currently working on system for Managing http Session
Hi Greg,
Yes. Only installed it a couple of weeks ago, but it seems to work fine
(using the Win95 version).
cheers,
Mark
- Original Message -
From: "genge1" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 01, 2001 4:57 AM
Subject: MyODBC for Windows ME
> Has anyone ins
Hi,
The webhosting company where I host my my site had upgraded their mysql to
3.23.32
and now my program has an error, saying :
Supplied argument is not a valid MySQL result resource in
the error is in the line containing :
while ($row = mysql_fetch_row($result1)) {
I check the new
Is there a boolean field type (Yes/No; True/False, 1/0) in MySQL or what is closest
to the boolean type
I know that in Oracle it is possible to select a number
from DUAL and put it in a variable. Is it possible
In mysql? and how?
Thanks
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://
On 01.03.2001 01:54:14 John Nielsen wrote:
> Hey everyone,
>
> This may have already come up a couple of times in the mailling list, but I
> I was wondering with mysql-3.22.32 if you can have two auto_increment's
> in one table, e.g.:
What would this be good for? Yes, I've seen that one of yo
Hi!
On Mar 01, Benjamin Pflugmann wrote:
> Hi.
>
> On Mon, Feb 26, 2001 at 08:57:19PM +0100, you wrote
> [...]
> > Yes, security info is to be sent to announcement list.
>
> Well, the last two weren't sent to the announcement list, AFAIK. Well,
> it's a question of its own, whether to send an a
Hi everybody, I qould like to this query:
select userid,count(userid) from points where acq=6 group by userid limit
100
but only get the results where count(userid)>1
And I don't know how to do that.
Could anyone of You please help me out?.
TIA.
/Patrik
-
On 01.03.2001 02:37:17 Rolf Hopkins wrote:
> Or use the no dependency flag or upgrade.
That's as good as suggesting to not use rpm at all. The dependencies are in
there with a reason, you know.
Never upgrade/install with --force/--nodeps.
On 28.02.2001 22:51:12 Jason Landry wrote:
> Well, except that the value of an auto-increment field CAN be set to a
> specific value (perhaps negative) an INSERT or UPDATE statement.
As long as the value is != 0 for INSERT statements.
-
On 28.02.2001 19:51:13 Gerald L. Clark wrote:
> In the dump, the autoincrement columns will have their actual values,
> not 0.
Yes, correct - and if the actual value is 0, it will contain just this. And
inserting a row with the col set to 0, will change the column value.
TRY IT!
-
On 28.02.2001 05:58:33 ?US-ASCII?Q?Fabio_Ottolini?= wrote:
> mysqldump "spits" not only table structures but data also. When you use
> mysql to import data it will first attempt to create the table and then load
> its values. If your table's got AUTO_INCREMENT set it will work fine after
> recre
101 - 144 of 144 matches
Mail list logo