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 exam
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
>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
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,
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 edi
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
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
jim
3 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
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
sc limit 5) and
(section = '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]
e site has 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://l
live site 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
..LIKE '%[img]' + i.image_name + '[/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 Li
stories (which i *know* exist).
i'm guessing 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]
ng
from the documentation?
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 <[EMAI
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
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
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
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
ch the
database. there is ~8.5 million records in it though.
Anyone know howto speed this up?
Kind Regards
Kris Amy
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
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 oper
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 pro
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:
> >
> >SE
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:
s
did you read the bottom of your own eMail? there's a link to unsubscribe appended
to every mail on this list!
-kg
alain siani wrote:
> I would like to unsubscribe of this list!!! Help me please !
>
> My address : [EMAIL PROTECTED]
>
> --
> Alain Siani
> (query,mysql)
>
> --
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
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 postin
amit
you will need to install MyODBC (available from www.mysql.com) and install that...you
could then access it from VB6 as you would access any other ODBC data source, from MS
Access to SQL Server to Oracle.
-kg
Amit wrote:
> Dear Sir,
>
> This a mail from a new established software com
sible 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 t
you can also use expect...such as:
#!//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 tcl list wit
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
password...i
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
33 matches
Mail list logo
