I have got a backup script that locks the MySQL tables then use cp(unix) to
copy the tables.
It then tar, then zips them up.
So my queston is what is the minimum privileges that this MySQL back user
needs just to lock tables?
Thanks
Simon Green
--
Live Lif
Hi,
>I'm having a problem when using Load Data where the single and double quotes
>in the text file are getting nuked. It appears that the escape character is
>not being respected but I'm not sure why. It is also knocking out
>characters near the quotes.
Your single and double quotes come out
On Thursday, 4. April 2002 08:12, Doug Bishop wrote:
> mysql_connect("localhost", "user", "password");
> $query = "SHOW TABLES;";
> $result = mysql_db_query("databasename", $query);
> $i = 0;
> while ($row = mysql_fetch_array($result))
> {
> $tableNames[$i] = $row[0];
> $i++;
> }
> for
Hi Everybody,
I am having an existing Applicaion with MySQL server running on Linux with
Tomcat 3.2.1 and JSP in English language. Now I have a requirement of
migrating the application into the Japanese Language.
Could any one tell me what all the changes I have to do inorder to migrate
my app
On Thursday, 4. April 2002 20:16, Rw wrote:
>
> http://www.abc.com?select * from test
>
> Thanks.
MySQL is not a web server. But you can use a scripting language like PHP or
Perl in combination with a web server and MySQL to do this.
Regards
Georg
---
Nick Arnett wrote:
>
> > -Original Message-
> > From: Doug Bishop [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, April 03, 2002 10:13 PM
> > To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> > Subject: RE: Table statistics
> >
> >
> > Try:
> >
> > > mysql_connect("localhost", "user", "password
Hi.
The simple way is use "SHOW TABLE STATUS FROM DATABASE_NAME" Like this in
php script (you also put this SQL into any application that you need)
";
echo "Table nameRecords";
while ($row=mysql_fetch_array($rs)) {
echo "",$row['Name'],"",number_format($row['Rows']),"";
}
echo "";
mys
Hi,
I am using Visual Basic application to insert and
update records in MySQL database.
MySQL 3.23 is installed in Windows 2000 Server.
I am running my VB application from my Windows 95
machine with MyODBC 2.50 for Win 95 installed in my
machine.
I have used the provider for the connection
as
Hi,
I have MySQL 3.23 installed in Windows 2000 Server 4
days ago. It runs as a service of the server. It was
working fine.
But now it stops abrubtly. When I run the PhpMyAdmin
from the browser it says the following :
--
Error
MySQL said:
Go Back
--
It does not say anything e
> -Original Message-
> From: Doug Bishop [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 03, 2002 10:13 PM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: RE: Table statistics
>
>
> Try:
>
> mysql_connect("localhost", "user", "password");
...
Might be helpful to the original
Try:
";
}
?>
Doug
-Original Message-
From: andy thomas [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 11:23 PM
To: [EMAIL PROTECTED]
Subject: Table statistics
Is there a command I can give in the mysql client to find the number of
rows in a table or, better still, the numb
From: "andy thomas" <[EMAIL PROTECTED]>
> Is there a command I can give in the mysql client to find the number of
> rows in a table or, better still, the number of rows in all the tables in
> a database?
To return the # of rows in a table:
SELECT COUNT(*) FROM table_name;
Not sure about all ro
Is there a command I can give in the mysql client to find the number of
rows in a table or, better still, the number of rows in all the tables in
a database?
Andy
-
Before posting, please check:
http://www.mysql.com/manual.p
I agree but this one one of those things which _SHOULD_ have been
researched.
denonymous wrote:
>
> From: "Colin Faber" <[EMAIL PROTECTED]>
>
> > Rw wrote:
> > >
> > > Is it possible to access a sql statement to mysql database through
> > > Internet explorer ? such as :
> >
> > No,
> >
> > MySQ
From: "Colin Faber" <[EMAIL PROTECTED]>
> Rw wrote:
> >
> > Is it possible to access a sql statement to mysql database through
> > Internet explorer ? such as :
>
> No,
>
> MySQL is not a web server.
Well, it's not an entirely invalid question...
One example that comes to mind is accessing ftp:
Here's one for you all...
I know it's not necessarily MySQL-exclusive, but I think it's relevant
enough.
Anyway, suppose you want to create a table to hold somewhat-regular events.
The events could be weekly, every two weeks, monthly, etc. In some cases, it
could even be "the 5th Friday of the mo
I'm having a problem with trying to come up with a work around for this
common(?) problem. I'mnew to using MySQL but have gotten a handle on it pretty easily.
My
problem is that I'm using itto develop a simple message board and of course message
boards have a lot
of text in them.
My problem is
No,
MySQL is not a web server.
Rw wrote:
>
> Is it possible to access a sql statement to mysql database through
> Internet explorer ? such as :
>
> http://www.abc.com?select * from test
>
> Thanks.
>
> --
>
> Best regards,
>
> Ridwan
> Goldbase Technology
>
> http://www.pembukuan
Trying to send this again... SPAM filter messing with me...
"this is a query about what hardware might make for a really good sql server"
There :-p
>Hello,
>
>I need some advise.
>
>We are about to purchase a huge system for use as a DB/web application server (mostly
>DB).
>
>I'd like to point
G'day All
>"kimtest","Kim","","","this is kim¹s test stories¹ to see how we c¹n
>accommodate single quotes¹ There are a ³couple² of ³double² quotes here
>to. And ³here are some single¹ quotes that¹re enclosed in
>doubles²","2002-4-4","",""
I seem to have found the problem to my own questi
Is it possible to access a sql statement to mysql database through
Internet explorer ? such as :
http://www.abc.com?select * from test
Thanks.
--
Best regards,
Ridwan
Goldbase Technology
http://www.pembukuan.com
---
query:
I am performing replication for a single database. Below is a log of
replication taken from the slave:
020403 17:59:18 Slave: connected to master '[EMAIL PROTECTED]:3306',
replication started in log 'hostname-bin.005' at position 623
There are no error messages in my log file. When i ins
Just though I will add the output that I am getting.This is a better
description of the error.Please help me!!!
make[1]: Entering directory
`/root/BUG_TRACKER/Msql-MYsql/Msql-Mysql-modules-1.2219/mysql'
make[1]: Leaving directory
`/root/BUG_TRACKER/Msql-MYsql/Msql-Mysql-modules-1.2219/mysql'
make
Hi,
hopefully I have reached the right list..
I have recently updgraded to version 3.23.49 and have found that when doing
the following query:
"select now()"
I get a universal time returned to me. I have this version installed on
linux 7.2 and I require a time in australian eastern standard ti
Duh! EXTRACT()
Sorry!
-Original Message-
From: Crook, Richard W [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 6:04 PM
To: '[EMAIL PROTECTED]'
Subject: string date thing
Hi all,
It's my first posting here so sorry if this is a silly newbie question for
the MySQL forum. I'
Hi all,
It's my first posting here so sorry if this is a silly newbie question for
the MySQL forum. I'd
like to change a string that looks like "04/03/2002" to "2002-04-03". The
initial column is, of course VARCHAR and I'd like it to be DATE. I've tried
CHANGE and MODIFY, it changes only some of
MySQL Version: 3.23.49
OS: Win 98
Query 1: select length ('abc') returns
You have an error in your SQL syntax near '('abc')' at
line 1
Query2: select length('abc') returns 3: OK
Note the space between the 'h' and '(' in Query 1. The
parser does not like this space...
The same problem occurs wi
G'day Colin
> load data local infile '~/Documents/web export.txt' into table stories
> fields terminated by ',' enclosed by '"' escaped by '\\' lines
> terminated by '\r'
> (StoryName,Writer,Heading,Caption,Body,ListDate,Section,Publication);
Thanks for your suggestion but sadly it didn't fi
Hi kim,
Try using
load data local infile '~/Documents/web export.txt' into table stories
fields terminated by ',' enclosed by '"' escaped by '\\' lines
terminated by '\r'
(StoryName,Writer,Heading,Caption,Body,ListDate,Section,Publication);
Also, if this is a windows text file you should be us
Hello All,
I'm having a problem when using Load Data where the single and double quotes
in the text file are getting nuked. It appears that the escape character is
not being respected but I'm not sure why. It is also knocking out
characters near the quotes.
The command I'm running is:
load dat
The manual is build (from what I can tell) about a week or so behind the
source tree on the work server. If you want to mess with the latest
snapshots check out
http://www.mysql.com/doc/I/n/Installing_source_tree.html
Przemyslaw Popielarski wrote:
>
> 3.23.50 not yet published, but 3.23.51 is al
3.23.50 not yet published, but 3.23.51 is already being developed, according
to the manual at http://www.mysql.com/doc/N/e/News-3.23.51.html.
--
./ premax
./ [EMAIL PROTECTED]
-
Before posting, please check:
http://www.mys
I would assume a plpgsql solution wouldn't be a bad one, All you would
really need is IF ELSEIF ELSE and FOR/WHILE, a way for procedures,
triggers, views, etc. to be able to access each other with in the
syntax of the language (providing routine/function support) along side
the ability to access
I can't seem to find help for this in the docs or with the search
engine.
I am installing the new 4.x version an rather than run it over 3.23 I
decided to erase the old packages first and start fresh. This is a
RedHat Linux 7.1 box. I am using the RPMs to do this.
After erasing all RPMs from 3.2
Hi,
create table test select * from summary_rts union select * from
summary_rts_old;
ERROR 1114: The table '#sqld70c_b4_0' is full
Can someone please help me figure out what is wrong with this. It was
working fine up until a few hours ago. The only reason I really choose to
use Mysql 4.0 was
Now I've read all the posts about database backup..
I'm currently building a www-site (an internet bookstore which is going to
be fairly large, one of the biggest in my country. This has been a pet
project for me for the last 8 months, otherwise I would have to watch the
company board waste loads
On Wednesday 03 April 2002 3:23 pm, ktt wrote:
> hello,
>
> i have plans to create a complex SQL database.
> before that i'd like to draw a scheme of it.
> could you please advice which
> program(freeware/shareware)
> would fit for that purpose?
> any links to pages, tutorials about graphical
> da
>Description:
This isn't a very critical issue, but I discovered today that if a
table has only one record in it, then a query with MATCH in the WHERE
clause will succeed for that record regardless of whether or not it
should. NOTE: I have read the manual with regards to fulltext
searching, the p
$r = mysql_query("SELECT * FROM hwureviews ORDER BY category,num DESC");
what are you trying to do with this statement?:
while ($info = mysql_fetch_row($max)) {
-Original Message-
From: Alex Behrens [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 4:08 PM
To: [EMAIL PROTECTED
mechanical pencil + graph paper? That's what I use.
ktt wrote:
> hello,
>
> i have plans to create a complex SQL database.
> before that i'd like to draw a scheme of it.
> could you please advice which
> program(freeware/shareware)
> would fit for that purpose?
> any links to pages, tutorials ab
hello,
i have plans to create a complex SQL database.
before that i'd like to draw a scheme of it.
could you please advice which
program(freeware/shareware)
would fit for that purpose?
any links to pages, tutorials about graphical
databases projecting would be great.
thank you in advance.
ktt.
Hey Guys,
I need to reorganize the list of reviews on my site so they are displayed by
category. However, I want it to display all the reviews from all categories
at once. How do I do this? Here is my syntax now for display all reviews at
once, but not sorted by category:
Hardware Reviews - %s A
At 16:53 -0500 4/3/02, Stephen Simons wrote:
>I have read the MySQL manual on column types and I
>can't find anywhere which is smaller, ENUM, SET, or
>TINYINT?
>
>Could somebody let me know which of those three is the
>smaller data type?
Go to the manual link at the bottom of the message and type
I have read the MySQL manual on column types and I
can't find anywhere which is smaller, ENUM, SET, or
TINYINT?
Could somebody let me know which of those three is the
smaller data type?
Thanks,
Steve
Stephen R. Simons
Software Development
The Academy of the New Church
STAIRS Project - www.th
On Wednesday 03 April 2002 2:02 pm, Lori Thompson wrote:
> Does MySQL have the capability for the user to specify their own
> delimiters for the command:
>
> INSERT into (database) values ("value1, value2,...,valuen");
>
> The values that I am inserting contain both "" and '' and I am receiving
Does MySQL have the capability for the user to specify their own
delimiters for the command:
INSERT into (database) values ("value1, value2,...,valuen");
The values that I am inserting contain both "" and '' and I am receiving
a syntax error.
-
Steve
Have you tried using compound index:
INDEX( POOL, STATE )
Just a thought.
David
-Original Message-
From: Steve Katen [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 10:13 AM
To: [EMAIL PROTECTED]
Subject: select query optimization
i am running a basic install of m
Yes, --localstatedir. See
http://www.mysql.com/doc/c/o/configure_options.html
Michael
On Wed, 3 Apr 2002, John Klein wrote:
> Sorry if this is an obvious question. I swear I RTFMed first.
>
> Is there any compile-time option to redefine MySQL's data area (normally
> mysql-path/var with com
Hello all,
Please pardon my "newbie-ness" I've been looking at somehow migrating from a
flatfile user system (/etc/passwd, etc) to a MySQL backend for authentication for all
my processes... qpopper, postfix, and apache/frontage (ick)
I can't seem to find anything that would enable me
Sorry if this is an obvious question. I swear I RTFMed first.
Is there any compile-time option to redefine MySQL's data area (normally
mysql-path/var with compiled versions)? I've seen many possible ways of
doing it at run-time, but really I'd prefer this to be compiled in so I
don't have to worr
It can't, try using JOIN.
Tyler Longren
Captain Jack Communications
[EMAIL PROTECTED]
www.captainjack.com
- Original Message -
From: "Leo Przybylski" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 03, 2002 1:35 PM
Subject: Subqueries
> Hello all,
>
> Does anyone kno
On Wednesday 03 April 2002 12:35 pm, Leo Przybylski wrote:
> Hello all,
>
> Does anyone know if MySQL can do subqueries?
Not the current version, no.
>
> I am trying to provide a SELECT subquery to an IN clause and I am getting
> errors. Is this possible?
Read the manual and follow the example
Thank you much - I somewhat understand the query that you posted now.
The problem that I'm dealing with NOW however is that it will only
display results if there is a second level referree. I need to get
results despite whether there are six levels or referrals, or only one.
I added a third
Hello all,
Does anyone know if MySQL can do subqueries?
I am trying to provide a SELECT subquery to an IN clause and I am getting
errors. Is this possible?
-Leo
-
Before posting, please check:
http://www.mysql.com/manual.p
look at the manual, section :
6.4.9 LOAD DATA INFILE Syntax
LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name.txt'
[REPLACE | IGNORE]
INTO TABLE tbl_name
[FIELDS
[TERMINATED BY '\t']
[[OPTIONALLY] ENCLOSED BY '']
[ESCAPED BY '\\' ]
]
[LIN
Hello again,
is there any way to make mysqldump dump every insert as a single insert
instead of making INSERT INTO ... VALUES (...), (),(...) and so on ?
I read the manual and there is sth about -e wich as I understood means
multiple inserts in single line, but I did'n use this switch.
no stored procedures yet. maybe vers 4.1
-Original Message-
From: Kevin D [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 12:59 PM
To: [EMAIL PROTECTED]
Subject: transactions, referntial integrity
I've been reading the docs but I just want to verify. It seems like the
latest
if your app is PHP, then use stripslashes() on field
-Original Message-
From: Pal Lucian [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 10:58 AM
To: [EMAIL PROTECTED]
Subject: underline char in a [char][varchar][text] field ?
Hello everybody,
I have a problem inserting a t
On Wed, Apr 03, 2002 at 01:58:55PM -0500, Kevin D wrote:
> I've been reading the docs but I just want to verify. It seems like
> the latest version of MySQL support transactions and referential
> integrity. Is this correct? Does MySQL now also support stored
> procedures?
BDB and InnoDB tables b
sql,query
I have two tables which are exactly alike. What I want to do is copy an
entire column(DESCRIPTION)from one table(ebooks2) and put that information
into the other table's(ebooks) description column where the ID(BOOK) matches
up. Is there a way to go about doing this?
Thanks,
A.J. Per
Hello everyone, I have the following line in my create table code:
SCAN_PARAM_ID MEDIUMINT(20) NOT NULL REFERENCES
SCAN_PARAMETER(SCAN_PARAM_ID)
I need to make it so that scan_param_id references to two differences tables? Will
this work?
SCAN_PARAM_ID MEDIUMINT(20) NOT NULL REFERENCES
SC
Alright, I've got a little bit of a problem with this query.
This is what the current query looks like ( I know I'm doing it wrong, I
just don't know how to fix it.. I'm not that familiar with the LEFT
JOIN/subquery stuff.. )
select cluster.cid, cluster.isp, cluster.country_id-20 as
Country_
>Description:
Users enter data from a php based web site and receive no errors
or warnings of any kind that something is amiss, but the data isn't
entered into the tables. When I go to the mysql command line and run
commands i get a table handler error.
>How-To-Repeat:
this happen
I've been reading the docs but I just want to verify. It seems like the
latest version of MySQL support transactions and referential integrity. Is
this correct? Does MySQL now also support stored procedures?
Thanks,
Kevin
-
Bef
Hi,
I am trying to store a .gz file in a BLOB field in a mysql database. I have
tried two commands :
1. Insert into mytable values('1', 'file1.gz');
2 Insert into mytable values('1,','\'file1.gz\'');
These two commands just store the name of the file in the BLOB field instead of
the content of
Hello everybody,
I have a problem inserting a text from anywhere (application,console,
doesn't matter) into a [char][varchar][text] field type. If I try to
insert eg: 'hello_there.txt' in a field ot type I enlisted above ,when I
read that field i get 'hello\_there.txt' and that is a big problem t
Hi,
When I do a make test for msql-Mysql-modules-1.22.19,two of the tests are
failing.They are
akmisc.t and mysql.t
It also says :
make[1]:*** [test_dynamic] Error 29
make: *** [test] Error 2
Can anyone pls help me with this.I have been trying for hours to fix
this.
Thanks
Prakash.
I am an avid PERL programmer, I also know java. I cannot completely agree
with either of you.
However, this debated subject is best discussed in another community.
The focus here is what has the necessary abilities/functionality to cause
SQL to become a 4th level language in MySQL.
High level fe
MySQL Manual | 4.1.2 my.cnf Option Files MySQL Manual [2621454]
MySQL Manual Search: Up Previous Next Chapters Sections Functions Concepts
4.1.2 my.cnf Option Files MySQL can, since Version 3.22, read default
startup options for the server and for clients from option files. MySQL
reads default o.
> -Original Message-
> From: Russell E Glaue [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 03, 2002 7:15 AM
...
> Does anyone on this list have a suggestion as what might be the best
> language to embed into MySQL? Be sure to consider memory efficiency,
> threadding, speed of th
That assumes you believe the myth that Java is really the language of choice
in the back rooms of large enterprise IT shops. It isn't. In the financial
industry perl is ubiquitous. Upper management will tell you Java is god, but
if you actually look at the deployed systems that are out there do
Note also that by doing this, your database will be denormalised. This may
not be a big deal, however.
On Wednesday 03 April 2002 9:55 am, you wrote:
> UPDATE mytable SET field1=field2;
>
>
> -Original Message-
> From: Chuck Barnett [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 03
its a permission issue.. do
>grant ALL on *.* to root@localhost ..
-Original Message-
From: Pramod Chowdavarapu [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 11:54 AM
To: [EMAIL PROTECTED]
Subject: Problem while installing DBD for mysql on linux.
Hi All,
I am tryi
One thing to consider with Perl is that perl 5 and perl 6 are totally
different beasts.
Perl 6 is built on top of parrot, a general purpose register based virtual
machine which is optimized to execute perl and similar languages. There are
already a small test language running on top of parrot
i am running a basic install of mysql version 3.23.49-log and i have a
pretty simple query that is not fast enough for my needs. any thoughts on
optimization would help.
the table description is below:
mysql> desc RADPOOL;
++--+--+-+-++
| Fie
update table
set newfield = oldfield
- Original Message -
From: "Chuck Barnett" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 03, 2002 6:10 PM
Subject: copying field x to field y for each record in table
> Hi, how do I do the following:
>
> I have a table I have a
Chuck,
Wednesday, April 03, 2002, 7:10:16 PM, you wrote:
CB> Hi, how do I do the following:
CB> I have a table I have added a new field to, I want to take field X and copy
CB> it to the new field for each record. What should this query look like?
UPDATE table_name SET y=x;
CB> Thanks,
CB> Chu
Am Mittwoch, 3. April 2002 18:10 schrieb Chuck Barnett:
> Hi, how do I do the following:
>
> I have a table I have added a new field to, I want to take field X and copy
> it to the new field for each record. What should this query look like?
>
UPDATE yourtable set newfield=x
Regards
Georg
---
Humph. Undocumented CHANGE MASTER TO MASTER_CONNECT_RETRY=60;
Still asking the other question if there is a fix for the problem or not...
-Original Message-
From: Luc Foisy [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 11:37 AM
To: MYSQL-List (E-mail)
Subject: Replication I
At 10:10 -0600 4/3/02, Chuck Barnett wrote:
>Hi, how do I do the following:
>
>I have a table I have added a new field to, I want to take field X and copy
>it to the new field for each record. What should this query look like?
>
>Thanks,
>Chuck
UPDATE tbl_name SET y = x;
---
Hi!
- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Wednesday, April 03, 2002 9:00 AM
Subject: Re: Replication and transaction questions
> On Tue, Apr 02, 2002 at 11:49:10AM +0200, Nico Sabbi wrote:
...
> > 2) why are creations o
UPDATE mytable SET field1=field2;
-Original Message-
From: Chuck Barnett [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 10:10 AM
To: [EMAIL PROTECTED]
Subject: copying field x to field y for each record in table
Hi, how do I do the following:
I have a table I have added a
Hi All,
I am trying to install DBD for mysql on linux machinein the process
when i did
"make test" i am getting the below error messages...
Could any one kindly help me in getting out of this??
Please refer the procedure to install Perl DBD module from source thru the
below link...
ht
MySQL version 3.23.32
(please don't ask me to upgrade to the newest version of mysql as an answer)
Everytime the replication server gets reset, the slave properties gets all
messed up
I am assuming the master.info gets trashed
Is this a known issue for this version?
Anyways, I can use the CHAN
Hi, how do I do the following:
I have a table I have added a new field to, I want to take field X and copy
it to the new field for each record. What should this query look like?
Thanks,
Chuck
-
Before posting, please check:
Russell E Glaue wrote:
>Actually, I like this proposal of being able to plug in any language into
>MySQL. I also want to make a note that Greg Cope has a very good point.
>And going from what Greg mentioned in an earlier e-mail in this thread,
>the embedded language of choice really needs to b
I didn't have time to try out your hints/techniques described in your
earlier post, but after playing around a bit with the web frontend I decided
that it would be more user intuitive to used the month as column and the
state as row... The reason being my change of heart is I also have a similar
r
I seem to be having issues with the way MySQL names
the table files under Unix and WinXP. I'm not sure if it's a
mysql issue or a windows issue.
Normally, when I create tables in MySQL, I like to capitalize the
first letter. Under unix, it all works fine and dandy. But under
WinXP, the table n
Ibrahim,
Wednesday, April 03, 2002, 11:30:28 AM, you wrote:
IKC> I want to knowledge about blob.
IKC> how can write or read image(jpeg,gif or tiff) to/from MYSQL database by
IKC> using Visual C++. MySQL++ seems too confused.
:) In the manual you can find examples of loading/reading binary d
Hi, pwxgao
I will suggest to use JBuilder6 EnterpriseEdition and
Borland Enterprise Server. You will be able to build EJB(CMP2.0),
which can persistent blob column, very easily without coding. :-)
pwxgao wrote:
>
> I also interestig in this topic...I wanna know how to save a blob object ,
>
Valerie,
Tuesday, April 02, 2002, 9:13:50 PM, you wrote:
VB> I have a mysql table, which gives the error read-only when I use LOAD DATA
VB> INFILE command. How do I change this, I read the online manaul with no
VB> success.
It means that user mysql has no permissions to write in those files.
Stephane,
Wednesday, April 03, 2002, 11:13:51 AM, you wrote:
SP> How can I connect to a distant MySQL Server -using tcp/ip- securely ?
You can set up SSL-encrypted connection between boxes.
You can find more info about SSL at:
http://www.mysql.com/doc/G/e/General_security.html
http
Jane,
Probably u downloaded the file on your windows box and ftp'ed it using
"ascii" mode instead of binary as Egor has suggested.
-Prakash.
-Original Message-
From: Egor Egorov [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 8:40 PM
To: [EMAIL PROTECTED]
Subject: M
On Wed, Apr 03, 2002 at 06:10:02PM +0300, Egor Egorov wrote:
: Murali,
: Wednesday, April 03, 2002, 1:55:57 PM, you wrote:
You know, I don't meant to be a bother, but can you folks at Ensita
reply to the list using standard reply conventions? All of your
replies have
Actually, I like this proposal of being able to plug in any language into
MySQL. I also want to make a note that Greg Cope has a very good point.
I believe it to be good to be able to plug in any language, but the mySQL
community may want to make a standard recomendation of a certain language.
A
I am running Windows XP with MySQL running as a service. When I want to
run MySQL with the option for logging (--log -bin), I have to start the
service MANUALLY and type the --log -bin in the parameters box each time I
restart the server. Is there an easier way to do this?
Thx,
Craig
JOUANNET,
Wednesday, April 03, 2002, 3:32:25 PM, you wrote:
Jeoen> I search mySQL-MAX on the mySQL web site and just found mySQL binaries (not
Jeoen> mySQL-MAX binaries). Is InnoDB table handler compatible with HPUX (10.20 or
Jeoen> higher) ?
You can compile it from the source according to the i
Jane,
Wednesday, April 03, 2002, 12:27:33 AM, you wrote:
JT> We have encountered the problem to install Mysql-3.23.49 version on Linux
JT> Redhat 7.1.
JT> 1. Run rpm with Mysql-3.23.49a-1.i386.rpm, the installation failed.
JT> 2. Gunzip mysql-3.23.49.tar.gz, we got the error: invalid compresse
Bernd,
Wednesday, April 03, 2002, 2:42:33 PM, you wrote:
BM> I want to get the difference between 2 tables.
BM> table_1:
BM> column_1
BM> A
BM> B
BM> C
BM> D
BM> table_2:
BM> column_2
BM> B
BM> C
BM> What is the sql select syntax to get as result A,D or B,C?
Look at JOIN clause:
Murali,
Wednesday, April 03, 2002, 1:55:57 PM, you wrote:
MP> When I try to install the Msql-Mysql module it throws up a list of
MP> questions.One of them is :
MP> Where is your MySQL installed? Please tell me the directory that
MP> contains the subdir 'include'. [/usr/local]
It looks like in
1 - 100 of 143 matches
Mail list logo
