Jonas Lind?n <[EMAIL PROTECTED]> wrote:
>
> Is it possible to grant access to individual rows in a table in MySQL?
No, MySQL doesn't support row level grants. In general you can use VIEWs to do that
(VIEWs are currently being implemented in MySQL).
--
For technical support contracts, goto htt
Hi Joshua,
First thing I'd try is upgrading to 4.1.1! And/or 4.1.2 when it's
released in a couple weeks.
Matt
- Original Message -
From: "Joshua Thomas"
Sent: Monday, March 29, 2004 10:51 AM
Subject: mysqld keeps crashing
> Hello all,
>
> I'm running mysql 4.1.0-alpha-log on FreeBSD
On Mon, Mar 29, 2004 at 08:44:28PM -0800, Gene H. Dreher wrote:
I seem to have locked myself out of my database. RH8/4.0.18-standard
... the key user does not have file/reload/etc access. and no access
at all to database mysql..
Is there some way to break this down as system root or is the only
s
Hi Scott,
> Is there any way to define a column in MySql 4 that is to be unique from
> this point forward. Meaning, there are indeed dupes in the column now,
> those are ok, there is really no repairing that damage as the data was
> inherited from somewhere else. I am constantly having to selec
Is there any way to define a column in MySql 4 that is to be unique from
this point forward. Meaning, there are indeed dupes in the column now,
those are ok, there is really no repairing that damage as the data was
inherited from somewhere else. I am constantly having to select the column
to see
Hi,
I asked yesterday about how to get swedish vocals (åäö)when using *load
data local infile "file.txt" into table* syntax.
The file.txt is written with swedish vocals and saved in unicode format,
the OS is Windows 2k and the mysql version is 4.0.18-max-debug. The vocals
are replaced with other si
I currently run this, which is 2 hits to the database.
Select serial from blacklist where serial = '23'
Select serial from seriallist where serial = '23'
I only desire to know if either of the 2 has at least one row, I am only
testing for existence here. Is there some way I can get around 2 que
Is it possible to grant access to individual rows in a table in MySQL?
regards
/Jonas
We like it on Netware 6.5, with memory equal to 10 times the size of
your largest DB. ie; DB=100mb RAM=1gb. Fastest proc you can afford.
>>> "Chad Attermann" <[EMAIL PROTECTED]> 3/29/04 1:56:05 PM >>>
Hello All,
I have been a MySQL user for some time and have always run MySQL on
older generati
This is correct, the index is not packed. Also, exactly the same
behavior can be observed if "GROUP BY" is used instead of "DISTINCT" -
if this makes my case any clearer. The table gets checked for
consistensy and optimized every hour.
I wonder if any members of MySQL development crew could she
I seem to have locked myself out of my database. RH8/4.0.18-standard ... the key user
does not have file/reload/etc access. and no access at all to database mysql..
Is there some way to break this down as system root or is the only solution to delete
the whole thing and re-install it?
--
MyS
Hi,
MySQL 4+ can use indexes for ORDER BY ... DESC (3.23 can only in some
cases) in every case that ASC can. However, reading a packed index in
reverse order is slower. I don't think your index is packed, though, if
it's a date-type column, unless you've specified PACK_KEYS in your
CREATE TABLE.
I am a personal user who just downloaded the version
4.0 and
mysql
> administrator. The first time I clicked on the
> "Administrator" icon
> on my desktop I get an error that says "failed
to start because
> msvcr70.dll was not found. Try to reinstall. I
did remove the
> program a
Chris,
I would consider loading this script only once and establishing a single
connection to the DB server and then making it loop with a time delay
waiting for data to be inserted into the DB - that's pretty much what it
does, right?
The thing is that if you invoke the script every time you
The timing is consistent both ways - have tried both queries back-to-back
alternatively many times. I'm pretty sure that it is not caching that causes the
discrepancy.
So, this turns out to be a known issue after all... Somehow I missed it. Thanks, Donny!
Vadim.
- Original Message -
Personally, it's an unexpected flaw that I hope one day will be fixed. But
I'm not holding my breath, even though they seem to be planning for it. But
it could also be because of query-cache.
To benchmark something like this, you really need to add SQL_NO_CACHE to
your select statement to get ac
Chris,
You would have to send the table structures including any indexes and also
the real queries.
It would also help if you would send an explain on your select statements.
100+ a minute is not much, I have one server currently doing:
Queries per second avg: 3157.235
Yes, that's per second, n
Hi all,
Just noticed that a simple query that returns only 14 rows is 10X slower
when "ORDER .. DESC" is used compared to "ORDER .. ASC".
The table has about 700,000 records, indexed on the field the table is
being ordered by.
Is this expected behavior?
MySQL 4.0.18 running under OpenBSD 3.4
Hi Guys,
Iv got a script that iv been working on written in perl which interfaces to
mysql via the dbi module..
The script only does two selects within the entire script, so I didn't think
it would be too taxing on the machine.
Turns out that when the script is executed around 100 times a minute
Dear Friends
then in compiling MyODBC (3.51.06)...
Making all in samples
make[1]: Entering directory `/storage/MySQL/src/MyODBC-3.51.06/samples'
source='my_basics.c' object='my_basics.o' libtool=no \
depfile='.deps/my_basics.Po' tmpdepfile='.deps/my_basics.TPo' \
depmode=gcc3 /bin/sh
Is it possible to query a tmp table that mysql creates automatically when
dealing with large queries?
When I do a 'show processlist' and it gives a state of 'Copying to tmp
table' , is there a way to query or access this tmp table to see the status
of the query?
Im thinking this would give me an
Ken Elder writes:
>Today I experimented on two computers. One consistently got the error
>message; the other consistently did not get the error message. Both
>computers were Win98SE with IE6.0. Their Win 98 and IE settings were
>identical (except for trivial stuff like home page and mouse contro
I'm trying to set up two-way replication between our colo and our office
(slow DSL line), so our web customers can get the fast speeds of our
colo, and the people in the office can also get the fast speeds of our
internal network.
Since our colo machine is logging customer shopping cart info (etc.
SQL gurus:
A few days ago we went live with a PHP/MySQL site. One of the pages
requires entry of a username and password. If a corresponding record is
found in the password table, the next page appears.
The authentication technique we used was a session variable. For most
users, but not all, t
Hi there,
I have a hard question, don't know if its possible to solve my query.
I have set up two tables like this
Table1:
softid (integer) (unique)
nameofcd (string)
softid| nameofcd
1test cd 1
2utils cd 1
3test cd 2
4b
Yes. We do something like this to build packages from a local install.
./configure --prefix=/usr/local/mysql-4.018
make
make test
make DESTDIR=${HOME}/build/mysql/pkg install
Adaikalavan Ramasamy wrote:
Dear all,
Is it possible to install mysql locally on Sun Solaris 8 as I do not have
root perm
SCSI, 15,000 RPM drives and a decent amount of memory 2-16 gigs. Dual procs
definitely do help; we have tried it with dual procs with hyperthreading and
without and with hyperthreading seems to be much faster.
Besides that, you can run it on any OS; we use Fedora, with Linux 2.6.x.
But that's o
Hello All,
I have been a MySQL user for some time and have always run MySQL on older generation
Sun servers running Solaris 8. I now seem to be outgrowing my setup and I (and I'm
sure others on the list) would appreciate input from the MySQL community as to which
hardware, OS, and MySQL flavor
How would I do this?
Let say I have an employee table with
Name varchar(64)
Dept int(11);
Salary int(11);
I want to grant select on Salary to a mysql user but only where dept = 1 let's say.
Normally I would create a view to do something like this.
But I was wondering if there would be anoth
It has come to my attention that we have maxed out our keys due to a stupid
update script bug. It seemst that we've not been explicitly naming our keys
and therefore mysql tried to be helpful and adds a new key each time!
*sigh*.
Is there a SQL command to DROP ALL keys on a table, so I can just AL
Thanks to all who helped me out. It seems I missed an essential AND
statement in my query. Including it brought me from 32 seconds to about 1-2
seconds and all seems to be doing fairly well. I'm a little concerned at
this point for the work I'm asking the hardware to do.
The server currently deal
That would work, BUT, I'm looking for a way that I don't have to change the
code in the application when I change the structure of the table. If I add
a column, I want its value copied to the new record, but don't want to have
to change the application to do so.
Your query requires me to alter th
THAT WORKED! Thanks - that was too easy!
Andrea
--- Kevin Carlson <[EMAIL PROTECTED]> wrote:
> Try this (untested) :
>
> update table set column=LEFT(column,
> LENGTH(column)-1)
>
>
>
> Andrea Broerman wrote:
>
> >I have successfully loaded data from a comma
> separated
> >file (CSV) into a
Try this (untested) :
update table set column=LEFT(column, LENGTH(column)-1)
Andrea Broerman wrote:
I have successfully loaded data from a comma separated
file (CSV) into a table, but the last field in each
record appears to have a little square symbol at the
end of the text which I assume is
http://www.geocrawler.com/archives/3/8/2002/11/50/10245455/
Kyle
- Original Message -
From: "Jeffrey Horner" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, March 29, 2004 12:05 PM
Subject: Creating index on very large table
> Hi folks,
>
> I've got a problem creating an index
I am running in Windows.
--- dan orlic <[EMAIL PROTECTED]> wrote:
> sounds like the difference between a windows system
> and a linux
> system. If you are doing the
> load on a linux system, a simple dos2unix
> should set you
> straight.
>
> dan
>
> Andrea Broerman wrote:
>
> >I have succes
No, no, no, no need to make it that complicated! :-)
If your table has the columns col1, col2, col3, col4, etc, and col1 is the
autoincrement column, and you want to duplicate the entire table, something
like this should work:
INSERT INTO t1(col2, col3, col4, ...)
SELECT col2, col3, col4, ... FRO
sounds like the difference between a windows system and a linux
system. If you are doing the
load on a linux system, a simple dos2unix should set you
straight.
dan
Andrea Broerman wrote:
I have successfully loaded data from a comma separated
file (CSV) into a table, but the last field in ea
I have successfully loaded data from a comma separated
file (CSV) into a table, but the last field in each
record appears to have a little square symbol at the
end of the text which I assume is either an end of
line or new line symbol. Is there a way to get rid of
that? How can I run the load dat
Views would be nice. :)
That idea sounds like it would work in a single-user envrinoment, which I'm
not. I agree, messy.
I'll just write a function to build a field list from a specified table
leaving out the AUTO_INCREMENT field...I can then do something like this:
SQL = "INSERT INTO tbl_name(
Oh, if only there were views!! That would make this easy. Maybe soon
(*please*). :)
Another approach (more cumbersome) might be to insert the rows you need to
duplicate into a temporary table, update the id_col adding max(id_col) from
the original table to each, and then to insert from the tempora
There is only 1 table. I want to replicate a record in a table except the
AUTO_INCREMENT column.
Your solution would work, but I'd prefer to not have to maintain a list of
columns in the application. Worst case I'll have the application generate
the query based on the table definition, but I was
Can you roughly outline the schema of the two tables?
If the key value doesn't have to match from the input to the final result,
you can always insert into a list of fields, skipping the auto_increment/key
column, and they will continue to be generated..
Assuming you have two tables with id_col,
I had same problem. I fixed it by adding/adjusting the
myisam_max_sort_file_size and myisam_max_extra_sort_file_size variables in
my.cnf to much larger values.
I adjust it to 4096M in my case (data = 35 Gb, index = 2.1 Gb ) and the
indexes go much faster. On similar box my index creation takes a
I have a table with just about 100 columns, and I would like to duplicate a
row exactly, except for one column, which is the AUTO_INCREMENT column.
Using 'INSERT INTO tbl_name SELECT * FROM tbl_name WHERE id_col = 1' doesn't
work, because it produces the following error: 'ERROR 1062: Duplicate ent
i have a table this is 50 Million, has 10 indexs, some are on varchar's
disk space is 34 GB for the MYD, and 6.5 GB for the MYI. Granted I have
a pretty old box, 2x660 Mhz P3's, and a RAID array good for about 25-30
MBs, it took me when the DB as at 42 million records about 28 hours to
reindex
No, this is a production system. I can't risk running non-production level
software.
I could try 4.1.1 on my development system but, even if it worked, I still
couldn't put that solution into place on the production server.
Jack
-Original Message-
From: dan [mailto:[EMAIL PROTECTED]
Sen
Hello Jeffrey,
Monday, March 29, 2004, 7:05:27 PM, you wrote:
JH> I've got a problem creating an index on a MYISAM table with 302,000,000 lines,
JH> roughly 58 GB on disk. Attached you will find the table definition, output
JH> of "mysqladmin variables", and "mysql -e 'show status'".
JH> and it'
Hi folks,
I've got a problem creating an index on a MYISAM table with 302,000,000 lines,
roughly 58 GB on disk. Attached you will find the table definition, output
of "mysqladmin variables", and "mysql -e 'show status'".
After creating the above-mentioned table, I ran:
ALTER TABLE test_table ENA
Mark,
Thank you. I subscribe to both lists as my system uses Tomcat (sometimes
Jetty) and MySQL with Servlets to do it's work. However, you were the
first person to reply!
Thanks for the answer - even if it is from the "wrong" list! :-)
Cheers,
-Richard
Mark Matthews wrote:
-BEGIN PGP S
just out of curiousity,
have you tried the 4.1.1 version?
there may (or may not) be something from 4.1.0 to 4.1.1
could be a total waste of time, but you never know.
Dan.
On Mon, 29 Mar 2004, Jack Coxen wrote:
> A quick update on this.
>
> I tried upgrading to the latest production MySQL - 4.0
A quick update on this.
I tried upgrading to the latest production MySQL - 4.0.18 - with no change.
So, if it's a bug, it's an unreported and uncorrected bug.
Also, I tried the query against different size tables. If I try the query
against ifInOctets_35, the index works. If I try it against i
Victoria,
The seleect statements that I wrote is what I use.
And if there was a limit should the limit be used in both o f my select?
Database changed
mysql> SELECT @@session.sql_select_limit;
++
| @@session.sql_select_limit |
++
|
Hello all,
I'm running mysql 4.1.0-alpha-log on FreeBSD 5.1, with InnoDB.
In the last month, I've had a number crashes, and table corruption. My
application is a website of medium volume, and the database is not more than
a few hundred MB. The errors I recieve are almost all signal 11 errors.
He
Try "MySQL/PHP Database applications" by Jay Greenspan and Brad Bulger.
It's a great buy and gets into a lot of the practical applications you'll be
doing a lot of coding for.
At 13:41 3/28/2004, A Mathias wrote:
>Preferably one that is for begginers to medium and thats covers both
mySQL
>and
I already specified the version, 4.1.1. My problem query is this,
SELECT Item
FROM StoredProc
GROUP BY Item
HAVING (First(User)="Gus");
my StoredProc query is a simple one,
SELECT Item, Op, User
FROM tblSource
ORDER BY Item, Op;
Any Thoughts?
Thanks
>>> "Nitin Mehta" <[EMAIL PROTECTED]
"Jayme Jeffman Filho" <[EMAIL PROTECTED]> wrote:
> I've got an unespected behavior using MySQL server-version 3.23.52 with PHP
> 4.3.0 (Apache/1.3.27 (Win32) PHP/4.3.0 running... ), if I submit an update
> query that do not modify any value on the target record the query does not
> return any row a
Hi,
Does anyone know of the fastest way to get the size of a single table row in
bytes?
Im currently using the following query: (this query takes 7 seconds which is
not efficient).
SELECT
SUM(LENGTH(CONTACT(view_stat_id,account_id,project_id,contact_id,timestamp))
) as size FROM table1 WHERE acc
"Nestor" <[EMAIL PROTECTED]> wrote:
> I send this last week and no one commented.
Nestor, I've already asked you check value of sql_select_limit variable:
SELECT @@session.sql_select_limit;
Is "SELECT * FROM course_eng" exact query that you use?
> Has anyone run into this simmilar proble
I am by no means an accomplished MySQL user, and generally deal with rather
simple queries having no need for anything particularly complex, until now.
I have been working on a query this past week which has tested my abilities
and when all is said and done, the query creates a rather hefty load o
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Richard S. Huntrods wrote:
> I need to access a specific directory from within tomcat, but I'm having
> a specific problem and require some advice.
>
> I have a link to a file in the servlet, something like
> "https://myserver.com/special-directory/fi
Scott Haneda wrote:
Wonder if there is a more efficient way of dealing with the following...
I have a user table and a serial_numbers table
User table has name, address, state, zip etc
Serial_numbers table has a id and a serial number.
Client wants a "hitlist" that shows the user data and the as
Tom?? P?ral <[EMAIL PROTECTED]> wrote:
> Hi,
> I want to store data in czech in mysql 4.0.18. I use property
> default-character-set=czech set in my.ini on localhost and all run well.
> But my hosting provider don't allow me to set this property on the
> server level :-), I can change it only
- Original Message -
From: "Egor Egorov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, March 29, 2004 3:54 PM
Subject: Re: replication in mysql5 between linux and windows
> Jonas Lind?n <[EMAIL PROTECTED]> wrote:
> > Hello list, I have successfully installed mysql5 on my win
I've got an unespected behavior using MySQL server-version 3.23.52 with PHP
4.3.0 (Apache/1.3.27 (Win32) PHP/4.3.0 running... ), if I submit an update
query that do not modify any value on the target record the query does not
return any row affected, while the same query executed in a C++ program
r
Jonas Lind?n <[EMAIL PROTECTED]> wrote:
> Hello list, I have successfully installed mysql5 on my windows box and my aim is set
> on replicating my mysql5 linux system. I think I am on the right track and the
> systems seem to talk to eachother according to my logs. My problem is that nothing
> i
Hello buddy,
try installing
MySQL-shared-compat for your platform
HTH
Nitin
- Original Message -
From: "Timothy Venn" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, March 29, 2004 7:13 PM
Subject: Libmysqlclient.so.14 on Solaris 2.8 (SPARC)
> Hello,
>
> Please can someon
Hello,
Please can someone tell me where I can get / compile the
libmysqlclient.so.14 file for Solaris 2.8 (SPARC) as an
application that I am installing requires this library file ?
Regards
Tim
South Africa
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http:/
Earlier on, I thought I could use rand () as follows:
SELECT rand () FROM Products LIMIT 2;
_
0.2036000.
0.125689..
2 rows
Your suggestion worked ok.
Thanks Alex
Ursprüngliche Nachricht-
Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Gesendet: Monta
"B. Fongo" <[EMAIL PROTECTED]> wrote on 29/03/2004 13:54:54:
> Does MySQL provide a way of selecting a limited number of rows at
> random? From a query that might return several rows, I want MySQL to
> return six rows at random at each time.
>
> For instance:
>
> Select * from [table] wher
I (a total newbie on sql) try to populate my tables by "load data local"
-syntax from a text file (saved in ANSI-coding) with swedish characters
(vocals å ä ö), but "select * from table" reveals that swedish vocals are
replaced by other signs.
If I load "manually" by "insert into table values"-synt
Does MySQL provide a way of selecting a limited number of rows at
random? From a query that might return several rows, I want MySQL to
return six rows at random at each time.
For instance:
Select * from [table] where [condition];
200 rows (0.0 sec)
Now - I need 6 rows at random.
Than
Hi *,
I got 2 statement of query which is related to each other but I am confused
whether I can join them into 1 statement
The first one is:
select A.CustId, max(B.InvoiceNum) as InvoiceNum
from Customer A, CustomerInvoice B
where A.CustId=B.CustId and A.CustStatus='AC' group by A.CustId
Hi,
I want to store data in czech in mysql 4.0.18. I use property
default-character-set=czech set in my.ini on localhost and all run well.
But my hosting provider don't allow me to set this property on the
server level :-), I can change it only on connection or database level.
I tried 'alter
Hello list, I have successfully installed mysql5 on my windows box and my aim is set
on replicating my mysql5 linux system. I think I am on the right track and the systems
seem to talk to eachother according to my logs. My problem is that nothing is
replicated in my databases but I think that th
Hi,
I want to combine to result-sets with 'union', but I don't know how to get the
'group by' right. I tried it like the example with 'order by' but that
doesn't work.
So I want to get something like:
(select * from tab1) union (select * from tab2) group by column
How can I get this to work wit
please include the query, you are using with no success and also specify the
version of your mysql.
Nitin
- Original Message -
From: "Ed Reed" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, March 29, 2004 1:27 PM
Subject: Access to MySQL query problem
> I'm coverting an Acc
I'm coverting an Access database to MySQL 4.1.1 and I need help with a
near impossible query. In the Access DB I used a stored procedure; I
think I should be able to solve this problem with a subselect in MySQL
but so far I'm not having any luck.
Here's the problem; In my stored precedure query I
78 matches
Mail list logo
