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
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 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 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.
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
-
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
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
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://
Is there a boolean field type (Yes/No; True/False, 1/0) in MySQL or what is closest
to the boolean type
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
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,
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
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
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 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
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.
---
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
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
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
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 (
- 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
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,
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
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
---
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,
>> 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
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
Table_A: ID APPL
B BI
A BII
* *
* *
C BII
* *
D BI
Table_B: Cnty ID
USC
Aus A
Aus B
USD
* sign
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
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.
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
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
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
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
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
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.
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
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
-
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.
---
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
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
> > 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
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
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.:
>
> +--+--+--+-+
My greetings.
Please forgive me for my bad English and please help me with my problem.
Solution of that problem i didn't find in mailing list, in manual and in others
sources. I was working and searching hard, but i can't find it.
My problem is: i want to create databases for my
Since you did not
./mysql_install_db --user=mysql
the files are owned by the wrong id.
chown -R mysql /usr/home/treebc.com/mysql/var
if that is the correct location for the database directories.
nirmala wrote:
>
> Hi,
> We have installed Mysql on our server(UNIX) . When I am telnet into
They replaced your MySQL with a new version.
Did they re-compile Apache and PHP to use the new MySQL libraries,
or is it trying to use the now missing ones?
Celso Pires wrote:
>
> Hi there,
>
> I've got a site hosted at an ISP and everything was going well when they
> decided to upgrade the sof
These libraries should be on Debian installation CD.
You just need to install them.
"Mark R. Martinez" wrote:
>
> Hello,
> Our problem concerns an abnormal abort of:
> ./configure --prefix=/usr/local/mysql
>
> error messages show that lncurses, lcurses, ltermcap, could not be found.
> W
Hi,
> 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.. ???
[EMAIL PROTECTED] wrote:
>
> 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 create
I hd this same problem. Ensure that /var, /var/lib, and /var/lib/mysql have
permissions set to: drwxr-xr-x
This cured the problem for me.
rick
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 01, 2001 6:19 AM
To: Ben Kennish
Cc: [EMAIL PROTECT
Did you change the permissions of the files after starting
the sever, or before?
Did you read the GRANT section of the manual.
Does your user have the UPDATE privilege?
Raman Aggarwal wrote:
>
> Dear Sir
>
> I am a regular user of MySql. I will be obliged if you help me.
>
> 1. The path of
DUAL is a dummy table in oracle ... !
In mysql you have two way to set variables:
1. set them directly via SET @variable={ integer expression | real
expression | string expression }[,@variable= ...].
2. or do something like select @variable:={ integer expression | real
expression | string expre
On 01.03.2001 13:16:47 soon chee keong wrote:
> Table_A: ID APPL
>
> B BI
> A BII
> * *
> * *
> C BII
> * *
> D BI
>
> Table_B: Cnty ID
>
>
dear Sir :
MySQL 3.22 on my linux 486 PC seems work so good. when I compile
a simple C API programe which catched from the MySQL tutorial, it
chokes at the end of compile process . the programe is as follows:
#include
#include
#define def_host_name NULL
#define def_user_name NULL
#define def
marsha writes:
> Hi guys,
>
> I am part of a team developing an interface from Microsoft Access on a
> Windows environment to mySQL on a Cobalt RAQ server (LINUX).
>
> When you say the software mySQLgui is in "beta testing", what level is
> that? Is alpha a step higher than beta, as in th
[EMAIL PROTECTED] writes:
> Hi folks, I'm having a hard time using bdb tables. Here are the
> details...
>
> I've create a few BDB tables, which are causing me great amounts
> of grief. The tables worked fine for a while, then suddenly
> started crashing mysqld. I decided to drop the offend
dear Sir :
MySQL 3.22 on my linux 486 PC seems work so good. when I compile
a simple C API programe which catched from the MySQL tutorial, it
chokes at the end of compile process . the programe is as follows:
#include
#include
#define def_host_name NULL
#define def_user_name NULL
#define def
dear Sir :
MySQL 3.22 on my linux 486 PC seems work so good. when I compile
a simple C API programe which catched from the MySQL tutorial, it
chokes at the end of compile process . the programe is as follows:
#include
#include
#define def_host_name NULL
#define def_user_name NULL
#define def
Gerald,
I've written to them asking your question.
I'd like to point out that I just got an empty record set when it is running
under ASP.
The query runs successfully through phpMyAdmin 2.0.5. I realized that the
query
(select count(*) as quantity from person;) works well in ASP so that I think
i
Yeah, except when the RPMS were created with an error. MySQL should not
require Perl to be installed in order for it to work, so in this case, yes,
use no dependancy flag. Have a look at the archives around november,
december last year. Heaps of info in regards to this.
- Original Message
Broadly speaking, I would agree with Cal becasue MySQL is, by its very
nature, a server application..
However, you can easily emulate it being an application by adding net
start(s) and net stop(s) to the beginning and end of your application - you
may have timing issues, however, with the start a
On Thu, Mar 01, 2001 at 02:37:30PM +0100, Entryon Corp., Chief Technical Officer - P.
Hasenfratz 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 f
There is entirely unexpected behavior here.
If you have gone to the trouble of defining a column in your database as
an auto_increment field
it should not simply stop working because you enter a negative number.
What we saw yesterday was the addition of a row with a negative number in
the auto_i
Well, for starters, I would say you need
> Table_B.Cnty="US" AND Table_A.ID="*";
not
> Cnty="US" AND ID="*";
- Original Message -
From: "soon chee keong" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 01, 2001 20:16
Subject: Error 1052:Query problem
> Table_A: I
Hi,gurus,
I am a novice at MySQL. When I try to run a sample program in the book of
"MySQL & mSQL" I get a error message from my apache server as follows,
*
Internal Server Error
The server encountered an internal error or misconfiguration and was unable to
complete your request.
Please
HI, I sent this note a couple days ago and no one has commented. I am
trying to implement DBI-1.14.tar.gz Data-ShowTable-3.3.tar.gz
Msql-Mysql-modules-1.2215.tar.gz . The first two packages completed
successfully byt the Mysql-modules failed druing the 'make test' step.I
am using mysql ve
I have never tried changing the default language myself but a suggestion
only is that are your columns of the right type?
- Original Message -
From: "Vitaly Dugaev" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 01, 2001 19:32
Subject: Use Ukrainian lenguage.
Dear sup
[EMAIL PROTECTED] wrote:
>
> On 01.03.2001 13:51:58 Robert Vetter wrote:
>
> > ENUM("no","yes")
>
> I always wondered: How much space does this take?
1 or 2 bytes, depending on the number of enumeration values (65535
values maximum). I've read this in the _MANUAL_ !
Robert
Is there reasonably current version of mysql that I can install or
compile under aix4.2.1. I have been unable to compile 3.23.33 because of
size limitations.
--
Mike Klein
Manager, System Services
Information Technology
Loyola University New Orleans
6363 St. Charles Ave.
New Orleans, LA 70118
50
HOORAY! It's finally working.
However, I'd prefer to have my mysql.sock socket file in /tmp/
Anyone know how to change the settings for MySQL (and also PHP4 and
phpMyAdmin) so that it looks in /tmp/ instead?
Cheers.
Ben
Rick Emery wrote:
>
> I hd this same problem. Ensure that /var, /var
Hi all.
I've compiled mysql 3.23.33 with support for DB-Berkeley. After it when I
try to launch mysqld it gave me a segmentation fault. Anybody has a similar
problem?
Note: I use Slackware 7.1 in a PC.
Thanks in advance.
Iago.
-
I am not sure this will solve your probleme but you need to add -lnsl and -lsocket to
the compile command line.
On Thu, Mar 01, 2001 at 11:03:11PM +0800, john1 wrote:
> dear Sir :
>
> MySQL 3.22 on my linux 486 PC seems work so good. when I compile
> a simple C API programe which catched from
On Wednesday 28 February 2001 22:04, [EMAIL PROTECTED] wrote:
>Hi folks, I'm having a hard time using bdb tables. Here are the
>details...
>
>I've create a few BDB tables, which are causing me great amounts
>of grief. The tables worked fine for a while, then suddenly
>started crashing mysqld. I de
Joe and Nancy M wrote:
>
> Thanks to everyones help, I have my webpages using php to read my mysql
> table and presenting the appropriate information. I upload and refresh my
> table via telnet when the whole thing needs refreshing.
>
> I would like to give my end user a tool to change the tabl
Ok, I am new in the IT world, and I just want to set up a mySql server.
I installed mySql on the WinNt server (on the lan in my office) with
mysqladmin running, and i installed myODBC on my win98 computer, with
settings that would match the server.
How can i test if this is working without makin
> I´m currently working on system for Managing http Session and would like
> to use a heap table for storing the session information. Session
> information is only of temporary intrest. But still I need an unique
> ID for reference with some other Tabels storing dtaa for the session.
> All these t
Dual PIII half gig ram.
VaLinux 6.2.3
When running configure, It checks size of char and says 0.
it fails and says that a static libm.a is not found. It is in /usr/lib,
but it says to install a static version.
Is there any other workaround for this.
-
Hi,gurus,
I am a novice at MySQL. When I try to run a sample program in the book of
"MySQL & mSQL" I get a error message from my apache server as follows,
*
Internal Server Error
The server encountered an internal error or misconfiguration and was unable to
complete your request.
Please
On Thu, Mar 01, 2001 at 12:04:27AM -0500, [EMAIL PROTECTED] wrote:
>
> I've replicated this problem on 3 different machines, and
> on 3.23.33 and 3.23.32. I had been using BDB tables for a
> couple weeks now in testing, without a hitch until the above
> query starting being used. I also tried to
Todd A. Jacobs writes:
> I downloaded and compiled the latest version of MySQLGUI and am connecting
> to MySQL 3.22.32 on OpenBSD. When I try to tunnel MySQLGUI through the
> following ssh tunnel:
>
> ssh -x -g -L 3306:localhost:3306 mysql
>
> I get this error message from the MySQL
Hello I have installed the latest rpm on an exiting RH6.2 Linux box. I
actually upgraded mysql to the newest version and everything went fine and
it verified after the installation was done.
The problem that I have is that I cannot log into mysql now. I have tried
to located mysqladmin anywh
On Wednesday 28 February 2001 22:04, [EMAIL PROTECTED] wrote:
>Hi folks, I'm having a hard time using bdb tables. Here are the
>details...
>
>I've create a few BDB tables, which are causing me great amounts
>of grief. The tables worked fine for a while, then suddenly
>started crashing mysqld. I de
Hello again!
In the prev episode i said that when i do INSERT DELAYED
mysql just catches sig 11, crashes and restarts. No record
inserted whatsoever. Nothing is written into the update log.
Here is a sample (even though it says 1 row affected, it is
actually not affected. nothing is inserted):
when do configure:
--with-charset=win-1251
It is clearly explained in the manual. READ THE MANUAL!
- Original Message -
From: "Rolf Hopkins" <[EMAIL PROTECTED]>
To: "Vitaly Dugaev" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, March 01, 2001 6:59 PM
Subject: Re: Use Ukrainian l
Hi
1. I'm working in Windows 2000, intending to run MySQL to localhost on same
laptop.
2. I've edited "my.cnf" to change to d: wherever it said c:, placed it 3
places, c:\, d:\ and d:\mysql\data\ as per Manual's Option Files. As I
unzipped binary directly to d:
3. None of these have worked:
d
They didn't work 'onsite'/live, or when downloaded. They *used* to work
for both.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To reque
You will get errors like these if your script does not print out a header
before spitting out other information. It is usually best to print the
header in the very beginning of the script so you do not have to worry about
it. You dont have to wait until you are about to print out some html.
$outp
Artem Koutchine writes:
> Hello again!
>
> In the prev episode i said that when i do INSERT DELAYED
> mysql just catches sig 11, crashes and restarts. No record
> inserted whatsoever. Nothing is written into the update log.
>
> Here is a sample (even though it says 1 row affected, it is
>On 28.02.2001 13:13:05 Bob Hall wrote:
>
> > >Og nu da jeg så nærmere på din email adresse, er du selvfølgelig velkommen
> > >til at spørge på dansk... ;-)
> >
> > Det er alltid hyggelig å se på andre språg på internettet, men hvis
> > du skriver på dansk, så skal de aller fleste taper sjans
Sinisa, i thought i pointed out that mysql ALWAYS
crashes on any single INSERT DELAY anytime,
any database, under any conditions and during any
weather. NO single INSERT DELAY can be executed
successfully.
Regards,
Artem
- Original Message -
From: "Sinisa Milivojevic" <[EMAIL PROTECTED]>
Laurent Oget writes:
> I am not sure this will solve your probleme but you need to add -lnsl and -lsocket
>to the compile command line.
>
> On Thu, Mar 01, 2001 at 11:03:11PM +0800, john1 wrote:
> > dear Sir :
> >
> > MySQL 3.22 on my linux 486 PC seems work so good. when I compile
> >
If all you need is a count of the items why not issue
Select count(distinct threads) as ctr from messages
Jack ;-)=
- Original Message -
From: "Ed Lazor" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, February 28, 2001 11:53 PM
Subject: how do you format this query?
> Hi =)
iii> You will get errors like these if your script does not print out a header
iii> before spitting out other information. It is usually best to print the
iii> header in the very beginning of the script so you do not have to worry about
iii> it. You dont have to wait until you are about to print o
OK, I admit it, I'm stumped. I've done this before, but I've lost the
script that used to do this.
All I'm trying to do is build a simple MySQL client program under AIX 4.3
with gcc, and I can't seem to get the link libraries right (the worst part
of porting!). Any help appreciated.
I've done t
> > 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.
Or quoting from http://www.bitbybit.dk/mys
On Thu, Mar 01, 2001 at 11:47:41AM -0500, Joe Kislo wrote:
> > I´m currently working on system for Managing http Session and would like
> > to use a heap table for storing the session information. Session
> > information is only of temporary intrest. But still I need an unique
> > ID for reference
Okay, I get it. The problem comes from the statement below,
wen> $db = param('test') or die("Could not find database!");
After I revised it to "my $db = "test" or die("Could not find database!");"
I get expected result.
Thanks for your consideration.
Regards,
--Wen
[EMAIL PROTECTED]
-
My question is about indexes...basically, I'm wondering how many indexes is
too much, and what the drawbacks are of having more indexes on a table? I'm
guessing INSERT and UPDATE queries probably take longer?
My table has the following fields:
member_id, first_name, last_name, username, password
Ben Kennish wrote:
>
> HOORAY! It's finally working.
>
> However, I'd prefer to have my mysql.sock socket file in /tmp/
>
> Anyone know how to change the settings for MySQL (and also PHP4 and
> phpMyAdmin) so that it looks in /tmp/ instead?
>
> Cheers.
>
> Ben
>
> Rick Emery wrote:
> >
> >
1 - 100 of 144 matches
Mail list logo
