Hello all,
I have writed a program and compiled it by g++.
I used from API function for connecting to MySQLServer :
mysql_real_connect(db,"192.168.2.245",NULL,NULL,"vlrdb",3306,"/tmp/mysql.sock",CLIENT_ODBC)
but when running it I receive following message:
Host "192.168.2.249" is not allowe
> Ok my gut would say that this would not give the result I want
> unless the id's are sorted by last name, and given inserts and
> such I can see that would not be the case. But I sense the
> glimmer of an approach in this query...
You're right, I don't know why I thought you wanted to sort by
OS - FreeBSD 4.7 Release
MySQL 3.23.54
Have an odd error. When reinstalling MySQL, I needed to add something's,
it says the hostname is wrong, I did a make clean and tried make
reinstall --force and everything else I can find. Never had this error
before! Nothings been changed since it was install
I have seen this error when
untarring a gz file with:
tar -xvf 'file.gz on the 4.08 distr.
that was just my mistake, and when i did
tar -xvzf mysql-4.0.9-gamma.tar.gz
everthing went smooth
Jim
-Original Message-
From: Defryn, Guy [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 13, 20
Hello all,
Since there is no reply still, i'm forwarding it again.
Hope someone will help to proceed further.
Mysql compiles fine, but make test fails.
OS: HP-UX
I tried with hp-ux default thread and gnupthread.
1)while trying with default systems pthread,
i got following error messages.
gma
Hello (sql,query)
(B I recently moved from mysql4.0.3 to mysql4.0.8gamma
(BI did a copy of my databases inside the *data* directory alone(i.e. *.frm*
(Bfiles)
(B All the tables are InnoDb tables
(B
(BNow I copied all those files to my new MYSQL_HOME\DATA directory
(B
(BBut when I try to
Hi,
I just uninstalled and reinstalled and got it to work on port 3306, but I
can't get it to work on any other port. As I said, I have changed this in
my.ini. Is there something else I should be doing to get this to work on a
non-standard port.?
TIA
- Original Message -
From: "C. Re
At 6:02 + 1/14/03, [EMAIL PROTECTED] wrote:
> SELECT id,first,last FROM names ORDER BY id LIMIT 2,1;
Work? Limits to one result, start at second offset. (I may have the 2,1 in
the wrong order though)
Ok my gut would say that this would not give the result I want
unless the id's are s
> SELECT id,first,last FROM names ORDER BY id LIMIT 2,1;
>
> Work? Limits to one result, start at second offset. (I may have the 2,1 in
> the wrong order though)
Ok my gut would say that this would not give the result I want unless the id's are
sorted by last name, and given inserts and such I
Hi,
I just installed MySQL on my WinXP box and not sure what's going on. The
server starts (or so it says it does) but I get an error saying I can't
connect to localhost. Not sure what else to say. I have included some info
below (note that I changed the port to 3308 in my.ini as Linux Mysql is
us
Would:
SELECT id,first,last FROM names ORDER BY id LIMIT 2,1;
Work? Limits to one result, start at second offset. (I may have the 2,1 in
the wrong order though)
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Monday, January 13, 2003 10:20 PM
> To: [EM
To begin with I am only about 3/4 of the pay through paul d's great book so bear with
me. Say I have a table (names) with columns (id, first, last) and I want the next
name when ordered by last, first in the table, say given a particular id. So how
would I frame the query. Something like
sel
I have been having a lot of trouble configuring mysql to do just the
simplest replication. Its a standard RedHat 8.0 install, I have followed
the directions on http://www.mysql.com/doc/en/Replication_HOWTO.html to the
letter half a dozen times now and still, the slave server crashes repeatedly
as
Thanks Paul,
It's working now.
cheers
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 14 January 2003 3:41 p.m.
To: Defryn, Guy; '[EMAIL PROTECTED]'
Subject: Re: Unable to install 4.08 or 4.09
At 15:31 +1300 1/14/03, Defryn, Guy wrote:
>I have tried to in
At 15:31 +1300 1/14/03, Defryn, Guy wrote:
I have tried to install mysql 4.0.8 and 4.0.9 and I get the following error
After running gunzip < mysql-4.0.9-gamma.tar.gz (source install)
Mysql-4.0.9-gamma/bdb/
Mysql-4.0.9-gamma/bdb/db/
Mysql-4.0.9-gamma/bdb/db/db_upg.c
Mysql-4.0.9-gamma/bdb/db/db.c
I have tried to install mysql 4.0.8 and 4.0.9 and I get the following error
After running gunzip < mysql-4.0.9-gamma.tar.gz (source install)
Mysql-4.0.9-gamma/bdb/
Mysql-4.0.9-gamma/bdb/db/
Mysql-4.0.9-gamma/bdb/db/db_upg.c
Mysql-4.0.9-gamma/bdb/db/db.c
Mysql-4.0.9-gamma/bdb/db/tags
Tar : skippi
Excellent! It works.
H M Kunzmann wrote:
Yes there is !
Use LOAD_FILE(path_name) as the value component of the insert/update
statement
On Mon, 2003-01-13 at 00:41, Haisam K. Ido wrote:
I have the following table,
CREATE TABLE cp (
id INT(11) NOT NULL auto_increment,
file
Sounds like the same problem I'm having (for which I'm still stumped and
don't know what has caused it): table mysql.user is read only.
Test this by logging into mysql and using the GRANT or REVOKE
statements.
--
Loren McDonald
Gods Of Music Reviewer/Editor
[EMAIL PROTECTED]
http://www.GodsOfM
On Mon, Jan 13, 2003 at 03:45:59PM -0300, Maximo Migliari wrote:
> In the MySQL manual, under
> http://www.mysql.com/doc/en/Upgrading-from-3.23.html
>
> it says:
> ---
> The old C API functions mysql_drop_db, mysql_create_db, and mysql_connect
> are not supported anymore, unless you comp
Just tried. Nope...
mysql> grant all privileges on mysql.* to ext identified by 'ext1tex2'
with grant option;
ERROR 1036: Table 'user' is read only
--
Loren McDonald
Gods Of Music Reviewer/Editor
[EMAIL PROTECTED]
http://www.GodsOfMusic.com
>
> Does the user 'mysql' have write access to t
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
John Bateman wrote:
Hi
First off I would like to say I appreciate all your help very much.
Now, here's what I have.
I installed, and confirmed that it runs properly, the Connector/J v3
drivers. my resin.conf looks like this:
jdbc/FormsAreUs
Hello,
I need to get a single result from a SELECT from a table with the following sturcture:
component - varchar(25) primary key
catNum - varchar(25) primary key
price - decimal(10,2)
my component list may contain duplicate catNum ie:
primary drive -WD1GJB
- W
Hi
First off I would like to say I appreciate all your help very much.
Now, here's what I have.
I installed, and confirmed that it runs properly, the Connector/J v3
drivers. my resin.conf looks like this:
jdbc/FormsAreUs
javax.sql.DataSource
And when I 'use' this co
>Description:
There seems to be a problem with mysql replication. When the slave server encounters
sql that uses backticks instead of single quotes. The
+replication stops until you manually advance the position number in the master.info
+file.
>How-To-Repeat:
1. Set up a replication server
2. en
on 01/13/2003 2:10 PM, Scott Haneda at [EMAIL PROTECTED] wrote:
>> How do you know this isn't simply a failure of your terminal window
>> to display the character properly? That's the most likely problem
>> here, not that your data are stored incorrectly.
Correct you are, the data in MySql was c
At 23:40 +0100 1/13/03, Stefan Hinz, iConnect (Berlin) wrote:
Ed,
That would work but is there no way to completely remove their
record?
With REVOKE, you can partially or totally revoke privileges from users.
What you can't do with REVOKE (in MySQL) is to erase a user completely.
For this, y
At 23:45 +0100 1/13/03, Stefan Hinz, iConnect (Berlin) wrote:
Maximo,
My company's website is running version 3.23.53a, and the main client
that
uses MySQL is PHP 4.2.3. Will mysql_connect() no longer work in
PHP? Although this manual entry is talking about the C API functions,
I
assum
Ed,
> That would work but is there no way to completely remove their
record?
With REVOKE, you can partially or totally revoke privileges from users.
What you can't do with REVOKE (in MySQL) is to erase a user completely.
For this, you will have to DELETE FROM mysql.user WHERE User =
'user2bremov
Maximo,
> My company's website is running version 3.23.53a, and the main client
that
> uses MySQL is PHP 4.2.3. Will mysql_connect() no longer work in
> PHP? Although this manual entry is talking about the C API functions,
I
> assume PHP uses these to communicated with MySQL. Perhaps I might be
Hi,
MySQL 4.0.9, a new version of the world's most popular Open Source Database,
has been released. It is now available in source and binary form for a number
of platforms from our download pages at http://www.mysql.com/downloads/ and
mirror sites.
Note that all mirrors may not be up to date; If
At 13:51 -0800 1/13/03, Scott Haneda wrote:
Was working on a database job last night, and ran into a little stumbling
block, hope all this comes though in email, if you see a ® it is a
"registered mark" just in case the email clients out there change it around.
So I have a simple database, one ta
on 01/13/2003 1:58 PM, Paul DuBois at [EMAIL PROTECTED] wrote:
> How do you know this isn't simply a failure of your terminal window
> to display the character properly? That's the most likely problem
> here, not that your data are stored incorrectly.
Well, I don¹t for certain, I just did a dump
Hello,
This is discouraging after I spent most of the weekend getting OpenSSL
working with our MySQL 4 server. Unfortunately I can't use Stunnel to secure
the connection between our website and our MySQL server because our ISP will
not allow me to run the Stunnel daemon on their servers. They hav
Was working on a database job last night, and ran into a little stumbling
block, hope all this comes though in email, if you see a ® it is a
"registered mark" just in case the email clients out there change it around.
So I have a simple database, one table, and say one field, varchar(14) and
in it
>From you example, not quite sure what you are trying to do (I could if, for
example generic tree was 0199, and 01 was tree and last two characters were
color or something like that)
At any rate, you can use string functions to pull data from portions of
fields to build whatever you want to search
Matt,
the variable mysql_embedded makes InnoDB more silent:
heikki@hundin:~/mysql-4.0/sql> grep -n mysql_embedded *.cc
ha_innodb.cc:659: if (mysql_embedded) {
ha_innodb.cc:768: srv_print_verbose_log = mysql_embedded ? 0 : 1;
mysqld.cc:390:bool mysql_embedded=0;
mysqld.cc:392:bool mysq
Hello, I'm in the process of moving from Postgres to MySQL and I have a
question.
+How do you prevent a field from being left empty?
I have an InnoDB table that looks like the following.
CREATE TABLE `stuff` (
`stuff_id` int(11) NOT NULL auto_increment,
`somevalue1` varchar(35) NOT NULL,
Hi,
SELECT LEFT(YOUR_COLUMN,2) FROM YOUR_TABLE.for position
SELECT RIGHT(YOUR_COLUMN,2) FROM YOUR_TABLE for type
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
Hello
I have two tables of InnoDB type.
CREATE TABLE `ledger` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(50) default NULL,
PRIMARY KEY (`id`),
KEY `id` (`name`)
) TYPE=InnoDB;
CREATE TABLE `voucher` (
`id` int(11) NOT NULL default '0',
`vdate` date NOT NULL default '
Matthew K. Gold wrote:
I agre with the DuBois recommendation. I have a couple of quibbles, but
overall, I think it's a great book (and I did a pretty exhaustive check when
I was first learning mysql.
Of course, if you want a generic how-to on designing databases or SQL
itself, there are an
On Monday 13 January 2003 17:49, Tonu Samuel wrote:
Hi,
Currently PHP's mysql extension doesn't support SSL. This will be available
in PHP 5.
Regards
Georg
-
Before posting, please check:
http://www.mysql.com/manual.php
Hi all!
I would like to build a query that I can use to search hierichally from
an char(4) id composed as followed
2positions for the class of plant (for example)
and 2 positions for the type of flower (for example)
if someone give me the id that means red rose tree, and I know there is
anothe
Hi all!
I would like to build a query that I can use to search hierichally from
an char(4) id composed as followed
2positions for the class of plant (for example)
and 2 positions for the type of flower (for example)
if someone give me the id that means red rose tree, and I know there is
anothe
Hi all!
I would like to build a query that I can use to search hierichally from
an char(4) id composed as followed
2positions for the class of plant (for example)
and 2 positions for the type of flower (for example)
if someone give me the id that means red rose tree, and I know there is
anothe
Hi all!
I would like to build a query that I can use to search hierichally from
an char(4) id composed as followed
2positions for the class of plant (for example)
and 2 positions for the type of flower (for example)
if someone give me the id that means red rose tree, and I know there is
anothe
Is there any way to disable log messages being written to the standard
output using Embedded Server? Using mysqld, they are automatically
redirected to mysql.err (under Windows, at least), but there seems to be
no way to do this in Embedded.
We would like to be able to display our own output to t
Hi All,
Trying my best to maintain some production servers running
mysql-max-3.23.53a-pc-linux-gnu-i686 with one master and one slave.
We keep having issues where we create a new table on the master, and
a short while later the slave will crash because it starts trying to
perform queries which in
In the last episode (Jan 13), Toomas said:
> Hello List,
>
> Is there a simplier way to embed an image stored in BLOB field into
> HTML than using 2 calls to Perl scripts - one to generate HTML and
> another call from that HTML via IMG tag to retrieve and print image?
> I mean, something like you
On Fri, 10 Jan 2003, Michael T. Babcock wrote:
> >if test -n "`ps acx|grep mysqld`"; then
> >/usr/bin/mysqladmin flush-logs
> >fi
> >
> >
>
> You're probably running it as root with the password loading from the
> /root/.my.cnf or something. Try adding the -uro
On 13 Jan 2003, at 18:49, Tonu Samuel wrote:
> I would like to help you but I can't. This is PHP issue, not MySQL-s.
> SSL connections are supported by MySQL, they are also available in C API
> but I am not sure if and how PHP uses them.
>
> Looking up into PHP manual http://www.php.net/manual/en
Simon,
Thanks, for the reply. I guess I better try the 64 bit version and see if
it makes a difference.
I'll report back what I find.
Cheers,
Andy
> -Original Message-
> From: Simon Green [mailto:[EMAIL PROTECTED]]
> Sent: 13 January 2003 16:58
> To: 'Andy Eastham'; [EMAIL PROTECTED]
I also got error from terminal:
sendsig: useracc failed. 0x8003bf6dbe00
0x005020
Pid 3093 was killed due to failure in writing the
signal context - possible static overflow.
I tried to logon on as "mysql" user. I didn't set
"mysql" user password.
I looked at hostname-bin.err:
MySQ
MySQL gurus:
I'm a big fan of the general query log for taking the occasional audit
of activity against our database server, as well as a tool for checking
on the efficiency of new (mostly PHP) projects that interact with MySQL.
What I don't like is that I have to stop and restart the server pr
That would work but is there no way to completely remove their record?
Ed
On Mon, 13 Jan 2003, Michael T. Babcock wrote:
> [EMAIL PROTECTED] wrote:
>
> > I've read the manual concerning REVOKE commands but how would I
> >completely remove a user inside MySQL? I can't imagine that it's as eas
Mike wrote:
I'm making a library website where users can store preferences about the
types of books/cds/etc... they like (e.g. romance, rock, cooking,
etc).
Once a month the list of 'New Releases' is updated. Currently there is
a New
Release box which shows releases based on the users prefe
Rodney Broom wrote:
If so, then the answer is that there isn't such a data type. If you want a link, then you'll have to make it yourself. I suggest making your column a varchar(). Then, you ~might~ get the data with a query like this:
SELECT CONCAT(CONCAT(''), link, '') FROM stuff;
But ple
Stephen Brownlow wrote:
You can make backup of the database and then drop the database..
Why do you want to do it?
When maintenance is necessary, it would be far better to be able to:
1. turn off one database,
2. use myisamchk, Unix or other applications to adjust it in any way,
3. turn it
Angel Flow wrote:
Would like to ask people's thoughts on whether Perl or
PHP has higher performance with MySQL. I've heard
rumours that DBI is slower than the PHP MySQL driver.
I would say that comparing DBI to ADODB is more appropriate; PHP more or
less directly calls the mysql C library fu
[EMAIL PROTECTED] wrote:
I've read the manual concerning REVOKE commands but how would I
completely remove a user inside MySQL? I can't imagine that it's as easy
as removing them from the user table.
If you remove them (or blank their password) in the user table, they'll
have no way of loggi
At 12:59 +0200 1/13/03, Octavian Rasnita wrote:
Hi all,
I've seen the following code in MySQL cookbook:
eval
{
# move some money from one person to the other
$dbh->do ("UPDATE money SET amt = amt - 6 WHERE name = 'Eve'");
$dbh->do ("UPDATE money SET amt = amt + 6 WHERE name = 'I
would like to help you but I can't. This is PHP issue, not MySQL-s.
SSL connections are supported by MySQL, they are also available in C API
but I am not sure if and how PHP uses them.
Looking up into PHP manual http://www.php.net/manual/en/ref.mysql.php
won't show up needed functionality for th
I´m upgrated the mysql to 4.0.8 version ( from 4.0.6 )
after this my server is going down of one hour for another one.
the log message is:
/usr/local/mysql4//libexec/mysqld: ready for connections
mysqld got signal 11;
This could be because you hit a bug. It is also poss
In the MySQL manual, under http://www.mysql.com/doc/en/Upgrading-from-3.23.html
it says:
---
The old C API functions mysql_drop_db, mysql_create_db, and mysql_connect
are not supported anymore, unless you compile MySQL with
CFLAGS=-DUSE_OLD_FUNCTIONS. Instead of doing this, it is prefera
Hello List,
Is there a simplier way to embed an image stored in BLOB field into HTML than using 2
calls to Perl scripts - one to generate HTML and another call from that HTML
via IMG tag to retrieve and print image? I mean, something like you do
it in a multipart e-mail message?
A more general qu
Since the http://lists.mysql.com/ archives site is down, I'll have to
ask this question without the benifit of the archives...
I have a (very large) Perl script that has a bad tendency to cause the
following warning from myisamchk:
myisamchk: MyISAM file /var/lib/mysql//table_name.MYI
myisa
Hi Andy
Is MySQL loading the tables in to memory?
MySQL AB say running MySQL on 64bit system should be faster.
Sorry I can not be more help.
Simon
-Original Message-
From: Andy Eastham [mailto:[EMAIL PROTECTED]]
Sent: 13 January 2003 15:34
To: [EMAIL PROTECTED]
Subject: Solaris Performance
I've read the manual concerning REVOKE commands but how would I
completely remove a user inside MySQL? I can't imagine that it's as easy
as removing them from the user table.
TIA,
Ed
mysql
-
Before posting, please check:
My isp is Omnis.com.
They have mySQL on my host server, and I have entered some contact info
for a password login system. The system they already have doesn't let me
use email addresses for logins.
This is my first time using mySQL, how do I get it to link? Will it let
me use email for login?
chr
Hi all,
I've seen the following code in MySQL cookbook:
eval
{
# move some money from one person to the other
$dbh->do ("UPDATE money SET amt = amt - 6 WHERE name = 'Eve'");
$dbh->do ("UPDATE money SET amt = amt + 6 WHERE name = 'Ida'");
# all statements succeeded; commit tr
On Mon, 2003-01-13 at 16:41, David Rock wrote:
> Could someone please post the basics on connecting to a MySQL 4 server from
> PHP at my website using a secure connection? The server is ready to accept
> a connection, I'm just not sure what to do next to initiate it. It seems
> like I would need t
> Stupid filter fodder: sql,query,queries,smallint
> > -Original Message-
> > From: Dean Householder [mailto:[EMAIL PROTECTED]]
>
> > The problem is with the new glibc-2.2.5-40 package released
> > on October 3,
> > 2002. Apparently its a known issue, and people are aware of
> > it. T
On Mon, 2003-01-13 at 14:11, Stevens, Ryan wrote:
> I understand the SQL statement in MySQL to be
> "SELECT sum(column name) FROM table;" but I would like to get a
> SUM of multiple columns. Is this possible??
Yes, you may use:
SELECT sum(c1+c2) FROM table;
or even:
SELECT sum(table1.v + tab
Hi,
I compiled MySQL 3.23.54, try MySQL CLI. Everything
looks fine. But when I tried to connection MySQL
through mm.mysql JDBC Driver, I got:
08:25:09SQLDataManager: Connecting...
jdbc:mysql://localhost:3306/mysql
08:25:09SQLDataManager: EXCEPTION:
java.sql.SQLExce
I don't think I have anything that should cause this. Here is my my.ini
from the the slave. The tables that are being excluded are not listed.
[mysqld]
basedir=C:/mysql
datadir=C:/mysql/data
set-variable=max_allowed_packet=16M
log-slave-updates
log-bin
# Replication variables
master-host=x.
Hi,
I compiled MySQL 3.23.54, try MySQL CLI. Everything
looks fine. But when I tried to connection MySQL
through mm.mysql JDBC Driver, I got:
08:25:09SQLDataManager: Connecting...
jdbc:mysql://localhost:3306/mysql
08:25:09SQLDataManager: EXCEPTION:
java.sql.SQLExce
SELECT SUM(colA+colB) FROM TABLE ?
Stevens, Ryan wrote:
> I understand the SQL statement in MySQL to be "SELECT sum(column name) FROM table;"
>but I would like to get a SUM of multiple columns. Is this possible??
>
> Thanks,
>
> Ryan
>
>
On Thu, 2003-01-09 at 17:40, David Rock wrote:
> Hello,
> Can someone give me a some overview information regarding using SSL with
> MySQL version 4? I want to setup a 128bit SSL connection between our website
> hosted at an ISP and our MySQL (on FreeBSD) server which is hosted in our
> office. B
Hi,
I've got a mysql application that was developed on win32 and linux that is
now going to be deployed on a Sun E250 Solaris 9 box with 3 36Gb non raided
SCSI disks. No problem I thought - the performance is fine on my PIII
850MHz laptop, so it will rock on an E250...
Not the case - the laptop
Hi,
Since you don't specify your OS, I assume you are using Linux;
if you are using another UNIX like system (BSD, Solaris,...),
my explanations below may be useless :(
A disk partition (as /dev/sda1) is a "bloc device",this is not the
same as a "raw device". You can get more info in Linux HOWTO:
* Stevens, Ryan
> I understand the SQL statement in MySQL to be "SELECT sum(column
> name) FROM table;" but I would like to get a SUM of multiple
> columns. Is this possible??
Yes. You can add multiple columns inside the SUM() function:
SELECT SUM(col1+col2+col3) FROM table;
--
Roger
sql
-
Victoria,
> Thank you for bug reports, both bugs are fixed.
That's fast :-))
What about the LOCAL bug (or feature)? I.e. you can start
mysqld --local-infile=1, or you can start MySQL Monitor like
mysql --local-infile=1, or even both, and it won't help. You cannot use
load data LOCAL.
Furthermor
>Description:
I've installed MySQL v4.0.8 chrooted like described in detail at
http://www.linuxquestions.org/questions/showthread.php?threadid=34338
Operating System is RedHat Linux v8.0 including ALL current available patches
...
As example I used the my-medium.cn
I would like to return rows, with specific columns, for each individual in
my NAMES table, with address and e-mail if these exist. Thought I had the
syntax down but I'm getting NULL results where I know there is data. I'm
used to using SQL Server shortcut * for outer joins, guess that's catching
Ahmed,
> 1. How can i trigger a database archive when a certain data base limit
> is reached in a table.
> Ex: when 1,00,000 records is reached, archive to file and clean table.
You will have to wait for MySQL 5.0. This version will have SQL
triggers.
> 2. How can i restore multiple files into d
Does the user 'mysql' have write access to the mysql database and files?
Loren McDonald wrote:
Im not sure what has gone wrong but the mysql.users table is set as
read only. I am trying to grant user privileges but cant because of
this. How can I change the status so that I can add to it?
I
Set up a loop where you delete with a LIMIT,
pause a few milliseconds to give others a chance to get in,
and loop until no records are deleted.
Philip Mak wrote:
I have a table in a database. I'm trying to delete 5 million rows from
it. But whenever I try to do this, while the delete command is
Could someone please post the basics on connecting to a MySQL 4 server from
PHP at my website using a secure connection? The server is ready to accept
a connection, I'm just not sure what to do next to initiate it. It seems
like I would need to set something up at our ISP to talk securely to the
r
On Monday 13 January 2003 13:50, Richard Brenner wrote:
> I use an application where users can post messages. The messages are stored
> in two tables that are related by the id of the new created message. I get
> the last id with the following query: "select max(id) as maxid from
> tasker_app"
> T
Thank you for your responses Paul,
To get MySQL4 to use OpenSSL I had to install OpenSSL 0.9.7 and modify the
configure script to move my new include and lib
directories to the end of the loop where it's searches for the OpenSSL files
so it would see the 0.9.7 version last and therefore use it.
Hi,
IMHO:
I think you should try :
1)
SET @a:=0;
LOCK TABLE your_table_name WRITE;
INSERT what_client_must_to_insert
SELECT @a:=MAX(ID) FROM tableetc
UNLOCK TABLE;
After unlock the table you can find the value of variable @a by doing:
SELECT @a;
2)
INSERT what_cl
* Richard Brenner
> I have a problem with a query:
>
> I use an application where users can post messages. The messages
> are stored
> in two tables that are related by the id of the new created message. I get
> the last id with the following query: "select max(id) as maxid from
> tasker_app"
Oops
SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
SEND-PR: will all comments (text enclosed in `<' and `>').
SEND-PR:
From: root
To: [EMAIL PROTECTED]
Subject: [50 character or so descriptive subject here (for reference)]
>Description:
>
I understand the SQL statement in MySQL to be "SELECT sum(column name) FROM table;"
but I would like to get a SUM of multiple columns. Is this possible??
Thanks,
Ryan
-
Before posting, please check:
http://www.mysql.com/ma
Hi,
I wonder if someone can paste a OLEDBSQL provider connection string to look at .
Many thanks..
Sam
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the
On Wednesday 08 January 2003 22:32, Stefan Hinz iConnect \(Berlin\) wrote:
> > Have you tried to reproduce them?
>
> Bug #1: GRANT USAGE doesn't seem to create a user:
>
> mysql> GRANT USAGE ON *.* TO 'foo'@'foohost';
> Query OK, 0 rows affected (0.26 sec)
>
> mysql> SHOW GRANTS FOR 'foo'@'foohost
I'm confused , what is the difference and raw device and a disk
partition ?
ex: on innodb I'm using /dev/sda1 for raw device, is it correct ?
tnks.
sql,query
-
++ Dyego Souza do Carmo ++ Dep. Desenvolvi
>Description:
I'm unable to start more than 1 thread, here are
the processes launched, as far as I know, one "mysqld" daemon is launch
per client/connection, but not in this case :
root 191563 1443 0 Jan 10 pts/2 0:00 /bin/sh
/usr/mysql/bin/safe_mysqld --user=mysql
my
Hi,
I've got a mysql application that was developed on win32 and linux that is
now going to be deployed on a Sun E250 Solaris 9 box with 3 36Gb non raided
SCSI disks. No problem I thought - the performance is fine on my PIII
850MHz laptop, so it will rock on an E250...
Not the case - the laptop
--- Amer Neely <[EMAIL PROTECTED]> wrote:
> > Greetings all. Hope someone could give me some pointers on this.
> >
> > I am working at a small ISP in Montreal. Some of our corpo users. have
> > access to a MySQL database, that we created for them (usually, this DB is
> > named after there username
HI,
I have a few questions related to DB archving / restore capability of
MySQL. Most of them are design issues but have a lot to do with what
MySQL provides.
PLease share your view on them.
1. How can i trigger a database archive when a certain data base limit
is reached in a table.
Ex: when 1,
1 - 100 of 119 matches
Mail list logo
