> I'm using the same MySQL version on debian and have no problem
> setting the key_buffer size. I take it you are setting
> "key_buffer" and not "key_buffer_size" in the my.cnf file ?
> eg.
> set-variable= key_buffer=32M
Yes, this is what I'm doing.
> Are you saying that running "change mas
hi, MySQL community. I am hoping to use the C API in Mac OS X using
codewarrior, but it looks like the libraries provided in the standard
MySQL distribution are not compatible. I've done a brief search
through the archives of this list and it looks like this problem has
been mentioned at leas
hi there i have been doing some test cases between master/slave , i have it
replicating but how is the slave meant to be used as the backup when the
master fails or better still how do i get the slave to share some of the
master sql server load ? atm i stopped the master on purpose to hopefully
see
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Tea Yu wrote:
> > Hi there!
> >
> > Sorry, cause I didn't copy-n-paste those so there were typos, actually I
> > created the table in console:
> >
> > 1) create table test (id INTEGER NOT NULL AUTO_INCREMENT, name
VARCHAR(255),
> > primary key (
sorry it was a file permissions error, got both running now have to
recompile php though :|
-Original Message-
From: Dan Rossi [mailto:[EMAIL PROTECTED]
Sent: Saturday, March 01, 2003 2:59 PM
To: [EMAIL PROTECTED]
Subject: replication slave startup
bit of a problem i installed a master s
bit of a problem i installed a master server then i installed a slave server
in its own path
i try to start it up and i get this error
030302 2:12:44 Fatal error: Can't open privilege tables: Can't find file:
'./mys
ql/host.frm' (errno: 13)
i have done the mysql_install_db script
--
PHP Database Mailing List (http://www.php.net/)
Mostly MySQL with a smattering of other db's from time to time.
hth,
Doug
On Fri, 28 Feb 2003 13:30:40 -, Andrew wrote:
>Using MySQL and PHP
>
>PS. Do any of you knw of a forum specifically out there for PHP and MySQL?
>
>Andrew
---
Hello,
This is the way I normally do queries that would be solved with
sub-selects in other products:
SELECT F.idFilm, F.title
FROM Films F, Loans L
WHERE F.idFilm = L.idFilm
AND L.dateReturn IS NULL;
Sam A. Funk
At 02:27 + 03/01/03, Remi Mikalsen wrote:
Hello,
I believe, and hope, I have a
Hello, Remi;
Try this; I *think* it'll work (but I'm also new to MySQL):
select F.idFilm, F.title
from Films F left join Loans L on F.idFilm = L.idFilm and L.dateReturn
IS NULL
where L.idFilm IS NULL;
This provides an interesting example of the difference between "on" and
"where", by the way; it
quoted from mysql-4.1/libmysql/libmysql.c
=
static ulong
mysql_sub_escape_string(CHARSET_INFO *charset_info, char *to,
const char *from, ulong length)
{
const char *to_start=to;
const char *end;
#ifdef USE_MB
my_bool use_mb_flag=use_mb(charset_info);
#endif
for (end=from+length;
I've been working off and on now for a while to try to set up a master
server containing all of the mysql privilege tables for our mysql servers.
This has turned out to be a huge pain and now I don't even know if it will
ever work. The biggest culprit is the fact that the mysql database is the
onl
Hello,
I believe, and hope, I have a very simple question, but as I am relatively new to
MySQL I might be missing out on the obvious solution.
Is it possible to use a single MySQL query (with the simple scheme presented) to
ask the following question?
Scheme:
Films (idFilm, title)
Loans (i
Hi Tore,
Thank you so much. You are correct, I had duplicate
records in the file. I haven't finish cleaning up the
table. Once I finish cleaning and run the query and
if I still duplicate, I will let you know.
Till then, thank you so much for the answer.
Unni
--- Tore Bostrup <[EMAIL PROTECTED]>
change
$sql .= "VALUES(?, ?)";
into
$sql .= "VALUES(?, password(?))";
Please note that password is a mySQL function and not a PERL function. So,
you need to use the password function again in verify the password.
Regards,
KH
> I have perl code like
>my $username = $query->param("user
At 18:49 -0500 2/28/03, Cl. Yuri Huitron Alvarado wrote:
Hi, I have MySQL 3.23.49 and I access the mysql with :
% mysql -u user -p
Enter password:***
and type :
mysql> use user's_database;
and returns :
Reading table information for completion of table and column names
You can turn off this
Hi, I have MySQL 3.23.49 and I access the mysql with :
% mysql -u user -p
Enter password:***
and type :
mysql> use user's_database;
and returns :
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database cha
Both email columns have the same format (varchar) and are indexed
individually:
describe SELECT person FROM person WHERE email1='foo' OR email2='foo';
++--+---+--+-+--+---+-+
| table | type | possible_keys | key | key_len | ref | rows |
How about:
my $sql = "INSERT INTO apidbusers VALUES (?, password(?))";
--jeff
- Original Message -
From: "Jianping Zhu" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, February 28, 2003 2:48 PM
Subject: Re: mysql encripted password from perl
> sth->execute($username, password
In the last episode (Feb 28), Mark Hennessy said:
> On Fri, 28 Feb 2003, Mark Hennessy wrote:
> > I just rebuilt mysql 3.23.55 on FreeBSD 5.0, and I am trying to start
> > mysqld with my databases, and all of a sudden I'm getting this error. I
> > was wondering if anyone has seen this and might kn
Additionally, it appears that this error only comes up when the DATADIR
for MySQL is set to a directory on an NFS-mounted drive. I am also asking
the FreeBSD list if they have seen anything like this come up.
--
Mark P. Hennessy [EMAIL PROTECTED]
On F
sth->execute($username, password($password1)) does not work.
On Fri, 28 Feb 2003, Jianping Zhu wrote:
>
> I have perl code like
>my $username = $query->param("username");
>my $password1 = $query->param("password1");
>my $sql= "INSERT INTO apidbusers ";
> $sql .= "VALUES(?, ?)";
Do you know how to make a counter, something like this
SELECTj++ClientCode ClientName
so the ouput seria
11030John
23202 Mary
34033Xavier
etc
Thnak
- Original Message -
From: "gerald_clark" <[EMAIL PROTECTED]>
To: "J
I just rebuilt mysql 3.23.55 on FreeBSD 5.0, and I am trying to start
mysqld with my databases, and all of a sudden I'm getting this error. I
was wondering if anyone has seen this and might know where I should start
looking?
--
Mark P. Hennessy [EMAIL
> when I do this this is what I get:
> starting mysql with databases from /var/lib/mysql
> 030228 16:00:55 mysqld ended
This may be your culprit right here... not sure where the mysql_install_db
defaults its installs to, but I'm guessing its not /var/lib/mysql. And you
installed everything into /
I have perl code like
my $username = $query->param("username");
my $password1 = $query->param("password1");
my $sql= "INSERT INTO apidbusers ";
$sql .= "VALUES(?, ?)";
$sth->execute($username, $password1);
In this way, password1 will be in mysql table as plain text.
how ca
Please help. I downloaded the binary distribution for
mysql-3.23.55-pc-linux-i686 to run on redhat linux 8.0
I've done the following commands:
shell>> cd /usr/local
shell>> gunzip < /downloads/mysql-3.23.55-pc-linux-i686.tar.gz | tar xvf -
shell>> groupadd mysql
shell>> useradd -g mysql mysql
she
Juan Carlos wrote:
Hello Everybody
I using MySQL and I want to show the record id for the SELECT
I know you can do
SELECT clientCode, clientName limit 20, 3
2030John
2040Charles
2050Mery
The limit show from record 21 (record id = 20) because the first start in 0
I want to show
Hi, I just installed 3.23.55 and I started getting this message when
I run mysql from the shell.
/tmp/mysql.sock exists and the permissions are right and mysqld is
running, also the weird thing is that php is connecting just fine.
any ideas?
thanks,
- Mark
-
Partly right
I'm using RedHat 7.3 and it has an automated update funktion. Both Apache, MySQL and
PHP are updated by the scripts, and during that proces the connection between PHP and
MySQL disappeared.
But how to diagnose where the configureationproblem is???
Henning
Michael Mulligan <[EMAIL P
I'm using link based sessions, but I don't think that can be the culprit.
The SQL statement includes WHERE sessID="whateveritis". Explorer appears to
identify the correct record because it clears the NULLs; it just doesn't
write the new data.
Roddie
on 28/2/03 9:45 am, Scott Haneda at [EMAIL PR
>> Here's a nice MySQL simple returning records query question!
>>
>> I want to return a staement saying 'number of records shave been
>> found'
> for your
>> selection.
>>
>> so presumably this is a simple row count based on the the returning
> recordset?
>>
>> Andrew
>
> Either with PHP or C you
So depending on which columns you were looking at, two rows might seem like
duplicates or not? If your SELECT statement only requested certain fields,
your result set might have duplicates that wouldn't be duplicates if you
were looking at other columns as well? Is this correct?
So if I had this i
Your guess is correct, DISTINCT works on the result set - i.e. if the result
set contains two result rows that contain exactly the same values, it will
eliminate the duplicate from the result set. SELECT DISTINCT is equivalent
with using a GROUP BY without an aggregate function.
SELECT DISTINCT x
hi,
I appreciate the time you spared for my problem.
Thanks, that helped :)
Regards
Anil
-Original Message-
From: Bruce Feist [mailto:[EMAIL PROTECTED]
Sent: Friday, February 28, 2003 2:47 PM
To: Anil Garg
Subject: Re: database query.
There really isn't enough information for me to a
> Here's a nice MySQL simple returning records query question!
>
> I want to return a staement saying 'number of records shave been found'
for your
> selection.
>
> so presumably this is a simple row count based on the the returning
recordset?
>
> Andrew
Either with PHP or C you can use mysql_num_
From: [EMAIL PROTECTED]
Subject: bug - sec_to_time has a low upper limit on the range
Description:
sec_to_time will not return times greater than 24,
my hunch is that sec_to_time() is wrapping at 24:00 for some reason or
that's some kind of bound, and it's not sticking to the TIME type which has
I have a client word database and I am attempting to create a database with
the results from a select that splits the description field based on the
spaces.
When just executing the select command, the output is correct. When using
the create command with the select command, apparently the IF stat
> From: "Sheryl Canter" <[EMAIL PROTECTED]>
>
> > > DISTINCT removes duplicates: rows that are the same in *all* columns.
> >
> > Would this be all columns in the table, or all columns retrieved by the
> > SELECT statement?
in the SELECT statement :)
SELECT queries do not alter your rows, you
Here's a nice MySQL simple returning records query question!
I want to return a staement saying 'number of records shave been found' for your
selection.
so presumably this is a simple row count based on the the returning recordset?
Andrew
---
In your If statement (if this is still true) you are using...
> if(($applique == 1) && ($puffyfoam == 0)) etc.
But in your list you are using
> {$row['applique']} Applique
> {$row['puffyfoam']} Puffy Foam
Since I am seeing bits and pieces
Hello everyone,
I am running MySQL version 3.23.52 on Mandrake 9.0 and access it from a web
application running on IIS on Win 4.0 Service pack 6a with MyODBC version
2.50.39.
The problem I am having is when I create a temporary table and then query
the temporary table I get a Table doesnt exist
Paul,
> DISTINCT removes duplicates: rows that are the same in *all* columns.
Would this be all columns in the table, or all columns retrieved by the
SELECT statement?
TIA.
- Sheryl
sql,query,queries,smallint
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Shery
Hi,
I have a table as shown with approx 500 lines:
---
Tndr| Detail|
34 | one |
47 | two |
34
MySQL
Part of configure reads:
(cd mit-pthreads; sh ./configure)
I invoked configure as so:
sh -v ./configure 2> /tmp/foo
This leaves the following at the end of /tmp/foo while its running:
./configure: mit-pthreads: No such file or directory
./configure: mit-pthreads: No such file or directo
Attempts at creating an embedded mySQL DLL for VB:
I can successfully use the mysql_init() function from libmysql.lib to create
a DLL for VB. However, when I use this function (in a DLL or lib)linked
against the libmysqld.lib or mysqlserver.lib it crashes the VB application
but not the C applic
Here's what I've got in my form:
echo "{$row['designname']}
{$row['designfile']}
{$row['designcomments']}
{$row['applique']} Applique
{$row['puffyfoam']} Puffy Foam
$mes
Hello Everybody
I using MySQL and I want to show the record id for the SELECT
I know you can do
SELECT clientCode, clientName limit 20, 3
2030John
2040Charles
2050Mery
The limit show from record 21 (record id = 20) because the first start in 0
I want to show that record i
Hello.
On Thu 2003-02-27 at 14:52:56 -0800, [EMAIL PROTECTED] wrote:
[...]
> Anyways, I'm running into a little bit of a performance issue as the old
> database report writer had direct access to the database through a c library
> (no sql interface). On some reports there can be as many as 100,00
OK It's a PHP-problem then..
You are right - I use PHP 4.
I thought it was a Apache-problem.
But when I try the phpinfo.php, I get this (among much more)
dbx
dbx support enabled
dbx version 1.0.0
supported databases MySQLODBCPostgreSQLMicrosoft SQL Server
dba
DBA support enabled
Supported ha
Neil,
> Hi! I've just started working in Linux, but I'd like to know which
> database is better to use, MySQL or PostgreSQL. Which one would be
> better in the long run?
I guess about anyone on this list will scream "Postgre is better", but
let me make an exception.
Some people consider Postgr
>Description:
after starting mysql via init script, one can not log off a SSH
session
>How-To-OBRepeat:
log into box via SSH as root
/sbin/service mysql start
attempt to log off.. and the session hangs until you use
another session to stop mysql.
>
What language are you using? As far as I know Apache doesn't connect to
databases, you have to use a programming language to do that. I'm guessing
you are using PHP and you have possibly upgraded it without compiling in
mysql support.
-Original Message-
From: Henning Olsen [mailto:[EMAIL
Hello
I use Apache/1.3.27 Server
I use to use a mysql-connection, but now the apache support is gone.
Trying to connect to my MySQL-database gives following result:
Fatal error: Call to undefined function: mysql_pconnect() in...
How do I get the MySQL-support back?
Henning (newbie)
___
From: "Frank LIU" <[EMAIL PROTECTED]>
> I also did some other test:
> I ceated two tables both only have two columns, and both load 5 rows.
> Talbe A has two int type columns,
> Table B has an int type as primary key, and a mediumblob column. I insert
a
> 4k data into blob column of each row.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
[EMAIL PROTECTED] wrote:
You have written the following:
It seems that the new MySql Connector/J has a "bug".
If one calls close() twice on the same statement a NullpointerException is
thrown.
Best regards
Horst Scheruga
Hmmm, the following testcase p
Why don't you verify what the values are in the variables. If the Variables
are not getting set then you would always see the "oops" in your statement.
Try...
echo $applique;
echo $puffyfoam;
Hope this helps
Roger
-Original Message-
From: Stitchin' [mailto:[EMAIL PROTECTED]
Sent: Friday,
Dear sir,
I'm using mysql Ver 12.16 Distrib 4.0.5-beta, for Win95/Win98 (i32).
I have an innodb table which contains more than 40 columns, after it load
5 rows, the query:
select count(*) from t;
takes 11 seconds. while the same table with ISAM type, the query only takes
0.02 second.
I
> Since you're posting on a MySQL list, you could probably expect some
> biased responses. Could you post more about what you need to use a
> database for, i.e., what are your needs, wants, what kind of data are
> you handling, connection rates, serving platform, code base, etc.
>
> Here are a few
You have written the following:
It seems that the new MySql Connector/J has a "bug".
If one calls close() twice on the same statement a NullpointerException is
thrown.
Best regards
Horst Scheruga
-
Before posting, please ch
Since you're posting on a MySQL list, you could probably expect some biased
responses. Could you post more about what you need to use a database for,
i.e., what are your needs, wants, what kind of data are you handling,
connection rates, serving platform, code base, etc.
Here are a few URLs I was
As with most things, depends on what you want to do, what are the
requirements ?
Jerry
- Original Message -
From: "InfoSysNCA" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, February 28, 2003 5:23 PM
Subject: MySQL or PostgreSQL
> Hi! I've just started working in Linux, but I
Hi! I've just started working in Linux, but I'd like to know which
database is better to use, MySQL or PostgreSQL. Which one would be
better in the long run?
--
Regards,
Neil
-
Before posting, please check:
http://www.mysq
Boy, this is getting real frustrating ... doesn't this seem to be child's
play? I'm not trying to do anything fancy ... I tried the && and
parentheses suggested below and it still didn't work. I even tried to put
quotes around the zeros and ones thinking maybe the program wasn't
recognizing that
Frank,
Sorry that I seem to be explaining this so poorly. I'll try to clarify what
I'm trying to do and what my questions are. Someone on this list did give me
code that I think will work. I haven't had a chance to try it yet.
My question about how DISTINCT works is this: does it operate on the *
On Fri, 28 Feb 2003, Sherwin T. Ang wrote:
> Well I guess the best way is to make an insert statement that goes like,
>
> INSERT INTO table values (3,'S',1,6,'2002-07-15','The Palm Computing
> Device',1),(2,'S',6,6,'2002-07-18','Programming for the
> Palm',1),(4,'S',5,6,'2002-07-1
> 6','Medical Ap
Hi,
> > Hi,
> >
> >I would like to know if is there a way to delete constraints
> >without dropping and recreating a table. If there isn't, I would
> >like to know when do you plan to implement this important feature.
I would also like to see this feature. I have been implementing a
On Friday 28 February 2003 18:07, Juan Carlos wrote:
> I want to make a Simple Select using MySQL that show me number of rows, or
> make a count
> and show something like this:
>
>
>record#ClientCodeClientName
> 1 1020John
>
On Friday 28 February 2003 15:57, Shripal Shah wrote:
> How can I Lock my database in MySQL with password. As we are having only
> password for User but what I have to do if I want to lock whole
> database.
There is no password per database in MySQL. But if the user doesn't have
permissions on t
On Friday 28 February 2003 15:19, Nitin Nanivadekar wrote:
> Dear friends,
> I am not getting INNODB support as per describd in
> mysql manual.
> my c:\ has only 230MB free can this be a problem?
> when i make changes in my.cnf as per the manual,
> 'mysql' stops responding.
> pls provide detailed
On Friday 28 February 2003 05:22, Dan Rossi wrote:
> hi there i was wondering if there was a must get mysql book or paper
> covering query optimisation ?
Some info you can find in the manual:
http://www.mysql.com/doc/en/MySQL_Optimisation.html
And look also at Paul DuBois book "MySQL".
The technique to do this is called a cross-tab(ulation) query or a pivot
table. A simple (and pretty static) cross-tab query can be created by the
use of CASE WHEN. But if you want a more generic solution that works for
all values, it gets a bit more complex. Spend some time investigating
Google
I have encountered a problem regarding MySQL / ODBC !
I have an application written in PB6.5 and running in Windows XP Home
Edition.
There is an error generated while updating to MySQL table:
"Row Changed Between Retrieve and Update".
I tried to move the application to Windows 98 and it worked pr
Since you haven't told us your table designs, I have to guess, but something
like:
SELECT I.ItemSKU,
I.ItemName,
I.ItemDescription,
I.PostCode,
I.Category,
I.CityID,
I.CTelephone,
I.ItemID,
I.Cfax,
I.Cemail,
I.Caddress
This is so simple and basic, I must be missing something
I have php code for displaying my embroidery designs on the web page. It's
going through the mySql database and the query to pull up all the designs
for a
chosen category works fine. I have two fields in
my database called "applique"
Sheryl,
I'm trying to determine which author has the highest royalty percent FOR
EACH PROGRAM, not overall. I'm displaying a list of programs and authors,
and when there is more than one author, I want to show the principal author
(i.e., the one earning the highest royalty percent).
Ok, so your des
Hi
I want to make a Simple Select using MySQL that show me number of rows, or
make a count
and show something like this:
record#ClientCodeClientName
1 1020John
2 1032 Mary
3
PHP Guys & Dolls I have a sight display issue that I just need to resolve :)
After a select I end up with a record = 9 but I want to display the record as
the name not the value.
The value was inserted as a value so I need to make a join to the original table
in the query, but alas I have tried a
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Tea Yu wrote:
Hi there!
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Tea Yu wrote:
Hi! I just tried
Windows ME + MySQL Server - 4.0.9/4.0.11 +
ConnectorJ - 3.0.4/3.0.6/3.1.0
with an InnoDB table
test (id bigint not null auto_increment, na
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Emma Wansbrough wrote:
My code works fine with autcommit on..however it does not support
autocommit off. This is quite a big bug, or I have missed something out.
Please let me know as I it would be of great interest to me if I was
mistaken or correct an
mysql,
Can I change the table one column to one row like this?
Table1:
key, count
A 123
B 456
C 789
to
Table2:
A B C
123 456 789
Thanks,
-
Before posting, please check:
http://www.mysql.
Yea thanks for correct this, so I'm getting the right resultSet in
console...
but still having problem thru ConnectorJ, "select last_insert_id()" returns
a String to me, rs.getString(1) throws no exception.
Tea
> You don't select last_insert_id() from table.
> This will return the last_in
Hi there!
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Tea Yu wrote:
> > Hi! I just tried
> > Windows ME + MySQL Server - 4.0.9/4.0.11 +
> > ConnectorJ - 3.0.4/3.0.6/3.1.0
> >
> > with an InnoDB table
> > test (id bigint not null auto_increment, name varchar(255))
> > also t
Yes,
Back up your data every night. Then you will only have to perform a single simple
restore instead of rebuilding from four months ago. I know that this sounds like a
smart ass reply but I am serious. Disk space is cheap. CD's are cheap. Other media
like DVDs are getting cheaper every day. U
My code works fine with autcommit on..however it does not support
autocommit off. This is quite a big bug, or I have missed something out.
Please let me know as I it would be of great interest to me if I was
mistaken or correct and you will consider fixing it.
If I switch off auto commit and sele
For readability, using the INNER JOIN clause makes it immediately clear
what/how you are joining the tables, but it isn't too hard to read that from
a WHERE clause either. Of course, for other types of join, definitely use
the JOIN statement.
It is *possible* that the optimizer may treat an INNER
I have a big problem to solve on my site, and I'm not sure how to approach
it. I'm selling software that's distributed as trialware (will be--haven't
launched yet). Users will be able to unlock the time-limited versions with a
license. I want to send the license to the user after her payment has be
Respondendo,
quinta-feira, 27 de fevereiro de 2003, 13:32:39, Mensagem Original:
AN> Are you using Windows? If so, this root/mysql user talk will be
AN> meaningless. You can still make the directory secure and only touchable
AN> by the user that mysql is running as. Is this what you need?
nope
Of course because your MySQL engine is off.
Start up your MySQL.
Why not with Linux. Linux is far better than the
Stupid Windows Plat form.
Windows is only for a computer idiot. (but I am not
meaning that you are idiot. I mean the windows).
--- Ahmed Shams <[EMAIL PROTECTED]> wrote:
>
> I am ha
Databases are neither slave nor master, servers are.
A master may have many slaves, but a slave may have only
one master.
Brandl, Thomas wrote:
Hey guys,
Simply said, imagine this scenario:
A MySQL server with about 10 databases: A and 1 to 9.
Database A contains a 'special' table that is supp
Hi All,
Please help me, how can I download, store or read a content of an BLOB field
to the local filesystem via the internet. I have tried it, but it wasn't
right:
SELECT Picture INTO DUMPFILE "C:\TempFile" FROM article where `ColumnID`=1
and `ArticleID`=4;
It stores the file to where the sql s
You don't select last_insert_id() from table.
This will return the last_insert_id() for each row of the table.
You just select last_insert_id().
Tea Yu wrote:
>Hi! I just tried
>Windows ME + MySQL Server - 4.0.9/4.0.11 +
>ConnectorJ - 3.0.4/3.0.6/3.1.0
>
>with an InnoDB table
>test (
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Tea Yu wrote:
> Hi! I just tried
> Windows ME + MySQL Server - 4.0.9/4.0.11 +
> ConnectorJ - 3.0.4/3.0.6/3.1.0
>
> with an InnoDB table
> test (id bigint not null auto_increment, name varchar(255))
> also tried
> test (id int not null
Dear Sir/Madam,
How can I Lock my database in MySQL with password. As we are having only
password for User but what I have to do if I want to lock whole
database.
Waiting for your favorable reply.
Thanks & Regards,
Shripal.
-
Thomas,
Well I guess the best way is to make an insert statement that goes like,
INSERT INTO table values (3,'S',1,6,'2002-07-15','The Palm Computing
Device',1),(2,'S',6,6,'2002-07-18','Programming for the
Palm',1),(4,'S',5,6,'2002-07-1
6','Medical Applications for the Palm Device',1);
The above
Hi,
If I run a mysql query then work through the results of that query one at a
time, deleting the record sometimes eg:
while (my $href = $sth->fetchrow_hashref())
{
if ($href->{'ExpiryDate'} eq '2003-02-22 00:00:00') {
# Do something
# then...
$db->do("DELETE FROM MyTable WHERE ID
Thanks, I just learn't a lot about SQL
---
Rob
**
Rob Cherry
mailto:[EMAIL PROTECTED]
+27 21 447 7440
Jam Warehouse RSA
Smart Business Innovation
http://www.jamwarehouse.com
**
-Original Message-
From: Diana Soares [mailto:[EMAIL PROTECTED
Thanks, I just learn't a lot about SQL
---
Rob
**
Rob Cherry
mailto:[EMAIL PROTECTED]
+27 21 447 7440
Jam Warehouse RSA
Smart Business Innovation
http://www.jamwarehouse.com
**
-Original Message-
From: Diana Soares [mailto:[EMAIL PROTECTE
Hello Nitin,
You can check the error messages in your database directory, it is usually
named your.hostname.err it will give hints on why the mysql server won't
start.
also make sure that the 230mb free on your drive c: doesn't yet include the
windows swap file, and your innodb space is less than
A select query I am running is working fine, except when the results are
returned I wouldn't mind the query select options to display the full list
again. Instead I believe there is a way I can query the table to display the
value selected from the previous page. Anyone know what I am talkingabou
I believe this is close to what I am needing.
Thank you for your time and detail.
My thank you to everyone else for their comments.
Thanks,
Jeff
On Thu, 2003-02-27 at 12:13, Vikash K Agarwal wrote:
> We have used procmail and PHP combination to achieve this for our
> department mail management
1 - 100 of 120 matches
Mail list logo
