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 Nancy
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
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 ---
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
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
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
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
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
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 and DO NOT
oops sorry again the DBD stuff should be
install Bundle::DBD::mysqlenter
...
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:
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
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 be
Doesnt 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: tera-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
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't
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
- 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 numbers
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
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
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
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
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.
However,
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
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. This is
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
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
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 fine in
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
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 field.
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)
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.
Jiri
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 XML
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: Copying
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 is the
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
"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
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
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/
-
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
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,
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
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
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 =
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 for the ride.
4.13.6 Splitting Data Across Different Disks Under Windows
I can't get this to work, any idas?
Thanx!
Andreas
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
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
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
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: submitter ID
Originator:Gord Shier
Organization:
MySQL support: none (yet)
Synopsis:
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
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
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 field
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 why
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
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
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
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 sperated
On Wed, 21 Feb 2001, Warren wrote:
SNIP
?php
MYSQL_CONNECT("localhost","yourID","yourPASSWORD");
mysql_select_db("yourDATABASE");
$ex=@MYSQL_QUERY("select * from questions where uid='1' ");
echo 'table width="95%" border="1" cellspacing="4" cellpadding="4"
- 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
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 HEY!
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
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:
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 are
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 possible to
-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
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
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
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
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
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 are
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
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"
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 in
Win32 static binary of MySQLGUI 1.7.4-2
cant unzip it
Keith
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
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
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
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 this
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
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
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, 2001
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 .frm,
1 - 100 of 118 matches
Mail list logo