Retrieving table and field a foreign key references

Hello, I am having trouble finding a way to retrieve the table and field a foreign key references by querying MySQL. If you look at the following example tables, there is no way after the tables are created to learn that: - address.sid actually references state.id Is this possible ? For

Re: libexec/mysqld: unknown option '--skip-bdb'

Jörg, thanks again for your help and your patience with this issue. You also caught oversights with strace and clarified that this is not a PATH issue. I've filed it at: http://bugs.mysql.com/bug.php?id=53667 You don't state it explicitly, but I take your text to mean If the MySQL tools are

libexec/mysqld: unknown option '--skip-bdb'

Hello, I am trying to produce an automated, reliable, and repeatable way of testing mysql releases, and I am finding an error that makes this impossible to accomplish. I am trying to compile mysql and install it in a non-standard directory. I do notwant mysql installed in /usr or /usr/local. For

Re: libexec/mysqld: unknown option '--skip-bdb'

On Fri, 2010-05-14 at 10:28 +0200, Joerg Bruehe wrote: The following error just won't go away: 100513 21:53:35 [ERROR] /tmp/msource/libexec/mysqld: unknown option '--skip-bdb' ... even after I manually search for the location where this flag is passed, and manually edit that source

Re: libexec/mysqld: unknown option '--skip-bdb'

Joerg, thanks again for the help. I disagree with you. I doubt many more users try to create a clean test installation of MySQL, in a specific directory, on a machine that already has MySQL installed. Correct - but if really the occurrence in mysql_install_db were the issue, then it

Re: libexec/mysqld: unknown option '--skip-bdb'

Do not install software in /tmp in Linux. /tmp is not guaranteed to survive a reboot. Thank you for the heads up. Well... there is *another* bug where if one specifies in their my.cnf filepaths that are over 100 characters, the filenames are truncated at 100, hence making it impossible to really

Updating my address book

Hi Can you please enter your contact details in my address book. Click on the link below: http://www.bebo.com/fr1/10232728a484122677b143804761c521525170d20 After we are connected, in the future, any changes you make in your contact details will be sent to me. Thanks for your help. Kris

help with SQL (join?) query

3 My desired output would look like: groupid groupname owner creator 1 test1john john 2 test2john jim 3 test3jim mary I was unable to find an example online.. Can anyone help? Thanks, Kris

Re: help with SQL (join?) query

test2 jim mary I just want the output from the groups table but a name instead of the number where creator# and owner# in groups table is associated to the uid in users. Hope this helps understand my problem.. Thanks Kris Peter Valdemar Mørch

select help - multiple where/limits

= 'features' order by published_date desc limit 5) etc... many thanks kris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Query Optimization

has 50x the number of rows and I'm concerned about trying to go live with it. If anyone could suggest ways to improve the query/table structure, I'd be most grateful. Kris SELECT i.image_id, i.image_name FROM table_image i LEFT JOIN table_story s USING (mainpic_id) WHERE s.mainpic_id IS NULL

Re: Query Optimization [sorted]

50x the number of rows and I'm concerned about trying to go live with it. Went back to the manual and realised that the table wasn't properly indexed. Makes a *big* difference! Sorry to waste your time/bandwidth. Kris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

query reference help

that it's something to do with the ON clause, but i don't understand what's wrong. many thanks kris -- kris burford midtempo ltd http://www.midtempo.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: query reference help

+ '[/img]%' what you're looking for? unfortunately not. i'd tried this without success and even set up some dummy text in a story with *just* the [img]myimage.jpg[/img] text. still doesn't find it... kris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Aggregate functions

? Kris Simonis OGD Software - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e

Hardware Help.

of hardware i need to be looking at to reach these levels of performance. Kris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request

PHP4 and MySql.

Hi, I am currently running PHP3 and would like to upgrade to PHP4 and lastest version of MySql. I am kinda new at this was wondering if somone could guide me in the right direction. Do I need to do a complete install of both? Kris __ Do You

Re: segmentation fault

Maybe it's about time you stopped being a fuckwit and read the whole message dip shit. file://Kris -Original Message- From: Gerald Clark [EMAIL PROTECTED] To: Breughel Macabuhay [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Thursday, 12 July 2001 12:36 Subject: Re

Query Slowness

. there is ~8.5 million records in it though. Anyone know howto speed this up? Kind Regards Kris Amy

Re: Query Slowness

yes i search on phone number. it's indexed(7) and the format of the phone data is (XX) . is there anyway this could be optimized. I will eventually remove the spaces and the first 4 characters from the input data and reload it in Kris Amy -Original Message- From: Don Read

RE; mysql user connections.

anyone know howto get mysql to allow multiple connections to a user? i'm trying to get a db working also using php4 but when someone is searching the db someone else can't query it. (it's http://virtuozo.hn.org/wp/ ) Kind Regards kris Amy

database directory permissions (unix)

is there any way to (config file or something) to preset what a database directory's permissions are when it is created (i want the database's directory to have permissions of 755 for a program that i'm writing, but it appears to default to 700)... i know i can write a script to perform this

saving database during os changeover

I'm going to be switching from my OS from Linux to Solaris and was wondering what steps I would need to take to save my tables during the OS conversion and restore them once it is complete. Is it as simple as tarballing the /var/lib/mysql directory and extracting it into the new OS, or is the

Re: Referer Count

yet another argument for sub-selects :) Paul DuBois wrote: At 2:31 PM -0800 3/22/01, Daren Cotter wrote: I have a table, which keeps track of member information (including which member referred the member). To get a count of the # of referrals for member 25, my query is: SELECT

Re: Outer and left join definition

bob... your example does not appear to work for me. maybe i'm missing something? i created two tables simply as: create table test1 values (id int); create table test2 values (id int); and populated them with some matching and non-matching data. however, when i run the query:

null value function

i remember coming across the mysql equivalent of the oracle nvl() function which will substitute in the case of a returned null value, but i can't seem to locate the command now...anyone know what it is? thanks! - Before

Re: null value function

nevermind...found it...ifnull() thanks anyway! Kris Gonzalez wrote: i remember coming across the mysql equivalent of the oracle nvl() function which will substitute in the case of a returned null value, but i can't seem to locate the command now...anyone know what it is? thanks

quota's ?

to limit other things like cpu usage or memory usage ? Thnx. Kris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread

change in user info requires restart

when adding a new user or changing the authentication information for existing users, the changes often do not take effect unless i take down and restart 'mysqld'. example: changing root's password and exiting the mysql client, i cannot log back in to the mysql client using the new

[Fwd: SCRIPTS IN DIFFERENTS DATABASES]

you can also use expect...such as: #!/path_to_binary/expect spawn mysql -u root -p expect "password:" send "password\r" expect "mysql" send "use db1" expect "mysql" send "alter table ...\r" expect "mysql" send "exit\r" expect eof also, since expect uses the tcl language, you could create a

Virtual Domains ?

Hi. Does mySQL have support for virtual domains ? And if so, how can i set it up ? (relevant documentation, ...) Kris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com