ve_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:Pet
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
>
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 offic
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 where id1 is not null; ?
>
> - Original Message -
> From: "Graeme B. Davis" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTE
urs, I guess you 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
>
> &
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
> -
> id1044NUL
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 l
On Mon, May 21, 2001 at 03:58:10PM +0200, Viktor van den Berg wrote:
>
> Hi!
>
> I like to know how to retrieve the record id after an "insert into" query.
> I have the table "user" containing two columns: UID (auto_increment) and
> USERNAME. After I have added a new user (using "insert into u
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 clie
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
> e
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
>
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
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 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 withou
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,
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 -
>
ocs to mean
> the first form was correct, perhaps it could be clarified)
> One way or the other, this doesn't solve my probem ;)
>
> Thanks for the feedback so far.
>
> -Bill
>
> Peter Pentchev wrote:
> >
> > On Wed, May 09, 2001 at 09:20:52AM -0400, Bill Mora
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
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
On Mon, May 07, 2001 at 04:08:53PM +0300, Halil TAS wrote:
> I Installed redhat 7.1 and Mysql. And use mysql_install_db and know when i
> use mysqladmin -u root -h myhostname -p password 'mypassword' take a error
> message. It's began Can't connect to MySQL server on ... (111) and i didn't
> see
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
--
Hey,
On Thu, May 03, 2001 at 08:01:11AM -0400, Marc Bragg wrote:
> Hi:
>
> Installed redhat 7.0 and had multiple mysql problems, but php4 from the
> disc seemed fine. Updated mysql to 3.23.37, now it works fine, but "php"
> gives me:
>
> PHP Warning: Unable to load dynamic library '/usr/lib/php4/mysq
On Tue, Apr 24, 2001 at 10:01:50AM -0700, Alan Halls wrote:
> Hi,
> Ok, it is a little off the Mysql topic but I need to know something and I
> know
> someone out there can help. I need to do a search on a UNIX box using either
> egrep or another command that will search for all occurances of a l
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
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 f
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 (
> nam
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 ca
On Tue, Apr 10, 2001 at 02:32:30AM -0500, Tim Thorburn wrote:
> Hello,
>
> After playing around for a few days in between real work, I got my new
> linux box up and running with RedHat 7.0 and MySQL 3.23.33 (the version the
> hosting company we use supports). My problem is that I know what pas
First off, I don't think you should use 'date' as a column name; isn't it
a reserved word?
Then, hmm.. is that column a DATE column, or DATETIME, or TIMESTAMP?
If it is DATETIME or TIMESTAMP, then you don't really need the DATE_FORMAT()
conversion; compaing a DATETIME or TIMESTAMP value directly
On Mon, Apr 02, 2001 at 10:33:48AM +0100, M. Verheijen wrote:
> Hay Iham,
> Should be there on www.mysql.com
[snip]
> >>> Mohamad Ilhami <[EMAIL PROTECTED]> 02-04-01 09:35 >>>
>
> Hi,
> I can't find MySQL 3.23.37. Please tellme where I can dl it. Where is the
> really latest release?
Uh. www.m
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 wit
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 eliminat
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
>./
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 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
On Mon, Mar 19, 2001 at 12:51:27PM +0100, - = k o l i s k o = - wrote:
> Hi!
>
> i try one little question.
>
> when the table2 have one more row then table1.. is possible try something
> like this:
>
> insert into table2 ($date, select * from table1 where username = '$uname')
One more 'column
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
On Fri, Mar 02, 2001 at 11:30:31AM -0500, Terry Babbey wrote:
> Here is my configure statement and the generated error message ( I am using
> GCC2.95.2):
>
> CC="gcc" CXX="gcc" ./configure --prefix=/usr/local/mysql
Have you tried CXX="g++"? The C++ compiler of the GNU Compiler Suite
is g++, you
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 w
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 ... S).
>
> Now, if I want to get an entry at position P (0...) in the list of
> entries ordered by
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 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
45 matches
Mail list logo