>I think I figured the problem out, but I still do not understand
>what happened, the following is showing how I got the query to
>work. I basically had to re-import suppliersiclink table to get this
>to work right in MySQL 3.23.33, but why? The data was fine in
>MySQL 3.22.
>
>mysql> select * f
>I`m trying to find the best method to match records between two tables in a
>MySQL database. But it must match atleast once, so here is a scenario for you
>to think about.
>
>Member - Job, Salary, Location
>Jobs - Job, Salary, Location
>
>All values will be enum sets in both tables as follows
>
>
>hi,
>
>i'm writing a book (wrox publishers) which uses mysql for the sample
>database.
>i seem to have encountered a problem with an SQL query.
>its a simple voting application, with a candidate table, and a vote table:
>
>create table candidate (
>candidatenumber integer not null auto_increment,
>Quick searches of Google and the MySQL page didn't turn up anything,
>so I'll ask here..
>
>Here's what I have:
>I have a table that among others, have fields called 'section_id'
>and 'parent_id'. The section_id is the id of the "self" section, and
>the parent_id is the id of the section that
>Hello,
>
>I have the following query:
>"SELECT thara_plane.id,thara_plane.nam
>e,thara_plane.nick,thara_plane.bodytext,thara_category.category "
>."FROM thara_plane,thara_category,substring(thara_plane.bodytext,225) as
>bodytext "
>."WHERE ((thara_plane.category = thara_category.id)) "
>
>Hi,
>
>
>A few days ago, I asked the list about a SELECT statement. I
>received 2 replies that didn't really work but helped me think about
>the problem some more. In my database I have 4 tables. For this one
>query, I am matching up data from 3 of these tables and then
>displaying them on a
Hello All,
I've created a table(using MySQL 3.23.33), using default values:
DROP TABLE IF EXISTS referral;
CREATE TABLE referral (
refer_id int(10) UNSIGNED DEFAULT '100' NOT NULL,
refer_fname varchar(20) DEFAULT '' NOT NULL,
refer_lname varchar(20) DEFAULT '' NOT NULL,
refer_email varchar
This statement:
SELECT Drivers.DriverID, Drivers.FName, Drivers.LName FROM Teams INNER JOIN
TeamDetails ON Teams.TeamID = TeamDetails.TeamID INNER JOIN Drivers ON
TeamDetails.DriverID = Drivers.DriverID WHERE Teams.TeamID = 1
works fine when executing natively in MySQL (MySQL-Front).
But when I
I solved the problem by adding ln -s /tmp/mysql.sock
don't know why the link disappeared.
David
On Mon, 5 Mar 2001, Systems Administrator wrote:
> I was logged into my mysql and just kicking right along, then my telnet
> session got disconnected, I logged back on, and found defunct processes
>
Maybe someone can help me out with MySQL's commercial license.
If MySQL server has a GPL license and MySQL client libraries have LGPL licenses, how
can a paid commercial license be required for products that incorporate LGPL MySQL
client libraries and depend on the GPL MySQL server? Does this
I was logged into my mysql and just kicking right along, then my telnet
session got disconnected, I logged back on, and found defunct processes
from my last login. I removed those processes, and tried again, ERROR
2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock
a mysql SQL question
-
I am programming a TV guide script and I am getting stuck
1) Admin must be able to add tv listings to a database using a form at
http://1001cgi.hypermart.net/project1/admin2.html
Please IGNORE all the form fields above "Start date - (mm/dd/)"
Hey,
I have no idea why my "mysql' server keeps giving me ERROR 2000 no matter
what I type. I have checked the syntax not seems alright. Would you please
show me some light?
Thank you for you help!
Edith Wong
Chinese University of Hong Kong
Tel: 852-2609-6446
-
I have taken the binaries for DEC OSF (Alpha) [dec-osf5.1-alphaev6] for
Mysql-3.23.33 and also DEC OSF (Alpha) [dec-osf5.1-alphaev6] for Mysql-3.23.32 and
tried to get them up and running, yet they freeze on Installing all prepared tables.
It just hangs and no matter what I do it will not g
You might want to check to see if the server is still running, it could have
crashed and burned in which case you would get than error when trying to
connect.
ryan
> I was looking through my website and everything was fine and then all of a
> sudden I got this error:
>
> ERROR 2002: Can't connec
I never successful rollback if I compile mysql from source in RedHat 7.0, I
think it is the compile problem...
-Original Message-
From: Stephen Faustino [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 06, 2001 5:44 AM
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
Subject: RE: BDB tables
At 8:42 PM -0600 3/5/01, Cal Evans wrote:
>Rolf,
>
>Does REVOKE remove a user form the mysql.user database when all their
>permissions have been revoked? (That was my question really, I knew about
>REVOKE, just not it's operation.)
No, it doesn't. To do that, you must issue a DELETE FROM user WH
Rolf,
Does REVOKE remove a user form the mysql.user database when all their
permissions have been revoked? (That was my question really, I knew about
REVOKE, just not it's operation.)
TIA,
Cal
http://www.calevans.com
-Original Message-
From: Rolf Hopkins [mailto:[EMAIL PROTECTED]]
Sent
- Original Message -
From: "Cal Evans" <[EMAIL PROTECTED]>
To: "Jonathan Dugan" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, March 06, 2001 0:43
Subject: RE:
> Greetings Jonathan,
>
> There are a couple of ways that you can add a user. the best way is to
grant
> that user pe
At 15:59 05/03/2001 -0300, Clarissa Castellã wrote:
Olá,
Quando uma máquina cliente se conecta com o MySQL, um dos parâmetros
enviados para autenticação é o IP da máquina ou o DNS, então
acredito que o problema é que o Wingate está impedindo essa
autenticação, para resolver o problem verifica na d
I would think an UPDATE would suit you just fine.
UPDATE mytable SET price=price*1.21 WHERE ...
- Original Message -
From: "fano" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, March 05, 2001 23:01
Subject: multiple inserts
> Hello mysql,
>
> Hi, I have a table "Invoices",
I think what you may be looking for is something like
CREATE TABLE SELECT FROM
Look up the manual on this.
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, March 04, 2001 12:11
Subject: encrypting a column
> I have a column in my maildb table t
I would say that's because mysql thinks that "-" is subtraction and not a
hyphenation. You could try:
mysql> drop database 'planhouse-broke';
or delete the directory called 'planhouse-broke'.
and in future, I think you'll save yourself a lot of agro if you use
underscore instead.
O | O
\
> Was wonder if any knows of a Perl equivalent to the PHP's version of
> phpMyAdmin?? We use phpMyAdmin but have a project that server doesn't
> have PHP installed, and frankly, to lazy to do all the typing thru telnet
> session! :)
I'm currently comparing MySQLTool to phpMyAdmin.
http://dajoba.
I can answer numb 1. for you but not 2. Look up the manual for mysqldump
and load infile (or something like that, I have to check the manual myself
but I have no time to do that for you).
The other (and probably easier way) is to upgrade your Cobalt machine and
then upgrade your tables from ISM
Well, this is a public, international mailing list. I wouldn't be surprised if
there were more.
Seung-woo Nam
Quentin Bennett wrote:
> How come the list is receiving some today? (Raid de Himalaya, Summer of
> 2001, African American History Minute).
>
> Normally we don't get bothered with these.
> How do I add a new user?? How do permission work?? I've spent an hour
> now and I still get:
> ERROR 1044: Access denied for user: '@localhost' to database 'mysql'
It's all explained in the MySQL Manual:
http://www.mysql.com/documentation/index.html
Hi,
MySQL is distributed under GPL. That means it's free of charge.
You can find and download the current version of MySQL at
http://www.mysql.com/downloads/mysql-3.23.html
How ever, do ask that Commercial Users take out one of our many support
options to allow us
to pay for the continued dev
Does the socket file still exist? My guess is that it got deleted somehow.
Check for cron jobs or something else that may cause it to "disappear".
- Original Message -
From: "Marcus Ouimet" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, March 06, 2001 7:46
Subject: Error Out o
I've gotten thttpd compiled with php running phpMyAdmin beautifully, if you want a
small lightweight httpd to use phpMyAmin with. Ive done it with x86 linux, ppc linux,
and sparc64 linux.
Advanced authentication, everything works swell.
I do it with php-4.0.3pl1 with a patch to the php, but I
Anyone know the update about a mac myODBC driver?
I'm into Linux, but I do most designing on the Mac, and have been searching
for a myODBC driver!!
-
Before posting, please check:
http://www.mysql.com/manual.php (the manua
Daniel Pope wrote:
>
> Hello,
> I was using C API under mysql-3.22.32. and I was forced to reinstall the mysql servr.
> Unfotunately I found only the version 3.23.23.
> Thw big problem is that the same sources give me under Mysql C API 3.33.23 the
>following
> message link error:
> In function
On Mon, Mar 05, 2001 at 04:36:27PM -0500, John Tsangaris wrote:
>
> I am trying to install DBD::mysql on a server which does not have
> mysql on it. ( The script will be accessing a mysql database on
> another server). The problem is, when I try to install dbd::mysql I
> am asked several questio
On Mon, Mar 05, 2001 at 04:10:59PM -0600, Stephen Faustino wrote:
>
> show variables showed that have_bdb is no, and none of the bdb
> variables are there. So does this mean that BDB is NOT compiled
> into the binary included in the Linux RPM, or does it mean that I
> need to add the necesary BDB
How come the list is receiving some today? (Raid de Himalaya, Summer of
2001, African American History Minute).
Normally we don't get bothered with these.
Quentin Bennett
Transport Systems Division
Infinity Solutions
web http:\\www.infinity.co.nz
mailto:[EMAIL PROTECTED]
Phone : +64 9 358 9720
You must have at least the mysql client libraries installed to use
DBD::mysql.
-jm
-Original Message-
From: John Tsangaris [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 05, 2001 1:36 PM
To: mysql
Subject: DBD::mysql
I am trying to install DBD::mysql on a server which does not have mys
Since the intention of fsync and fdatasync seems to be
to write dirty fs buffers to persistent storage (i.e.
the "oxide") then the best time is not necessarily
the objective. Given the IDE times that people have
been reporting, it is very unlikely that any of those
IDE disks were really doing 200
On Mon, 5 Mar 2001 21:50:42 +
Pierre-Alain Joye <[EMAIL PROTECTED]> wrote:
> > create table root(
> > create table subcats(
> > create table subsections(
>
> And now I need 230 levels, huh :).
>
> How about a simple tree structure ?
If our thinking of a tree structure is the same, I believ
Right now I am running mysql on couple dual processor sparc ultra-80s.
Since mysql is using solaris threads the mysql daemon is running
in a single process with lightweight threads for each connection.
So mysql can only run on one of the processors.
Is it advisable to try to compile mysql using p
As far I can tell, you have to rebuild from source.
BDB works very bad for me (linuxppc). Extremely slow and errors.
Christian.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.m
I was looking through my website and everything was fine and then all of a
sudden I got this error:
ERROR 2002: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (111)
It was working fine, and now for some reason won't connect? Any suggestions
how to fix this and why it would
hello there,
i am a novice, so bear with this rather trivial question.
how do i turn off the column-headers for select statements in mysql??
couldn't find any help with the online manual.
waiting.
praveen
-
Befor
After install a new proxy (wingate) here I couldn't connect to mysql server remote
in any client machine, only in the machine were is the proxy. Mysql returns error
10065. I tryed to find the error description at the manual and at the site, but I
didn´t find. What is error 10065? The person w
Hello,
I was using C API under mysql-3.22.32. and I was forced to reinstall the mysql servr.
Unfotunately I found only the version 3.23.23.
Thw big problem is that the same sources give me under Mysql C API 3.33.23 the
following
message link error:
In function my_compres_alloc my_compress. o (
To all adventure motorcyclists
First I know that a lot of you didn't request information from me and if
you would prefer not to hear from me again please reply to this mail with
unsubscribe in the subject field and you will be removed from this list.
For those of you who are interested in taking p
Hi,
Your main problem will be in storage - datetime fields are only down to the
second, so you will have to store the times as integers, and then do your
own arithmetic on them.
If you stored the time as ('unix time' * 100) + hundreths, then you could
probably still do some arithmetic using the
show variables showed that have_bdb is no, and none of the bdb variables are
there. So does this mean that BDB is NOT compiled into the binary included
in the Linux RPM, or does it mean that I need to add the necesary
BDB-related variables to /etc/my.cnf?
Stephen L. Faustino
Senior Software Eng
In some RDBMS there is something called ROLLBACK.
However, I am not sure if MySQL does support features such as ROLLBACK,
If mySQL doesnt support ROLLBACK then you need to do a recovery from your
previous backups.
On Sat, 03 Mar 2001, Pål Wester wrote:
> When you delete somthing... is there
On Mon, Mar 05, 2001 at 10:34:38AM +0100, Piotr Szybiak wrote:
>
> I am a 5th year student of University of Technology in Poznan
> (Poland). I would like to use MySQL in commerce project (Internet
> Auction). I will develope my Auction in Linux. Have I buy a licence
> from you ??? How many it cos
On Mon, Mar 05, 2001 at 03:44:20PM -0600, Stephen Faustino wrote:
>
> Yes, I specified that the table should use the BDB table handler,
> but it does not appear that the table was created as a BDB table.
Are you *sure* you're running a version with BDB support compiled in?
The output of SHOW VARI
Yes, I specified that the table should use the BDB table handler, but it
does not appear that the table was created as a BDB table. The following
are the results of my sessions on Solaris and Linux:
Solaris:
mysql> create table test (x int) type = BDB;
Query OK, 0 rows affected (0.46 sec)
mysql
I am trying to install DBD::mysql on a server which does not have mysql on it. ( The
script will be accessing a mysql
database on another server). The problem is, when I try to install dbd::mysql I am
asked several questions.. one of
which being: what is the path to mysql? I don't have a pat
On Mon, Mar 05, 2001 at 11:27:54AM -0600, Stephen Faustino wrote:
>
> I've installed 3.23.33 on both Solaris and Linux RH 6.2 using the
> tarball for Solaris and the RPM for Linux. The BDB tables work as
> expected on Solaris, but they did not not work under Linux. What
> I'm seeing is that I ca
Would like to install this with cxx not gcc! Made the following adaptation
to website documentation for section 4.12.6:
CC="cc -pthread"
CFLAGS="-O4 -ansi_alias -ansi_args -fast -inline speed -speculate all -arch
host"
CXX="cxx -pthread"
CXXFLAGS="-O4 -ansi_alias -ansi_args -fast -inline speed -
I consider this a bug... other might not.
I have:
.my.cnf:
---
[client]
password
host = mysql.rollanet.org
[mysql]
verbose
---
If I type "mysql" by itself, everything works fine. But if I try to use
"-ppassword" on any tool, it fails. I think that "password" in the config
shouldn't tri
Hello,
Michael Widenius wrote on Monday, March 05, 2001:
>
> I wonder from where the fdatasync() is comming; MySQL is not doing
> those (if you are not running mysqld with --flush)
The call is either a fsync or an fdatasync that is done by Berkley DB on the
transaction log.
Regards,
Chris Dela
On Mon, 5 Mar 2001 10:13:29 -0600
"Johnny Withers" <[EMAIL PROTECTED]> wrote:
> Well, if you have everything setup right.. this is easy to do in SQL.
>
> Lets say you have your root table:
[...]
>
> and your sub categories:
[...]
>
> and your final category:
[...]
>
> now you can simply
Gossamer Threads (http://www.gossamer-threads.com) has an near identical
knockoff written in perl calles mysqlman
- Original Message -
From: "MikeBlezien" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, March 05, 2001 10:53 AM
Subject: phpMyAdmin equivalent
> Hello All,
>
> Was
> create table root(
> create table subcats(
> create table subsections(
And now I need 230 levels, huh :).
How about a simple tree structure ?
hth
pa
-
Before posting, please check:
http://www.mysql.com/manual.php (the
Hi!
> "Jeremy" == Jeremy Hansen <[EMAIL PROTECTED]> writes:
Jeremy> We're doing some mysql benchmarking. For some reason it seems that ide
Jeremy> drives are currently beating a scsi raid array and it seems to be related
Jeremy> to fsync's. Bonnie stats show the scsi array to blow away id
Hello,
I'm new to mySQL, and I need a binary release for Solaris x86. Unless
somebody knows why I can't compile the source. I'm using the GCC
compiler version 2.95.2.
Here is my configure script:
CC=gcc CFLAGS="-O6 -fomit-frame-pointer -DHAVE_CURSES_H" \
CXX=gcc \
CXXFLAGS="-O6 -fomit-frame
Hi!
> "Mike" == Mike Black <[EMAIL PROTECTED]> writes:
Mike> Here's a strace -r on IDE:
Mike> 0.001488 write(3, "\214\1\0\0Blah Blah Blah Blah Blah Bla"..., 56) = 56
Mike> 0.000516 fdatasync(0x3)= 0
Mike> 0.001530 write(3, "\215\1\0\0Blah Blah Blah Blah Blah Bla".
I'm working on the following select statement and have a few problems:
select if(contact.comp_name, contact.comp_name, concat(contact.first_name,
' ', contact.last_name)) as name, if(substring(radacct.username,1,4) =
'brow', lcase(trim(leading concat(substring_index(radacct.username,'-',1),
'-')
SELECT with two (or one) of the three fields - probably with loads of OR's
after the intial search returns 0 rows.
Messy maybe but I don't see any other way.
You can't use a SELECT like you are currently using with fields of the same
name in different tables - I'm surprised you are not throwing
March 5, 2001
Dear Prospective Colleague,
I will be deeply in debt to anyone who helps me find an internship in Chemical
Engineering for the summer of 2001. I am a Chemical Engineering student at the Cooper
Union in NYC, and I can successfully perform the following scientific assays: Light
Mi
Hello
-Original Message-
From: Jon Haworth [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 05, 2001 11:09 AM
To: 'Quentin Bennett'; MySQL (E-mail)
Subject: RE: Just Checking
ping!
-Original Message-
From: Quentin Bennett [mailto:[EMAIL PROTECTED]]
Sent: 05 March 2001 03:04
Hello,
I'm reading this list for some time and checked the FAQ, archive
but i haven't found any hints ...
I have an own written app which is using a 'kind of database' to
calculate the difference between two (or more) events which can
happen between tens or hundreds of seconds.
Now i want to sw
Hi,
Check for open64 in the archives for the last month, and you will find your
answer (which is to upgrade your gcc).
Regards
Quentin
-Original Message-
From: john1 [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 6 March 2001 4:47 a.m.
To: [EMAIL PROTECTED]
Subject: C API problem
dear Sir
"MikeBlezien" wrote:
>
> Hello All,
>
> Was wonder if any knows of a Perl equivalent to the PHP's version of
> phpMyAdmin?? We use phpMyAdmin but have a project that server doesn't have PHP
> installed, and frankly, to lazy to do all the typing thru telnet session! :)
MysqlTool
Looks pretty go
Please add /usr/local/mysql/bin in your PATH.
dwayne> I'm fairly new to MySQL and unix. I have installed mysql on redhat 6.2 without
too many problems. I am changing my o/s to FreeBSD 4.2 and have installed mysql after
many hours of grief. I have mysql set to start at boot time and this seems t
Hello
Please excuse my ignorance, I am very, very new to databases and escpecially
MySql.
I have a couple of questions that I would be most grateful if someone could
answer for me.
1. I have a Cobalt Raq4 with mysql 3.22.32 installed. I also have a Win98
machine with 3.23.33 installed. I have m
Hello
> Is there a place or book where a newbie can gather information on
> indexes?
Section 12.4 of the manual is your friend. "EXPLAIN SELECT foo" will
tell you what indexes are used in doing your "foo" query.
cheers
--
TS
---
I think you really need another couple tables, even though your just writing
a sample.
You probably need a table named 'election' and one named
'electionparticipants'
Your election table would contain things like the date of the election, the
total number of votes cast, etc.
The electionparticip
I would make the select statement look like this
SELECT Candidate.FIRSTNAME, Candidate.LASTNAME, count(Votes.VoteNumber) ,
count(select votenumber from Votes)
FROM Candidate LEFT OUTER JOIN Votes ON Candidate.CANDIDATENUMBER =
Votes.CANDIDATENUMBER
GROUP BY Candidate.FIRSTNAME, Candidate.LASTNAME
john1 wrote:
>
> dear Sir :
>
> MySQL 3.22 on my linux 486 PC seems work so good. when I compile
> a simple C API program which catched from the MySQL tutorial, it
> chokes at the end of compile process . the program is as follows:
>
> #include
> #include
>
> #define def_host_name NULL
> #de
Because
TINYINT has a MAX VALUES of 127
pre the mysql docs:
TINYINT[(M)] [UNSIGNED] [ZEROFILL]
A very small integer. The signed range is -128 to 127. The unsigned range is 0 to 255.
if you unsign the column, you can get to 255
I would use something larger, because you will have more than 255 me
Joris Kluivers wrote:
>
> hi,
>
> i have a problem
> i have a database table created with the statement:
> CREATE TABLE chatmessages (id tinyint(6) DEFAULT '0' NOT NULL AUTO_INCREMENT,
>message text, username varchar(100), UNIQUE id (id);
>
> I insert records with:
> INSERT INTO chatmessages
check the archive, someone answered that one this weekend.
Cal
http://www.calevans.com
-Original Message-
From: Joris Kluivers [mailto:[EMAIL PROTECTED]]
Sent: Sunday, March 04, 2001 5:56 AM
To: [EMAIL PROTECTED]
Subject: insert + AUTO_INCREMENT
hi,
i have a problem
i have a database
I've installed 3.23.33 on both Solaris and Linux RH 6.2 using the tarball
for Solaris and the RPM for Linux. The BDB tables work as expected on
Solaris, but they did not not work under Linux. What I'm seeing is that I
can create a BDB just fine. However, attempting a rollback results in:
ERROR
On Sat, 03 Mar 2001 19:51:04 -0500, Alec Solway <[EMAIL PROTECTED]> wrote:
Try using DECIMAL, this works best for monetary values in my experience.
>>I'm having some trouble with the following:
>>
>>I have a sample table that has one record where price == 123.54, however
>>
>>select * from gp
Alec
Exact matches on float values are notoriously unreliable - the problem with
the math is that it can often turn out the value at something like :-
123.539
which won't produce an equality match.
For this you would probably better use a DECIMAL field.
And
I don't know for sure.. but If you did not specify how many decimal places to have, or
you specified too many/too less, then you
will need to trail 0's on your price. IE: 123.54 may be stored as 123.5400 in the
database.
If you don't want this 'feature' redefine your column as type 'double (5,2)
Greetings Jonathan,
There are a couple of ways that you can add a user. the best way is to grant
that user permissions on an existing database. If the user does not exist
then it will be created. That's the way I do it because then I don't have to
beg my ISP for insert/update permissions on the m
on 3/3/01 4:54 PM, Jonathan Dugan at [EMAIL PROTECTED] wrote:
> and I follow what is says:
> shell> mysql -u root mysql
> ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)
It sounds like you've _already_ set a root password, so you need to specify
it:
mysql -u root -p
OK, here is the story.
I have a PII Linux RedHat 7.0 server. I installed the Mysql package that
comes with it and also the dependent applications as specified.
I try to start the mysqld and it gives me an OK and then I status it and
it says
mysqld dead but subsys locked
I am asking fo
An RPM installation indicates that you might be installing on some
version of Linux. Could you specify the platform, the operating system,
the Mysql release Number so
that people with the experiece that you need will able to respond. My
experiece is with SusE Linux 7.0 and release Mysql-3.23.32-1
Robb
Exact error messages would be good at this point and it may be possible that
their version of MySQL may not fully support the command you are trying to
perform although with an UPDATE TABLE I would hope this unlikely.
I think you probably need to provide:-
SQL statement you are trying to e
Well, if you have everything setup right.. this is easy to do in SQL.
Lets say you have your root table:
create table root(
id integer unsigned not null auto_increment,
description varchar(50),
key root_key (id)
);
and your sub categories:
create table subcats(
ping!
-Original Message-
From: Quentin Bennett [mailto:[EMAIL PROTECTED]]
Sent: 05 March 2001 03:04
To: MySQL (E-mail)
Subject: Just Checking
Hi,
I someone sees this, can they respond, because I have received nothing from
the list for 30 hours +. It's now 16:00 NZ Time, 03:00 GMT on M
February 1, 2001 marks the start of the African American History Minute
Webcast tour. The tour will visit more than 150 historically significant
African American locations across the country and make them available to you
via streaming video.
Absolutely Free
In addition to providing vid
I`m trying to find the best method to match records between two tables in a
MySQL database. But it must match atleast once, so here is a scenario for you
to think about.
Member - Job, Salary, Location
Jobs - Job, Salary, Location
All values will be enum sets in both tables as follows
Job = en
dear Sir :
MySQL 3.22 on my linux 486 PC seems work so good. when I compile
a simple C API program which catched from the MySQL tutorial, it
chokes at the end of compile process . the program is as follows:
#include
#include
#define def_host_name NULL
#define def_user_name NULL
#define def_p
I have a column in my maildb table that I need to encrypt using the Password
feature. The users and the passwords are stored in another table in the
database, I would like to just rip them out of the non-encrypted fields
(radcheck.UserName, and radcheck.Value) and place them into the
maildb.Usern
Douglas Gilbert wrote:
> There is definitely something strange going on here.
> As the bonnie test below shows, the SCSI disk used
> for my tests should vastly outperform the old IDE one:
First thank you and others with my clueless investigation about
the module loading under Debian GNU/Linux. (I
Hello All,
Was wonder if any knows of a Perl equivalent to the PHP's version of
phpMyAdmin?? We use phpMyAdmin but have a project that server doesn't have PHP
installed, and frankly, to lazy to do all the typing thru telnet session! :)
TIA,
Mickalo
Mike(mickalo)Blezien
===
Hi,
it would be nice to have a replicate-ignore-table for the Master also!
It works fine, but if one has to replicate only certain tables of a db
it would be good to have this.
It is not enough to have this on slave only, because we do not want to
send the data of whole databases across the n
Charles, you need to be more descriptive about exactly what
problem you're having. Spell out your hardware, OS, MySQL
version, etc., and describe what isn't working.
Charles L. Hagen [[EMAIL PROTECTED]] wrote:
> I cannot seem to get this database program to work correctly. I am asking for any
Jonathan Dugan wrote:
> your documentation is simply wrong. NONE OF THE USER PERMISSION materal makes sense.
> I am read ing here
> http://www.mysql.com/doc/D/e/Default_privileges.html
> and
> http://www.mysql.com/doc/A/d/Adding_users.html
>
> and I follow what is says:
> shell> mysql -u root m
I think I figured the problem out, but I still do not understand what happened, the
following is showing how I got the query to
work. I basically had to re-import suppliersiclink table to get this to work right in
MySQL 3.23.33, but why? The data was fine in
MySQL 3.22.
mysql> select * from sup
hi,
i'm writing a book (wrox publishers) which uses mysql for the sample
database.
i seem to have encountered a problem with an SQL query.
its a simple voting application, with a candidate table, and a vote table:
create table candidate (
candidatenumber integer not null auto_increment,
firstnam
1 - 100 of 154 matches
Mail list logo
