Check out GROUP BY
-Ursprüngliche Nachricht-
Von: Scott Haneda [mailto:[EMAIL PROTECTED]
Gesendet: Freitag, 6. Februar 2004 23:34
An: MySql
Betreff: iterating through a month
In MySql is it possible to repeat through a month, for example I would like
to
Select count(user) from table w
Hi,
Am Freitag, 6. Februar 2004 16:03 schrieb Dusan Spisak:
> Hello everybody!
>
> I need to create some simple database. I've started to build it up in
> Microsoft Access. MS Access was really great for me, it was very easy and
> user friendly, intuitive. Without any manual I've managed to create
Andre MATOS <[EMAIL PROTECTED]> wrote:
>
> Is it possible to GRANT an USER to just UPDATE one specific FIELD instead
> of the entire TABLE?
Yes, you can grant UPDATE privilege on the certain column:
http://www.mysql.com/doc/en/GRANT.html
For example:
GRANT UPDATE(column1) ON db
* dan orlic <[EMAIL PROTECTED]> [2004-02-05 18:31 +0100]:
> i have an issue with my.cfg. I am trying to change the value of
> wait_timeout. it's default value is 28800., my install is 4.0.15. As
> i understand it, the my.cfg file needs to be in /etc dir.
1.) Shouldn't it be "/etc/my.cnf" ?
Geoffrey, Dan,
- Original Message -
From: "Dan Nelson" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Saturday, February 07, 2004 5:27 AM
Subject: Re: Memory Leak using InnoDB ?
> In the last episode (Feb 07), Geoffrey said:
> > I'm running MySQL 4.0.17 with RH Linux 8 on
Michael,
- Original Message -
From: "MIchael Johnson" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Saturday, February 07, 2004 1:03 AM
Subject: INNODB - Reclaiming ibdata space and various ibdata questions
> --0-1416817391-1076108604=:94234
> Content-Type: text/plain; c
Hi,
I am a blind user and for me it would be very helpful if I could use
this GUI.
At the moment I have got the problem, that you have to click on every
item.
There are no short cuts and it is not posible to navigate using the
tab-key or context-menue.
Or the arror-keys.
Perhapts you can include
Thanks to all, it works fine.
Regards
John Berman
-Original Message-
From: Martijn Tonies [mailto:[EMAIL PROTECTED]
Sent: 06 February 2004 22:18
To: [EMAIL PROTECTED]
Subject: Re: A challenge I think
Hi,
> Using MySQL 4x
> I have two tables
> Lists and members
> Now for every list t
El Sáb 07 Feb 2004 02:28, escribió:
> Mr. Alfredo
> Pls, will you give the complete structure as 'create query' of your
> database? that will help us to solve your problem.
> Pradap
This is the structure of the table that holds the sequential numbers for
various documents that need them:
CRE
I am trying to get MySQL to automatically create a date seven days from
the date a new record is created. The new records will be inserted
through an ASP, VBScript website. I have managed to get this to work in
MS Access by typing in to its default field in the database Now()+7. As
you would ex
* Matthew Stuart
> I am trying to get MySQL to automatically create a date seven days from
> the date a new record is created. The new records will be inserted
> through an ASP, VBScript website. I have managed to get this to work in
> MS Access by typing in to its default field in the database Now
Greetings,
I'm in the process of migrating from Access to MySQL. I've imported access
queries into MySQL, and they do show up (using a third party db manager,
they show up under tools).
In Access, queries can be used like views. I.e. you can select from them.
Now, the version of MySQL I'm using
I assume the INSERT statement you have suggested goes on the webpage
that has the form from which the new record will be created, Is that
correct?
Thanks.
Mat
On Saturday, February 7, 2004, at 02:24 PM, Roger Baklund wrote:
* Matthew Stuart
I am trying to get MySQL to automatically create a d
Ah, I see. Of course. And adding 0 is exactly what the manual says to do.
I was about to reply to say that |0 works where +0 does not when Bernard
sent his excellent suggestion to cast as unsigned. Then I spent a while
trying to figure out why you got such a large number for '40'. I
finally
Hello,
Does anyone know if InnoDB Hot Backup supports the new tablespace
format being introduced in the latest versions of InnoDB?
I'm quite tempted to switch from MyISAM to InnoDB using the new
tablespace format, but I'm put off by how inflexible InnoDB files seem
to be. I like being able to mov
On Fri, Feb 06, 2004 at 08:18:10PM +, Phil wrote:
> Doesn't seem to change the mtime on table files. It appears that for
> InnoDB tables these files are only updated when the definition of a
> table is changed. The content of the all InnoDB tables is kept in one or
> two massive files directly
Thanks for checking this out. However, with InnoDB tables you only get
the .frm files under a database directory and these are only modified
when you change the definition of a table. The data itself is kept in a
big binary file(s) one directory up, whose modification time cannot be
used to deduce
* Matthew Stuart
> I assume the INSERT statement you have suggested goes on the webpage
> that has the form from which the new record will be created, Is that
> correct?
Yes.
--
Roger
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lis
Hi,
I've some data out of a legacy application which has a list of names and
mailing addresses for contacts. The legacy data is from a DG database.
Every few weeks my sql database will be repopulated. There are four
varchar(30) fields describing names and addresses (name1,add1,add2,
add3
Dan, Heikki,
- Original Message -
From: "Heikki Tuuri" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, February 07, 2004 11:39 AM
Subject: Re: Memory Leak using InnoDB ?
> Geoffrey, Dan,
>
> - Original Message -
> From: "Dan Nelson" <[EMAIL PROTECTED]>
> Newsgroups:
Geoffrey,
- Original Message -
From: "Geoffrey" <[EMAIL PROTECTED]>
To: "Heikki Tuuri" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Saturday, February 07, 2004 10:11 PM
Subject: Re: Memory Leak using InnoDB ?
> Dan, Heikki,
>
> - Original Message -
> From: "Heikki Tuuri" <[EM
Chris,
- Original Message -
From: "Chris Elsworth" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Saturday, February 07, 2004 7:25 PM
Subject: InnoDB Hot Backup & new tablespace format
> Hello,
>
> Does anyone know if InnoDB Hot Backup supports the new tablespace
> format
[EMAIL PROTECTED] wrote:
> What happens when you do a show slave status on the slave machine
This:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 10 to server version: 4.0.15-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> show sl
Hello MySql Buffs,
I have a problem. I am running mysql on slackware 9.0, version
4.0.15a. I have a web server running on a Red Hat Enterprise machine,
and would like to access the mysql database thru php, etc. Nothing new
here (except to me!). using a php script: like this:
$dsn =
Brian L. Walter wrote:
Greetings,
I'm in the process of migrating from Access to MySQL. I've imported access
queries into MySQL, and they do show up (using a third party db manager,
they show up under tools).
In Access, queries can be used like views. I.e. you can select from them.
Now, the ver
Hi,
You're probably right. All the status variables seem to start over
after hitting 4,294,967,295. :-( I don't get why they're only using 32
bit integers for the variables that they know can go WAY over that
amount. :-/
Matt
- Original Message -
From: "Mikhail Entaltsev"
Sent: Frida
HI everyone:
I am using a dual 800 MHz power mac G4 in which I have installed MySQL.
When ever I try to create a new database in MySQL, I receive the
following error
"mysql> create database dogs;
ERROR 1044 (42000): Access denied for user: ''@'localhost' to database
'dogs'"
Can anyone assist
Hey guys,
I was wondering if there is a converter for access databases to mysql or
phpmyadmin
I downloaded some stats files for my football league, but they are in
access,
Anyway I can convert them?
Karl James (TheSaint)
[EMAIL PROTECTED]
http://theufl.com/
--
MySQL General Mailing List
Fo
i have converted access to mysql easily using the sqlyog gui tool
-Original Message-
From: karl james [mailto:[EMAIL PROTECTED]
Sent: Sunday, February 08, 2004 11:09 AM
To: [EMAIL PROTECTED]
Subject: convert
Hey guys,
I was wondering if there is a converter for access databases to mysql
Hi,
I have instaled mysql 4.0.17 on a debian server, but i have a big problem.
I can only connect to mysql at the server and only with -h localhost. If I try
this:
mysql -h server -u root
from anywhere i receice always the same response:
ERROR 2003: Can't connect to MySQL server on
I am new to mysql and I am having trouble getting started. I am using a
Macintosh G5 running OS 10.3.2. I got mysql installed and it would run,
however when I tried to create a database, I got an error saying
permission denied. I tried running the scripts/install_mysql_db, and I
had to change p
On 8 Feb 2004, at 00:29, [EMAIL PROTECTED] wrote:
Hi,
I have instaled mysql 4.0.17 on a debian server, but i have a big
problem.
I can only connect to mysql at the server and only with -h localhost.
If I try
this:
mysql -h server -u root
from anywhere i receice always the same response:
Make sure that you have persmission to create database.
Check MySQL manual:
http://www.mysql.com/doc/en/index.html
From: mysql <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Error creating database
Date: Sat, 7 Feb 2004 19:00:54 -0500
HI everyone:
I am using a dual 800 MHz power mac G4 in whi
Hmmm, I dunno.
Perhaps the term: mysql -h 'server' -u root
Should be changed to: mysql -h your_hostname -u root
As "your_hostname" is the actual FQDN of your server.
Brian Duke
SS-TCAM//87797
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Saturday, February
You can install MYSQL on your Windows machine and use this user interface
for managing the database http://www.mysql.com/downloads/mysqlcc.html
From: "Dusan Spisak" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: Just simple question...
Date: Fri, 06 Feb 2004 16:03:23 +0100
Hello everybody!
mysql wrote:
HI everyone:
I am using a dual 800 MHz power mac G4 in which I have installed MySQL.
When ever I try to create a new database in MySQL, I receive the
following error
"mysql> create database dogs;
ERROR 1044 (42000): Access denied for user: ''@'localhost' to database
'dogs'"
You a
Hi
You can only connect as root from localhost for security I think.
If you want to connect from elsewhere create a new user and use that - look
for GRANT on www.mysql.com
Peter
-Original Message-
From: Duke, Brian [mailto:[EMAIL PROTECTED]
Sent: 08 February 2004 01:50
To: [EMAIL PROTEC
O'Reilly has a favorite database poll right now - visit
http://www.oreilly.com/ for details
Cheers!
--zak
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
While reading the manual the other day, I noticed that MySQL supports a syntax
of INSERT INTO table VALUES (x),(y),(z). Very handy, and nice and fast.
However, when this syntax was tested on an AS/400 and an Ingres installation,
it doesn't work. The manual doesn't list this format as an exten
39 matches
Mail list logo