Hello,
I have a memory problem when added records to a table.
The situation is like this (simplyfied) :
query << "select id, symbol from " << STOCKS_TABLE_NAME << std::ends;
std::vector symbols;
query.storein(symbols);
std::vector::iterator I;
for(I = symbols.begin(); I != symbols.end(); I++) {
On Wed, Oct 24, 2001 at 06:25:58AM -0400, Tony wrote:
>
> I am looking for a creative way to optimize my web application
> (largely reads) with a transaction firehose on the data input side.
> Batch vs. OLTP, if you will.
>
> Is there any technical reason why I could not configure the master
> da
Hi
My sys config
OS = NT4 (installed mysql here)
database = MYSQL4.23
language = Visual Basic
I have written an application on visual basic.
If i work from the localhost is working fine.
If I install my application on any other machine,
I get an error
"can't connect to mysql server on 'localho
Hi Mr. David,
I hope a bit of explanation for Steve Mayers' solution would help you.
The query by Mayers
select distinct a.username, a.ip from users a, users b where a.ip=b.ip &&
a.username != b.username;
I think I can explain the behaviour of the query:
Suppose the table contains the data:
us
Hi
I am student of Indian institute Of Technology
Madras(India) I downloaded your beta version of
MySqlGui for linux. But it is saying cannot connect to
server. even after i edited .cnf files. Further i am
unable to set password for any of clients i made.
please help me to get through it
yours t
Hi
I am student of Indian institute Of Technology
Madras(India) I downloaded your beta version of
MySqlGui for linux. But it is saying cannot connect to
server. even after i edited .cnf files. Further i am
unable to set password for any of clients i made.
please help me to get through it
yours t
Michael Widenius wrote:
> The symbol 'mysql_module_entry' doesn't come from the MySQL library,
> so this is a PHP problem.
Okay.
> Note that you can use MySQL 4.0 with the old MySQL 3.23 library
> without any problems.
Yes, it works fine if I use the libmysql that is bundled with PHP. Only
> > select distinct a.username, a.ip from users a, users b where a.ip=b.ip &&
> > a.username != b.username;
> >
> Thanks!! Worked like a dream! I'm not quite sure why it knew to pull only
> ip's that are in there more than once though?
>
Here's what it's doing. It does a join on itself where t
> PROBLEM 2
> I have developed several Applications in Delphi 4 based upon Paradox
Tables
> and am now re-engineering everything (using Delphi 6) to be based upon a
SQL
> DataBase instead. For which I hope to use MySQL Server to access the
> DataBase.
>
> What Components/Objects should I be using
Since it's late here I dont have the time tonight to answere most of
your questions but I can say this. MySQL is Very fast in Delphi apps. My
ISAPI stuff loves it.
I use ASTA and ZEOS componets in D5 to connect to MySQL with no
problems. ASTA allows me to run my apps accross the Internet /LAN/
Please forgive me if this is being addressed to the wrong quarters. In
which case I would be very grateful if it might be forwarded as required.
I have downloaded version 3.23.43 of MySQL but regret to find the manual
notes at "3. Introduction to MySQL: A MySQL Tutorial" on how to get started
ar
I think u cannot do automatically, since MySQL does not support table
trigger or view. U can only get value C by select statement, otherwise u
need to update the column C by another processing.
Best regards,
Kenneth.
- Original Message -
From: "Kodrik" <[EMAIL PROTECTED]>
To: <[EMAIL PR
I know you most likely want to add the full source of teh pics to
database, but this is nt a good idea. The best way would be to just write
the picture location to the database. If you write the pictures itselves,
then it will make the database rather big. I have one database over 45mb
and all th
After the first version of this email was filtered out as spam because
it did not contain any database-related words (which should hereby be
fixed hopefully), here comes my email again:
After signing up for this list a few days ago, I noticed that I did not
get any emails yet except for the ones
Hi,
I started using mm.mysql-2.0.x on our test system and I noticed a
difference in the behaviour of ResuletSet between this version and some
older version we used.
Apparently, the older version automatically goes to the first record if
you call ResultSet.getString() or similar methods. without
At 21:29 -0400 10/24/01, [EMAIL PROTECTED] wrote:
>Greeting! I am trying to convert an application from a DB2 based
>program to MySQL. We are still evaluating MySQL and learning.
>We are using Java and the JDBC driver mm.mysql.jdbc-1.2c to
>create the database. The Java version of this program usi
Greeting! I am trying to convert an application from a DB2 based
program to MySQL. We are still evaluating MySQL and learning.
We are using Java and the JDBC driver mm.mysql.jdbc-1.2c to
create the database. The Java version of this program using this
driver is not creating some of the tables.
I actually find the command line databases way easier to use than graphical
ones. You have more direct control over them, and they are leaner/faster
than GUI based ones. However, there are GUI based admin tools that you can
get from the MySQL website so you can feel more 'at home'.
I was a *real*
Hi list:
How can I update a table field from a another table field, the
multitable update is not implemented or yes?.
I am thinking in use a foreign key (references) or tmp table or can I
use table aliases? something like this:
replace into table master( fielda, fieldb , fieldc) select t1.field
You may also want to make sure that you did: flush privileges; to make sure
they are implemented.
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 24, 2001 7:36 PM
To: Avelino F
Cc: [EMAIL PROTECTED]
Subject: Re: into outfile error
At 1:08 -0400
I come from a microsoft environment and never really had to deal with a
command line based database before.
All the documentation for MySQL doesn't make sense to a rookie and is
frustrating... Anywhere to go where I can feel like I can learn
something?
Thank you,
Todd Williamsen, MCSE
home: 84
It worked
Thanks
Vijay
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 24, 2001 4:45 PM
To: Vijayanand Sukumar; '[EMAIL PROTECTED]'
Subject: Re: problem with permissions on solaris
At 16:06 -0700 10/24/01, Vijayanand Sukumar wrote:
>Hi,
>I
> I'm using 3.22.27 and am getting an error when I submit queries.
>
> I do a select * from table where...
>
> And it gives me:
>
> ERROR 1030: Got error 127 from table handler
chris@entropy:~$ perror 127
Error code 127: Unknown error 127
127 = Record-file is crashed
Run isamchk -r on the ta
At 16:06 -0700 10/24/01, Vijayanand Sukumar wrote:
>Hi,
>I installed Mysql on solaris 8 as root. I am able to access the database on
>the system.(Create tables ...access them etc).
>but when do it from the JSP it complains
>
>javax.servlet.servletException: General Error : Access denied for user:
At 23:11 + 10/24/01, [EMAIL PROTECTED] wrote:
>Hello,
>
>I am wondering if there is a way to make automatic computations into
>a particular column, for instance:
>
>Table ONE has column's A, B and C.
>
>When I post data to A and B, can I have C automatically calculate A
>/ B and post that an
At 1:08 -0400 10/24/01, Avelino F wrote:
>Hello,
>
>I managed to set the file permission and managed to send the output
>to the mysql database directory used. Do you know if there is a way
>to make mysql write to a remote directory? Is there a global or
>local configuration that can be specifie
Yes, you can do:
update whatever set C=A*B+3 where whatever
On Wednesday 24 October 2001 07:11 pm, [EMAIL PROTECTED] wrote:
> Hello,
>
> I am wondering if there is a way to make automatic computations into a
> particular column, for instance:
>
> Table ONE has column's A, B and C.
>
> When I pos
Check out this page.
You still have to create the table in mysql first, then you can run the LOAD
DATA INFILE command .
http://www.mysql.com/doc/L/O/LOAD_DATA.html
- Original Message -
From: "Todd Williamsen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, October 24, 2
Hi,
I installed Mysql on solaris 8 as root. I am able to access the database on
the system.(Create tables ...access them etc).
but when do it from the JSP it complains
javax.servlet.servletException: General Error : Access denied for user:
'@sunblade11' to database 'Messages' .
The connection u
Is this possible? I tried it, and the format is all garbled... I have
an application that outputs data into a CSV file and was wondering of a
way to have it automatically inserted into a database with it formatted
for the query of those results.
Thank you,
Todd Williamsen, MCSE
home: 847.265.
Hello,
I am wondering if there is a way to make automatic computations into a particular
column, for instance:
Table ONE has column's A, B and C.
When I post data to A and B, can I have C automatically calculate A / B and post that
answer onto column C?
Again, I want this to happen aut
Thanks for the help it seemed to have worked. But now I get a different
error. I am getting to the server but I am getting error:
>From Database server
Found old style password for user 'webuser'. Ignoring user. (You may want to
restart using --old-protocol)
***
Hi,
here is my half selfmade :) bug report.
I´ve tried this on different machine with different linux version (other
one is linux 2.2.18)
And I also tried more RAM (512 MB ) without any change to the error.
Maybe you can help me :
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject:
Instant M
I'm trying to do a search against two fulltext indexes. I can successfully
search against either one separately, like:
$psl->set_query("SELECT Products.ID, Products.Name, " .
"Products.Photo, Products.Description " .
"FROM Products, Categories, ProductsCategories " .
"WHERE Catego
I all.
I'm using 3.22.27 and am getting an error when I submit queries.
I do a select * from table where...
And it gives me:
ERROR 1030: Got error 127 from table handler
and no data.
Any ideas how to fix this?
Thanx,
Mike Diehl.
This works perfectly, you're a genius :-)
I will have to have a rethink about how to write SQL querries for mysql.
Thanks again.
Jeff.
"Kalok
Well, how many records are in the table? How many would be returned by the
query you present?
Is the SQL you show the FULL sql?
What is the output of the EXPLAIN SELECT
What about "SHOW INDEX FROM TABLE gw".
b.
kmlau wrote:
> -Original Message-
> From: kmlau [mailto:[EMAIL PROT
Hi!
> "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes:
Sinisa> Jeremy Zawodny writes:
>> On Wed, Oct 17, 2001 at 12:18:28AM +0100, Mark Maunder wrote:
>> > Where does one post (possible) bugs for mysql 4?
>> >
>> > I believe this worked in MySQL 3:
>> >
>> > mysql> create table
> "Eric" == Eric <[EMAIL PROTECTED]> writes:
Eric> What is quite puzzling is MySQL's estimation of the number of rows
Eric> from each of the self-joins. The conditions on alias queryTable0
Eric> actually refer to 1582 rows, and the conditions on alias queryTable1
Eric> refer to 39 rows. N
Hi!
> "Sebastian" == Sebastian Bergmann <[EMAIL PROTECTED]> writes:
Sebastian> Just compiled PHP (current CVS) with support for MySQL 4.0.0, but now
Sebastian> Apache won't start:
Sebastian> Cannot load /usr/local/apache2/modules/libphp4.so into server:
Sebastian> undefined sy
Hi!
> "Jeremy" == Jeremy Zawodny <[EMAIL PROTECTED]> writes:
Jeremy> On Tue, Oct 16, 2001 at 12:40:31AM +0300, Michael Widenius wrote:
>>
>> Benefits (of BIND):
>> - The server doesn't have to convert numbers to strings before sending them
>> to the client.
>> - The clients doesn't have to
On Wed, 24 Oct 2001, Allen Tang wrote:
> Hi Boyd,
> Thanks. I check pub/openserver5 nothing relate the MYSQL.
What you need from this site is all patches for your OS version.
uname -X will tell you then you need to down load and install them for
your version.
> What value I should give those tw
Thanks!! Worked like a dream! I'm not quite sure why it knew to pull only
ip's that are in there more than once though?
David
- Original Message -
From: "Steve Meyers" <[EMAIL PROTECTED]>
To: "David Wolf" <[EMAIL PROTECTED]>; "Steve Meyers"
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent:
David,
The way I accomplish this is using two queries...first I write a general
query that shows the IP address of any IP that has more than one user
associated with it:
SELECT DISTINCT(ip) AS ip, COUNT(*) AS count
FROM members
GROUP BY ip
HAVING COUNT > 1
ORDER B
I think I understand. This should work...
select distinct a.username, a.ip from users a, users b where a.ip=b.ip && a.username
!= b.username;
Steve Meyers
> -Original Message-
> From: David Wolf [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, October 24, 2001 3:17 PM
> To: Steve Meyer
It's still not quite doing what I want. I only want a list of IP's where
there are more than 1 instance of an ip--and then display each of the
multiple occurrences of the single ip (and repeat for each ip which has more
than 1 occurrence)..
The queries are all so close, but, don't give what I wan
Here are my compiling notes.
I find gcc the best for compiling both MySQL and Perl modules as
outlined below.
Compiling Applications for SCO Open Server 5.0.5
Compiling the Tools
This CD contains compilers and tools in the sco-downloads directory that
can be loaded using the SCO 'custom' util
Hi Boyd,
Thanks. I check pub/openserver5 nothing relate the MYSQL.
What value I should give those two parameter
MYSQL_TCP_PORT=???
MYSQL_UNIX_PORT=???
When I run "bin/safe_mysql --user=mysqladm &"
get error message
011024 16:44:52 mysqld started
dynamic linker : /usr/local/mysql-3.23.43-pc-sc
In Relational Database you usually create tables where the columns are
primitive datatypes such as number, varchar2, date (these are oracle
primitive dataypes).
So... to create a table Customer, for example, you would do something like:
create table customer (
customerID number(10),
custo
I think you're looking for:
SELECT username, ip, count(*) FROM users GROUP BY 1, 2
Steve Meyers
> -Original Message-
> From: David Wolf [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, October 24, 2001 12:21 PM
> To: [EMAIL PROTECTED]
> Subject: Query help...
>
>
> I'm trying to come u
I am running Solaris 2.6 (on Sparc) and would like to install
mysql, dose new version mysql 3.23.43 support Solaris 2.6? I
only see 2.7 and 2.8 in binary download and notes.
Thanks,
Sam,
-
Before posting, please check:
http:
Hi!
Ok, it was probably how Brent had moved .frm files
around. MySQL-Front is not to blame.
Regards,
Heikki
http://www.innodb.com
At 02:25 PM 10/24/01 -0500, you wrote:
>At 03:25 AM 10/24/2001 , you wrote:
>>Ansgar,
>>
>>what could cause the problem Brent reports in MySQL-Front?
>>
>>InnoDB re
Jason Whitlow wrote:
> Sorry for for the dumb question buuut.
>
> I have been connecting to a database on my localhost using perl's DBI.pm
>
> This is how I currently do it.
>
> use DBI;
> $data = "databasename";
> $driver = "DBI:mysql";
> my $dbh = DBI->connect("$driver:database=$data", "use
Sorry for for the dumb question buuut.
I have been connecting to a database on my localhost using perl's DBI.pm
This is how I currently do it.
use DBI;
$data = "databasename";
$driver = "DBI:mysql";
my $dbh = DBI->connect("$driver:database=$data", "username", "password")
or die "
http://searchdatabase.techtarget.com/sDefinition/0,,sid13_gci213671,00.html
An object-oriented database management system (OODBMS), sometimes shortened
to ODBMS for object database management system), is a database management
system (DBMS) that supports the modelling and creation of data as obj
Hi,
if you want to enjoy the foreign keys from innodb in mysql 4 then you
can't use binaries from the rpm files.
The rpm files contain innodb .43, not .43b!
But the source 4.0.0 and the .tar.gz binary 4.0.0 (non-rpm)
contains .43b which supports foreign keys.
Kind regards
Tore
--
Not quite what I need.. Though, it's very close :) The problem is that with
the query given, it only shows one username for each IP.. I actually want to
show ALL usernames for each IP with the IP occurs more than once... (and
ignore the users who have a distinct IP address).
David
- Origina
Everything that I have read describes MySQL as a Relational DataBase
Management System (RDBMS). PostGreSQL bills itself as an Object-Relational
DataBase Management System. Is there a difference between the two and, if
so, come someone either explain the difference or point me to a resource
that e
Hi
I've installed MySQL 3.23.43 binaries on Solaris 2.5.8 without UNIX
root privilege. During installation, someone else with UNIX root
privileges ran mysql_install_db, added a normal user xxx and an admin
yyy. At this point I do not see yyy owns all directories and all files.
Fol
Try
SELECT lastip,username FROM users HAVING count(*) > 1 GROUP BY lastip;
(or possibly
SELECT lastip,username FROM users GROUP BY lastip HAVING count(*) > 1;
)
david
On Wednesday 24 October 2001 2:21 pm, David Wolf wrote:
> I'm trying to come up with a query to do the following... I'm no
> > http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Da
> > tabase_Administration.html#mysqld-max
> >
> I just tried that, it gave me a page not found error.
>
That's because the link is too long for one line -- try copy and pasting, making sure
to get the entire link.
Steve Me
> >
> >
> > I saw this (mysql-max) on the MySQL Website but no where (at least no
where
> > obvious) can the description be found.
>
> Its here...
>
http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Adm
ini
> stration.html#mysqld-max
I just tried that, it gave me a page not
Sorry bout the blank one.
try this
Jim Lucas
- Original Message -
From: "Gregory Jon Welling/Parts Trading Inc." <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, October 24, 2001 10:38 AM
Subject: quotes
> This is more of a php problem than mysql, but since I am using them
- Original Message -
From: "Gregory Jon Welling/Parts Trading Inc." <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, October 24, 2001 10:38 AM
Subject: quotes
> This is more of a php problem than mysql, but since I am using them in
> combo...
>
> I have a database for people
I'm trying to come up with a query to do the following... I'm not having
lots of luck :(
The table is a user database. The columns I'm interested in are: username,
lastip. I'm interested in pulling information out that would show usernames
for each IP that appears more than once in the database..
Hi!
>Michael Blood wrote:
>
>> I am running 3.23.40 on a dual pentium III 800 with 1 GB Ram.
>>
>> I have been getting an table handler returns error 127 error
>>
>> If I fix the table with myisamchk -r or -o it will work for a while and then
>> I will get the same error again.
>
>Try dumping and
I have these 3 tables:
T1: T2:
Service Application | Application Machine
---
network DHCP DHCP mach1
Database SQLSQL mach2
EmailExchange SNMP mach2
network SNMP Exch
> > > How to know how many sessions are currently open against a MySQL
> database ?
> >
> > MySQL manual 7.28 SHOW Syntax
> >
> Thanks for your answer, but I need to know the names of the users
> currently
> logged in the database.
> Regards,
>
And he told you exactly where to find it. Try SHO
I believe WinMySQLAdmin (if running on Windows) or the Unix/Linux/Solaris
equivalent (I assume there is one) shows in its Processes window all users
connected to the server and their associated process IDs.
Cheers,
Fred Woolsey
-Original Message-
From: Ing. Gustavo Edelstein [mailto:[EMA
"Ing. Gustavo Edelstein" wrote:
> Thanks for your answer, but I need to know the names of the users currently
> logged in the database.
> Regards,
SHOW will do that as will 'mysqladmin processlist'.
http://www.mysql.com/doc/S/H/SHOW_PROCESSLIST.html
b.
--
On Wed, 24 Oct 2001 14:36:45 -0300, "Ing. Gustavo Edelstein"
<[EMAIL PROTECTED]> wrote:
>>Thanks for your answer, but I need to know the names of the users currently
>>logged in the database.
>>Regards,
>>
check your log files, normally found in the DATADIR, this will tell you who's
doing what
Under MySQL 3.23.40/Win32 and 3.23.33/Linux, neither mysql.user.user nor
mysql.user.password are permitted to have NULL values:
mysql> insert into mysql.user set user=NULL,password=NULL;
ERROR 1048: Column 'User' cannot be null
However, the default 'guest' user has NULLs for both of these values
Tom Hicks wrote:
> I am thinking of running MySQL on my box for some work with PHP. I am
> concerned about the mods to the directory structure. I can't seem to
> find a list for mods it will make on RedHat7.1
> Could you please help me out with that?
Not sure what you mean by 'mod', but you can
Thanks for your answer, but I need to know the names of the users currently
logged in the database.
Regards,
Ing. Gustavo A. Edelstein
Tech. Mgr.
Equiplus Argentina S.A.
__
Visit us On Line at www.equiplus.com
Email addresses:
Operations: [EMAIL PROTECTED]
Cons
"Oscar Castaneda V." wrote:
> Hi,
>
> i ran into a pretty boxy problem this morning, as I tried to login as mysql manager
> with
> #mysql -u root -p
> # (i forgot the password)
>
> its either this, or the other administrator, whom i cannot contact right now,
>changed the password without my know
Michael Blood wrote:
> I am running 3.23.40 on a dual pentium III 800 with 1 GB Ram.
>
> I have been getting an table handler returns error 127 error
>
> If I fix the table with myisamchk -r or -o it will work for a while and then
> I will get the same error again.
Try dumping and restroing the
I am thinking of running MySQL on my box for some work with PHP. I am
concerned about the mods to the directory structure. I can't seem to
find a list for mods it will make on RedHat7.1
Could you please help me out with that?
Thanks
Harpreet wrote:
> I am using concat in my sql and it runs fine on mysql client. But when use
> din php it gives me an error:
> Supplied argument is not a valid MySQL result resource in
> /var/www/html/scripts/cfg_code_delete.php on line <
>
> $ssql="select concat(category, "-", code) as fill_colu
Hi,
i ran into a pretty boxy problem this morning, as I tried to login as mysql manager
with
#mysql -u root -p
# (i forgot the password)
its either this, or the other administrator, whom i cannot contact right now, changed
the password without my knowledge of it.
What can i do? is there som
On Wed, 24 Oct 2001, Allen Tang wrote:
> I have sco-unix 3.2v5.0.4.
> Now, install mysql-3.23.43-pc-sco3.2v5.0.6-i386
>
> Seems the mysql server can't start.
> The error message as follow.
> Please give me a hint.
>
> Thanks.
>
> $ ./bin/mysql -h ed -u allen -p
> Enter password:
> dynamic linke
On Wed, 24 Oct 2001, Scott Powell wrote:
> Hello all,
> I'm the poor guy trying to get Perl talking to a MySQL database on SCO
> OpenServer 5.0.5. I've managed to get the binary distributions of MySQL
> 3.23.43 working, as well as DBI-1.20 installed. However, I cannot get
> the MySQL driver workin
I am using concat in my sql and it runs fine on mysql client. But when use
din php it gives me an error:
Supplied argument is not a valid MySQL result resource in
/var/www/html/scripts/cfg_code_delete.php on line <
$ssql="select concat(category, "-", code) as fill_column, code_id as
submit_colum
Gregory,
This is a PHP question, really, but...
If you just echo the $companyname variable, you don't need double quotes around it:
If that is not what you are actually doing, give us the real code you are usign with
$companyname in it, and we'll take it from there.
At 19:38 2001-10-24 +0200
Hello,
I have sco-unix 3.2v5.0.4.
Now, install mysql-3.23.43-pc-sco3.2v5.0.6-i386
Seems the mysql server can't start.
The error message as follow.
Please give me a hint.
Thanks.
$ ./bin/mysql -h ed -u allen -p
Enter password:
dynamic linker: ./bin/mysql: symbol not found: bzero
Killed
$ ./bi
Can someone tell me why this doesn't work?
create table download_warehouse
( avalonid int, downloads int, month int, year int )
SELECT avalonid, count(avalonid) downloads, month(stamp) month, year(stamp)
year
FROM avalon_downloads
group by avalonid, month, year;
The select statement works fine b
> How to know how many sessions are currently open against a MySQL database ?
Gustavo,
MySQL manual 7.28 SHOW Syntax
Regards,
=dn
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://l
Steve Meyers wrote:
> In a previous message, I failed to mention one of the main reasons you
> would NOT want to use a 500-character primary key. MySQL uses a key
> buffer to keep as much index information in memory as possible. The
> longer the key, the less info it can keep in memory, and
I've encountered this problem several times on complicated queries that
return no rows.
mysql_errno:1015
mysql_error:Can't lock file (errno: -30989)
After this error, I can't run queries to any associated tables, and the only
I know how to get around it is to restart mysqld.
Does anyone know why
This is more of a php problem than mysql, but since I am using them in
combo...
I have a database for people from the former Soviet Union that have
participated in a certain program. One of the fields represents the name of
their company. It is common (although not universal) practice to use qu
A quick check of a MyODBC connection made from Access 2000 to a MySQL
database (with 5 tables open) shows as a single process in WinMySQLAdmin...
the total connections show up as 3 (including the WinMySQLAdmin connection,
I assume). Bumping that up to ten open tables and one open query increases
First try:
mysqld-max-nt -remove
When its the first time running use:
mysqld-max-nt --standalone
-So you can see what is happening...
Shutdown
Then:
mysqld-max-nt -install
Restart as a service.
I just went through this last night...
Butch Bean
-Original Message-
From: Demirchya
Dear members,
How to know how many sessions are currently open against a MySQL database ?
Thanks.
Ing. Gustavo A. Edelstein
Tech. Mgr.
Equiplus Argentina S.A.
__
Visit us On Line at www.equiplus.com
Email addresses:
Operations: [EMAIL PROTECTED]
Consulting: [E
> I'm wondering whether this has something to do with the following words of
> wisdom in the reference manual:
> "For tables that changes a lot you should try to avoid all VARCHAR or BLOB
> columns. You will get dynamic row length as soon as you are using a single
> VARCHAR or BLOB columns."
>
>
Hello everyone,
I really need your help. I have been stuck for couple of days on trying to setup
MySQL server such, that it supports InnoDB tables. First of all I copy the following
into my.ini after [mysqld]
innodb_data_file_path = ibdata1:2000M
innodb_data_home_dir = c:\ibdata
set-variabl
>
> Dear members,
>
> How to know how many connections are established using the MySQL ODBC
driver ?
>
> Thanks.
>
> Ing. Gustavo A. Edelstein
> Tech. Mgr.
> Equiplus Argentina S.A.
> __
> Visit us On Line at www.equiplus.com
> Email addresses:
> Operations: [EM
> Well, count(*) is not a column, it is a function of a column.
> When it searches, it doesn't know the result of count so you
> cannot specify
> it in the where clause.
>
> This would work, but you have all the records retrieved, not only
> the ones
> who have more than 10 in the group:
>
>
At 14:24 24/10/2001 +0400, Mike Blazer wrote:
Hi Mike,
Thanks for the bug report.
The explanation why the insert command doesn't works on Win32,
is because the link file pointing for the DATA DIRECTORY wasn't
created in the create table command, like the Unix version does.
The Win32 OSs don't hav
I am running 3.23.40 on a dual pentium III 800 with 1 GB Ram.
I have been getting an table handler returns error 127 error
If I fix the table with myisamchk -r or -o it will work for a while and then
I will get the same error again.
Here are some of the stats on the table
rows:1126904
index len
Hello All.
Advise, plz.
When some inquires, mysql says:
ERROR 2013: Lost Connection to MySQL server during query
I repeat my query and result is good after follow message:
ERROR 2006: MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 1
Current database: database
"Wix,Christian XCW" wrote:
> Hi!
>
> How print the result from a query on my printer? I'm using the command line
> on linux.
> Lets say that I want to print everything from the table "Mercedes" in the
> database "Cars".
Pipes.
> How do I adjust the lenght of the lines?
man nenscript
Basically
1 - 100 of 137 matches
Mail list logo
