Hi Andy
What you can do is make a "copy" of your genre_titles table through
aliasing, this will allow you to only return the results that have both
genres and should reduce the need for programmatical sorting - aliasing also
makes for less typing :).
SELECT a.name, b.titleid
FROM titles a, genre_
On Mon, 13 Oct 2003 21:01:37 -0700
Matt Young <[EMAIL PROTECTED]> wrote:
> The manual says:
>
> " For example, if the library is installed in `/usr/local/mysql/lib', use
> -L/usr/local/mysql/lib -lmysqlclient -lz on the link command. "
>
> But I found no z library?
you need libz.
run these com
I dont know about going in, but i wonder if there is an extension module to
do this for you. I currently have to use a class i built to extra the xml
from a query in php :\
> Is it possible to direct xml support for queryiing a SQL statement and
> get the result in also in xml?
>
> Prasad
>
>
>
>
Is it possible to direct xml support for queryiing a SQL statement and
get the result in also in xml?
Prasad
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
The manual says:
" For example, if the library is installed in `/usr/local/mysql/lib', use
-L/usr/local/mysql/lib -lmysqlclient -lz on the link command. "
But I found no z library?
Matt Young
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
It works on small tables fine. However when entries grow somewhere over 20 000 it
stops (a rough estimate, did not test for
the exact number). When I have for say 80 000 and have a select returning 2 000
entries it still doesn't work right.
I don't quite understand the "cardinality" value, at l
Timotius Alfa wrote:
Pls help me guys.
what's wrong with this command ?
select a.siswa_id,a.nama,b.Nilai from Query_DataSiswa a left join ( select siswa_id,Nilai,Tes_Id from Nilai_Harian where tes_id = 1 and pertemuan = 1 and paket_id = 1 and tingkat = 1) b on a.siswa_id = b.siswa_id where a.p
Pls help me guys.
what's wrong with this command ?
select a.siswa_id,a.nama,b.Nilai from Query_DataSiswa a left join ( select
siswa_id,Nilai,Tes_Id from Nilai_Harian where tes_id = 1 and pertemuan = 1 and
paket_id = 1 and tingkat = 1) b on a.siswa_id = b.siswa_id where a.paket_id = 1 and
a
The Uscript concept is worth a short look.
Recently I discussed a new lightweight middleware for the web called Uscript.
I have the system up and running with help and information pages at
http://12.234.12.151/cgi-bin
my home computer. I will try to keep the system up during the day for those
I am running mysql through a pipe with flags
-s -n -R -r
which works fine except a pipe read hangs when there is no data for a query. I
tried many things, nothing works.
Running on Linux with version 3.23,53
Thanks
Matt Young
--
MySQL General Mailing List
For list archives: http://lists.mys
Hi,
I have three tables, a title's table, a genre's table and a genre_titles map
table (to model the many to many relationship between genre's and title's).
I need to write a query that will return title's that match two or more
genre's. An example would be one title could be a comedy/drama and I
[EMAIL PROTECTED] wrote:
how to delete rows which table1.field=table2.field
thanks
delete t1 from t1,t2 where t1.field=t2.field
at least, that's how I read the manual. Works for me.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.
At 1:25 +0200 10/14/03, Mikhail Entaltsev wrote:
Hi,
Do you use version 4 or 3?
I am using version 4.0.14.
I thought that I need to use
"set-variable = timezone = CST" for it to work under MySQL 3.
MySQL docs:
"...set-variable = variable=value
This is equivalent to --set-variable variable=valu
Hi,
> Do you use version 4 or 3?
I am using version 4.0.14.
> I thought that I need to use
> "set-variable = timezone = CST" for it to work under MySQL 3.
MySQL docs:
"...set-variable = variable=value
This is equivalent to --set-variable variable=value on the command-line.
Please note that --se
As an interesting note... I recently moved one of my legacy databases from
SQLSVER7 onto my production mySQL server.
It took 10min.
Well, ok, maybe a bit longer... but my buddy, wonderful godlike java geneous
that he is wrote an applet that will move all the data over from SS7 to
mySQL without h
cppaddict wrote:
Hi,
I'm just starting out with mysql and would like to know if there are any good
database diagramming and development tools for mysql. Something that would
allow me to create a db and all the relationships graphically and then have the
sql code automatically produced. Ideally
Hi Randy,
Unique keys are not disabled with DISABLE KEYS -- so the unique
constraint isn't violated. From
http://www.mysql.com/doc/en/ALTER_TABLE.html
"ALTER TABLE ... DISABLE KEYS makes MySQL to stop updating *non-unique*
indexes for MyISAM table."
Matt
- Original Message -
From: "Ra
Hi Peter,
I don't know what your multiple languages are, but remember that
full-text indexing doesn't currently work with multi-byte character
sets.
Anyway, the "built in" stopword list is in the myisam/ft_static.c file
of the source code. This is mentioned in the manual for SHOW VARIABLES:
http:
On 13 Oct 2003 at 16:59, Adam Clauss wrote:
> Well the issue wasn't so much with my program at runtime, but at
> design time (now). What I am doing is hardcoding the string that
> creates the table into the program. Program then calls SHOW CREATE
> TABLE and compares the two strings to see if th
Well the issue wasn't so much with my program at runtime, but at design time
(now). What I am doing is hardcoding the string that creates the table into
the program. Program then calls SHOW CREATE TABLE and compares the two
strings to see if they are the same. If not, it drops and recreates.
Wh
Stephan -
First, change to the root user on the Linux computer:
su -
And hit RETURN. Enter the root password when prompted. Then type
mysql
And hit RETURN. You should get into mysql then. Type
use mysql;
And hit RETURN.
Then type
GRANT ALL on *.* to [EMAIL PROTECTED] IDENTIFIED BY 'yourpas
"Robert Morgan" <[EMAIL PROTECTED]> wrote:
>
> Hi, I'm populating a dropdown with table names so the user can then choose the table
> he/she wishes to
> edit. However I just want to show the lookup tables. I tried "show tables from DB
> where table like 'lkp' ;"
> but got an error; I'm just won
Hi:
Do you use version 4 or 3? I thought that I need to use
"set-variable = timezone = CST" for it to work under MySQL 3.
Also, does anybody know if "CST" is recognized? Or do I have to use GMT-6 or
something like that?
Thanks for your time and help.
King regards,
Juan Antonio
- Original
Your ulimit -a output shows 256 max processes; mysql threads each
count as one process. If you're wondering why you get 245 and not
256, perhaps some of the kernel threads take up the remaining slots.
If you're wondering why you can't get 500 threads, have you tried
doing a "ulimit -u 500" before
At 14:48 -0500 10/13/03, Adam Clauss wrote:
I'm currently writing a program that will make use of the SHOW CREATE TABLE
statement to verify that existing tables are correct (if not, it drops them
and recreates). Why is it though that the SHOW CREATE TABLE statement
returns the answer on multiple l
You are not entering the right password.
If you did NOT set a password for root, then leave the -p option off.
Stephan Wölfel wrote:
When I start MySQL with "mysql -u root -p" I get again the error 1045
("Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)".
What am I doing wrong ?
-
When I start MySQL with "mysql -u root -p" I get again the error 1045
("Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)".
What am I doing wrong ?
- Original Message -
From: "gerald_clark" <[EMAIL PROTECTED]>
To: "Stephan Wölfel" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
I'm currently writing a program that will make use of the SHOW CREATE TABLE
statement to verify that existing tables are correct (if not, it drops them
and recreates). Why is it though that the SHOW CREATE TABLE statement
returns the answer on multiple lines? Why not just one line? And is it
pos
Hi, I'm populating a dropdown with table names so the user can then choose the table
he/she wishes to
edit. However I just want to show the lookup tables. I tried "show tables from DB
where table like 'lkp' ;"
but got an error; I'm just wondering whether it can be done using show tables or
whet
* dan orlic
> How, in a sql script, do I gracefully fail an insert? For example, I
> insert a record that has an primary key of 1, and it already exists. I
> want my script to
> Move down to the next record, not fail out. Thanks!
See the IGNORE option of the INSERT statement:
http://www.mysql.
# if using perl and DBI pseudo code
die $ERROR if ($dbh->errstr() && $dbh->errstr() !~ /Duplicate Error/);
If $dbh->errstr() =~ /Duplicate Error/
do your specified logic
Else
Return inserted id
- Dathan Vance Pattishall
- Sr. Programmer and mySQL DBA for FriendFinder Inc.
- http://fr
At 13:44 -0500 10/13/03, dan orlic wrote:
How, in a sql script, do I gracefully fail an insert? For example, I
insert a record that has an primary key of 1, and it already exists. I
want my script to
Move down to the next record, not fail out. Thanks!
If you're executing the script with the mysq
How, in a sql script, do I gracefully fail an insert? For example, I
insert a record that has an primary key of 1, and it already exists. I
want my script to
Move down to the next record, not fail out. Thanks!
dan
Thank you!!!
It works.
Hector
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, October 13, 2003 1:44 PM
To: Personal
Cc: [EMAIL PROTECTED]
Subject: Re: SELECT DISTINCT question
SELECT D
http://www.mysql.com/doc/en/DELETE.html
and from that page:
DELETE t1,t2 FROM t1,t2,t3 WHERE t1.id=t2.id AND t2.id=t3.id
or
DELETE FROM t1,t2 USING t1,t2,t3 WHERE t1.id=t2.id AND t2.id=t3.id
In the above case we delete matching rows just from tables t1 and t2.
>From MySQL 4.0, you can specify m
SELECT DISTINCT(LEFT (product_number,5)) FROM products.
http://www.mysql.com/doc/en/String_functions.html
hth
Jeff
Personal
Bonjour Frédéric,
Ce liste est en anglais. Je crois que tu veux http://www.vbmysql.com . Mais le
site est en anglais. Il y a beaucoup de exemples de VB 6 et VB .net sur ce site.
En plus il existe un liste français à (mais il y a récemment beaucoup de silence) :
Liens utiles :
Poster un m
Hello everybody:
I have the following scenario:
I have a database of products, each of those products have a product number
(like 04543000). Now the first five digits represent the product number, and
the 2 following digits represent a differet color for the same product.
Would that be are there mySQL drivers for use on packet pcs with VB?
- Original Message -
From: scr informatiques
To: [EMAIL PROTECTED]
Sent: Monday, October 13, 2003 4:57 PM
Subject: connexion avec un pocket pc
bonjour,
nous souhaitons que des utilisateurs m
bonjour,
nous souhaitons que des utilisateurs munient de pocket pc puissent accéder à une base de donnée mysql stocké sur un serveur en nos locaux. Pour cela nous souhaitons envoyé une commande à partir de Visual Basic (embedded). Existe-t-il des commandes adapter pour cela ?
Merci
F
how to delete rows which table1.field=table2.field
thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
At 17:56 +0200 10/13/03, Director General: NEFACOMP wrote:
Thank you for the answer but it seems you didn't understand my question.
The question is clear.
The answer is "you cannot do that" and the reason is "because MySQL's
access control system doesn't work that way." There is the concept of
us
Stephan Wölfel wrote:
Thanks for the advise.
However I have some additional questions:
ad 2) How can I check the grant privileges ?
ad 3) How can I "run this as the mysql root user" ?
mysql -u root -p
enter the root password you set when you installed mysql
use mysql
enter the grant command.
---
Thank you for the answer but it seems you didn't understand my question.
I was not asking about windows users.
I may reformulate my question as follows:
1. suppose you have a database that will be accessed by both students and
their teachers for different works
2. you understand that students have
Hi,
I am using these lines in my.cnf at [mysqld_safe] section.
[mysqld_safe]
timezone = GMT
It works fine for me.
Best regards,
Mikhail.
- Original Message -
From: "Juan Antonio Ruiz Zwollo" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, October 13, 2003 5:38 PM
Subject: Se
Hi.
I am trying to change the timezone for MySQL (version 3.23.56) but it does
not seem to work.
Currently the timezone is set to "MDT" (I think its the default for MySQL).
I added the following line to /etc/my.cnf at the [mysqld] section:
set-variable = timezone=CST
But when I try to stop an
Stephan -
Gerald posted good instructions for doing proper privileges, but: Login
as root, and execute this command:
GRANT ALL ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY 'yourpassword';
This will apply permissions for user stw from host 127.0.0.1. You'll
need a password to login. Run:
mysql -u
Thanks for the advise.
However I have some additional questions:
ad 2) How can I check the grant privileges ?
ad 3) How can I "run this as the mysql root user" ?
- Original Message -
From: "gerald_clark" <[EMAIL PROTECTED]>
To: "Stephan Wölfel" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
S
Hi Jim,
thanks for the advise.
What you tell all works. But even after this I still get the same error 1045
when typing "grant all on *.* to stw". Why ?
Stephan
- Original Message -
From: "James Cradock" <[EMAIL PROTECTED]>
To: "Stephan Wölfel" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Hi,
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Nitin" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Monday, October 13, 2003 5:52 AM
Subject: Re: Views in MYSQL
> What about when the script uses persistent connections, these Temp
Tables
> would never go aw
I'm not clear on this. What happens to duplicates under the following
scenario?
MyISAM table with either (or both!) a primary key or a unique index.
Alter table my_table disable keys.
Import 200K records.
Alter table my_table enable keys.
But it turns out there are duplicate records. Does MySQL a
1. The command is not properly formed.
2. You don't have grant privileges.
3. Run this as the mysql root user.
Stephan Wölfel wrote:
When I try to execute "grant all on *.* to stw" where stw is my user name, I get an error
1045 ("Access denied for user: '@127.0.0.1' (Using password: NO).
Is there
Stephan -
Connect to MySQL via a shell or command-line, change to the mysql
database with
use mysql;
...then query the user table:
select * from user
Also, to connect to the database server as a specific user, you'll need
to enter
mysql -u stw
or
mysql -u stw -p
...if you specified a pas
When I try to execute "grant all on *.* to stw" where stw is my user name, I get an
error 1045 ("Access denied for user: '@127.0.0.1' (Using password: NO).
Is there a way to check for user datas ? Or how to resolve this problem ?
Stephan Wölfel
A group_id cannot be both 1 AND 3, but it can be 1 OR 3.
Try OR
Jouni Hartikainen wrote:
Hi.
> how about:
>
> select record.*
> from link
> where group_id='x'
> left join record on record.archive_id=link.archive_id
> ?
The problem with this query is that with simple left join, I can
search on
That wouldn't work because for example:
GMT day for 2003-10-13 = '2003-10-13'
EDT day for 2003-10-13 = GMT '2003-10-12 20:00:00 -> 2003-10-13
20:00:00'
I want the GROUP BY (adjusted to EDT) to show 2003-10-13, but it shows
2003-10-12 know what I mean?
I don't know how to work around this...
Hi! I'm going to use the fulltext index in an multilingual product and need to
modify/translate the stopword list. According to the documentation:
"The stopword list can be loaded from the file specified by the ft_stopword_file
variable. See section 4.5.7.4 SHOW VARIABLES. Rebuild your FULLTEXT
At 02:55 PM 10/11/2003, cppaddict wrote:
Hi,
I'm just starting out with mysql and would like to know if there are any good
database diagramming and development tools for mysql. Something that would
allow me to create a db and all the relationships graphically and then
have the
sql code automati
-p without the passwd immediately following is not compatible with
input redirection.
Either add the password after the -p with NO space, or better yet,
create a .my.cnf file in the home directory of the user running the script
and have it contain the user and password settings.
Victor Spång Arthur
Hi Group,
I am wondering whether MySQL is planning to implement Group based privileges.
To make my question clear, consider a database where some users are not allowed to
update data and other are allowed to update. Will it be possible to create a group
that has got some privileges and whenever
Hello,
I'm experimenting with a large table (currently 9.7 M rows / 500 MB disk
space) that stores measuring results and I sometimes (!) get slow
queries for no good reason. The table looks like this:
++
| values |
++
| int (11)
Hello,
I would like to examine with as much detail as possible the following
aspects of my queries:
- Hows the total execution time distributed between disk reads / writes
and cpu / memory usage?
- Hows the total execution time distributed between index search and
actually reading data?
- Among
did you install your debian with "bf24" option??? it´s a kernel 2.4
instalation... in my debian woody 4.0 is very goodmysql 4.0 is ok!
BOA SORTE!!!
---
Gustavo Polillo Correa - Analista de Sistemas
Instituto de Biociencias - USP
Sao Paul
Hi There,
i tried to load a big file into a MySQL table using LOAD DATA LOCAL INFILE ...
Everything worked fine but after about 2 hours it say:
Lost connection to MySQL- server during query
The server was allwaiys up and I don't have a clue what happend.
I thought, that maybe our intranet was do
then who said, you cant delete temporary tables
Nitin
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Nitin" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Monday, October 13, 2003 3:22 PM
Subject: Re: Views in MYSQL
> Hi
>
>
> - Original Message -
> Fro
Hi
- Original Message -
From: "Nitin" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, October 13, 2003 10:42 AM
Subject: Re: Views in MYSQL
> I'm not talking about storing data into temporary tables for ever, but for
> the better accessibility inside the s
I'm not talking about storing data into temporary tables for ever, but for
the better accessibility inside the scripts. As anyway after the connection
to your MySQL server is closed, temporary tables no more remain there. So
you can just use those tables from within a single script, to help you mak
Victor Sp?ng Arthursson <[EMAIL PROTECTED]> wrote:
> Hi!
>
> I'm having a strange problem - I can't read data using the
>
>mysql -u root -p database
> Not getting any error message, but some kind of introduction text
> flashes by reading:
>
>
> [powerbook:~] victor% /usr/local/mys
Dicky 'Mas Saint' wrote:
Hi !
Does anybody have experience running MySQL with OpenMosix ?
How is the performance increase ?
Thank you.
According to this paper:
http://cedar.intel.com/cgi-bin/ids.dll/content/content.jsp?cntKey=Generic+Editorial%3a%3axeon_openmosix&cntType=IDS_EDITORIAL&catCode=BMB
Sorry for wrong answer, actually, that's the behavior of oracle query cache,
so I guessed it would be same for MySQL too. I sincerely apologize for any
inconvenience caused.
Nitin
- Original Message -
From: "Dan Nelson" <[EMAIL PROTECTED]>
To: "Nitin" <[EMAIL PROTECTED]>
Cc: "Reto Bauman
if you are using mysql on web (which is the most possible case, as MySQL is
created to be used on web), you can use your scripts to create tamporary
tables and use them as views. else you can write procedures for that
purpose, depending on your need.
Nitin
- Original Message -
From: "Tim
Hi Jordan
Have had a look at the date input page, and the source code that it produces
looks fine. If you still haven't sorted it out could I suggest the
following:
Output the tenure date at the following points in the application:
1) When it is returned by the input form.
2) When it is returned
Hi!
I'm having a strange problem - I can't read data using the
mysql -u root -p database
Not getting any error message, but some kind of introduction text
flashes by reading:
[powerbook:~] victor% /usr/local/mysql/bin/mysql -u root -p *** databas
< /path/to/tabell.sql
/usr/local/mysql/b
73 matches
Mail list logo
