Well, whaddaya know?? Ya can use asp for a cheap price!!!
Doesn't mean that your ISP is going to support it though or any other
language/scripting tool for that matter.
- Original Message -
From: "Joshua Chamas" <[EMAIL PROTECTED]>
To: "Rolf Hopkins" <[EMAIL PROTECTED]>
Cc: "Joe and Na
Hi to all!
I have to use an UPDATE query with ORDER BY and LIMIT clauses.
This is the query:
UPDATE TBLTEST SET LOCKEDBY='test' WHERE FIELD1 LIKE 'test_' ORDER BY
INS_DATE LIMIT 1;
MySql tells me that I have an error in my SQL syntax near 'ORDER BY
INS_DATE' at line 1.
I use Mysql 3.23.30-gam
Dear all,
Can images be saved in an mysql database as a BLOB?
If so, how can I write the code in sql to add an image to a mysql database record, and
then subsequently view image in a browser via perl programming ?
--- Thank you ---
If you use perl try DBIx::XML_RDB:
http://www.xml.com/pub/a/2000/12/13/perlxmldb.html
(I don't tested this modul.)
You can try my soft Maccess :-) (with XML output):
http://www.meopta.com/products/software/maccess/
bye
Marek
- Original Message -
From: "Gorjan Todorovski" <[EMAIL PROT
On Wed, Feb 21, 2001 at 09:38:23AM +0100, Gorjan Todorovski wrote:
>
> Is there support for XML in mySQL?
What does your question mean?
XML is about representing data in a structured and easily interchanged
fashion.
MySQL is all about *storing* and *retrieving* data which is stored in a
normali
> Hi to all!
>
> I have to use an UPDATE query with ORDER BY and LIMIT clauses.
> This is the query:
>
> UPDATE TBLTEST SET LOCKEDBY='test' WHERE FIELD1 LIKE 'test_' ORDER BY
> INS_DATE LIMIT 1;
>
> MySql tells me that I have an error in my SQL syntax near 'ORDER BY
> INS_DATE' at line 1.
> I
Hi! I was introduced to MySQL on the web and was wondering whether
anyone can answer the following questions about MySQL:
1) I am being hosted on a server and the server is Cobalt RaQ3 type with
linux. It's a unix based server. Is it possible to install MySQL on my
server? If so, which type of th
Gorjan Todorovski ([EMAIL PROTECTED]) writes:
> Is there support for XML in mySQL?
No la comprende, senor - XML is a markup language, MySQL is a database. What does ne
have to do with the other?
--
Ed Carp, N7EKG [EMAIL PROTECTED] 940/367-2744 cell phone
http://www.pobox.com
Hi
I asked the same Q a while ago about bin data if you look in the archives of
this list it should still be there look under "binary data" as the subject
To point you in the right direction tho here are some excerpts from my
answers that I kept...
if you look at the second excerpt there is a p
Hi,
When running myisamchk -r -e /path/to/table/table_name.MYD : I get this message
back : table_name doesn't have a correct index definition. You need to recreate
it before you can do a repair.
So I did:
step1
drop index index_name1 ON table_name
drop index index_name2 ON tabel_name
step2
create
I see the definition of update in the online manual... This is the link:
http://www.mysql.com/doc/U/P/UPDATE.html
and this is what is written:
From MySQL manual ONLINE ***
UPDATE [LOW_PRIORITY] [IGNORE] tbl_name
SET col_name1=expr1, [col_name2=expr2, ...]
hi all
i have make sure there is a bug of mysql with mysql-3.23.32
repeat this bug.
CREATE TABLE A (
B bigint(20) unsigned DEFAULT '0' NOT NULL,
value bigint(20) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (B)
);
*p.s the same with take off primary key
insert into A values(92293079034542
I stand corrected - sorta.
Look further down in the manual: ORDER BY for UPDATE
is not introduced until v. 4.0.0.
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlfaq
> -Original Message-
> From: Denis Gasparin [mailto:[EMA
Rolf Hopkins wrote:
>
> >
> > My ISP told me they supported asp, so I had a friend of mine set up the
> asp
> > code for me and he tested it on his server. When I put the code in my
> > pages, it did not work. I called my ISP back and found out the first
> person
> > was wrong. They run Unix a
oops sorry again the DBD stuff should be
install Bundle::DBD::mysql
...
and in the rush to attempt to help, the little kahuna makes numerous
mistakes...
but in the end truth and justice prevails... he hopes...
-Original Message-
From: Irmund Thum [mailto:[EMAIL PROTECTED]]
Sent: 21 Febr
On Wed, Feb 21, 2001 at 03:35:11PM +0700, Didi wrote:
> Dear all,
>
> Can images be saved in an mysql database as a BLOB? If so, how can
> I write the code in sql to add an image to a mysql database record,
> and then subsequently view image in a browser via perl programming ?
http://public.yah
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 possible to
retreive data in XML format from some table. This is supported in Oracle 8i for
eaxmple
"Jeremy D. Zawodny" wrote:
>
Is there support for XML in mySQL?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To
Hi,
I'm new to MySQL so please forgive me if this post is very rudimentary.
I've created a new database and added all my tables, etc...
Everything seems to be fine except for a blob field in one of my tables.
I'm using myODBC and ColdFusion 4.0 on Win2000. When I output the content
the blob co
Hi, In addition to what Balanis found about a year ago :
>I have some problems with mysql because it does not
>cooperate very well with greek characters.
>
>The first problem is that mysql distinguishes the capital characters
> with accend from all the other possible "ways" the same letter can b
Doesn´t anyone have ever had problems while transfering a large database
from windows to mysql (unix) with an ODBC connection???
Do I missed something here??
Rafael Teruszkin
-Original Message-
From: Rafael Teruszkin [mailto:[EMAIL PROTECTED]]
Sent: terça-feira
Hi,
Does anyone know if the DBD Transaction Safe Table support has been
implemented (and working) for the NT release of 3.23.33 ?
I have created tables with type=BDB but fail to have any joy with
transactions
Cheers,
Bruce Percy
Peopledoc Ltd.
-
Hi All,
i'm currently setting up my first mySQL database, and have made the mistake
of updating the root user's password without using the Password() function,
meaning i am unable to get at the mysql database, or the new one i had just
created.
As has been suggested on this list, i have tried us
On Wed, 21 Feb 2001, Rolf Hopkins wrote:
> Have you tried checktable? Are there many numbers giving weird results or
> just one? Are you running an old version of Mysql? Any of the columns auto
> inc by any chance.
in the database there's only one auto_increment field in another table.
I haven
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.
Now I need to make the server sort data strings encoded
in koi8-ru in SELECT .. ORDER BY .. statements correctly.
At this stage I don't need
Hello,
I use SuSE Linux 7.1 with a 2.4 kernel. I have installed the normal
SuSE-MySQL packages and creates the default tables. I can normaly use mysql
if I am root. But if i'm logged in as normal user or try to connect to mysql
via php i got the following error message:
MySQL Connection Faile
- Original Message -
From: "Arturo Busleiman" <[EMAIL PROTECTED]>
To: "Rolf Hopkins" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, February 21, 2001 20:38
Subject: Re: MySQL Tables
> On Wed, 21 Feb 2001, Rolf Hopkins wrote:
>
> > Have you tried checktable? Are there many
Cheers, Ive subscribed and resent the email.
On Tue, Feb 20, 2001 at 10:49:36PM -0800, Jeremy D. Zawodny wrote:
> On Tue, Feb 20, 2001 at 04:19:27PM +, Tristan 'Minty' Colgate wrote:
> >
> > I have recently been asked to implement per database quotas for
> > mysql for a large scale shared
Hi Everybody (hi Doctor Nick)!
I use ASP and adodb.recordset to connect to a MySQL-database.
I use the following code to insert into the db:
[CODE START]
set rsGroup = server.CreateObject("adodb.recordset")
sql = "tblGroup"
rsGruppe.Open sql, connect
with rsGroup
.AddNew
At the company I work for we decided to try and implement reverse quotas.
rather than limit said user to x we keep track of their usage and compare it
to x. If they should happen to exceed that values then they are billed for
the overage. It's very muhc like how UU bills us on our bandwidth for th
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.
Jiri Mikulas
[EMAIL PROTECTED]
http://
Steve,
I never received Mr. Van Engen's response. I appreciate your response.
However, my question remains unanswered. If you put "sequence" in the
GROUP BY it does not give you the value that correspond to the MAXIMUM
sequence. As a matter of fact I can't find any combination of values
that
Hello,
I've recently successfully downloaded and installed both MySQL and MyODBC on
my Win2000 "box". Everything thing works great, except that for every
connection via MyODBC I make, the ODBC-setup dialog "TDX mysql Driver
Connect" pops up and I have to hit its OK button to close it. There is a
I sent this a couple of weeks ago at the time I joined the list, but I didn't see it.
Please excuse if it is a duplicate, but I still need to know the answer.
I am localizing (in French) a Delphi MySQL application which uses the Zeos
components which in turn use libmysql.dll.
Can anyon
I linked the mysql tables into my access database and did a cut and paste of the
access tables into the mysql tables. This was
an intranet setup though.
Rolf Hopkins wrote:
> - Original Message -
> From: "Joe and Nancy M" <[EMAIL PROTECTED]>
> To: "Rolf Hopkins" <[EMAIL PROTECTED]>
> Sen
jatin wrote:
>
> 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-1.i386
HI
Still having problems building mysql v3.23.33 on Tru64 V4 using gecko 2.8.1
and gnu make vs..
Error I an getting is
can't find listed++. This library exists in /user/local/lib and I set my
LD_LIBRARY_PATH to /usr/local/lib.
Anyone seen this ?
Thank You
John Markunas
I would also like to add to this, that I think it would be a good addition
to the documentation.
Gregg
- Original Message -
From: Gregg Housh <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, February 20, 2001 4:08 PM
Subject: format masks for a Masked edit
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.
-
Before posting, please check:
http://www.mysql.com/manual.php (t
Yeah, I totally agree with the idea of limiting the fields selected for most
operations. But it would be useful even for using something like the MySQL
client -- I want to see the majority of fields but don't care about a few
text or varchar fields. It's a pain to type in the field list every ti
Paul A. Rubin writes:
> Hello all,
>
> I'm running MySQL 3.23.32 under Red Hat 7.0. Neither my students nor I
> have encountered any visible problems, but the error log is full of
> messages like the following:
>
> >010221 2:05:06 Aborted connection 1000 to db: 'rubin' user: 'rubin'
Does anyone know how to do a Dynamic Link from GoLive 5.0 (PC) to
mySQL running on a Solaris web server? Any advice or direction would
be appreciated.
--
--
Mac Support WebSite: http://macweb.ida.org/
-
How about :
select a.flight_no, a.sequence, a.city
from stop_offs a left join stop_offs b
on b.sequence = a.sequence + 1 and a.flight_no = b.flight_no
where b.sequence is NULL;
Richard Reina wrote:
>
> Steve,
>
> I never received Mr. Van Engen's response. I appreciate your response.
> Howeve
Hi there,
I installed the binary file of MySQL on Windows 2000 and want to configure
it now.
I tried to do it with the winmysqladmin tool. When I use the button my.ini
setup there are just the two following lines written:
[WinMySQLAdmin]
Server=C:/mysql/bin/mysqld.exe
How can I configure
Your link approach is fine (and I consider it preferable).
Assume you suddenly start selling ties. With the Link_type approach, you simply need
to create a new link type and you're ready to roll. Much simpler than needing to
create a new table/relationship.
Also, suppose you're asked: Show me
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 possible to retreive data in XML format
> from some table. Thi
You could try the Sendkeys command in VB to pre answer the message box
SendKeys {ENTER}, False ' Answer for box before it appears
'if the Wait parameter was true the Answer would go into the sheet cell
'but with it false the Dialog box appears before the Answer is sent
> -Original Me
Hello all,
I'm running MySQL 3.23.32 under Red Hat 7.0. Neither my students nor I
have encountered any visible problems, but the error log is full of
messages like the following:
>010221 2:05:06 Aborted connection 1000 to db: 'rubin' user: 'rubin'
>host: `localhost' (Got timeout reading co
David Vender wrote:
>
> >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 fin
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-1.i386 cannot be installed
and same er
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
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
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
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
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
"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;
>
>
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.
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 ..
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
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
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 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
"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.
--
>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
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
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
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
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
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
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.
> 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
-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;
+-+
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
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
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
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/
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
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
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]
-
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
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
>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
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
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
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!
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
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!
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
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
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
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
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
- 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
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
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
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
> > 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?
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
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|
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
1 - 100 of 150 matches
Mail list logo
