Victoria Reznichenko wrote:
Sameh,
Sunday, July 14, 2002, 3:09:53 PM, you wrote:
SA Can anybody help me figuring how to control granting users
SA permissions to created functions in MySQL like we do for SELECT,
INSERT,
SA ...etc or it is not possible and every one logged in to
Hi,
Im just wondering why MySQL ver 3.23.51 is not supporting LOAD DATA INFILE
syntax, I downgrade my server to the older one which is MySQL ver 3.23.44,
is there any bug about using it in the latest version?
R.B.Roa
Traffic Management Engineer
PhilCom Corporation
Tel. No.(Office)
Hi,
I'm using MySQL-Max-4.0.1-alpha on WinNT4SP6 with InnoDB as default
table type.
I have a database creation script like this:
//Section A
CREATE TABLE AParents (
Id int unsigned not null auto_increment,
Parent int unsigned not null,
primary key (Id),
index Parent (Parent)
) TYPE =
Hi,
I want to know one thing about MYSQl,
Why does this software always give the unix-socket
problem when compiled and installed.
I am installing on redhat 7.1.
Is there a remedy to this or this will continue
forever.
Any help will be appreciated.
Thanks
Is there any problem in my.cnf file?
[mysqld]
log-bin
server-id=165
skip-bdb
skip-name-resolve
skip-innodb
flush
port=3306
socket=/tmp/mysql.sock
set-variable = key_buffer_size=16M
set-variable = max_allowed_packet=1M
set-variable = flush_time=300
I only use MyISAM...LOAD DATA INFILE syntax I
On Tuesday, 16. July 2002 08:55, [EMAIL PROTECTED] wrote:
Hi,
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://www.mysql.com/doc/L/O/LOAD_DATA_LOCAL.html
Regards Georg
-
Before
On Tuesday, 16. July 2002 07:11, Aaron Axelsen wrote:
Hi,
020715 23:40:08 mysqld started
020715 23:40:08 /usr/local/mysql/libexec/mysqld: Can't create/write to
file '/usr/local/mysql/var/Alpha.pid' (Errcode: 13)
020715 23:40:08 /usr/local/mysql/libexec/mysqld: Can't find file:
Nope, the SQL query I suggested earlier is incorrect because it biases the
display by AVG of votes already. You do need to divide the average by all
votes, as suggested by Mark.
In what environment do you want to use this Ian? Can it not be done with two
queries...if it is in some programming
I got iti wasn't able to add the local-infile option in my server
configthanks for the help
R.B.Roa
Traffic Management Engineer
PhilCom Corporation
Tel. No.(Office) (088) 858-1028
(Home) (088) 858-8889
Mobile No. (63) (919-3085267)
-Original Message-
Hi all,
Which tools would you recommend to performance monitoring of a MySQL
database server?
I'm thinking of the following:
System: CPU utilization, disk I/O.
RDBMS: buffer cache hit ratio, transactions/sec, connections.
Yours
--
Lasse Laursen [EMAIL PROTECTED] - Systems Developer
NetGroup
Hi,
perhaps Mytop will be good for you ...
http://jeremy.zawodny.com/mysql/mytop/
David
- Original Message -
From: Lasse Laursen [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, July 16, 2002 10:56 AM
Subject: Performance Monitoring/Counters
Hi all,
Which tools would you
Daniel,
are you using a non-latin1 character set? Have you looked in the error log
mysql.err? What, if anything, did mysqld-max print when it crashed?
From the manual http://www.innodb.com/ibman.html#InnoDB_history:
...
MySQL/InnoDB-3.23.49, February 17, 2002
...
Fixed a bug: if one defined a
Jenny Christy wrote:
Hello All,
Can anybody tell me the query or procedure by which i
can generate the .sql file. So that I dont need to
write the query again and again on prompt.
Just by executing the .sql file(or script language), I
will able to create table, insert the data on
Jenny,
Tuesday, July 16, 2002, 9:09:30 AM, you wrote:
JC Can anybody tell me the query or procedure by which i
JC can generate the .sql file. So that I dont need to
JC write the query again and again on prompt.
JC Just by executing the .sql file(or script language), I
JC will able to create
Nitesh,
Tuesday, July 16, 2002, 3:46:39 AM, you wrote:
ND I have my MySql 3.23 running, I installed MyODBC in my Win98 PC and created a DSN
for MySql.
ND When I use MS Access to connect to MySql I get an Error saying Host 192.168.1.103
is not allowed to connect to this MySql Server.
ND I
Elby,
Tuesday, July 16, 2002, 3:58:15 AM, you wrote:
EV i installed MySql -Max 3.23.51 on Winodows 2000, but when I try initiate
EV it appears the following error:
EVMySql service cant be initialized
EVSystem error 1067
EVThe process finished suddenly
EV Some help please?
Run
Kiss,
Tuesday, July 16, 2002, 10:11:45 AM, you wrote:
KD I'm using MySQL-Max-4.0.1-alpha on WinNT4SP6 with InnoDB as default
KD table type.
KD I have a database creation script like this:
[skip]
KD When I run the section A and B in any order, MySQL crashes and InnoDB
KD tablespaces go wrong
Tim Luoma wrote:
newbie warning
I'm trying to write my first shell script using MySQL. I've checked
Welling Thomson and Google but I think I'm searching the wrong
keywords or something.
The shell script will be non-interactive, but interactively this is
what I would do:
mysql
I am currently trying to insert images which are roughly around 140Mb each
into my database using the data type longblob. The problem I seem to be
having it that I cannot set the max_allowed_packet to go over 67107840. In
my /etc/my.cnf I have the following line:
set-variable=
Heikki,
Yes, I'm using Hungarian character-set as default.
I've checked the mysql.err, and it contains nothing important.
The full content of mysql.err right after starting mysqld-max, runnig
the script and crash:
---
MySql: ready for connections
---
Maybe, because MySQL crashed before it
I am a new user of mysql
I installed 3.23.51 on my nt
this is my my.ini files.
[mysqld]
innodb_data_home_dir =
innodb_data_file_path = ibdata1:30M:autoextend
default-table-type=innodb
[WinMySQLAdmin]
Server=C:/mysql/bin/mysqld-max-nt.exe
When I use the winmysqladmin it report in HAVE_INNODB
On Tue, 2002-07-16 at 02:31, Bill Bernat wrote:
Question: is there anything I need to be aware of when writing dump
files to a local directory for my user, I'm having the following
problem.
1. I create a directory in my own home directory (linux, red hat 7.2)
~/dumps and give it 777
Can anyone suggest free database desiging tool that supports mySQL.
Case studio 2.9 demo version supports mySQL but it does not allow more than
6 Tables to be designed.
Moreover demo version does not give option for referential integrity
constraints. i.e. scripts are generated without Foreign
Hello all,
I am having a problem in referential Integrity in mySQL. I have
created a parent table which have deptno from 1-10. When i insert a row in
child table that has deptno as foreign key it accept a value 11 which is
actually not present in parent table.
Can
The instructions where followed from the website exaactly and all the
file premissions are correct, but I still get the following errors in
ther log file:
020716 05:23:59 mysqld started
^G/usr/local/mysql/libexec/mysqld: File './Alpha-bin.1' not found
(Errcode: 13)
020716 5:23:59 Could not
Error code 13: Permission denied
Check if the user that runs mysql (usually user mysql) has permissions
on those directories. Usually, the ownership is mysql.
An example (i also have the mysql group):
[root@cartman mysql]# pwd
/var/lib/mysql
[root@cartman mysql]# ll -dh . .. *.* mysql
Sameh,
Tuesday, July 16, 2002, 9:26:27 AM, you wrote:
SA Victoria Reznichenko wrote:
SA
SA SA Can anybody help me figuring how to control granting users
SA SA permissions to created functions in MySQL like we do for SELECT,
SA INSERT,
SA SA ...etc or it is not possible and every one
Aaron,
Tuesday, July 16, 2002, 1:25:23 PM, you wrote:
AA The instructions where followed from the website exaactly and all the
AA file premissions are correct, but I still get the following errors in
AA ther log file:
AA 020716 05:23:59 mysqld started
AA ^G/usr/local/mysql/libexec/mysqld:
Aman,
Monday, July 15, 2002, 8:35:16 PM, you wrote:
AR I want to write sql query to duplicate a row. It has a PRI key called ID.
AR The MySQL database looks like
AR IDNameAddress
AR 345 Aman42, sb
AR 346
AR 347...
AR I want to duplicate the ID=345.
AR
Adnan,
Tuesday, July 16, 2002, 2:18:22 PM, you wrote:
AY I am having a problem in referential Integrity in mySQL. I have
AY created a parent table which have deptno from 1-10. When i insert a row in
AY child table that has deptno as foreign key it accept a value 11 which is
AY actually
Xinguang,
Monday, July 15, 2002, 6:01:35 PM, you wrote:
I have been trying to use the LOAD data command to load the data
XS instead of using the sql insert into table. It works fine but I have
XS got some warnings, how can I see these warnings, is there a log for
XS it, how can I see these
Nick,
Monday, July 15, 2002, 5:58:31 PM, you wrote:
NM I'm using version 3.23.53 on Win 2k.
NM The same things happens to me.
NM I've also noticed that if you don't specify a WHERE clause and you have a
NM Auto-incrementing ID field, it is reset to zero and the next record you
NM create starts
Massimo,
Tuesday, July 16, 2002, 1:02:15 PM, you wrote:
MP I am a new user of mysql
MP I installed 3.23.51 on my nt
MP this is my my.ini files.
MP [mysqld]
MP innodb_data_home_dir =
MP innodb_data_file_path = ibdata1:30M:autoextend
MP default-table-type=innodb
MP [WinMySQLAdmin]
MP
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Ian M. Evans wrote:
| snip
| SELECT @totalVotes:=COUNT(titleid) FROM movieratings
| /snip
|
What version of MySQL are you using? I just tried this on MySQL-4.0.2
and it worked.
If your version of MySQL doesn't support variables (they go pretty far
[snip]
sqltext2 = Select sum(orders.amount * products.price) AS total from
orders,products where orders.product=products.productid AND cluster = '
cluster 'and orderdate ' printdate ';
[/snip]
If the query conditioals are the same for both queries you can just include
sum(orders.amount *
[snip]
Can anybody tell me the query or procedure by which i
can generate the .sql file. So that I dont need to
write the query again and again on prompt.
[/snip]
Create a text file containing your query commands and then save it as
filename.sql (calling it whatever you wish of course) and then
AR I want to write sql query to duplicate a row. It has a PRI key called ID.
AR The MySQL database looks like
AR IDNameAddress
AR 345 Aman42, sb
AR 346
AR 347...
AR I want to duplicate the ID=345.
AR Any suggestions ?
VR You can have duplicate values
Chris,
Tuesday, July 16, 2002, 2:13:57 AM, you wrote:
CK Can MySQL bind to two or more IP addresses?
Nope.
CK i.e. --bind-address 127.0.0.1 --bind-address x.x.x.x --bind-address y.y.y.y
CK ?
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is
Hi list,
Same thing here, mysql 3.23.51 works well during about 2 hours then
suddently load average grow up to 200 and more ...
Load average is less than 4 with 3.23.49.
We're using binary tar.gz non max versions from Mysql.com
OS : Linux Red hat 7.2
kernel : 2.4.10
1 Go RAM
2 * Intel 1 Ghz
Of the data? Or of the queries?
Not the data. Just your query, the output from explain and a create
table statement.
Query:
SELECT DISTINCT cards_crypt.*
FROM user_haves, cards_crypt WHERE
cards_crypt.name LIKE %harrod% AND
user_haves.card_name = cards_crypt.name AND
Hello
I have a question for all you MySQL people out there
We are a group of people planning to make a small open source
ERP/accounting/finance program. We have earlier used MySQL to great
satisfaction in other areas and would like to use it here. My question is:
Do you think MySQL is secure
Hi list,
Same thing here, mysql 3.23.51 works well during about 2 hours then
suddently load average grow up to 200 and more ...
Load average is less than 4 with 3.23.49.
We're using binary tar.gz non max versions from Mysql.com
OS : Linux Red hat 7.2
kernel : 2.4.10
1 Go RAM
2 * Intel 1 Ghz
Difficult to answer without knowing what the
unix-socket problem is.
p shah wrote:
Hi,
I want to know one thing about MYSQl,
Why does this software always give the unix-socket
problem when compiled and installed.
I am installing on redhat 7.1.
Is there a remedy to this or this will continue
Hi,
This is not related with your issue but if you want to
do serious development, don't use Windows 98 in any of
its versions. It is going to give a lot of problems.
Bye and Good Luck.
--- Matthew Scarrow [EMAIL PROTECTED] wrote:
I've built a whole program with vb6 and mysql
database back
I have two collumns in my mysql database like this
+--++
|id|domain |
+--++
|user@domain1com |domain1.com |
|[EMAIL PROTECTED] |domain1.com |
|[EMAIL PROTECTED] |domain1.com |
+--++
in a
Hi everybody,
is there a way to calculate the number of rows retrieved by a mysql query,
without actually performing it?
I want to make a paginated result like in most search engines, and for that
I need to display the number of pages
the result would have, but I do not want to actually
Hi!
I found out, that the MySQL-daemon /usr/sbin/mysqld (Version 4.02, the rpm
version), installed under RedHat 7.3 (i386) doesn't like the option
Randomize mmap() base from the Grsecurity kernel patch suite...
Greetings,
tobias gablunsky
__
We use MySQL to store financial data and have never had a problem.
The things you mentioned (transactions/backup/power failure security) should
be used with ANY database that stores critical information that cannot be
lost. No database is completely bullet proof. Regular backups stored at an
Try adding a primary key to the table.
alter table webpage add autoid INT UNSIGNED NOT NULL PRIMARY KEY
AUTO_INCREMENT
This will help the database functions search through the table quicker.
I think another area where the query is getting slowed down is in the
translation of the Java. Java is
Patrick J Okui wrote:
I have two collumns in my mysql database like this
+--++
|id|domain |
+--++
|user@domain1com |domain1.com |
|[EMAIL PROTECTED] |domain1.com |
|[EMAIL PROTECTED] |domain1.com |
Not without actually performing SOME kind of query. You could
select count(*) from...
and insert the rest of your query there. This would give you the count.
Then store this in a session variable (PHP) for subsequent pages.
Most of the time though, I just put a NEXT button. ADODB has some
Walter D. Funk wrote:
Hi everybody,
is there a way to calculate the number of rows retrieved by a mysql query,
without actually performing it?
I want to make a paginated result like in most search engines, and for that
I need to display the number of pages
the result would have, but I do not
update table name set id = replace(id, '1', '2');
hope this helps
anil
- Original Message -
From: Patrick J Okui [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, July 16, 2002 9:47 AM
Subject: UPDATE command..
I have two collumns in my mysql database like this
well, #1, I would revision my data model. since user and domain are 2
distinct pieces of information, I would suggest that you consider pulling
them apart and placing them in separate fields.
#2
update users set is = concat(left(id,position('@',id)),'domain2.com') where
domain = domain1.com
or
Patrick J Okui [EMAIL PROTECTED] wrote on 16.07.2002 15:47:50:
I have two collumns in my mysql database like this
+--++
|id|domain |
+--++
|user@domain1com |domain1.com |
|[EMAIL PROTECTED] |domain1.com |
|[EMAIL
Please tell me if the MySQL 4.0.2-alpha Windows 95/98/NT/2000/XP (17.2M)
supports the subselect command.
Thank you !
_
Narcis GRATIANU
ICQ#: 13344551
More ways to contact me: http://wwp.icq.com/13344551
_
Hi Oleg,
I have similar problems on FreeBSD with one or two slow queries
hogging the CPU. I am running native threads. I am looking at a
parameter in the kernel (/usr/src/sys/i386/conf/LINT). It is the HZ
parameter and has to do with polling frequency. The default is 100,
I am experimenting
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Matthew Scarrow wrote:
| Try adding a primary key to the table.
|
| alter table webpage add autoid INT UNSIGNED NOT NULL PRIMARY KEY
| AUTO_INCREMENT
|
| This will help the database functions search through the table quicker.
Probably not. If the
Got it,
Thanks to all of your replies!
W.D.F.
- Original Message -
From: Cal Evans [EMAIL PROTECTED]
To: Walter D. Funk [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, July 16, 2002 11:44 AM
Subject: RE: Calculating rows in a result set
Not without actually performing SOME kind of
Hello,
don't somebody know about an application which allows
to create the ERA model of a database using GUI and generate
SQL code which makes this model real?
eg:
GUI: [table1]--[table2]
[table1]
|-attr1
|-attr2
...
SQL code:
create table1 (table1_id datatype,attr1 datatype1,attr2 datatype2...)
Hi,
Im using the MySQL C API for my clients and MyISAM tables for the
database (clients and server on W2k). I would now like to be sure that
the client never hangs when inserting tuples into a table (using
mysql_real_query()). This could happen if some other client holds (and
doesnt release) a
Hi All
The Table design goes like this
Company Table
companyid integer
name varchar(100)
Services Table
ServiceIDinteger
Servicevarchar(50)
Company Services
---
companyidinteger - References
You said:
--
is there a way to calculate the number of rows retrieved by a mysql query,
without actually performing it?
I want to make a paginated result like in most search engines, and for that
I need to display the number of pages
the result would have, but I do not
sql,query
IMHO, I'd look at creating a view that postfix looks at instead of the
table. This way you could concat the data for the view but keep it separate
in the table. rename the table users_table or something and create a view
called users.
Other than that, the concat statement I and
Please tell me if the MySQL 4.0.2-alpha Windows 95/98/NT/2000/XP (17.2M)
supports the subselect command.
No version of MySQL currently supports subselects.
From http://www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html
Subselects are currently being implemented in the 4.1 development
Hi All
The Table design goes like this
Company Table
companyid integer
name varchar(100)
Services Table
ServiceIDinteger
Servicevarchar(50)
Company Services
---
companyidinteger - References
http://www.thekompany.com/products/dataarchitect/
It's not free but it is cross platform and I think it supports pgsql.
=C=
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: Dusan Juhas [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 16, 2002 10:33
Dear Dirs,
I think I' ve found a bug.
Please run the following query
(I know you don' t have my db,
try something similar)
CREATE TABLE order_cross
SELECT date_format(data_iniz_num,'%y') as anno,ord_tmp.soc,ord_tmp.ml,
ord_tmp.cod_agente, ord_tmp.linea,
CASE WHEN
Victoria,
I see the problem is with sql/share/charsets/latin1.conf
because German umlaut 'ü' and 'Ü' is mapped to 59 'Y' in the
sort_order array. This is very much unlike the treatment
for the other umlauts ('ä' -- 5C and 'ö' -- 5D)
german1.conf does map 'ü' -- 55 'U' giving a correct sort
On Tue, Jul 16, 2002 at 02:51:59PM +0200, Mathias Bertelsen wrote:
Hello
Do you think MySQL is secure enough to keep peoples bookkeeping in?
is it safe enough to use without risk of losing important data? Is
it necessary to do anything to make it secure? (eg. use of
I've set up replication and the slave is updating any changes made to the
master, but these errors keep showing up in the error log. Any ideas??
020716 12:57:26 Slave: Failed reading log event, reconnecting to retry, log
'walt-bin.002' position 265
020716 12:57:26 Slave: reconnected to
Dear Dirs,
I think I' ve found a bug.
Please run the following query
(I know you don' t have my db,
try something similar)
CREATE TABLE order_cross
SELECT date_format(data_iniz_num,'%y') as anno,ord_tmp.soc,ord_tmp.ml,
ord_tmp.cod_agente, ord_tmp.linea,
CASE WHEN
Please
Do you have some information for install mysqlgui in Linux, i do not how do
it?
Thank you...
Luis R. De Freitas R.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Hi!
If the master is idle, then a slave of MySQL release 3.23.51 prints:
...
020715 12:05:33 Error reading packet from server: (server_errno=1159)
020715 12:06:03 Slave: Failed reading log event, reconnecting to retry,
log 'mysql.001' position 73
020715 12:06:03 Slave: reconnected to master
[snip]
CREATE TABLE order_cross
SELECT date_format(data_iniz_num,'%y') as anno,ord_tmp.soc,ord_tmp.ml,
ord_tmp.cod_agente, ord_tmp.linea,
CASE WHEN month(data_ordine) = 1 then qty else 0 END as jan,
CASE WHEN month(data_ordine) = 2 then qty else 0 END as feb,
CASE
Someone has a pretty lousy filter installed
At 02:56 PM 07/16/2002, you wrote:
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must include
one of the following words in your message:
sql,query
If you just reply to
A load of 2? Heck we have systems that run a load of 20 or more without
issues. If you are doing a lot of connections you might look at optimizing
your code. Also using indexes can increase the speed as well.
---
Brad Dameron
I want the latest (highest) iSession to be selected:
SELECT iSession FROM O_Sessions GROUP BY iUser
Because of GROUP BY, allways the first(!) recordset for iUser is selected.
But i want the last recordset to be selected :-(
How can this be done ?
(mySQL)
(iSession ist the primary key =
Hi - I've been using MySQL for a variety of functions with great success
over the last year. However, I recently rebuilt my log database server
after a crash, and I've been having a lot of trouble with two tables getting
corrupted.
One table stores my syslog entries from Kiwi Syslod Daemon, and
I plan to attempt installing MySQL on a Cobalt Raq4 this week - anyone have
experience/advice to share? My plan is to download the RPM from mysql.com
and follow the directions on the site, but I have read some things on the
internet that say to stay away from the rpm...
Kristy
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
i configure/make/make install mysql-3.23.51 on sparc solaris using
gcc-2.95.2. i used the configure option --sysconfdir=/usr/local/etc.
i ran the mysql_install_db script, i performed all the chown/chgrp
operations, i copied mysql.server to
David,
Tuesday, July 16, 2002, 3:55:46 PM, you wrote:
DB Same thing here, mysql 3.23.51 works well during about 2 hours then
DB suddently load average grow up to 200 and more ...
DB Load average is less than 4 with 3.23.49.
DB We're using binary tar.gz non max versions from Mysql.com
DB OS :
I have an INNODB table which has 4 records in it. customer_number is the
primary key.
If I run
select count(cutomer_number) from customer;
It takes about 15 seconds to return the number of rows.
I ran explain on the query and it's using the unique key index on
customer_number.
If I run
Hello.
On Sat 2002-07-13 at 05:03:43 -0700, [EMAIL PROTECTED] wrote:
If you are on the same OS and rsync happens fine, then you should not loose
any data.
But only if he also somehow assures that no updates take place on the
master while doing the rsync. Additionally, he should do a flush
Hello.
On Mon 2002-07-15 at 15:44:11 +0200, [EMAIL PROTECTED] wrote:
Can someone plz send me the posting from mysqlab concerning the beta
training , I deleted it accidentally...
Thanks
You can find the same information here:
http://www.mysql.com/training/certification.html
Greetings,
[root@Alpha mysql]# pwd
/usr/local/mysql
[root@Alpha mysql]# ls -al
total 48
drwxr-xr-x 12 root mysql4096 Jul 15 01:31 .
drwxr-xr-x 14 root root 4096 Jul 15 01:27 ..
drwxr-xr-x2 root mysql4096 Jul 15 01:57 bin
drwxr-xr-x3 root mysql4096
USually all the databases sets up fine BUT recently, I have
had to adjust databases to 0777 in order to get them to
work and change the ownership.
I prefer the more secure model of mysql.
How can I fix this?
--
contact:
Dave Yadallee NetKnow The Internet Knowledge Company
[EMAIL PROTECTED]
Hi, I'm developing a system which will use transactions with InnoDB.
In principle, when you use transactions, there is some risk that a
deadlock will happen and MySQL will abort the transaction. In this
situation, you should generally try to do the transaction again. I'm
wondering
*
Hi
Dont use the rpm, go for the package at
http://pkgmaster.com/packages/raq/4/
and install it from there, just point and click!
Peter
---
Excellence in internet and open source software
---
Sunmaia
On 16 Jul 2002, at 21:39, Robo wrote:
I want the latest (highest) iSession to be selected:
SELECT iSession FROM O_Sessions GROUP BY iUser
Because of GROUP BY, allways the first(!) recordset for iUser is
selected. But i want the last recordset to be selected :-(
I'm not sure what you
Hello.
On Tue 2002-07-16 at 07:47:33 -0500, [EMAIL PROTECTED] wrote:
Of the data? Or of the queries?
Not the data. Just your query, the output from explain and a create
table statement.
Query:
SELECT DISTINCT cards_crypt.*
FROM user_haves, cards_crypt WHERE
cards_crypt.name LIKE
Hi,
will it work if I add some custom fields to the mysql user table?
Regards
-jm
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To
On Tue, Jul 16, 2002 at 03:52:35PM -0400, walt wrote:
I have an INNODB table which has 4 records in it. customer_number is the
primary key.
If I run
select count(cutomer_number) from customer;
It takes about 15 seconds to return the number of rows.
I ran explain on the query and
On Tuesday 16 July 2002 05:05 pm, Jeremy Zawodny wrote:
On Tue, Jul 16, 2002 at 03:52:35PM -0400, walt wrote:
I have an INNODB table which has 4 records in it. customer_number is
the primary key.
If I run
select count(cutomer_number) from customer;
It takes about 15 seconds to
Hi,
the date format of MySql is /mm/dd (2002/07/16) right?
How I do to insert the date typing in my form dd/mm/ (16/07/2002)?
It is possible?
Thanks,
Elby
_
MSN Photos é a maneira mais fácil e prática de editar e
Well if you want the latest and greatest iSession irrespective of the user
use
select max(iSession) from O_Sessions;
If it is to be grouped by user, then
select user, max(iSession) from O_Sessions group by user;
This will give you the max iSession for a user.
Regards
Satish
-Original
Walt,
InnoDb physically counts all the rows in the table (unlike MyISAM
tables which stores the row count in a separate location). So in your case
it went through all 99,994 rows. The more rows you have in the table, the
longer it will take. I don't know how accurate Show table status
two pieces of advice.
1: Stop posting over and over again.
2: Check the archives. This is has been discussed in the past 3 months.
There is probably some very good advice there.
=C=
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: K Frey
thank's for your replies, but that did not help :-(
this is the setting (also look below for example table):
O_Sessions contains multilpe recordsets for iUser (let' say iUser=42).
I want the last RECORDSET of this iUser=42, not the first.
With GROUP BY, all the various recordsets with iUser=42
I have a build an ASP page to enter data in a mysql database.
When I open the page I get the following error :
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[TCX][MyODBC]Lost connection to MySQL server during query
/centraladmin/products.asp, line 88
When I refresh it
1 - 100 of 126 matches
Mail list logo
