On 6/7/01 5:33 PM, Gary Huntress [EMAIL PROTECTED] wrote:
I'll bet it's a roundoff problemtry select * from sequence_protein where
mol_wt 53211.62 and mol_wt 53211.63
Regards,
Gary SuperID Huntress
===
FreeSQL.org offering free
Ok, I've answered my own question but now have another.
How do I reference the sitename for the 3 sites?
sitename returns the last sitename for all 3 I tried S1.sitename etc. but it
doesn't work.
$query = SELECT * FROM department LEFT JOIN sites S1 ON
deptsite1=S1.sitekey LEFT JOIN sites S2 ON
You might want to first find lastlength before running the update query.
- Original Message -
From: Siim Einfeldt aka Itpunk [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, June 08, 2001 2:25 AM
Subject: dealing with datetime
Hi,
Just working here on a php-mysql project
is the column an int?
if this is the case why not you strip the pound sign before inserting.
with PHP you can always add the sign when retrieving.
Hasan
- Original Message -
From: technical Support [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, June 08, 2001 1:52 AM
Subject:
Hmmm.. could be something as simple as a line break - but that is often hard
to diagnose via email
Please send me the relevant files (off-list) - I should be able to find the
error quickly.
--zak
Barry C. Hawkins wrote:
on 6/7/01 17:58, Zak Greant at [EMAIL PROTECTED] wrote:
Barry C.
Strange. I've never had any problems with the RPMs
- Original Message -
From: Duane Douglas [EMAIL PROTECTED]
To: Rolf Hopkins [EMAIL PROTECTED]
Cc: Patrick Malone [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, June 07, 2001 21:59
Subject: Re: Rookie admin needs install help
At
On 07-Jun-01, Jason Bradley Nance said something totally profound about libwrap
problems (compiling) and config questions that made me ponder...
JBN Hello everyone.
JBN I have hit a snag trying to compile mysql 3.23.38. After running
JBN this configure command:
[snip]
JBN If I don't
/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: YES)'
Ciao Michela,
unless you changed the 'user' table contents, you could easily connect
to every db as root without providing any password. What's the command line
On Thu, Jun 07, 2001 at 07:36:54PM -0400, R Talbot wrote:
Jeremy
So what your pointing out is I am seeing several threads
generated by mysqld...
Yes.
But that does not answer as to why the rpm installation
start with one thread??
Both installations which I compiled from
- Original Message -
From: Adrian D'Costa [EMAIL PROTECTED]
To: Mysql Mailing List [EMAIL PROTECTED]
Sent: Friday, June 08, 2001 13:59
Subject: php/mysql question
Hi,
I am not sure whether this relates to this list or the (not working) php
list.
For simplicity: I have a form
Hello All,
When I insert data submitted via a web page into mySQL, the pound (£)
symbol gets converted to something like 8916.
I am using PHP and Apache on the Server side.
Has anyone else encountered this strange problem?
*
At 7:16 PM +0200 6/7/01, Sean O'Keeffe wrote:
hi there,
i've got a problem which someone might be able to help me with.
i'm importing text files into a database in mysql using mysqlimport :
/users/mysql/bin/mysqlimport -u * databasename *.txt
however i'm getting the following error all
Ok, so you can obtain a random result (thought that was what random()
was for), but still cannot understand how this could be usefull. I use
encrypt to store password info in a database, but how do you compare the
user entered password with the one in the database if the results vary
the whole
./configure --with-mysql=/usr/bin --with-apxs --enable-track-vars
Ciao,
sorry but I just joined this mailing list, so I am not aware of any
previous messages.
/usr/bin ?
Why in that directory?
Can I please get to know how did you install MySQL? By RPM?
Please try these 2 find
Sounds like you have a problem with the .frm file. Try checking the
permission of xref.txt.frm or some part of that. Try making sure it
is set to the proper owner with read and write permissions (usually
mysql or mysqladmin is the owner).
Best of luck
Ken
hi,
We have a mysql database called database1.
It has a table called table1 this table has no records.
But due to this table we are losing the 16 MB of space in our quota.
I think its due to these files :
Files Space
1)table1.frm 8 KB
If you use Delphi or VB, VC, there are some API program that let you access
MySQL direct. Not worry about ODBC.
Sommai Fongnamthip
At 01:00 7/6/2001 -0700, Van wrote:
Muhammad Asif wrote:
i have a table with 1 records in MS Access and
MySQL with no index in either database.
I
On Fri, Jun 08, 2001 at 12:43:16AM +0100, Jorge Oliveira wrote:
Hi,
I have two tables in my database:
#TB1
ID_tb1 (auto-incremented)
ID_tb2
name
address
#TB2
ID_tb2 (auto-incremented)
method
status
I need to run a query that inserts values into #TB1 and #TB2,
Thanks Ansgar for your answer. What I missed concerning my question, is that
I need to be able to get informations from MySQL and integrate them into a
Mac App Quark XPress, using a specific plugin for Photo Composition, If I
really understood what I was as to do.
I wonder how phpMyAdmin would
Please explain why I get multiple Daemon process
when I start mysql.server..Such as
1075 pts/0S 0:00 sh /usr/local/mysql/bin/safe_mysqld
--user=root --pid
1093 pts/0SN 0:00 /usr/local/mysql/libexec/mysqld
--basedir=/usr/local/
1095 pts/0SN 0:00
Hi,
I am not sure whether this relates to this list or the (not working) php
list.
For simplicity: I have a form that displays data from a table. I will
take just one field that displays a name
input type=text name=name value=? echo $row[name];?
This allow a user to update the changes when
The Linux kernel is 2.2.13 and has been installed from a Mandrake
distribution. This is also the source of Apache, PHP 3 and MySQL. The
distribution puts files in non-standard places so I am wondering if the
solution to my problem is to find the right base directory to use in the
Did you try the following code
$updtStmt = update vusers set orgname=\$tname1\ where id=$tid;
Should do the job.
Regards
P. Miquet
- Original Message -
From: Adrian D'Costa [EMAIL PROTECTED]
To: Mysql Mailing List [EMAIL PROTECTED]
Sent: Friday, June 08, 2001 7:59 AM
Subject: php/mysql
On Thu, Jun 07, 2001 at 06:43:01PM +, [EMAIL PROTECTED] wrote:
Dear Sirs,
We have a very large database (badge_history has 4,000,000 rows)
and the explain for our query looks like this:
Like what?
By using indexes for a query, the product of the row estimates from
an explain
On Thu, Jun 07, 2001 at 02:05:57PM -0500, Aaron Williamson wrote:
I'm sure this has been beat into the ground here, but I've nowhere
else to turn.
Whenever you're sure that a question has been asked many times before,
it's best to check the documentation and the mailing list
archives. We're
On Thu, Jun 07, 2001 at 08:23:03AM -0400, R Talbot wrote:
Please explain why I get multiple Daemon process
when I start mysql.server..Such as
1075 pts/0S 0:00 sh /usr/local/mysql/bin/safe_mysqld
--user=root --pid
1093 pts/0SN 0:00 /usr/local/mysql/libexec/mysqld
Jeremy
So what your pointing out is I am seeing several threads
generated by mysqld...
But that does not answer as to why the rpm installation
start with one thread??
Both installations which I compiled from source start
with multiple threads.. ( diffrent machines Caldera 2.3)
On Fri, 8 Jun 2001, Udayavani Udayavani wrote:
It has a table called table1 this table has no records.
But due to this table we are losing the 16 MB of space in our quota.
I think its due to these files :
Can we minimise the space accquired by table1.ISD by any means?
What is the
Did you add user to your database with the SQL GRANT statement?
Neil
On Thu, 7 Jun 2001, Martin wrote:
Warning: MySQL Connection Failed: Access denied for user:
'[EMAIL PROTECTED]' (Using password: YES) in setup.php on line 92
I am sure that all information is correct as far DB
Description:
I receive the following error when running scripts/mysql_install_db
Error is :-
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
Installing all prepared tables
SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
SEND-PR: will all comments (text enclosed in `' and `').
SEND-PR:
From: root
To: [EMAIL PROTECTED]
Subject: [50 character or so descriptive subject here (for reference)]
Description:
I
Hi,
I keep running into the following error trying to compile (running
./configure) mysql -3.23.38 on Solaris 8 x86:
checking return type of sprintf... configure: error: can not run test
program while cross compiling
I'm using gcc 2.95.3.
Has anyone compiled succesfully on sol8 x86 and is
Just use the password() function, which will return a nice 16-byte 1-way encrypted
string.
On Fri, 08 Jun 2001 00:04:18 -0700
Richard Ellerbrock [EMAIL PROTECTED] wrote:
Ok, so you can obtain a random result (thought that was what random()
was for), but still cannot understand how this could
Hi ,
I downloaded the mentioned tarball and when I ran configure on my machine,
these were the messages which were shown on screen and it failed.
---
#./configure
loading cache ./config.cache
checking host
On Fri, 8 Jun 2001, Gabriele Bartolini wrote:
$tname =urldecode($name);
$tname1 = stripslashes($tname1);
$updtStmt = update vusers set orgname='$tname1' where id=$tid;
It all depends on these 2 variables settings:
magic_quotes_gpc= On
magic_quotes_runtime= Off
I
On Fri, 8 Jun 2001, Rolf Hopkins wrote:
- Original Message -
From: Adrian D'Costa [EMAIL PROTECTED]
To: Mysql Mailing List [EMAIL PROTECTED]
Sent: Friday, June 08, 2001 13:59
Subject: php/mysql question
Hi,
I am not sure whether this relates to this list or the (not
- Original Message -
From: Adrian D'Costa [EMAIL PROTECTED]
To: Rolf Hopkins [EMAIL PROTECTED]
Cc: Mysql Mailing List [EMAIL PROTECTED]
Sent: Friday, June 08, 2001 17:47
Subject: Re: php/mysql question
On Fri, 8 Jun 2001, Rolf Hopkins wrote:
- Original Message -
From:
Thierry Coopman writes:
At 16:10 +0300 07-06-2001, Sinisa Milivojevic wrote:
Is there a way to tune MySQL for a lot of updates? most performance
tunings consider selects not updates.
Since the table is in memory, I guess HDD speed is not a factor (on a
SunFire280R those are FCAL disks).
I am trying to install mySQL on my Solaris 2.5.1 system. I have downloaded
the latest binary and followed the instructions as best I understand them
(not being very familiar with UNIX systems). I have not used the default
directory (/usr/local/mysql).
I have not found a solution for the
Road Runner writes:
i am unable to execute the configure command as part of the mysql
installation.
if i execute this statement using 'configure found in
/usr/doc/libtool-1.3.5/demo/:
[root /mysql-3.21.33c-pc-linux-gnu-i686]#
/usr/doc/libtool-1.3.5/demo/configure
Hello, I need some help to solve a problem starting mysql . I have installed all the
files in a specific directory, and modify basedir, datadir et pid_file in the file :
support-files/mysql.server. Running the daemon is OK but when i try to start mysql i
have the following message : error 2002
Rob Sedman writes:
I am trying to install mySQL on my Solaris 2.5.1 system. I have downloaded
the latest binary and followed the instructions as best I understand them
(not being very familiar with UNIX systems). I have not used the default
directory (/usr/local/mysql).
I have not found
Hi,
So where does mysql get its salt from? Is it a random salt?
This confused the hell our of me for around an hour!
You should look MySQL manual not C crypt manpage ;). And yes, this is
random salt and makes life little bit more secure.
Ok, so you can obtain a random result (thought
On 08-Jun-01, Super-User said something totally profound about Fail to compile on
Solaris 8 Intel that made me ponder...
S Hi,
S
S I keep running into the following error trying to compile (running
S ./configure) mysql -3.23.38 on Solaris 8 x86:
S
S checking return type of sprintf...
[EMAIL PROTECTED] writes:
Description:
I receive the following error when running scripts/mysql_install_db
Error is :-
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
[EMAIL PROTECTED] writes:
Hello, I need some help to solve a problem starting mysql . I have installed all the
files in a specific directory, and modify basedir, datadir et pid_file in the file :
support-files/mysql.server. Running the daemon is OK but when i try to start mysql i
have the
Hey there. I got it working quickly but there were a few issues I
wanted to mention about using a binary distribution.
First off:
The file /usr/local/mysql/libexec/mysqld doesn't exist or is not
executable
The binary distribution puts mysqld into bin/ not libexec/, so you'd
think
Dear Sir,
AFAICS your query does a FULL join of tables badge_history, badge,
badgests, department, area AND an additional LEFT JOIN. Even with indexes
the product may be too big for large tables. What says EXPLAIN SELECT?
Thomas Spahni
On Thu, 7 Jun 2001 [EMAIL PROTECTED] wrote:
Dear Sirs,
Hello All,
I have tried the settings as suggested in this FORUM like using htmlentities
etc... however, my pound sign in the database is displayed as: ú
Any more tips help etc...
-Original Message-
From: technical Support [mailto:[EMAIL PROTECTED]]
Sent: 07 June 2001 21:53
To:
Hello all,
does anyone have any feedback whether there is any difference in the
efficiency of the following query on a fairly large dataset
1. select * from tbl
2 select count(*) from tbl
3. select field1,field2,field3 from tbl
TIA
Chris Penning
CSM Systems Inc.
Edmonton, AB
T5J 3S9, Canada
The explain result (product of rows) is less than 200,000. I'll include it here, but
I don't know if it's readable or not:
Hi,
I DESPERATELY need help!
This motor does't seem to have a gas pedal.. It takes a full 4+ seconds to
run! Only ~500 rows in table. I chopped a lot of group by ordering, etc
off.
SELECT d.DigIDsKey,d.Title,d.ValueEnglish,d.URL
FROM DigIDs AS d
WHERE d.DigIDsKey IN(22, 27, 84, 164, 272, 289,
Perl is already installed installed on the server.
Mike
-Original Message-
From: Rolf Hopkins [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 07, 2001 7:17 PM
To: Mike Jimenez; Mysql
Subject: Re: What am I missing?
You don't need MySQL-bench-3.23.38-1.i386.rpm to run mysql but if you
Hi,
Are there any issues with user variables ( SET @variable:=) overflowing
memory on the server?
At any one
time I wouldn't need most of them, but I don't see any way of
removing them
once set. Might this be an issue, or is there some garbage collection
and/or memory limit on the
I have installed mysql-3.23.38-hp-hpux10.20-hppa1.1 on an hpux10.20 Unix
machine. However, I cannot get the mysqld executable to run. I get an
error that looks like this:
# ./bin/safe_mysqld --skip-grant --user=mysql
Starting mysqld daemon with databases from /usr/local/mysql/data
I donwloaded the mysql 3.23.38 binary for AIX 4.3.3 and installed an IBM rs6000
workstation. When I try to start mysql server with safe_mysqld, I got following error
message:
Start MySQL server deamon
exec(): 0509-036 Cannot load program /usr/local/mysql/bin/my_print_defaults because of
On Fri, 8 Jun 2001, Rolf Hopkins wrote:
What you wrote here and what you wrote below are not the same
update vusers set name=Adrian D'Costa where id=3;
update vusers set name='Adrian D\'Costa' where id=3;
will both work. Look up the section on escaping special characters in the
mysql
Hi,
is there a way I can assign quota to database users, so they want be able to use
all of my disk size? Ideally I would like to assign quota to each user
individually.
Is it possible at all?
Rafal
--
_/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/
On Fri, 8 Jun 2001, technical Support wrote:
Hello All,
I have tried the settings as suggested in this FORUM like using htmlentities
etc... however, my pound sign in the database is displayed as: ú
Are you seeing this stuff from the standard Windows telnet client?
If so get yourself a
Perhaps you need the MySQL-DBI-perl-bin RPM (?).
Is there such a thing?
On Fri, 8 Jun 2001, Mike Jimenez wrote:
Perl is already installed installed on the server.
Mike
You don't need MySQL-bench-3.23.38-1.i386.rpm to run mysql but if you
still want to use it, you need to install perl
Can anyone describe me the architecture of mysql operation ??
I know it starts with a script, that manages the child process, and if child
dies, it's replaced by a new one.
I have several mysqld processes working simultaneously.
How do they comunicate with each other ? Do they read concurrently
Yeah I tried to install that to but it would not compile. It wanted lib
files that were not there? It seems as though the RPM version does not
install them? But on another server I have that has MYSQL compiled from
source the lib files were present?
These are the files I'm talking about
Ok, I've emailed
[EMAIL PROTECTED]
three times, and I'm still not off the SQL database list. What's going
on? Am I
doing something wrong? How do I get off this list? If there's a
moderator out there, could (s)he please take me off the list?
Thanks
This is what it says now when I run mysqld_multi start 2:
perl: warning: Setting locale failed.
perl: warning: Please check that your locale settings:
LANGUAGE = (unset),
LC_ALL = (unset),
LANG = en_US
are supported and installed on your system.
perl: warning: Falling
Hi all ,
I got a critical situation to solve and I wonder if you can help me on
that. I promise to be very specific on my questions once I know what need to
be done, except that instead of Oracle I got to connect mySQL via java.
The first questions are:
1) Do I need to download a driver,
Can I do query like this:
Select Database1.table1.field1, database2.table1.field1, database2.table2.field2 FROM
database1.table1, database2.table1, database2.table2
François Boucher
[EMAIL PROTECTED]
I can't believe MySQL is behaviouring that way and giving that kind of errors.
I've tried MySQL versions 3.23.33 and 3.22.27 both in Solaris and RedHat linux,
all with the same results.
Can anyone please help?
Thx in advance,
Joan
The tests consists in:
* creating a table,
* to insert 2
Is there a common cause to the following problem?:
mysql select parent_referral from referral;
ERROR 1030: Got error 127 from table handler
I can run a describe on the table and I can sucessfully run:
select count(*) from referral
but if I try to actually query the data in the table I get
Did you try EXPLAIN query? That might give you some hints as to why it is
taking so long. That might point you in the right direction.
j- k-
On Friday 08 June 2001 08:28, Paul Wilkinson wrote:
Hi,
I DESPERATELY need help!
This motor does't seem to have a gas pedal.. It takes a
I am trying to use a fulltext search to searh a database of varchars and
text objects on version 3.23.23.
my query is select id, price, manufacturer, shortdesc, partnumber,
MATCH (shortdesc) AGAINST ('digital') AS score from product LIMIT 0,15
.
all of my fields return corret values, but score
Hello all,
I have some questions about password encryption. I want to make some sort of
encryption method that disables a human to read the password, but does allow my (php)
script to convert the encoded password to a human-readable password, the member
originally entered and the member
Yes Im running RegHat 6.2 I downloaded the RPM's off the mysql website.
Mike
-Original Message-
From: Larry Hotchkiss [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 08, 2001 11:22 AM
To: 'Mike Jimenez'
Subject: RE: What am I missing?
what OS ya running? RH? Are the RPM's ya used from
I got it working
Thanks anyway
Siomara
From: Siomara Pantarotto [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: connect MYSQL via java
Date: Fri, 08 Jun 2001 14:31:26 -0300
Hi all ,
I got a critical situation to solve and I wonder if you can help me on
that. I promise to be very specific
Hi, Mysql guys:
I have problem to install mysql into my DEC-AlphaServer 800 which run
DEC-osf4.0d. I downloaded mysql source file: mysql-3.22.30-dec-osf4.0f-
alphaev6.tar.gz, after run #./configure, then #make, it show the
problems, although I try command #make install, the error message is
I tried this query:
Update phone inner join tmpphone on phone.empno = tmpphone.empno
set
phone.lname = tmpphone.lname,
phone.fname = tmpphone.fname
and it didn't work.
This works in MSAccess.
Is this syntax (or something like it) supported by MySQL??
Hi all,
I got my java connection working but now I need to export a MS Access
database to mysql database.
Does anyone knows the fastest way to do it
My main question is:
Is there a way to export the table structures and data at same time? Or do I
have to create the tables structures
Look in the manual about the ENCODE/DECODE functions.
j- k-
On Friday 08 June 2001 10:28, you wrote:
Hello all,
I have some questions about password encryption. I want to make some sort
of encryption method that disables a human to read the password, but does
allow my (php) script
Never run isamchk with the server running.
Joan Vidal wrote:
I can't believe MySQL is behaviouring that way and giving that kind of errors.
I've tried MySQL versions 3.23.33 and 3.22.27 both in Solaris and RedHat linux,
all with the same results.
Can anyone please help?
Thx in advance,
You really shouldn't be using SELECT *. Try SELECT S1.sitename AS
FirstSiteName, S2.sitename AS SecondSiteName, etc etc etc.
Ok, I've answered my own question but now have another.
How do I reference the sitename for the 3 sites?
sitename returns the last sitename for all 3 I tried
Hi, All.
I have a problem to run a script in mysqlmanager.
I have file generated with mysqldump with the data definition of my
database, but
the error show is (You have an error in your SQL syntax near ';).
Has anyone encountered this problem .
Thanks.
I've installed mysql 3.23.38 from source on redhat 7.0 (apache 1.3.39 and
PHP 4.0.5 also installed from source). The PHP and the apache are running
fine, and I can view database tables using MysqlAdmin from a web browser,
but if I run mysql from the command line, I get the following error mysql:
Is there a common cause to the following problem?:
mysql select parent_referral from referral;
ERROR 1030: Got error 127 from table handler
chris@mirage:~$ perror 127
Error code 127: Unknown error: 127
127 = Record-file is crashed
chris@mirage:~$
Our system is running 3.22.23b and we're
Try it =P (just don't forget the WHERE clause)
If you want to make your query easier to write, use aliases:
SELECT d1t1.field1, d2t1.field1, d2t2.field2 FROM database1.table1 AS d1t1,
database2.table1 AS d2t1, database2.table2 AS d2t2 WHERE d1t1.id = d2t1.id
AND d2t1.id = d2t2.id
Can I do
Hello all,
does anyone have any feedback whether there is any difference in the
efficiency of the following query on a fairly large dataset
1. select * from tbl
This will be the slowest.
2 select count(*) from tbl
This will be very fast since MySQL is optimized for it (the number is
I've used a rule of thumb that I was told ages ago when working on other
databases that inserting records into a non-indexed table is faster
generally than inserting records into an identical but indexed table.
I realize that this statement is probably an antiquated guideline.and
I'd like to
I am using VC++ 6 on Win2K.
What is the exact process I need to go through to set this up to use it?
I compiled the original project in the root directory. I then setup one of my
programs to include the mysql.h as the example had. I also have the lib file
included to link in the project
Jeremy:
Looks like I might have to eat my words a little. Not entirely on the running
of MySQL in a jail, but, perhaps that too, in time.
The application started as a knowledge-base, billing application.
The piece I'm concerned with now involves an implementation using
.profile/.bash_profile
Description:
I was installing MySQL on my Red Hat 7.1 server; I tried both the RPM and the
tar.gz format. No matter what, though, I don't have mysqladmin or safe_mysqld files
anywhere. I imagine that there are several other things missing as well. Note that
when I try to run make with
Hi
How do I perform this query using one operation?
SELECT * FROM tablename WHERE account = (select account from tablename
where name='BILL');
What I want is to lists all entries who's account is the same with 'BILL'.
Thus far, what I know is to extract the account of 'BILL' and then
perform
Let me see if I understood your question:
select * from tablename a, tablename2 b where a.account='BILL' and
a.account=b.account
It's tow tables or just one table?
because if it's just one table just do select * from tablename where
account='BILL'
see you,
Augusto
On Sat, 9 Jun 2001, Jaime
This was a problem originally submitted on msql-mysql-modules:
Under Darwin 1.3.3/PPC G4, using mysql built from mysql-3.23.36+, the perl module
DBD-mysql-2.0901 (and previous versions of DBD::mysql do this as well) returns 0 for
$dbh-{'mysql_insertid'} (return LAST_INSERT_ID from a database
I don't have source for glibc, so i executed this
statement 'localedef -i en_US -f ISO-8859-1 en_US'
But it still gives me that error!
...Rohit
- Original Message -
From: James Barwick [EMAIL PROTECTED]
To: Rohit Peyyeti [EMAIL PROTECTED]
Sent: Saturday, June 09, 2001 12:29 AM
At 21:38 08/06/2001 -0500, Adam Clauss wrote:
Hi,
If you are compiling a console application without the support
of MFC add the #include windows.h line, otherwise when using
MFC during the wizard process, check the support for sockets.
Regards,
Miguel
I am using VC++ 6 on Win2K.
What is the
Hello All:
I have two mysqld runnning in ports: 3307 3308 respectively. I started the
second one by using 'mysqld_multi start 2'. whereas mysqld running on
port 3307 is the default mysqld started at the boot time.
when i issue command such as:
mysql -u root -p (it connects to my new mysqld
database,sql,query
On Fri, 8 Jun 2001, Gabriele Bartolini wrote:
magic_quotes_gpc = On ; magic quotes for
incoming GET/POST/Cookie data
And, what about: magic_quotes_runtime ?
Off.
Adrian
Sorry about this questions but why would you want to run two copies of
mysqld when it is capable of hosting as many different databases as
you need? Even if you needed two databases with the same name you
could still just create two different MySQL users for it.
Thanks,
Neil
On Sat, 9 Jun
I'm a new user, working through the tutorial provided in the MySQL documentation
(chapter 9). I'm trying to load the data from the pet.txt file into the pet table
using the specified command: mysql load data local infile pet.txt into table pet;
I get the following:
ERROR:
File 'pet.txt' not
Not sure what the load data local infile thing is, but I always
load text files from the command line like this (on Red Hat linux):
% mysql -u some_guy -p some_db /full/path/to/file.txt
I'm a new user, working through the tutorial provided in the MySQL
documentation (chapter 9). I'm trying
98 matches
Mail list logo