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 us
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 postin
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:
> './my
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 lan
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
NetGrou
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
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 o
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 creat
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:
EV>MySql service cant be initialized
EV>System error 1067
EV>The process finished suddenly
EV> Some help please?
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 wron
Tim Luoma wrote:
>
>
> 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> selec
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= max_allowed_pac
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 could
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 d
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 keys
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 anybody
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 us
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
drwxr-xr
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 e
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
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> actuall
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 the
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 st
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> S
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Ian M. Evans wrote:
|
| SELECT @totalVotes:=COUNT(titleid) FROM movieratings
|
|
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
back, 3.23
[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.a
[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 c
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 d
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 spon
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
Du
>> 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
user_haves.tota
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 en
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
Du
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
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 retrieve
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
__
Te
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
of
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 a
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 gr
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
update 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"
o
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 |
>
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 pri
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 SO
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 Company(companyid
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 wa
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 others
> 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 Company(companyid
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 A
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 o
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
> transactions/backu
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 master
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)
http://lists.mysq
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 W
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 rep
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
Net
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 => lat
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 /etc/rc3.
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
S
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
ta
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
* Wh
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
www.su
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 wha
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_cryp
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 req
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
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
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 Mes
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 [mailto:[EM
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 ar
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 works
Hi,
Select companyid, count(*) from CompanyServices where
serviceid = 1 or serviceid = 2 or serviceid = 3
group by companyid
having count(*) = 3
Bye and Good Luck.
--- Arul <[EMAIL PROTECTED]> wrote:
> Hi All
>
> The Table design goes like this
>
> Company Table
>
> companyid
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 work
Have you tried something like this,
SELECT iSession FROM O_Sessions GROUP BY iUser ORDER BY iSessions DESC;
Mike
- Original Message -
From: "Robo" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 16, 2002 3:39 PM
Subject: ??? Simple sql-question: SELECT iSession FROM O_Se
1 - 100 of 125 matches
Mail list logo
