) || end_active_trans(thd))
goto error;
+if (check_table_access(thd, SELECT_ACL, tables))
+ goto error;
if (grant_option check_grant(thd,SELECT_ACL | INSERT_ACL | UPDATE_ACL |
DELETE_ACL,tables))
goto error;
thd-in_lock_tables=1;
Submitter-Id:
Originator:Peter Pentchev [EMAIL
On Tue, May 22, 2001 at 02:41:44PM -0400, Dimiter Atanasov wrote:
Hello,
my name is Dimiter Atanasov.
I'm newbie in mysql servers. I have a strange problem, when i try to select
anythik written on Bulgarian (windows-1251) I recieve a unexpected results,
some letters are unacceptable lice
On Tue, May 22, 2001 at 12:29:35PM -0400, Graeme B. Davis wrote:
Is there a way to get the AVG of all specified NON-NULL columns in one row?
Right now I am doing this in a little script, but it would be nice if I
could do something like this:
DATA
-
id1044NULL3
should lock the table before your
insert statement, do the insert, retrieve the id just inserted, and then
unlock the table so others can operate with the table again.
This is my guess...
Anybody have another way???
Siomara
From: Peter Pentchev [EMAIL PROTECTED]
To: Viktor van den Berg
Ahh.. that, too :)
G'luck,
Peter
--
If I were you, who would be reading this sentence?
On Tue, May 22, 2001 at 12:04:34PM -0500, Cal Evans wrote:
Select avg(id1) from tableName where id1 is not null; ?
- Original Message -
From: Graeme B. Davis [EMAIL PROTECTED]
To: [EMAIL
Can you try this with a more recent MySQL version?
I cannot reproduce it here, on FreeBSD 4.3 running MySQL 3.23.38.
G'luck,
Peter
--
This sentence contains exactly threee erors.
On Tue, May 22, 2001 at 08:32:24PM +0300, Tarog Adrian wrote:
Hello,
I think me and my fellows here at office,
On Tue, May 22, 2001 at 10:36:02AM -0700, bineet suri wrote:
hello mysql
This is bineet from osprey software technology from
india actually i just installed and configure the
MySql database instead of postgres in linux and i have
a script which actaully create the table structure in
the
On Mon, May 21, 2001 at 11:32:46AM +0530, Adrian D'Costa wrote:
Hi,
I have been trying this on my localhost and this works
select special.contid, special.cityid, special.curr1, special.catalogo,
special.hf, special.curr2, special.vitofferta, special.fh, special.club,
special.stars,
On Wed, May 16, 2001 at 04:13:50PM +0530, [EMAIL PROTECTED] wrote:
We are planning to migrate from Oracle to mysql. Before we do it, i need
clarification on:
1. Does mysql supports triggers ?
2. if a client has to excess mysql then is a copy of mysql needed to be
installed on the clients
On Tue, May 15, 2001 at 11:27:19AM +0200, Vankeerberghen, Pieter wrote:
Thank you, Ok, I looked in the manual but I coul dnot obtain an answer. How
can I check that a date I'm importing is valid, e.g. how to check for
20001131 (MMDD) ?
You'll have to do this kind of validation checks in
On Tue, May 15, 2001 at 12:43:02PM +0200, RAZAKA wrote:
I would like to create multiple tables in a database.
HowTo Use REFERENTIAL INTEGRITY with MySQL ?
May I use FOREIGN KEY or REFERENCES?
Note: MySQL Release = 3.23.36
Thanks for help :)
In short, you can't..
From the MySQL manual
On Tue, May 15, 2001 at 10:24:38AM -0400, Chris Lambrou [CGL] wrote:
Hello,
This is more like a UNIX question: In our LINUX box
startup file, we have an entry to start mysql.
However, when the machine boots, mysql starts as root.
How do we make it to start as mysqladm (the user
we
On Tue, May 15, 2001 at 04:45:22PM +0200, Viktor van den Berg wrote:
Hi,
I am new to this list, so maybe this question is asked before.
I like to know how to use the except statement in MYSQL. EXCEPT is
(almost?) the same as an exlusive or (XOR):
select userid from user1
except
On Thu, May 10, 2001 at 10:24:11AM -, AVDHUT SHEDGE wrote:
in SQL query can we use sysdate to get System date like Oracle
What's wrong with NOW(), as seen in the manual?
Reference Functions Date and Time Functions
Next time, take a look there :)
G'luck,
Peter
--
yields falsehood, when
On Thu, May 10, 2001 at 10:16:33AM -0700, Simon Chan wrote:
In 6.13 of the mysql manual (Setting up th initial Mysql Privileges), it mentions
that the Mysql
root user is created as a superuser who can do anything. The Initial root password
is empty, so
anyone can connect as root without a
On Wed, May 09, 2001 at 09:20:52AM -0400, Bill Moran wrote:
Thanks for the reply, but I need a binary transfer of the DATA in the
field only. INTO OUTFILE does 2 things that corrupt the data:
1. Puts field data in the file
2. Escapes characters.
As far as I can tell, I either have to use
.
-Bill
Peter Pentchev wrote:
On Wed, May 09, 2001 at 09:20:52AM -0400, Bill Moran wrote:
Thanks for the reply, but I need a binary transfer of the DATA in the
field only. INTO OUTFILE does 2 things that corrupt the data:
1. Puts field data in the file
2. Escapes characters
On Wed, May 09, 2001 at 10:51:44AM -0400, Bill Moran wrote:
Peter Pentchev wrote:
So, MySQL 3.22.x does not have the capability to produce dumpfiles,
only outfiles.
Ah. I just read the whole of your message. You are using a 3.22.32 server -
so, sorry, but you're out of luck
On Mon, May 07, 2001 at 07:21:59AM -0700, [EMAIL PROTECTED] wrote:
Hi all,
I've started using MySQL for the first time and I'm hvaing a bit of a problem with
defining an AUTO_INCREMENT column. I'm using ver 3.23.32 which I downloaded for
Linux and Win2k. I am having this problem on both
True.
The only thing that could be done is write a UDF (user-defined function),
which accepts a table and field name as parameters and somehow manages
to find the first unused ID in that table.. and hope it is atomic, too..
I don't think this is too easy to do, though :)
G'luck,
Peter
--
On Mon, Apr 16, 2001 at 07:54:56AM -0500, Jeff Holzfaster wrote:
Hi!
This query works: select date_format(date, "%W, %e %M %Y") as date from
table
This query doesn't: select concat(date_format(date, "%W, %e %M %Y"),"
",another) as time_of_day
I'm wondering if it is possible to use
On Fri, Apr 13, 2001 at 12:37:40PM +0200, Z_da_eXTaZie wrote:
I can make this query: select a from table.
I can count it: select count(a) from table.
I can select it: select distinct a from table.
But how can i count it?
select count(distinct a) from table doesn't works
It works for me
First, get a book on SQL. Read about joins in SELECT statements.
Then, if you still need a quick answer, try the following:
INSERT INTO table_c(name, score)
SELECT name, a.score - b.score
FROM table_a a
LEFT JOIN table_b b ON b.name = a.name;
Hope that helps.
G'luck,
Peter
--
No language
On Tue, Apr 10, 2001 at 12:48:26PM +0200, Guerin Damien wrote:
Hi,
How use CHECK constraint in a CREATE TABLE declaration ??
The language used is MySQL
Indeed, i try many attempt but no success... Somebody could help me ??
I try to do that :
create table Picsou (
name
It would be my guess that you're trying to store inet_aton()'s value
into a signed integer column, which is in the range of roughly -2G - 2G-1,
while inet_aton()'s result is unsigned, in the range 0 - 4G-1. Whenever
inet_aton() happens to return a value 2G-1, MySQL truncates it and stores
into
On Wed, Mar 21, 2001 at 05:07:59AM +0300, [EMAIL PROTECTED] wrote:
please tell me about this error:
Fatal error: Call to unsupported or undefined function mysql_pconnect() in
mainfile.php on line 17
or
Fatal error: Call to unsupported or undefined function mysql_pconnect() in
On Tue, Mar 20, 2001 at 03:44:44PM -0800, Marcus Ouimet wrote:
I went into my database today and noticed that there was 102,000 entries.
Somehow a whole pile of crap was added to the end of the database. I think
it can easily be fixed but am not sure. Is there a way that I can eliminate
On Tue, Mar 20, 2001 at 03:12:39PM -0600, Jeff Jones wrote:
I am using mysqld_multi to have several different mysql servers start. I have
finally gotten it to work with php when I connect to a non-standard socket,
such as /tmp/mysql.sock2. Does anyone know how to connect to a database with
On Tue, Mar 20, 2001 at 11:55:59AM -0500, [EMAIL PROTECTED] wrote:
Hello
I am looking for help how to put gziped plain data file to mysql DB
and then get it from there.
Every time I try OUTFILE to file and then gzip -d file name I got file corrupted
Any help will be appreciated
Are you sure
On Mon, Mar 19, 2001 at 12:22:09PM +0100, - = k o l i s k o = - wrote:
Hi!
I have a problem. I would like copy one row from table1 to
another table2. How could I do?
I tried something like this:
insert into table2 values (select * from table1 where username = '$uname')
both (table1
On Fri, Feb 02, 2001 at 03:38:09PM -0500, Noah Romer wrote:
mysql insert into bugs_activity (bug_id,who,when,field,oldvalue,newvalue)
values (334,18,20010131145149,'bug_status','NEW','RESOLVED');
ERROR 1064: You have an error in your SQL syntax near
'when,field,oldvalue,newvalue) values
On Mon, Jan 29, 2001 at 01:30:57PM +0100, Tim Samshuijzen wrote:
Hello,
I have just deleted thousands of records but the file
is still the same size as before. How do I make the
file compact? i.e. how do I get rid of all the "empty
spaces" in the table?
Look at the MySQL manual.
On Sat, Jan 27, 2001 at 09:58:23AM -0600, Thomas Katsampes wrote:
Hello,
I'm trying to figure out the correct syntax for requesting
the database to
remove all records older than 14 days. The mysql query that
I am using (from within
php4) is:
//---update news so only last two weeks of
On Tue, Jan 23, 2001 at 11:19:20AM +0100, Gustav Wiberg wrote:
Hi
Why can't I do like this?
insert into tbnamn (fornamn, efternamn) values('g1','g2','g3','g4');
where fornamn and efternamn is the only fields in the table tbnamn
Try:
insert into tbnamn (fornamn, efternamn) values
I believe Tomi Junnila meant you should try without the comma..
UPDATE users SET visits=visits+1WHERE ...
(no comma before WHERE)
G'luck,
Peter
--
I am jealous of the first word in this sentence.
On Tue, Jan 23, 2001 at 06:27:22PM +0800, Jamie wrote:
I've been trying a variety of things
On Tue, Jan 23, 2001 at 05:39:47PM +0100, Sander Pilon wrote:
Okay, here's one for the guru's out there :)
I have a list of entries with unique id numbers X, and a set of sort methods
(S1 ... Sy).
Now, if I want to get an entry at position P (0...z) in the list of
entries ordered by
36 matches
Mail list logo
