Dominique:
Thanks for your suggestions/ideas. After playing with it for a little while
longer of banging my head into a brick wall, I realized I was using a left
join when I needed a right. You have my table structures pretty much down -
here's the final SQL statement that I use to return 1 row
Hi,
Am Donnerstag, 5. Februar 2004 03:43 schrieb Scott Haneda:
> on 02/04/2004 02:23 AM, Bernd Tannenbaum at [EMAIL PROTECTED]
>
> wrote:
> > 2 possible ways to go:
> >
> > Feed a Textfile with your statement in the db:
> > PATH/mysql db < /sql_scripts/sql_statements_as_textfile --password=pass
>
Hi,
I am new to mysql & managed to do the mysql replication, that works fine.
Now can this whole process be automated.
For example:
1) Asume that more that 2 mysql servers can be used for the replication,
like A->B->C
A--master
B,C -- Slaves to A
2) Also in the scenario 1 is it possible to mak
Philip Walden wrote:
Michael Stassen wrote:
You need supp_cd to be first in an index. Try
ALTER TABLE hpi_supp_agmt ADD INDEX supp_ind (supp_cd);
then try to add your foreign key constraint again.
Michael
Looks like that does not work. BTW this does work (without adding a
separate index) in
Hi,
Thanks for the info!
I am already able to debug the server startup.
I would like it to stop
at someother point, perhaps a point where a SELECT statement is executed
for example..
Thanks!
-Original Message-
From: Miguel Angel Solorzano [mailto:[EMAIL PROTECTED]
Sent: Thursday, Febru
I have a database with one 17GB table containing about 23 million customer records.
The table has about 15 fields. I wanna index five of them to speed up searching.
My indexing operation keeps failing with error:127 (record table has crashed).
The process fails of different fields at different
At 01:31 5/2/2004, Ananth Raghuraman wrote:
Hi,
Hi all,
I am not part of the official MySql team. I am just a lone developer.
I tried debugging MySql source (server) in Visual C++, but it doesn't
seem to work. I followed the instructions in the MySql manual and
added a few breakpoints at a few ran
Hi all,
I am not part of the official MySql team. I am just a lone developer.
I tried debugging MySql source (server) in Visual C++, but it doesn't
seem to work. I followed the instructions in the MySql manual and
added a few breakpoints at a few random places, but the debugger
never stopped ther
I have a site where members rate movies they've seen. I run a routine to
recommend 5 titles based on movies they've given a max 5 rating. It's
very slow, and I think a better MySQL query can speed it up. I'm running
MySQL 3.23.54.
Tables:
movies (unique id plus movie info)
subcats (movie id, subca
Sergei,
Any chance of getting a ft_dump Windows binary in the distribution? :-)
Regards,
Matt
- Original Message -
From: "Sergei Golubchik"
Sent: Monday, February 02, 2004 11:33 AM
Subject: Re: query the data of a fulltext index directly from index?
> Hi!
>
> On Feb 02, Alexander Ba
Hi David,
ALTER TABLE table ADD ListingID MEDIUMINT UNSIGNED NOT NULL
AUTO_INCREMENT PRIMARY KEY FIRST;
That will add the column at the beginning of the table (first column).
Remove "FIRST" from the end if you don't want that (it will then go at
the end) or replace it with: AFTER some_other_colum
Hi,
- Original Message -
From: <[EMAIL PROTECTED]>
Sent: Wednesday, February 04, 2004 12:12 PM
Subject: Server Behavior.
> Seeking opinions on this.
>
> Server is Dual Pentium Xeon 2.8, 6 GB RAM, running RedHat Linux 7.2,
> MySQL 4.0.17, all installed and tested with no problems.
>
> I h
on 02/04/2004 02:23 AM, Bernd Tannenbaum at [EMAIL PROTECTED]
wrote:
> 2 possible ways to go:
>
> Feed a Textfile with your statement in the db:
> PATH/mysql db < /sql_scripts/sql_statements_as_textfile --password=pass
>
> Give command directly In the shell-script:
> PATH/mysql --skip-column-nam
Hi,
Is it posssible to specific the max file size allowed for mysql database?
Thanks,
Keng Heng. Chan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello
I am going thru the source code of MySQL client.
I am not able to understand in general how MySQL is
handling unicode characters. All the function take
(char*) as arguments?
Is it expecting all the data to be UTF8-encoded and
before executing the queries (i was looking into the
batch file
Michael Stassen wrote:
You need supp_cd to be first in an index. Try
ALTER TABLE hpi_supp_agmt ADD INDEX supp_ind (supp_cd);
then try to add your foreign key constraint again.
Michael
Looks like that does not work. BTW this does work (without adding a
separate index) in postgres.
mysql> alt
On 4 Feb 2004, at 20:32, Dan Muey wrote:
We are implementing three or four MySql servers (as a start)
and I'm writing the Troubleshooting Guide for our operational
staff. None of these folks have any MySQL experience (and
I'm a newbie myself). I need a pretty basic 'Cheat Sheet' for
troubleshooti
Hallo,
I am in the process of setting up a simple replication and have a
question that I can't figure out from the docs.
I have 2 servers, N1 is a test machine and hosts 2 databases "live" and
"test". N1 is a slave to N2 which is a production machine and primary
host of "live".
Basically I want
I am using 3 different systems...
Each have a registration system...
I believe they all use md5 to encrypt the password.
Is it possible to just put as the "value" of the password record something like this:
dbname.dbtablename
So that it will be that value, instead of one that is inserted into th
> Thanks,
No problem, but please post to the list and not just
me so we can all learn and share.
Also top posting is bad form, just FYI.
>
> I have been perusing the web site, but the manuals don't
> always give reasons WHY you would run something. For example
http://www.mysql.com/doc/en/FL
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wednesday 04 February 2004 16:03, mos wrote:
> At 09:35 AM 2/4/2004, John Croson wrote:
> >I have a simple query:
> >
> >SELECT id,year,month,day,cat_id FROM events
> >LEFT JOIN calendar_cat ON
> >events.cat=calendar_cat.cat_id
> >WHERE year>=YEAR(C
Try setting the basedir=
parameter in your my.cnf file.
>> Original Message <<
On 2/4/04, 3:32:26 PM, Michael Satterwhite <[EMAIL PROTECTED]> wrote
regarding Starting MySQL 4.1:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
> I've reinstalled MySQL 4.1. I'm
Here is my final analysis of this problem. May it be correct or not, mysql
is no longer panicing the child process..
libgcc was either corrupt or incompatible. It was the original version so
I lean towards corrupt. Whatever corrupted it, I have no idea what, mysql
was PISSED off about it. What
At 09:35 AM 2/4/2004, John Croson wrote:
I have a simple query:
SELECT id,year,month,day,cat_id FROM events
LEFT JOIN calendar_cat ON
events.cat=calendar_cat.cat_id
WHERE year>=YEAR(CURDATE())
AND month>=MONTH(CURDATE())
AND day>=DAYOFMONTH(CURDATE())
AND cat_id='2' OR cat_id='5'
AND approved='1'
Hi Sergei!
Great news. Thanks very much! :-)
Matt
- Original Message -
From: "Sergei Golubchik"
Sent: Tuesday, February 03, 2004 1:54 PM
Subject: Re: query the data of a fulltext index directly from index?
> Hi!
>
> On Feb 02, Matt W wrote:
> > Sergei,
> >
> > Any chance of getting a
I may have resolved the crashing issue...
I upgraded gcc and libgcc, as well as bintools and cpp for dependancy
issues... the child PID no longer crashes... possible that the libgcc was
corrupt? im stracing the pid now and it does not exit as before. no more
constant respawning. I will enable
I have two MySQL databases that are networked together. If changes can be
made independently to each of the databases - what is the best way to
synchronize them? How can I synchronize them in real time? If the network
link goes down, can the synchronizations be placed upon a queue until the
connect
All logging will grow very rapidly on a `busy` server. To enable all
logging you can add the --log option to the safe_mysqld command.
safe_mysqld --log
>> Original Message <<
On 2/4/04, 3:48:46 PM, Daniel Powell <[EMAIL PROTECTED]> wrote
regarding Re: Mysql ECHI
its pretty default. I'd like to enable all logging if possible. What
specificly should I enable in my.cnf?
On Wed, 4 Feb 2004 [EMAIL PROTECTED] wrote:
> If the server is up and running can you log in a perform a
> show variales from the mysql monitor. From this information you can learn
> whe
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I've reinstalled MySQL 4.1. I'm trying to start the server (mysqld_safe), but
it fails to start. The log file shows the message:
/usr/sbin/mysqld-max: Fatal error: Can't find messagefile
'/share/mysql/english/errmsg.sys'
The files exists, but the p
If the server is up and running can you log in a perform a
show variales from the mysql monitor. From this information you can learn
where your logs are being stored.
...
Also, what sort of logging are you currently performing? Are you logging
just errors , slow queries or everything?
...
It appears to be running with safe_mysqld
root 7237 1 0 14:26 pts/000:00:01 /bin/sh /usr/bin/safe_mysqld
--defaults-file=/etc/my.cnf
and locate *.err returns nothing.
On Wed, 4 Feb 2004 [EMAIL PROTECTED] wrote:
> A locate *.err returns nothing?
> What happens when you attempt
A locate *.err returns nothing?
What happens when you attempt to start MySQL with safe_mysqld?
>> Original Message <<
On 2/4/04, 3:04:54 PM, Daniel Powell <[EMAIL PROTECTED]> wrote
regarding Re: Mysql ECHILD resets on Queries:
> nothing of the sort. no .err file
This goes along with the PIDs
[EMAIL PROTECTED] mysql]# strace -p 20018
select(5, [3 4], NULL, NULL, NULL) = 1 (in [4])
fcntl64(4, F_SETFL, O_RDWR|O_NONBLOCK) = 0
accept(4, {sa_family=AF_UNIX, path="@¬@@è4@"}, [2]) = 5
fcntl64(4, F_SETFL, O_RDWR) = 0
getsockname(5, {sa_family=
Sorry for the OT,
I deleted the messages from the perosn who sent me a response offlist.
In response to his personal emails in reply to:
http://lists.mysql.com/mysql/158945
he said, Perl was a write only language
(meaning it is hard to read since careless
people may do sloppy code - not me tho
The hostname.err log will generally be located in the data directory.
>> Original Message <<
On 2/4/04, 2:42:02 PM, Daniel Powell <[EMAIL PROTECTED]> wrote
regarding Re: Mysql ECHILD resets on Queries:
> Where exactly SHOULD these be and is it something I need t
> We are implementing three or four MySql servers (as a start)
> and I'm writing the Troubleshooting Guide for our operational
> staff. None of these folks have any MySQL experience (and
> I'm a newbie myself). I need a pretty basic 'Cheat Sheet' for
> troubleshooting common production type pr
Where exactly SHOULD these be and is it something I need to enable in
my.cnf
the generic /var/log/mysqld.log has this each time the process dies:
Number of processes running now: 0
040203 22:21:08 mysqld restarted
Cannot initialize InnoDB as 'innodb_data_file_path' is not set.
If you do not wan
We are implementing three or four MySql servers (as a start) and I'm
writing the Troubleshooting Guide for our operational staff. None of
these folks have any MySQL experience (and I'm a newbie myself). I need
a pretty basic 'Cheat Sheet' for troubleshooting common production type
problems.
The s
Have you looked in the hostname.err logs for the MySQL server?
>> Original Message <<
On 2/4/04, 2:00:53 PM, Daniel Powell <[EMAIL PROTECTED]> wrote
regarding Mysql ECHILD resets on Queries:
> Ive got a machine running redhat 9 kernel 2.4.20-28.9 and a recent up
Ive got a machine running redhat 9 kernel 2.4.20-28.9 and a recent update
from APT seems to have destroyed mysql somehow.
Mysql Version is 3.23.58-1.9
Any query kills the child process of mysqld and it has to respawn. This
does not seem to be the proper behaviour and it is causing many issues
Hi,
> >> > When creating a stored procedure, what must I do to
> >> > create a procedure/function in a specific database?
> >> >
> >> > I created a function "hello" like in the example, but
> >> > afterwards, I cannot create it from another database
> >> > connection.
> >>
> >> Currently you can't
On Wed, Feb 04, 2004 at 07:21:30PM +, [EMAIL PROTECTED] wrote:
> The older system is choosing to use a different index. I would suggest
Any idea why it would choose this? Shouldn't mysql keep using the same
indexes?
> running an analyze on your new tables and see if you can get the newer
>
The older system is choosing to use a different index. I would suggest
running an analyze on your new tables and see if you can get the newer
system to use the same Postsindex8 index.
>> Original Message <<
On 2/4/04, 1:01:46 PM, Alan <[EMAIL PROTECTED]> wrote r
Hi folks. I'm in the midst of moving from a debian unstable system to a
gentoo system and I'm having some problems getting mysql to give me the
same performance. On the new gentoo system (with more hardware) a fairly
complex query (a search on a UBBThreads forum) is taking 10+ seconds to
complet
From: vincent.gueu [mailto:[EMAIL PROTECTED]
> I've installed mysql under Linux and what I do, I always have this
> number of error message :"040204".
> Please I need your help!
> Thank u
I have no idea what your problem is, but I'd be amused if you had the number "040205"
tomorrow (those
Are you able to start the MySQL server? Is there anything being logged to
the hostname.err log?
>> Original Message <<
On 2/3/04, 7:23:50 PM, "vincent.gueu" <[EMAIL PROTECTED]> wrote
regarding Mysql error message:
> I've installed mysql under Linux and what I
Mike Johnson wrote:
From: John Croson [mailto:[EMAIL PROTECTED]
I have a simple query:
SELECT id,year,month,day,cat_id FROM events
LEFT JOIN calendar_cat ON
events.cat=calendar_cat.cat_id
WHERE year>=YEAR(CURDATE())
AND month>=MONTH(CURDATE())
AND day>=DAYOFMONTH(CURDATE())
AND cat_id='2' OR cat
Seeking opinions on this.
Server is Dual Pentium Xeon 2.8, 6 GB RAM, running RedHat Linux 7.2,
MySQL 4.0.17, all installed and tested with no problems.
I had a small database for testing purposes, and then dropped it,
leaving the default installation databases, mysql and test.
If I run top from
I've installed mysql under Linux and what I do, I always have this
number of error message :"040204".
Please I need your help!
Thank u
Vinx
Accédez au courrier électronique de La Poste : www.laposte.net ;
3615 LAPOSTENET (0,34/mn) ; tél : 08 92 68 13 50 (0,34/mn)
--
MySQL General Mailin
Hi!
On Jan 12, Holm Tiffe wrote:
> >Description:
> mysqld 4.0.17 crash on FreeBSD 5.1-current-alpha
> >How-To-Repeat:
> Any acces over IP (not domain socket) crashes mysqld:
> #/usr/local/bin/mysqladmin: connect to server at 'install' failed
> error: 'Lost connection to MySQL server during q
i'm using this one : http://vsbabu.org/webdev/zopedev/ieeditor.html
but it works just on IE5.5 SP1 and above (IE6;)
- Original Message -
From: "fab" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, February 04, 2004 5:06 PM
Subject: wysiwyg web soft
> Hi to all,
>
> I'm fe
I understand that I need to update the db's cardinality for this table
I need speed
Should I run CHECK TABLE or ANALYZE TABLE or myismachk -a?? I need the quickest one
because with 56179085 records this could take a while...
Thanks for the replies
Rob
-Forwarded Message---
Hi!
On Jan 23, Dave Rolsky wrote:
> Here's a recipe:
>
> create table foo (foo text, bar text);
>
> create fulltext index foo on foo (foo, bar);
>
> mysql> show index from foo;
>
> +---++--+--+-+---+-+--++-
Hi to all,
I'm fed up with Access as a wysiwyg editor for mysql. Generaly, i'm fed
up with client that i have to install on each comp. Actualy, i'm looking
for an opensource wysiwyg web software. Something like the very good
phpMyAdmin but with 'visual' request editor for simple users.
If anyo
Did you run an ANALYZE TABLE?
>> Original Message <<
On 2/4/04, 9:33:30 AM, rmck <[EMAIL PROTECTED]> wrote regarding index
question:
> I ran an insert..select from one table to the other ( changed some column
types to int from varchar on new table).
> the inser
- Original Message -
From: "rmck" <[EMAIL PROTECTED]>
> Are my indexes all gone?? If so how do I recover them! Thanks
hehe ;-)
MySQL just doesn't know the cardinality of the indexes yet (the cardinality
number is a *guess*)
Try CHECK TABLE and I think you will see the cardinality num
- Original Message -
From: "rmck" <[EMAIL PROTECTED]>
> Are my indexes all gone?? If so how do I recover them! Thanks
hehe ;-)
MySQL just doesn't know the cardinality of the indexes yet (the cardinality
number is a *guess*)
Try CHECK TABLE and I think you will see the cardinality num
Hi John,
I think you missed on the precedence of AND/OR
if you change to
> AND (cat_id='2' OR cat_id='5' )
it should work as you want it to
/Johan
John Croson wrote:
I have a simple query:
SELECT id,year,month,day,cat_id FROM events
LEFT JOIN calendar_cat ON
events.cat=calendar_cat.cat_id
WHERE ye
"Martijn Tonies" <[EMAIL PROTECTED]> wrote:
> Hi,
>
>> > When creating a stored procedure, what must I do to
>> > create a procedure/function in a specific database?
>> >
>> > I created a function "hello" like in the example, but
>> > afterwards, I cannot create it from another database
>> > conne
From: John Croson [mailto:[EMAIL PROTECTED]
> I have a simple query:
>
> SELECT id,year,month,day,cat_id FROM events
> LEFT JOIN calendar_cat ON
> events.cat=calendar_cat.cat_id
> WHERE year>=YEAR(CURDATE())
> AND month>=MONTH(CURDATE())
> AND day>=DAYOFMONTH(CURDATE())
> AND cat_id='2' OR cat_id
"Pierre Luguern" <[EMAIL PROTECTED]> wrote:
>
> Ooops .. I think I have to be more precise about what I mean by
> replication.
>
> In facts the two servers A and B (in slave mode) have to replicate
> different tables included in the same database and I do not want to manage
> the replication thr
I have a simple query:
SELECT id,year,month,day,cat_id FROM events
LEFT JOIN calendar_cat ON
events.cat=calendar_cat.cat_id
WHERE year>=YEAR(CURDATE())
AND month>=MONTH(CURDATE())
AND day>=DAYOFMONTH(CURDATE())
AND cat_id='2' OR cat_id='5'
AND approved='1'
ORDER BY year,month,day ASC
Results:
+-
I ran an insert..select from one table to the other ( changed some column types to int
from varchar on new table).
the insert went fine.
mysql> INSERT INTO Feb04_int SELECT * from Feb04;
Query O
> Why not use another language that has mysql hooks built in?
Good suggestion.
> For example, from version 4.3.0 PHP comes with SAPI to allow
> scripting from the command line, ideal for cron style tasks
> and it's mysql support is very mature.
Or better yet, Perl. Not only is its mysql suppor
Hi,
> > When creating a stored procedure, what must I do to
> > create a procedure/function in a specific database?
> >
> > I created a function "hello" like in the example, but
> > afterwards, I cannot create it from another database
> > connection.
>
> Currently you can't create SP in the partic
"Martijn Tonies" <[EMAIL PROTECTED]> wrote:
>
> When creating a stored procedure, what must I do to
> create a procedure/function in a specific database?
>
> I created a function "hello" like in the example, but
> afterwards, I cannot create it from another database
> connection.
Currently you c
On 04-Feb-2004 Peter Lovatt wrote:
> hi
>
> it is very simple in php
>
> $query = 'SELECT *
$query="SELECT flds, you, want FROM ...
> $output .=
> "\"$row["somefield"]\"\t\"$row["some_other_field"]\"\t\"$row["yetnothe
> r_fiel
> d"]\"\t" ;
>
$output .=implode("\t", $ro
Hassan,
By Murphy's law, they WILL get corrupted if you don't have a
backup. You need a current backup, or you need an older
backup and a way to redo the updates.
That said, if you do a FLUSH TABLES after your update, then
corruption is unlikely--no more likely than for any other OS file.
After
Hi all,
>They are mostly windows-only tools!
>
>CowBoyNeal uses only mysql console client! jejeje :-) (just a joke!)
>
>PHPMyAdmin is a web based tool, very nice
>SQLyog is a basic, very nice tool also (www.sqlyog.com)
>DBTools is very very nice, and also support PostgreSQL
>(www.dbtools.com.br)
>
They are mostly windows-only tools!
CowBoyNeal uses only mysql console client! jejeje :-) (just a joke!)
PHPMyAdmin is a web based tool, very nice
SQLyog is a basic, very nice tool also (www.sqlyog.com)
DBTools is very very nice, and also support PostgreSQL
(www.dbtools.com.br)
MySQL-Front is ve
Why not use another language that has mysql hooks built in?
For example, from version 4.3.0 PHP comes with SAPI to allow scripting from
the command line, ideal for cron style tasks and it's mysql support is very
mature.
--
Russell.
--
MySQL General Mailing List
For list archives: http://lists
Dear all
How can I make a user defined function (written in C/C++) what returns a
row or rowset / result set (like "show open tables")
for example select udf(1,'par2') what returns
C1 | C2 | C3
+--+-
1 | 2 | A
2 | 3 | B
3 | 4 | C
Thanks Gergő
--
MySQL General Ma
Gowtham Jayaram <[EMAIL PROTECTED]> wrote:
>
> - Are there any benchmarks that provide information
> on time taken to run 'CHECK TABLE' and/or 'REPAIR
> TABLE' on tables of different sizes ?
You can run your own benchmarks and find out the statistics you need.
>
> - What are the factors tha
- Original Message -
From: "Luis Lebron" <[EMAIL PROTECTED]>
> The data tables look like this:
>
> Manhours
> mid | ProjectId |ChargeNum | Catid | Hours | EmployeeId
>
> 1 | 32 |11 | 19 | 80 |200020
> 2 | 32 |11 | 19 | 24
> |23
>
>
> Tasks
> TaskID |ChargeNum |Catid |Em
Ooops .. I think I have to be more precise about what I mean by
replication.
In facts the two servers A and B (in slave mode) have to replicate
different tables included in the same database and I do not want to manage
the replication through my application but only with the standard
replication
I just hacked out a script that will give me a month at a glance in MySql
3.x, I was thinking, there must be a way to do this in SQL.
Table
---
Name (varchar 48)
Date (timestamp 14)
Currently, I select distinct on the name to get all unique names, then I
iterate on each name and issue a count
Hi,
Am Mittwoch, 4. Februar 2004 07:19 schrieb Hassan Schroeder:
Scott Haneda wrote:
> I need to to the following
> Select serial from serials;
>
> Problem is I need to run this from a script which cron will call once a
> day, how do you pass a select statement to mysql with user and pass so it
>
On Jan 31, 2004, at 1:09 AM, Adam Goldstein wrote:
On Jan 30, 2004, at 10:25 AM, Bruce Dembecki wrote:
On Jan 28, 2004, at 12:01 PM, Bruce Dembecki wrote this wonderful
stuff:
So.. My tips for you:
1) Consider a switch to InnoDB, the performance hit was dramatic,
and it's
about SO much more
hi
it is very simple in php
$query = 'SELECT *
FROM table
WHERE somefield = "'.$somevalue.'"
ORDER BY somefield
';
$mysql_result = mysql_query($query, $mysql_link);
while($row = mysql_fetch_array($mysql_result))
{
$output .=
"\"$row["somefield"]\"\t\"$row["so
On Wednesday 04 February 2004 05:44, Scott Haneda wrote:
> I need to to the following
> Select serial from serials;
>
> Problem is I need to run this from a script which cron will call once a
> day, how do you pass a select statement to mysql with user and pass so it
> can all happen in one go?
my
Scott Haneda wrote:
I need to to the following
Select serial from serials;
Problem is I need to run this from a script which cron will call once a day,
how do you pass a select statement to mysql with user and pass so it can all
happen in one go?
Something like this should work:
#!/bin/bash
/path
Hi,
I hope someone can point us in the right direction.
We have built up a database of over 2 million part numbers applicable to the
horticultural machinery trade.
This is held on our website in a MySQL database and subscribers can do all sorts of
searches by manufacturer or part number or des
Hi,
Am Dienstag, 3. Februar 2004 22:50 schrieb Alex croes:
> I'm currently using MyCC as a tool to "view" and maintain a
> MySQL-database of mine.
> I find it quit a good tool, but which tool are you guys using. I have
> heard about MySQLfront
> and Navicat. Are this also good tools to maintain th
I need to to the following
Select serial from serials;
Problem is I need to run this from a script which cron will call once a day,
how do you pass a select statement to mysql with user and pass so it can all
happen in one go?
--
-
Scott
Hi all,
When creating a stored procedure, what must I do to
create a procedure/function in a specific database?
I created a function "hello" like in the example, but
afterwards, I cannot create it from another database
connection.
The column "db" stays NULL in table "procs".
Any idea?
With re
Hi Philip,
> > Hmmm..., it doesn't seem to be a problem for me in 4.0.17:
> >
> > mysql> CREATE TABLE t3
> > -> (
> > ->id CHAR(5) NOT NULL,
> > ->description VARCHAR(48) NOT NULL,
> > ->PRIMARY KEY (id)
> > -> ) TYPE = InnoDB;
> > Query OK, 0 rows aff
You need supp_cd to be first in an index. Try
ALTER TABLE hpi_supp_agmt ADD INDEX supp_ind (supp_cd);
then try to add your foreign key constraint again.
Michael
Philip Walden wrote:
Michael Stassen wrote:
Hmmm..., it doesn't seem to be a problem for me in 4.0.17:
mysql> CREATE TABLE t3
88 matches
Mail list logo
