Hi!
Socket file specified is : /var/lib/mysql/mysql.sock
which on my system has a filesize of zero. I'm running a Red Hat
7.0, Kernel 2.2.16-22smp
which I installed with MySQL (ie, MySQL wasn't installed separately from
source files.)
I've got three copies of mysqld running when I do a ps (
At 18:59 21/02/2001 +0100, Markus Brückner wrote:
Hi!
You can edit the my.ini file using the instructions on MySQL
manual items Option Files,Tuning Server parameters.
To have a complete idea how you can use the configuration files
you need to read the whole Manual, because some instructions are
me
[Please cc me, I'm not on the list.]
Hi there.
I'm trying to compile mysql-3.23.33 on NT 5, and have run
into this:
Performing Custom Build Step on .\Strxmov.asm
'masm' is not recognized as an internal or external command,
operable program or batch file.
Error executing c:\winnt\system32\cmd.e
Title: Îáðàùàþñü ê Âàì ñ ïðîñüáîé ïîìî÷ü ìíå â ïðèîáðåòåíèè ëåêàðñòâà
Óâàæàåìûå ãîñïîäà!
Îáðàùàþñü ê Âàì ñ ïðîñüáîé ïîìî÷ü ìíå â ïðèîáðåòåíèè ëåêàðñòâà. Åñëè áû ýòî íå áûë âîïðîñ æèçíè è ñìåðòè, ÿ áû íèêîãäà íå ðåøèëàñü îáðàòèòüñÿ ê Âàì. Íî ýòîò ïðåïàðàò äëÿ ìåíÿ - ïîñëåäíÿÿ âîçìîæíî
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I'm not sure how cold fusion works with mySQL. I'm not sure if you
have to build modules for cold fusion to interface with mySQL, but
PHP is built that way. If you upgrade mySQL ( from 3.22 to 3.23 ),
you will get these same errors. A rebuild of PHP w
Hello,
i've Solaris 5.8 Beta-refresh in a SPARC , and later i've
downloaded from http://www.sunfreeware.com
mysql BINARY versión 3.22.26.a-sol8-sparc and i try to
"./configure" suddenly albort saying :
"ld.so.1 : mysql error : libstdc++: can't open : files
Hi.
On Wed, Feb 21, 2001 at 09:38:33PM -0700, [EMAIL PROTECTED] wrote:
[...]
> /configure -with-low-memory for MySQL 3.23.33 but lost patience after watching
> it do 38+ hours of frantic disk swapping. I went to www.mysql.com and followed
> the seemingly most obvious path to downloads. There, i s
Hi-
I have run into many problems with the tight security features of mysql. In
particular, consider this situation: I start the mysql daemon as "root",
create a database (say "test"), and "grant all" permissions on this
database to another user (say "temp"). Then, when I shutdown the daemon an
Since XML is a way to exchange data...and it is protocol/platform indepdnent
there is a very good reason to have XML docuemts going in and out the
database. For example the database server can offer HTTP services, so we
don't need stuff like JDBC/ODBC and all that. It can be done through HTTP,
the
Specifying it as a primary key (or a key of any kind) is analogous to
creating an index. So you are already indexing them explicitly.
Cal
http://www.calevans.com
-Original Message-
From: Gorantla, Aruna [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 21, 2001 9:47 AM
To: '[EMAIL P
Hello Everybody,
I would like to perform database backup while the server is running. I
don't want to use mysqldump as the tables are huge. So I consider to use
BACKUP TABLE sql command to perform it. In addition, I find that this
command only backups the .MYD and .frm, i.e. no .MYI files will
Ahhh using mysql command instead of mysqldump command to import. It
worked splendidly!
Gracias,
Jeff Gannaway
At 07:21 PM 2/21/01 -0300, Fábio Ottolini wrote:
>I just importa data created by mysqldump using
>mysql -u username -p dbname < table
>MySQL asks for my password and it's done.
>
>B
INSERT INTO table_name(field_name)
VALUES("sbie\'2000")
WHERE field_name=value;
-johnny
-Original Message-
From: Elaine Silva [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 21, 2001 5:17 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: HELP!!
Please,
How can i insert
Upon trying to compile MySQL 3.23.33 for BSDi, I get the following error
message. The line used to configure was:
./configure --with-low-memory --prefix=[mysql path] (and before someone
emails) where [mysql path] is filled in with the path I used...
gcc -DMAP_TO_USE_RAID -I./../include -I../incl
On Wed, Feb 21, 2001 at 05:22:31PM -0500, Michael Bacarella wrote:
> > > > XML will become a common and powerful way to express/exchange data
> > > > on the web. I hope MySQL decides to go along for the ride.
> > >
> > > This is all fine and good, but why does MySQL itself have to do this?
> > >
please tell me
how to build mysql+dbd+windows2000 to surport transactions.
thank you very much
i beg your help and best luck with you
topsky
--
»¶ÓʹÓà 21CN µç×ÓÓʼþϵͳ http://www.21cn.com
Thank you for using 21cn.com
Yes, I tried that too.
It is certainly better than working directly in the command line, but
you still have to watch your formatting very carefully.
I still say a good GUI is the best way to go for data entry and
updates.
Besides, I have found telnet to mysql insecure and I got stumped
trying t
where's your mysqld located?
just change your safe_mysql script to contain the correct location of your
mysqld binary.
also, i *think* mysqladmin -uroot -p[pass] shutdown
is the preferred shutdown mechanism, didn't even know you could do that
with mysql (client).
are you sure it's actually sto
Paul,
I'm not sure if this is in the manual, but do you have some sort of general
timeframe when mySQL 4.0
will be available for the masses?
Christopher Oson
[Big Fan Of Your mySQL Book]
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 21, 2001
>Description:
A core dump is issued if you execute the 'tee' command with a
file that exists but you have no permission to write to it.
>How-To-Repeat:
$ su -
$ touch /tmp/core.lst
$ su - anyotheruser
$ mysql -u -p
mysql> tee /tmp/core.lst
>Description:
I've posted before on this: running scripts/mysql_install_db
hangs at
'Installing all prepared tables'
and when i say hangs kill -9 is the only option.
I have been told to check permissions (they're all fine in
comparison with a wo
Does the newest version of mysql support transaction ?
How does you solve your data integrity problem in your appliacation?
Yours,
Sincerely
King Wang
Shanghai Huateng Software Systems Co, Ltd.
8/F, Wenxin United Press Tower, 755 Wei Hai Road, Shanghai 200
hello-
i just ran gunzip on the binary distribution i got from mysql.com (
mysql-3.23.33.tar.gz ).
The 'mysql_install_db' cannot be run because it has a '.sh' ending on it. Actually
many of the files in that same folder have a '.sh' ending. (mysql_install_db.sh)
Why is this, and what do I do
Salutations Doug,
>>My point is that XML is coming and it's a good thing. MySQL
>>is an important part of the Open Source community and I
>>don't want to see it trivialized or handicapped in relation
>>commercial RDBMS. In the meantime, I'm willing to recommend
>>it to clients and wait patientl
Hi,
I am getting the following errore when trying to link the MySQL client
library with a C++ program I have written.
/usr/local/mysql/lib/libmysqlclient.a(my_open.o): In function `my_open':
my_open.o(.text+0x14): undefined reference to `open64'
/usr/local/mysql/lib/libmysqlclient.a(mf_format.o
Hello,
The size of some tables are more than 300Mb (myisam). If use mysqldump, I
cannot estimate the actual size of a table..
Joe
>From: Ed Carp <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED], [EMAIL PROTECTED]
>Subject: Re: Backup
>Date: Wed, 21 Feb 2001 22:27:27 -0600
>
>Li Joe ([EMAIL PROTE
You could very well shorten the overall elapsed time if you can
configure your
script into 2 (or more) scripts, each doing 1/2 of your updates, and run
them
in parallel.
Cheers,
Kent
-
Before posting, please check:
http://w
Li Joe ([EMAIL PROTECTED]) writes:
> I would like to perform database backup while the server is running. I
> don't want to use mysqldump as the tables are huge. So I consider to use
> BACKUP TABLE sql command to perform it. In addition, I find that this
> command only backups the .MYD and .fr
Escape it with a backslash - insert into table (field1) values
('sbie\'2000')
This is covered in the manual http://www.mysql.com/manual.php
jason
- Original Message -
From: "Elaine Silva" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, February 22, 200
What are you intending to do with $peek? You only use it once and it's
sucking up one of your rows.
-jm
-Original Message-
From: Warren [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 21, 2001 5:33 PM
To: [EMAIL PROTECTED]
Subject: seemingly anomalous behaviour in Selects entered m
This Report was made using the WinMySQLadmin 1.0 Tool
2001/02/22 07:34:49
Description: When using MyQDBC with Delphi TTable components and using the
table
names in uppercase the size of character fields is reported wrong as 128. I cannot
change
the table
Original Message
From: "Matthew P. Marino" <[EMAIL PROTECTED]>
Subject: Re: So, what do you do with a "tarball" anyways.
To: Steve Ruby <[EMAIL PROTECTED]>
OK.
I'm trying to prove/disprove the viability of the MySQL/PHP/Apache triad in
order to get funding for the "real" pro
At 12:24 AM -0500 2/22/01, [EMAIL PROTECTED] wrote:
>Hi,
>
>I have a table which contains a row called ListID which is set to auto
>increment, I added a load of test data into the table while I built my
>website so I could test various things out, anyway that is all finished now
>and I am ready to
Denis L. Menezes ([EMAIL PROTECTED]) writes:
> I am hosting a website at an ISP(Verio) with mysql support. Whenever I =
> use the standard mysql commands, I get an "access denied" error. I =
> presume one of the following is wrong :
Every ISP I've hosted at has either a FAQ or a help desk for th
Eric Frazier ([EMAIL PROTECTED]) writes:
> One thing I want. A Java way to save a data structure and recover it later.
> Easy in perl, not so easy in Java. But XML would be a great way to do it in
> Java.
Why Java? That's like going to a gas station and saying "I want gas specifically
formul
INSERT INTO table VALUES ('sbie\'2000');
-Original Message-
From: Elaine Silva [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 22 February 2001 12:17
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: HELP!!
Please,
How can i insert the "'" character (like "sbie'2000") in a
database usi
The database does it.
It is my understanding that MSSQL will return the results of a query in XML.
The idea, as I understand it, is to create web pages with XML data. (I
attended a XML class where we did this) Since the web page contains code to
call the database and the result is in XML, then it
Win32 static binary of MySQLGUI 1.7.4-2
cant unzip it
Keith
Hi,
I have a table which contains a row called ListID which is set to auto
increment, I added a load of test data into the table while I built my
website so I could test various things out, anyway that is all finished now
and I am ready to go live so I have dropped all the test data from the t
For someone like my self having a tool to export via XML is bloatware, Any XML
handling should be delt with in the milddleware, where it will be utilized NOT
the database it self.
Michael Bacarella wrote:
> > > Gorjan Todorovski ([EMAIL PROTECTED]) writes:
> > >
> > > > Is there support for XML
I have a relational DB question. I'll preface this and say I've had no
formal training in DB's only on-the-job knowledge. I've been trying out some
CASE tools and have discovered the following:
Lets say I have a table that stores PEOPLE. I also have a table that stores
SHIRTS, PANTS, SHOES. Now
Steve Ruby ([EMAIL PROTECTED]) writes:
> it do 38+ hours of frantic disk swapping. I went to www.mysql.com and followed
> the seemingly most obvious path to downloads. There, i saw the section which
> says "Binary (tarball) distributions". I downloaded the item for FreeBSD. Only,
> it's not a "gz
Hey HEY! Another old Fox-Jockey! :) (There are still a few of us left in the
world)
While I understand your suggestion, I would suggest that you steer clear of
using Select * at all except when testing or when there is no other way. You
will get better performance by specifying the fields you wan
> Gorjan Todorovski ([EMAIL PROTECTED]) writes:
>
> > Is there support for XML in mySQL?
>
This is a reasonable inquiry. MS-SQLSever 2k and Oracle are both
implementing a lot of XML functionality in their RDBMS's. Oracle
is ahead of SQLServer, I believe.
Like it or not, these two RDBMS's
Hi folks,
I have a problem with BDB tables. Please look at this short mysql session:
mysql> create table sample (
id1 int(8) not null,
id2 int(8) not null,
primary key (id1,id2))
type=BDB;
Query OK, 0 rows affected (0.67 sec)
mysql> insert into sample values (1, 2);
Query OK, 1
I think your command
$peek = @mysql_fetch_row($ex);
fetches the first row - you don't output it - and the cursor goes
to the next row.
For all remaining rows you use mysql_fetch_array($ex) which
starts from the second row (see above). This results in n rows,
with the first one invisible and
I havent done any FoxPro pgmming but if u
could you get the error message returned from Mysql..
It sounds like user privilege problem...
Cheers!
Thiru
On Thu, 22 Feb 2001 11:15:23 +0800
"edith" <[EMAIL PROTECTED]> wrote:
-> Dear Sir/Madam,
-> I'm a Visual FoxPro programmer. I want to use
The problem is that the value returned for a column requested
in a group query without an agregate function is undefined,
There is NO associated link between some column that you
didn't put in the function and one that does not appear
in the group by statement.. In fact usually (in my databases
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
$peek=@mysql_fetch_row($ex);
while($row = mysql_fetch_array($ex))
at that point in your code
the first call to mysql_fetch_row() moves the result pointer up one
position..
therefore, losing your first row.
if you have to have $peek..
make a call t
Jeremy D. Zawodny ([EMAIL PROTECTED]) writes:
> On Wed, Feb 21, 2001 at 11:18:49AM +0100, Gorjan Todorovski wrote:
> >
> > By support for XML I mean that u can insert XML documents directly
> > in the database, of course u need to have the table properlu craeted
> > first. Also it should be possi
Gerald Jensen ([EMAIL PROTECTED]) writes:
> As an alternative, I would suggest one of the fine books on MySQL. Our
> developers each have a copy of the Paul DuBois book ("MySQL" / New Riders)
> as well as the O'Reilly book "MySQL & mSQL". Both are excellent learning and
> reference resources, and
Is it possible to have the following situation:
Schema:
id
first
last
optional_id
I want to do a select like this:
SELECT D.id, D.first, D.last, D.optional_id, db1.first, db1.last
FROM db1 AS D
LEFT JOIN db1 ON D.optional_id=db1.id;
and have it return:
|id|first|last|optional_id|first|last|
HI. When I was trying to include the "custon.hh" header file, I got some
error messages
like this.
gcc -lsqlplus -I/usr/include -I/usr/include/mysql -L/usr/lib -o test3
test3.cc
In file included from /usr/include/custom.hh:71,
from test3.cc:5:
/usr/include/custom-macros.hh:8299:16: w
> > Gorjan Todorovski ([EMAIL PROTECTED]) writes:
> >
> > > Is there support for XML in mySQL?
> XML will become a common and powerful way to express/exchange data
> on the web. I hope MySQL decides to go along for the ride.
This is all fine and good, but why does MySQL itself have to do this?
Aaron Weiker ([EMAIL PROTECTED]) writes:
> application interface. XML is this magic layer in the middle that each party
No it's not. XML is simply an emerging standard to describe metadata. No magic
involved.
> about to get this Email). The solution would be to have this other middle
> tier
Also, specifying fields won't break things when people add fields to a
table.
On Wed, 21 Feb 2001, Cal Evans wrote:
> Date: Wed, 21 Feb 2001 11:07:36 -0600
> From: Cal Evans <[EMAIL PROTECTED]>
> To: Jason Landry <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
> Subject: RE: Future suggestion
>
> Hey H
Mehalick, Richard RE SSI-GRAX ([EMAIL PROTECTED]) writes:
> Another reason, maybe even a better one, is that XML is less database
> specific. So too will be the data. So the result of a query is no longer
> tied to the database that produced it.
Untrue. Data is data. The result of a query sh
- Original Message -
From: "Pete Harlan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 22, 2001 4:51
Subject: Quoting numbers? (was Re:MySQL Tables)
> > I think you'll get better results if you don't quote your numbers.
Quotes
> > should be used for text and dates
On Wed, 21 Feb 2001, Warren wrote:
> SNIP
> MYSQL_CONNECT("localhost","yourID","yourPASSWORD");
> mysql_select_db("yourDATABASE");
> $ex=@MYSQL_QUERY("select * from questions where uid='1' ");
> echo ' align="center" bgcolor="#CC" bordercolorlight="#FF"
> b
One thing I want. A Java way to save a data structure and recover it later.
Easy in perl, not so easy in Java. But XML would be a great way to do it in
Java.
Eric
At 10:42 AM 2/22/01 +1000, Opec Kemp \( Ozemail \) wrote:
>*big snip*
>
>I agree with Cal, the XML module should really be sperat
John Jensen ([EMAIL PROTECTED]) writes:
> Do you have a remote server?
> Do you have a lot of data to enter into your database?
> Ask yourself:
>
> Would you rather preface each and every insert with
> "INSERT [data] INTO [table.column] ...", than enter data by filling
> in blanks in a w
Doug Poland ([EMAIL PROTECTED]) writes:
> > Why would it be easier to write said layer if it was inside the DBMS
> > instead of outside?
> >
> Speed is the reason to have it in the RDBMS.
It doesn't belong in MySQL. By that logic, monolithic kernels are a Good Thing.
> My point is that XML is
Hi!
I've got this seemingly anomalous situation that occurs when using a SELECT.
If I use the MYSQL command line thing and SELECT * FROM QUESTIONS, it tells
me that there are 7 rows in the set. There are, in fact 7 rows. Perfect.
HOWEVER, if I execute the following script I always get 1 row
Hi,
I am not familiar with the current state of MySQL
security. I know there were serious problems with
previous versions, but that was a year ago.
I am planning to install an application program that
use MySQL as backend on our external server. There are
other important database server running
Hi!
On Feb 21, Kirill Magdalinin wrote:
> Hello,
>
> can anyone help me to solve the following problem:
>
> I've installed MySQL server Ver 8.0 Distrib 3.22.32 from
^^^
> FreeBSD 4.1 ports while installing OS.
Here's your problem. I don't know
On Wed, 21 Feb 2001, allen2k wrote:
>
> Statement:
> Syntax error or access violation: You have an error in your SQL syntax near
> 'xxx","c","-1","-1",")' at line 1
>
>
> Was updating a log table in the database that has a message field. The message fie
hi,
i need to write my own very basic aggregate functions for MySQL and had a
couple of questions regarding this:
* does anybody know of a site with a collection of UDF's written by other
MySQL user?
* i read an old posting (from 99) about somebody writing a little tool,
which enabled him to wri
Anybody know what's wrong? After 'java LoadDriver'
I always get the message:
Exception: Communication link failure:
java.io.EOFException
SQLState: 08S01
VendorError: 0
java.sql.SQLException: Communication link failure:
java.io.EOFException
at
org.gjt.mm.mysql.MysqlIO.init(MysqlIO.java:37
>Description:
the comments in the my-*.cnf files say that they should be
installed as /etc/mf.cnf.
>Fix:
change the comments in my-*.cnf to read '/etc/my.cnf'
>Submitter-Id:
>Originator:Gord Shier
>Organization:
>MySQL support: none (yet)
>Synopsis: typo in s
On Wed, Feb 21, 2001 at 09:49:40AM -0600, Mehalick, Richard RE SSI-GRAX wrote:
>
> Some relational databases return results in XML format.
The *database* does that, or an add-on query tool does that?
It'd be trivial to implement an add-on for mysql (xmlmysql, a
command-line tool maybe) which wou
hello Friends.
I am very new to mysql and web site work, so please help me.
I am hosting a website at an ISP(Verio) with mysql support. Whenever I use the
standard mysql commands, I get an "access denied" error. I presume one of the
following is wrong :
1. Maybe the user@localhost should be ch
Some relational databases return results in XML format.
-
/ Rick Mehalick Senior Consultant
/ Shell Services International SSI-GPAX
/ Phone: 281-544-5092(WCK)
/ Fax:281-544-2646(WCK)
/ email: [EMAIL PROTECTED]
-
lrwxrwxrwx 1 root root 11 Jan 19 13:28 /usr/lib/libc.so -> ./libc
.so.1
-rwxr-xr-x 1 root bin 1135056 Jul 20 2000 /usr/lib/libc.so.1
Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Offici
al MySQL binary' --with-extra-charsets=complex --enable-a
I got a solution. The error log files (*.err) were owned by root. That
caused problem.
The ownership was changed to mysql and it is working well now.
Thanks.
Hyup
> -Original Message-
> From: Jeremy D. Zawodny [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, February 20, 2001 11:53 PM
> To: H
4.13.6 Splitting Data Across Different Disks Under Windows
I can't get this to work, any idéas?
Thanx!
Andreas
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
On Wed, Feb 21, 2001 at 01:26:56PM -0500, Michael Bacarella wrote:
> > >
> > > Gorjan Todorovski ([EMAIL PROTECTED]) writes:
> > >
> > > > Is there support for XML in mySQL?
>
> > XML will become a common and powerful way to express/exchange data
> > on the web. I hope MySQL decides to go along
Statement:
Syntax error or access violation: You have an error in your SQL syntax near
'xxx","c","-1","-1",")' at line 1
Was updating a log table in the database that has a message field. The message field
was
being updataed with:
query = "I
Hello Max, I am just catching up on my mysql messages and it didn't
look like your question got answered. I am still learning mysql, but
I know electronics. The first thing I would check, in your case, is
the memory chips on the errant machine. Are the speeds identical? I
have had a similar pr
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Excuse the wrapping..
Any ideas on how to speed this up?
takes 10 secs on a p2 300.
If i could get the second table to not scan all 132,775 rows, it
would be great. I have indexes in it:
mysql> show keys from suppliersiclink;
+-+
> I think you'll get better results if you don't quote your numbers. Quotes
> should be used for text and dates (depending) but not numbers.
Out of curiosity, why?
We use quotes for numbers all the time here, for consistency's sake;
the programmer doesn't have to worry about the representation
I see in your 'Explain's, the 2 queries use different indexes, the fast
one uses soc_date_idx, and the slower one uses q_idx. The trick,
perhaps is to force
soc_date_idx to be used in the 2nd case. (Adding ORDER BY soc_date might
do it, 'soc_date=X and (queue_id=Y and server_id=Z) ) might do it.
It's indexed..
if you create a table like so:
create table planner(
id integer not null auto_increment,
tstamp timestamp,
uid integer not null,
db_id integer not null,
vendor bool not null default 0,
list bool not null default 0,
companylist
Denis:
I'm not sure you really want a printed MySQL manual ... the software is
dynamic, and is constantly being upgraded. The online manual is updated
frequently, and is closer to the software you may be using.
As an alternative, I would suggest one of the fine books on MySQL. Our
developers eac
I highly recommend Paul DuBois' book, it's an excellent read and a great
reference.
At 04:05 PM 2/21/2001 -0500, Thalis A. Kalfigopoulos wrote:
> > As an alternative, I would suggest one of the fine books on MySQL. Our
> > developers each have a copy of the Paul DuBois book ("MySQL" / New Riders
Please,
How can i insert the "'" character (like "sbie'2000") in a
database using the INSERT command?
tanks,
Elaine.
Don't E-Mail, ZipMail! http://www.zipmail.com/
-
Befo
Hello,
Perhaps you can call me stupid or just blind, but I can't find a
specification of the MySQL Server/Client protocol anywhere...
I need it to implement a simple, lightweight MySQL client for mIRC (so using
MySQL++/libmysql is out of the question).
Is there such a document lying around, if s
>Description:
I'm testing various pieces of freeware to make sure they work well
under Solaris; mysql_config didn't work on my system, due to (I believe)
a shell programming problem:
if ! test $# -gt 0; then usage; fi
For whatever reason, standard solaris Bourne shell doesn't li
"Gorantla, Aruna" wrote:
>
> Hi,
> I would like to know whether the primary keys are automatically indexed in
> MySQL or do you have to index them explicitly?
>
> Thanks in advance,
> Aruna.
>
>
A primary key is a unique index.
--
I just started using MySQL in the past month or so, and love it so far. I come from a
background that includes a lot of FoxPro (way back in the days of FoxBase for the
Macintosh). I also have had a bit of MS SQL Server experience, but more using it as a
back end for Visual Foxpro.
One of the
Hi.
On Wed, Feb 21, 2001 at 12:32:21PM -0800, [EMAIL PROTECTED] wrote:
>
> I will respond in more detail later but just quickly now :
>
>
> > Hm. Sorry, I don't understand your argument. By the for loop, your
> >query does the same, doesn't it (selecting the rank of one album in
> >each metro
I just importa data created by mysqldump using
mysql -u username -p dbname < table
MySQL asks for my password and it's done.
BR,
Fábio Ottolini
- Original Message -
From: "Jeff Gannaway" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, February 21, 2001 1:21 PM
Subject: Copy
Have you tried the -H flag to the mysql client ?
The client at least can produce HTML.
"Mehalick, Richard RE SSI-GRAX" wrote:
>
> The database does it.
>
> It is my understanding that MSSQL will return the results of a query in XML.
> The idea, as I understand it, is to create web pages with X
Hey,
it depends on what type of relation you want. I'm no expert, but
here's my 2cents.
If PEOPLE can only have one shirt, one pants, one shoes ...
then
(1)your PEOPLE table might look like.
CREATE TABLE PEOPLE(
people_id auto.. blaa
pants_idint ..
Jiøí Mikulá¹ wrote:
>
> Hi all.
> I have problem with MySQL 3.23.32 on FreeBSD4.2
> SELECTs are not case sensitive, any suggestion how to set it ?
> I'v looked into DOCs, but i'm not so clever from it :(( ...
> my config options was only
>
> ./configure --prefix=/usr/local/mysql
>
> Many thaks.
"Graeme B. Davis" wrote:
>
> Is it possible to have the following situation:
>
> Schema:
>
> id
> first
> last
> optional_id
>
> I want to do a select like this:
>
> SELECT D.id, D.first, D.last, D.optional_id, db1.first, db1.last
> FROM db1 AS D
> LEFT JOIN db1 ON D.optional_id=db1.id;
>
>
I would have to say that I agree with both sides of the issue.
XML isn't about the database creating the interface nor is it about the
application interface. XML is this magic layer in the middle that each party
expects the other one to do. Microsoft and Oracle have both taken the
initiative to m
I will respond in more detail later but just quickly now :
> Hm. Sorry, I don't understand your argument. By the for loop, your
>query does the same, doesn't it (selecting the rank of one album in
>each metro is the same as selecting for all metros the rank of one album)?
The subtle differ
jatin writes:
> Hello Sinisa,
>
> I have mailed you regarding Installation on .rpm binary of mysql.
> I am once again telling you,
>
> I have a Linux6.2 OS , and want to install MySql3.22.32 client and development.
>But it give imediate following error
>
> error:MySql-client-3.22.32
So, what do you do with a "tarball" anyways. Since compiling the source is
hopless( "sql_yacc.cc"), I'm looking for a binary.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql
I am sorry, my error message was not clear.
The following is an error message..
> Statement:
> Syntax error or access violation: You have an error in your SQL syntax
near
> 'xxx","c","-1","-1",")' at line 1
I was simply writing a sting into a database fiel
1 - 100 of 150 matches
Mail list logo
