Jang wrote:
Hello,
I'm new in this MySQL list. I only want to know what are the default
privileges that are required, so that a normal user (wihtout any special
priv.) can acces only to his DB, create tables, manage, insert, ..., his
tables.
I have try some differents config, but never
Hi,
Can I have two (or more) different SQL-databases running at the same time on
the same server (or same computer)? Does it varies between the systems?
And if I can, are they all available to PHP at the same time?
If you *really* mean different databases, then yes, no problem (one of
Sanjeev Kabra wrote:
Hi,
I installed MyODBC and even configured it. MySQL db running on Solaris is
running under the root user. While defining the DSN using MyODBC in the
username I tried putting root user and the password for the same but I keep
getting error "can't connect to MySQL
I used to be subscribed to the ISP 'Globalnet'.
I have now moved to the ISP 'Demon'.
I can no longer obtain this newsgroup, I rang Demon and they informed me
that the newsgroup had to be submitted to them!
Please could someone who knows how, submit this newsgroup to Demon.
Thanks.
Legal
On Tue, Jan 30, 2001 at 12:26:34PM -0600, Meyer, Patrick wrote:
I am slowly gaining connections to the database that just sleep. I
know these can arise from not closing the database. I am accessing
it via MyODBC from Active Server Pages. However, I set wait_timeout
to 3600... I have some
Hello,
does anyone know a way to use a mysql database in a fortran
program?
I want to use something like embedded SQL in the fortran
program (f2c or g77 on a linux machine).
Manfred Meier
[EMAIL PROTECTED]
-
Before posting,
On Tue, Jan 30, 2001 at 02:35:29PM -0700, Nathan Cook wrote:
It seems like I have seen somewhere that load balancing and
fail-over-services are available for MySQL, to share the load and
mirror the data between two machines.
Other than MySQL's built-in replication, which doesn't handle
On Wed, Jan 31, 2001 at 09:44:06AM +0100, Chappuis J.-Vincent wrote:
Hi all !
I would like to know when the fields value has been changed and by
wich user ? Does it exist a trace or an history of the tables in
mysql database ?
Maybe. If logging is enabled on the server, you can probably
Iam Getting the error
"Unable to Connect to Local MySql Server through socket 'var/lin/mysql/
mysql.sock"
my Version For MySql is 3.22.32.
What is Th solutin For this mail me asap
adieu
Balaji.N
Get free email and a permanent
On Tue, Jan 30, 2001 at 09:44:55AM -0600, johnny p. wrote:
I have several tables in my db that can potentially become *very*
large *very* quickly. I was thinking about creating a table for
each user of my database to keep data separate and allow each table
to be 4GB due to OS restrictions.
On Thu, Feb 01, 2001 at 08:47:21AM -, Stephen Livesey wrote:
I used to be subscribed to the ISP 'Globalnet'. I have now moved to
the ISP 'Demon'.
I can no longer obtain this newsgroup, I rang Demon and they
informed me that the newsgroup had to be submitted to them!
Please could
On Thu, Feb 01, 2001 at 02:12:03PM +1300, Quentin Bennett wrote:
Hi,
Each time I install mysql from a binary release that I have created,
I have to modify safe_mysqld so that it can be called from
mysql.server.
This is because safe_mysqld checks to see if it knows what is going
on
At 08:47 01/02/2001 +, Stephen Livesey wrote:
I used to be subscribed to the ISP 'Globalnet'.
I have now moved to the ISP 'Demon'.
I can no longer obtain this newsgroup, I rang Demon and they informed me
that the newsgroup had to be submitted to them!
Please could someone who knows how,
"Matis, Jan" wrote :
Hallo,
I have small problem with my sql (again :)
version:3.23.32
linux: SuSE 6.2 kernel: 2.2.16, 2.2.18, 2.4.1
lib: libc-2.1.2-31 (suse)
compiled: gcc-2.95.2, egcs 2.7.2.3
compilation parameters: --prefix=/opt/mysql ( --without-debug
--enable-assembler)
memory:
On Wed, Jan 31, 2001 at 09:14:23PM +0100, Marcello Giovagnoli wrote:
Hi,
I have a problem with mysql 3.23.30 (binary distribution) and
Slackware 7.
Runnining different programs that access to database, the numbers of
mysqld grow up.
But when a single program exit, the number of mysqld
On Thu, Feb 01, 2001 at 04:19:06PM +0800, msquared wrote:
What happens if you pass decode() the wrong password?
Does it fail to decode? Does it simply return scrambled data?
Try it and see. :-)
--
Jeremy D. Zawodny, [EMAIL PROTECTED]
Technical Yahoo - Yahoo Finance
Desk: (408) 328-7878
On Thu, Feb 01, 2001 at 09:14:36AM +0100, Matis, Jan wrote:
Hallo,
I have small problem with my sql (again :)
version:3.23.32
linux: SuSE 6.2 kernel: 2.2.16, 2.2.18, 2.4.1
lib: libc-2.1.2-31 (suse)
compiled: gcc-2.95.2, egcs 2.7.2.3
compilation parameters: --prefix=/opt/mysql (
HI all
I can connect to Mysql server but cannnot connect to localhost(when no other
application is running on localhost)
please let me know if anybody has any solution
Thanks
shantanu
-
Before posting, please check:
Hi all,
I have installed MySQL 3.22.26a on a Solaris SPARC machine. When I try to
run mysql_install_db I get the following message:
-
Creating db table
Creating host table
Creating user table
Creating func table
Creating tables_priv table
Creating columns_priv table
ld.so.1:
I do have libstdc++.so.2.10 already - so how do I set LD_LIBRARY_PATH?
Thanks so much!
David
On Thu, 1 Feb 2001, Quentin Bennett wrote:
Hi,
Do you have libstdc++.so.2.10.0 somewhere on your system. If not, you'll
need to get it, if so you'll need to set LD_LIBRARY_PATH to point to the
Hello,
I'm new in this MySQL list. I only want to know what are the default
privileges that are required, so that a normal user (wihtout any special
priv.) can acces only to his DB, create tables, manage, insert, ..., his
tables.
I have try some differents config, but never have reach the right
Thanks for your help - of course it was as simple as .
Best to all,
David
On Thu, 1 Feb 2001, Quentin Bennett wrote:
Hi,
When you say 'hangs', what do you mean? Does CTRL-C work? Does the server
have to be killed with kill -9?
Are you running the program in the background?
#
Connecting to the tables in MySQL works fine. For example I can connect to
the MySQL tables using MS Access. I would like to know if it is possible to
connect to the tables of another database from MySQL. So instead of going
from MS Access to MySQL I would go from MySQL to an AS400.
Do I
Does anyone know why the Windows version of mysqlc (the command line client with
READLINE support) doesn't support the SOURCE command?
Thanks,
Mark Chalkley
-
Before posting, please check:
http://www.mysql.com/manual.php
I am running MySQL 3.23.32 on Linux 2.2.16 with large file support. Large
tables (tens of GB) work fine. mysqladmin variables shows large file support
is enabled.
The problem I am having showed up when I loaded a bunch of data into a simple
non-indexed table and then tried to do the following
mySQL currently does not support stored queries or views, though views are
planned in a future version of mySQL according to
http://www.mysql.com/doc/T/O/TODO.html. You can achieve a good speed
increase using mySQL as a back end to Access. The amount of performance
improvement will depend
msquared wrote:
I'm working for a company that has a paranoid client, and the client wants
their database to be 'secure'.
By 'secure' they mean that even if someone gains root access on the
server, the data in the database can't be compromised (obtained).
I can think of a couple of
On Wed, Jan 31, 2001 at 08:50:44PM +0100, leo.putz wrote :
Sorry for having to post the same problem a second time -
but by now I'm really at a loss.
Is there really no one out there to give me a hint?
I need the output of a query result (all query information is in one
row) in one column
On Wed, Jan 31, 2001 at 02:32:23PM -0800, Chuck Carson wrote:
I need to run more mysql processes than the default of 3. Where is
this configured?
MySQL runs as a single process but is multi-threaded. It dynamically
spawns new threads for incoming connections.
Jeremy
--
Jeremy D. Zawodny,
Connection myConn =
DriverManager.getConnection("jdbc:mysql:///test_db1?user=Usernamepassword=pas
sword");
Try with:
Connection myConn =
DriverManager.getConnection("jdbc:mysql://localhost/test_db1,"user","passwor
d");
===
Saludos,
Enric Badia
SONRIE,
LAS
On Wed, Jan 31, 2001 at 09:12:05AM +, Basil Hussain wrote:
I think I understand this now. The table_cache is the maximum number
of tables MySQL can keep open all the time. If your table_cache is
lower than the actual number of tables in use (in my case 64 versus
70), then when a table
Trying to build mysql-3.23.32 under solaris 7 with gcc version 2.95.2
19991024 (release) got error message :
gcc -DDEFAULT_CHARSET_HOME=\"/usr/local\"
-DDATADIR=\"/usr/local/var\"
-DSHAREDIR=\"/usr/local/share/mysql\" -DUNDEF_THREADS_HACK
-I./../include -I../include -I ./.. -I.. -I.. -O6
Description:
After U/G to 3.23.32 from 3.22.25 we can't make any inbound
TCP/IP connections if the mysql.user.host field is blank.
UNIX socket connections still work.
The documentation says that '' is the same as '%', but it
doesn't seem to be true.
msquared a crit :
Perhaps you want to distribute a CD full of databases, and people buy
access to specific databases. access = password
IMHO, this method can't protect the content of the CD.
Hace a closer look :
- you have read acces to the CD (files-level read access), but your
MySQL
Have you tried using the binary tarball from the MySQL web site?
http://www.mysql.com/Downloads/MySQL-3.23/mysql-3.23.32-pc-linux-gnu-i686.ta
r.gz
Jeremy
no I didn't ...so I changed it now and we will see on afternoon :)
Jan
hi there!
it seems logical to me that using CASE...END in an ORDER BY clause ought
to work. i can set up a CASE statement in a SELECT:
SELECT CASE test.ID WHERE 1 THEN 2 WHERE 2 THEN 1 END AS c
and i get the expected output. however, if i then try to move the whole
case statement into the
Now I can say I tryed
http://www.mysql.com/Downloads/MySQL-3.23/mysql-3.23.32-pc-linux-gnu-i686.ta
r.gz
too
and it dind't helped
mysqld got signal 11;
The manual section 'Debugging a MySQL server' tells you how to use a
stack trace and/or the core file to produce a readable backtrace
I have been running the 'menagerie' tutorial from the mySQL manual and sure
enough SELECT * FROM pet WHERE name REGEXP "[wW]"; returns Claws, Bowser and
Whistler. However, when I run SELECT * FROM pet WHERE name REGEXP "[w]"; (or
[W]) I still get the same results. Is there something I need to set
On Thu, Feb 01, 2001 at 02:25:15PM +1000, Peter Likidis wrote:
I hope this hasn't been asked before but I have asked in multiple
NGs etc and no one seems to know how to answer it.
I have gone through the instructions on setting up MYSQL on the
server (MacOS X). The problem is there is no
Hi there,
A DB newbie question - can I use MS Access for remote mySQL databases using myODBC??
Thanks.
I hope this hasn't been asked before but I have asked in multiple NGs
etc and no one seems to know how to answer it.
I have gone through the instructions on setting up MYSQL on the server
(MacOS X). The problem is there is no socket. I have no idea what I did
wrong. I cannot find a socket file
Primarily the database serves the web server so it is always the same host.
The database may vary, but some more than others. I feel confident that
some path through an ASP either crashes or the connection close command is
never reached or does not exist. However, I would think that the
Actually to ensure updateable tables in MS Access you need a TIMESTAMP(14)
and an AUTO_INCREMENT column.
Pat...
[EMAIL PROTECTED]
- Original Message -
From: "Scott Baker" [EMAIL PROTECTED]
To: "Gregory King" [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, January 31, 2001 11:43 AM
You state that the temporary files are on a separate partition.
Does the filesystem on this partition support large files?
Chris Black wrote:
I am running MySQL 3.23.32 on Linux 2.2.16 with large file support. Large
tables (tens of GB) work fine. mysqladmin variables shows large file
Hi all,
In the light of my recent experiences with tuning my MySQL server, I had a
few ideas about how getting optimum performance from your MySQL server could
be made a little easier for everyone.
My idea is to have some kind of facility to 'auto-tune' the server
configuration variables for
If you are installing from a binary release that you created, and need
to fix
save_mysqld after each installation, then you should complain to the
person that
created the binary release.
Or did I miss something?
Quentin Bennett wrote:
Hi,
Each time I install mysql from a binary release
hi!
"Marcello" == Marcello Giovagnoli [EMAIL PROTECTED] writes:
Marcello Hi,
Marcello I'm sorry, for my previus question "To thread or not to thread "
Marcello but now all it's OK. :)
Marcello Looking at /etc/my.cnf, i could see two variables:
Marcello set-variable= thread_cache=8
Petras Virzintas writes:
Hi, I'm trying to make mysqlgui on Linux 6.x. I have the following problem and any
advice will be welcome:
g++ -O3 -g -pipe -fforce-mem -fforce-addr -I. -I../mysql++-1.7.8/sqlplusint
-I../mysql-3.23.26/include -c do_sql.cc
I am running MySQL 3.22.32 on a sun enterprise server, but I am having
problems with update logging. When update logging is specified in the
/etc/my.cnf file and the MySQl process restarted logging will commence
but will stop after a few hours (the number of hours is variable!).
Connecting to the
Sir, Joe Celko's 'SQL For Smarties' has two chapters devoted to tree
problems. After a quick look in the book, it appears to me that you
can use one of his algorithms if you restructure your table and adapt
his SQL to the MySQL dialect. See the chapter on Nested Set Models.
Bob Hall
Hi,
I
1. Start the mysqld.
2. Make sure it is opening the socket in /var/lin/mysql
3. Make sure /var/lin/mysql is set mode 775
Balaji Nallathambi wrote:
Iam Getting the error
"Unable to Connect to Local MySql Server through socket 'var/lin/mysql/
mysql.sock"
my Version For MySql is 3.22.32.
There are some reserved words in new release. Read the manual.
- Original Message -
From: Paco Martinez [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, February 01, 2001 3:39 PM
Subject: MySQL + htdig
Is there any problem with htdig and MySQL 3.23.???
My PC was executing
Hi,
firstly thanks for your answer, [EMAIL PROTECTED] works very very well !
We are doing a very hard work with mySQL , used as main database inside
our ERP Oasi. (instead of DB2 or ORACLE).
We have a performance problem with memory usage.
the process accesses to database via ODBC
It seems that MySQL 3.23.32 has an internal deadlock problem, causing the
database to stop responding.
Situation:
6 processes (each on a different system) connect to a mysql database and insert
various system data into a set of MyISAM tables. Each process uses the user
'logdaemon' which has
Yes that is true but what I want to get at is. Like I want to get
all Childs of the Parents. But NOT the Parents. Meaning if the
one with a Parent ID is the PARENT then the Others with his ID
in the Parent_ID field is his children, And I want this to happen
like create a Treeiew for Instance
What would be the best way to take two separate databases, and merge them
together into a third database? From the discussions i've read, it seems
that dumping them both, then importing them to this new database might be
a way of doing it, but is a good way? will it work? Can you suggest a
If all tables name are unique, and if you can bear the downtime, just shut
down the server and copy the files of one of the database to another
database will do
- Original Message -
From: "Andrew Dennison" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, February 01, 2001 11:21 PM
But you still have to buy the ORACLE software right?
If the ORACLE database were free then I would be very interested
Chris
Web Engineer
Chartway Federal Credit Union
- Original Message -
From: "Fowler, J.T." [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, February 01, 2001
So sprach Fowler, J.T. am Thu, Feb 01, 2001 at 09:17:13AM -0600:
My error - I had the [EMAIL PROTECTED] URL in my notepad not the correct
ORACLE link
Well, I still don't get it - why should I want to shell out a huge amount of
money? I mean, your post would fit a lot better, if this was a
I was hoping that since each member of the SET really
represents a number, that there would be some bitwise
operation that would painlessly produce all the members
of the SET that appear at least once.
Sir, I apologize for taking so long to respond. I was moving some
furniture this weekend and
Hi Monty,
Why do you need to retrieve so many rows to the client? Can't you use
LIMIT to restrict the number of result rows?
The point is that the program scans the entire table and process each row
in a diffrent way, executing other queryes inside the main SQLFetch() loop.
Someting like
This works for me in access
SELECT families.objid, families.name, families.parentid, families_1.objid,
families_1.name, families_1.parentid
FROM families LEFT JOIN families AS families_1 ON families.objid =
families_1.parentid
WHERE ((families.parentid)=0);
-Original Message-
From:
Where can i get API for c??
I need API to use a gcc compiler in a freebsd OS!!!
tkz!!
[]'s Jader
By now you're probably thinking gasoline priced at about $1.49 is cheap.
Me too! As it is now $1.58 for regular unleaded. Now that the oil
Just an off topic observation. $1.58 is cheap. Here, (in the UK) our
Gas price is $6 a gallon. (Yes, six US dollars a gallon).
Its kinda annoying
"AS" == Alexander Skwar [EMAIL PROTECTED] writes:
AS Well, I still don't get it - why should I want to shell out a huge
AS amount of money? I mean, your post would fit a lot better, if
AS this was a Oracle mailinglist
The point, I beleive, is that Oracle finds MySQL such a threat to
their
Geoff Coffey wrote:
I am new here...
I am in the process of migrating a site built with FileMaker Pro to MySQL
and PHP mostly because filemaker's web capabilities are too limiting. In one
situation, we have a database of about 20,000 rows that contains two text
columns. One is the full
Heres the minimal version just to list children
SELECT families_1.name
FROM families INNER JOIN families AS families_1 ON families.objid =
families_1.parentid
WHERE (((families.objid)=1) AND ((families.parentid)=0));
I dont actually use mySQL but am considering it as an option but
Hi all,
I just came across this little tid-bit of information today and thought I'd
share it, seeing as it's potentially very useful to anyone trying to export
records from MySQL and then import them into a 'repeating' field in
Filemaker Pro.
When importing a text file of single-field records,
On Thu, Feb 01, 2001 at 04:21:15PM +0100, [EMAIL PROTECTED] wrote:
On 01.02.2001 14:54:11 Fowler, J.T. wrote:
Migration Kit for MySQL to Oracle on Linux Now Available.
Moving just got easier with the new MySQL-to-Oracle Migration Workbench-the
ideal migration software for developers
thanks A lot. :)..
Julian Strickland wrote:
This works for me in access
SELECT families.objid, families.name, families.parentid, families_1.objid,
families_1.name, families_1.parentid
FROM families LEFT JOIN families AS families_1 ON families.objid =
families_1.parentid
WHERE
On 01-Feb-2001 Sinisa Milivojevic wrote:
HI!
Most probably processes are waiting for the slave to get updated.
To circumvent the problem, you should :
- use our binary (if possible)
- avoid LOCK TABLES, which truly is necessary only in some rare cases
Regards,
Sinisa
And i thought 72.9 Cents (Canadian) per litre was expensive :(
Redvers Davies [EMAIL PROTECTED] on 02/01/2001 09:03:19 AM
To: [EMAIL PROTECTED]
cc: [EMAIL PROTECTED] (Ray Ray), [EMAIL PROTECTED] (mySQL Mailing List),
[EMAIL PROTECTED] (Jeff Hunt), [EMAIL PROTECTED] (Ed Holmes),
Where can i get an exemple of connection using c with mysql!
for gcc with freebsd OS.
tkz!
[]'s Jader
Would you please offer me something please ?
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Mysql Bug ? (Can't Connect to Mysql Server on 192.9.200.2
(10055))
Description:
I am connecting from Visual Basic 6 to Mysql via
ODBC DSN. When i made 94 sleeped connection after 94
Speaking as one who tried working with such a connection, FORGET IT.
While entering data, I might get all or half a record entered when
the message arrives telling me the information cannot be posted,
because another user was editing that record (which I could tell was
simply NOT the case),
I think I'd be buying one of those hybrid cars if I were you. They get
something like 60 miles per gallon. I think I'd be riding my bike more
too...
Oh, and last I checked, gas here in Ohio is $1.28/gallon today.
:)
-Angela
Redvers Davies wrote:
By now you're probably thinking gasoline
I have no problem with paying for good software or good services;
that deserves payment.
I just hate to pay for something, only to find it doesn't do what I
need it to do, the warrantee is worthless, and getting tech support
is like pulling teeth. Argh!
Basic business practice should be
Hi
Attempting to make nysql-3.23.32 on a DEC alpha Tru64 box. Keep
getting error
/install-dir/lib/mysql ( no such file or directory ). Anybody seen
this before ?
Thank You
John Markunas
-
Before posting, please
In the manual.
www.mysql.com
On 01 Feb 2001 17:29:02 -0200, Jader Wallauer wrote:
Where can i get an exemple of connection using c with mysql!
for gcc with freebsd OS.
tkz!
[]'s Jader
-
Before posting, please check:
- Original Message -
From: "Ren Tegel" [EMAIL PROTECTED]
To: "Redvers Davies" [EMAIL PROTECTED]
Sent: Thursday, February 01, 2001 7:17 PM
Subject: Re: [CGI] Gas Prices
This sure would be a reason for microsoft to distribute less cd's and more
pre-installed os's due to 'increased
On Thu, Feb 01, 2001 at 05:29:02PM -0200, Jader Wallauer wrote:
Where can i get an exemple of connection using c with mysql!
for gcc with freebsd OS.
tkz!
[]'s Jader
1) Any of the C clients in a MySQL source distribution: mysql, mysqladmin,
mysqlshow, etc.
2)
I have read on replication, just recently.
What I could gather from the manual: The replication creates an exact
mirror of a database on another server using a parent server to a daughter
server method.
Which brings up two issues: How long is the lag? How could I use this to
load balance?
dear Sir :
MySQL 3.22 on my linux 486 PC seems work so good. when I compile
a simple C API programe which catched from the MySQL tutorial, it
chokes at the end of compile process . the programe is as follows:
#include stdio.h
#include mysql.h
#define def_host_name NULL
#define def_user_name
When using mySQL I've learned to avoid OR in any queries as much as possible
. Almost always this causes a major speed decrease. Consider this table:
CREATE TABLE test(
userID int, # (non-unique)
testID int, # (non-unique)
PRIMARY key(testid,userid)
);
Suppose this table is
Hi all just wanted some professional opinions on my web site located at
http://www.IWantYourStuff.com
I developed the site using HTML (of course) with Perl scripts accessing a
mySQL database. If anyone would like to comment on it or make any
suggestions please drop me a line.
Thanks.
Geoff Coffey wrote:
I am new here...
I am in the process of migrating a site built with FileMaker Pro to MySQL
and PHP mostly because filemaker's web capabilities are too limiting. In one
situation, we have a database of about 20,000 rows that contains two text
columns. One is the full
Shouldn't the first query have parenthesis? As in:
DELETE FROM test WHERE userID=X AND (testID20 OR
testID80);
Even if it works the other way, parenthesis make it more clear what
you're trying to accomplish.
-Angela
Michael Griffith wrote:
When using mySQL I've learned to avoid OR
Hi!
I really need a search engine that can make my users able to do a free text search in
my MySQL database. I have 800 records, so a query like
SELECT * FROM table WHERE content LIKE '%searchtext%'
goes really slow.
I wonder if MySQL support Chinese encoding full text index?
From: "Geoff Coffey" [EMAIL PROTECTED]
Sent: Thursday, February 01, 2001 5:25 PM
I am in the process of migrating a site built with FileMaker Pro to MySQL
and PHP mostly because filemaker's web capabilities are too limiting. In
one
situation, we have a database of about 20,000 rows that
Shouldn't the first query have parenthesis? As in:
DELETE FROM test WHERE userID=X AND (testID20 OR
testID80);
Even if it works the other way, parenthesis make it more clear what
you're trying to accomplish.
-Angela
Actually, yes. Sorry about the poor example. My point is that
on 2/1/01 1:36 PM, Gonzalo Aguilar at [EMAIL PROTECTED] wrote:
Making search engines is not a trivial thing, but this may be an
aproach...
I appreciate all the replies. In my original post I also asked about the
FULL TEXT index type. If I may ask again, has anyone had any experience with
Hello list,
After searching the documentation on the site, as well as the archives, I
have yet to find the answer to this question. If I have overlooked it
somewhere, just point me in the right direction.
The question:
I have two tables, set up exactly the same, except the names of the
Hi Barry,
I do not know what do you use for feeding your database, but in Perl you
shoud use the DBI module, and insert the binary data through bindings.
use DBI;
use strict;
...
my $dbh = DBI-connect("dbi:mysql:image_db", "user", "password") || die
"$DBI::errstr\n";
In the last episode (Feb 01), Michael Griffith said:
CREATE TABLE test(
userID int, # (non-unique)
testID int, # (non-unique)
PRIMARY key(testid,userid)
);
Suppose this table is populated with 1,000,000 rows. Then do this:
DELETE FROM test WHERE userID= AND
Can be done in two steps, but not in one:
insert into deleted_users select * from active_where where username='joe';
delete form active_users where username='joe';
what you mention about usernames not being unique in the deleted_users
table is
not a problem as long as you don't have a primary
It is in the manual.
Approximately ( Don;t have manual in front of me ):
insert into deleted_users select from active_users where user_name =
"joe_smith";
delete from active_users where user_name = "joe_smith";
Aaron Williams wrote:
Hello list,
After searching the documentation on the
Hi!
On Feb 01, Nicolas GREGOIRE wrote:
msquared a ecrit :
Perhaps you want to distribute a CD full of databases, and people buy
access to specific databases. access = password
IMHO, this method can't protect the content of the CD.
Hace a closer look :
- you have read acces to the
Hi!
On Feb 01, Tõnu Samuel wrote:
msquared wrote:
I'm working for a company that has a paranoid client, and the client wants
their database to be 'secure'.
By 'secure' they mean that even if someone gains root access on the
server, the data in the database can't be compromised
Hi!
On Jan 30, Sheer El-Showk wrote:
Please cc [EMAIL PROTECTED] on any response, I'm on the list but I filter to
a file, thanks.
Can someone (maybe with some MySQL-innards code experience) please explain
this problem:
Generating an index on the first character of a varchar(70) on a
well I believe this has to do with the file descriptors, but I use RH 7.0
and you can change the file descriptor max under /proc/sys/fs/file-max and
inode-max
On Thu, 1 Feb 2001, Chuck Carson wrote:
I was under the impression ulimit controlled this, but someone just told me
that by default,
1 - 100 of 154 matches
Mail list logo
