Hello,
I have a question about a query. We have a guestbook and I want to do some
statistics for the messages in it. So I've created a query that looks like
this.
select hour(msg_date_time), count(*)
from messages
where user_id = 'almar'
group by hour(msg_date_time)
It returns the hour and the
Keith,
I have the below query that returns the correct records but the
POINTFUND.description field is all NULL while it has values in the table.
Any idea why? Thanks.
SELECT
RACES.RACE_ID,
RACES.sequence,
TYPES.typelong,
SCHEDULE.event,
SCHEDULE.date,
PARTY.lname,
Hi!
I just tried with 3.23.48 on Linux-2.4.16-SMP-64GB (ext2 I think), and a
5000 MB data file was created.
Best regards,
Heikki Tuuri
Innobase Oy
---
InnoDB - transactions, row level locking, and foreign key support for MySQL
See http://www.innodb.com, download MySQL-Max from
Satish,
Saturday, February 09, 2002, 12:21:06 AM, you wrote:
SS Hi guys,
SS I am not able to insert into the MySQL database
SS anymore. I think it has reached the table size. How do
SS i check the size to see if it has reached the table
SS size? Also let me know how to increase the table
FISHER,
Friday, February 08, 2002, 9:01:10 PM, you wrote:
Feoen I have 2 SuSE Linux 7.2 machines at home... These boxes
Feoen have completely different hardware in each... But the
Feoen O/S on each, contains virtually all of
Feoen the same applications...
Feoen On the first machine, MySQL
Paul,
Saturday, February 09, 2002, 1:14:56 AM, you wrote:
PC Can't connect to local MySQl server through port 111
Please, check the following link:
http://www.mysql.com/doc/C/a/Can_not_connect_to_server.html
--
For technical support contracts, goto https://order.mysql.com/
This email is
Try to delete the index (drop index) of the table!
I had the problem and solved this this way.
regards,
Andreas
On Samstag, Februar 9, 2002, at 11:41 Uhr, DL Neil wrote:
Keith,
I have the below query that returns the correct records but the
POINTFUND.description field is all NULL while
Nuno,
Friday, February 08, 2002, 11:04:51 PM, you wrote:
NT Hello to all,
NT I'm trying to make a query with only one command but I can't see how to do
NT it.
[skip]
NT What I want to do is get a list from table QB related to an item from
NT table QA:
NT For
Use SELECT * FROM Table1 WHERE BINARY name LIKE K%
It will probably slow the search...
You can also define the table a BINARY but 'Most' will be different than
'most'
Butch Bean
-Original Message-
From: savaidis [mailto:[EMAIL PROTECTED]]
Sent: Saturday, February 09, 2002 3:07 AM
To:
I don't know you table structure but something like this would do it...
SELECT * from QB as tbl1
JOIN relAB as tbl2
ON tbl2.A=tbl1.A
where tbl2.a='a1'
Butch Bean
-Original Message-
From: Egor Egorov [mailto:[EMAIL PROTECTED]]
Sent: Saturday, February 09, 2002 7:24 AM
To: [EMAIL
Hi,
I had successfull installed MySQL on RedHat 6.1 (2.2.12-20) for a long
time
but recently there was a power shutdown and in the next bootup I am
unable
to bring the deamon.
I unstalled MySQL and trying to reinstall the new one but its going
nowhere.
Hello All,
Later this year, O'Reilly will be hosting the fourth annual Open Source
Conference.
In preparation for the conference, they have asked us to issue a request
for proposals for conference talks and tutorials.
We know that there are a lot of people out there doing a lot of
interesting
Hi,
I try it and I get a syntax error:
You have an error in your SQL syntax near 'on tbl2.A=tbl1.A where
tbl2.A='a1'' at line 1
My tables structure are:
show fields from QB;
+--+-+--+-+-++
| Field| Type|
Hello Almar
I have a question about a query. We have a guestbook and I want to do some
statistics for the messages in it. So I've created a query that looks like
this.
select hour(msg_date_time), count(*)
from messages
where user_id = 'almar'
group by hour(msg_date_time)
It returns the
Nuno,
I think these examples will work OK for what you want...
Butch
SELECT QB.id, QB.ref, QB.question from QB, relAB
WHERE QB.ref=relAB.B
AND relAB.B='a1'
SELECT DISTINCT QB.id, QB.ref, QB.question from QB, relAB
WHERE QB.ref=relAB.B
AND relAB.B='a1'
I moved a database from one server to another (mysqldump - mysql dbname
filefromump) ... and on the new server one table that has an auto
increment index fails with duplicate keys after the first insert ... the
first insert as an integer bound value (2147483647) rather than using
the established
On Friday 08 February 2002 19:28, Eric Mayers wrote:
Jim,
What you're asking about is the timestamp data type.
Look at : http://www.mysql.com/doc/D/A/DATETIME.html
In a nutshell, if you assign 'null' to a timestamp column it will put in
value of 'NOW()'.
Eric Mayers
Software Engineer
Hi,
Ok. Now I don't get syntax error but I don't get any results.
Anyway, I think that it is something like your examples.
Again, I need to get this results with only one query:
1st: get results from relAB to see QB relations:
SELECT B from relAB WHERE A='a1';
* DL Neil
Consider:
a) add a 'construction' table with the row-values 0 through 11
(or 23) and use it to do a left join against the
messages tbl;
b) if the database is not busy, use perl to fire off 12 (or 24)
separate queries.
c) use perl to 'fill in the holes', putting zero values in the
Just for further puzzlement --
I've run 'check table extended' on the table, dropped the table and
reloaded it, shut down the server and restarted it ... all to the same
effect. First insert to the table is the 214... integer limit then
duplicate key errors.
On Sat, Feb 09, 2002 at 11:18:08AM
Hi,
This morning is posted a message :
---
I have a question about a query. We have a guestbook and I want to do some
statistics for the messages in it. So I've created a query that looks like
this.
select hour(msg_date_time), count(*)
from messages
where user_id = 'almar'
group by
Bob,
There are some RDBMS-es that implement SQL to the point of apparently setting up a
construct that links
tables -
foreign key based data integrity being the first example that springs to (my)
mind. However relational logic
suggests that the way to set up a linkage between tables is
Hi,
Can Mysql ignore alphabet , like 'the' when
ORDERING a name.
A sample :
I have a table (first_name) :
- The test.
- Falcon
- The Armageddon
- Battle
When ordering it will be :
Battle
Falcon
The Armageddon
The test.
Can it be like this :
The Armageddon
Battle
Falcon
* Almar van Pel
snip
mysql select uren.uur,
- count(messages.msg_date_time)
- from uren left join messages
- on hour(messages.msg_date_time) = uren.uur where messages.user_id =
'almar' group by uren.uur
- ;
I'm not sure it will solve your problem, but try this:
select
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi all,
I'm having a spot of bother with permissions (i think)
I just set up MySQL for private developement at home with PHP and
created a db 'mydb' and granted all privs to nick@localhost
Now, I can 'USE mydb' from the command line but if I try to
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
* and then Paul DuBois declared
Note that the message doesn't include a user name in front of the '@'.
Which it would if you were specifying one.
Hello Paul,
I did notice that but I /am/ specifying a user mysql_connect($host,
$user,
Hello fellow mySQL users,
I'd like to know if UPDATE/DELETE statements use indexes on the where
statement the same way as SELECTs.
If I build a SELECT using the WHERE statement that I use in an UPDATE/DELETE
statement, can I use that accurately to determine what indexes mySQL will
use?
At 23:31 +0100 2/9/02, Nick Wilson wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
* and then Paul DuBois declared
Note that the message doesn't include a user name in front of the '@'.
Which it would if you were specifying one.
Hello Paul,
I did notice that but I /am/
sql,query
At 15:35 -0700 2/9/02, Andrei Cojocaru wrote:
Also, how do I reset an auto-increment value back to 1 (with all
rows being already deleted of course).
ALTER TABLE tbl_name AUTO_INCREMENT = 1;
Thanks for your help in advance.
At 22:25 +0100 2/9/02, Nick Wilson wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi all,
I'm having a spot of bother with permissions (i think)
I just set up MySQL for private developement at home with PHP and
created a db 'mydb' and granted all privs to nick@localhost
Now, I can 'USE
[I didn't get a response from openbsd-sparc, so I'm trying here. Any help
would be appreciated!]
I'm trying to get a MySQL server running under a recent OpenBSD 3.0 snapshot
on an Ultra 5, but I'm not having much luck.
I tried installing the binary mysql-server package (from
* and then Paul DuBois declared
BTW
er... I have your book here :)
Ah. Well, in *that* case, check p429 and pp464-465. You may be getting
bit by the phenomenon described there.
sql
Aha! Well that certainly appears to be it but now I'm getting Access
denied to user apache@localhost
At 0:19 +0100 2/10/02, Nick Wilson wrote:
* and then Paul DuBois declared
BTW
er... I have your book here :)
Ah. Well, in *that* case, check p429 and pp464-465. You may be getting
bit by the phenomenon described there.
sql
Aha! Well that certainly appears to be it but now I'm
Hello,
I've been reading about TIME _FORMAT in the mysql manual. Does this only
work
with a manually entered time?
SELECT TIME_FORMAT('13:45:00','%h:%i') as time FROM table_name;
I tried this,
SELECT TIME_FORMAT('column_name','%h:%i') as time FROM table_name;
to format my time column, But it
At 2:08 -0800 2/9/02, Joe Chesak wrote:
I am attempting to combine COUNT, GROUP BY, and LEFT
JOIN.. Adopting the theme on
http://www.mysql.com/doc/C/o/Counting_rows.html my
goal is to display only species/sex combinations that
occur more than once. Additionally I wish to include
the count for
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
sql
* and then Paul DuBois declared
Do you have an entry for user apache, host localhost in the user
No just entries for 'nick' and 'root'
table, and have you deleted the entries for user='' and run FLUSH
PRIVILEGES?
Certainly have.
- --
Hello mike
I've been reading about TIME _FORMAT in the mysql manual. Does this only
work
with a manually entered time?
SELECT TIME_FORMAT('13:45:00','%h:%i') as time FROM table_name;
I tried this,
SELECT TIME_FORMAT('column_name','%h:%i') as time FROM table_name;
to format my time
Hello,
Removing the quotations worked. Thanks for the help.
Mike
- Original Message -
From: DL Neil [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Saturday, February 09, 2002 5:54 PM
Subject: Re: My SQL TIME_FORMAT
Hello mike
I've been reading about TIME
I changed it...
they were | AND relAB.B='a1' in the other examples
| SELECT QB.id, QB.ref, QB.question from QB, relAB
| WHERE QB.ref=relAB.B
| AND relAB.A='a1'
|
| SELECT DISTINCT QB.id, QB.ref, QB.question from QB, relAB
| WHERE QB.ref=relAB.B
| AND relAB.A='a1'
|
How do you install it I untarred it and now what do I do. I am running RH
7.0 downloaded mysqlgui-1.7.5.
Thanks
Andy Magana
San Diego,Ca
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Harald,
I was now able to repeat the error and fixed it. If one defines a non-latin1
character set as the default (german1 in your case), then the sorting order
of the InnoDB internal datatype DATA_VARCHAR was undefined, and foreign key
system tables did not work, because they contain
Dear MySQL users,
I have just pushed my latest changes in the replication code in our 4.0
development tree, which change the slave to use two threads - I/O thread that
gets the data from the master and logs it, and SQL thread which processes the
logged data. I have tested it extensively, and
Hello MySQL users
I was wondering if one of you could advise me on the best solution to a
problem I'm having - I'm sure this has been done before but haven't found
anything in the archives.
Basically the problem I am having is how best to handle multiple values for
a specific column, in this
i need help!!
i an doing my assignment using mysql to establish a database!!
i already create the table and insert the data,
but i don't know how to create a export file,
anyone can help me!!
_
Ãâ·ÑÏÂÔØ MSN
44 matches
Mail list logo