Re: basic question about joins....

On Sunday 04 July 2004 11:36 pm, bruce wrote: > hi... > > i'm trying to figure out how to deal with joins > (left/right).. > > i have the following test tbls... > > create table universityTBL( > name varchar(50) not null default '', > ID int(10) not null auto_increment, > pr

Re: InnoDB and long semaphore waits

Mitch, please send the FULL .err log to me. Best regards, Heikki - Original Message - From: "Mitch Pirtle" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Saturday, July 03, 2004 4:41 PM Subject: InnoDB and long semaphore waits > Hi listers, > > I just got here, so plea

Re: basic question about joins....

Bruce: The problem is that you have universityTBL listed twice in your list of tables. Here is your statement, with numbers for each of the sources. SELECT schoolTBL.name, universityTBL.name FROM (1) universityTBL, (2) schoolTBL LEFT JOIN (3) universityTBL ON schoolTBL.universityID = university

basic question about joins....

hi... i'm trying to figure out how to deal with joins (left/right).. i have the following test tbls... create table universityTBL( name varchar(50) not null default '', ID int(10) not null auto_increment, primary key (ID), unique key (name) )type =MyISAM;

Re: mysql sql files...

At 17:21 -0700 7/4/04, bruce wrote: hi.. i can run sql files that have sql statements by : shell:>mysql -u -p is there a way to run foo.sql if i'm already inside the mysql env... neither a search of google/mysql indicates that you can... You don't have to use Google. Just read the section on the

RE: Problem Starting mysqld on Tru64

Hi, Customer has found that port 3306 was open on another server in the cluster, and that seems to be what was causing it. Thanks for listening. Quentin -Original Message- From: Quentin Bennett [mailto:[EMAIL PROTECTED] Sent: Monday, 5 July 2004 9:52 a.m. To: MySQL (E-mail) Subject: Pr

Re: mysql sql question

On Sunday 04 July 2004 07:16 pm, bruce wrote: > quentin/emmett... > > my question > > it appears that mysql essentially take the two > values returned from the select, and inserts them > into the (name,collegeid) that i specified... > > if this is the case, then i'm cool Yes, this is the

Re: mySQL LIMIT and ORDER BY Problem???

On Sunday 04 July 2004 02:52 am, Gary Mack wrote: > Hi there, > > I recently learned about LIMIT so that I can page > through records on a web page I am creating. > However, when coupled with ORDER BY, the sorting > does not work anymore. Can someone look at my below > query and point out what I

RE: mysql sql files...

to clairfy it looks as though the "source" function/command allows you to use the script from inside the mysql env... disreagrd -bruce -Original Message- From: bruce [mailto:[EMAIL PROTECTED] Sent: Sunday, July 04, 2004 5:22 PM To: [EMAIL PROTECTED] Subject: mysql sql files...

mysql sql files...

hi.. i can run sql files that have sql statements by : shell:>mysql -u -p http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: mysql sql question

quentin/emmett... my question it appears that mysql essentially take the two values returned from the select, and inserts them into the (name,collegeid) that i specified... if this is the case, then i'm cool mind if i ask you antoher question from a design perspective... i'm creating

RE: mysql sql question

hey i tried your suggestion.. and it worked... could you walk me through why it worked... also, could i do the same basic thing if i wanted to get values from different levels of parent tables ie, i want to insert a name/id in table1, however, i need to get the id from a parent tbl,

RE: mysql sql question

Hi, The insert says 'insert data in to two columns, name and collegeid'. The select says "get two columns, 'tom' and id" - 'tom' is a fixed value, the same for each row, and id is taken from the test table. If you want the name from test, then use mysql> insert into dept (name,collegeid) -

RE: mysql sql question

Hi, You've already specified some values, so you can't then add a 'select' clause as well. Try mysql> insert into dept (name,collegeid) -> select 'tom', id from test where name="sammy"; HTH Quentin -Original Message- From: bruce [mailto:[EMAIL PROTECTED] Sent: Monday, 5 July 2004

RE: mysql sql question

i created the following as a simple test... mysql> describe test; +---+--+--+-+-++ | Field | Type | Null | Key | Default | Extra | +---+--+--+-+-++ | name | char(20) | YES | MUL | NULL|

RE: mysql sql question

what you provided would almost do it... but i want to insert into the "dog table" the name that i submit... i'd like to do something like if i submit dogname, ownername insert into dog (name, ownerid) values ($dogname, owner.id) select ownerid from owner where owner.name = $ownername; -bruc

RE: mysql sql question

my bad... should have mentioned that both the owner and dog name are unique, but one owner can have multiple dogs... so just how does the "insert ... select" work.. it looks like it could actually do what i need, but i can't seem to get it working correctly.. -bruce -Original Message-

Problem Starting mysqld on Tru64

Hi, A previously stable of "Ver 4.0.13-max for dec-osf5.1 on alphaev67" install on Tru64 today decided not to restart, with the error: 040705 9:31:52 Can't start server: Bind on TCP/IP port: Address already in use 040705 9:31:52 Do you already have another mysqld server running on port: 33

mySQL LIMIT and ORDER BY Problem???

Hi there, I recently learned about LIMIT so that I can page through records on a web page I am creating. However, when coupled with ORDER BY, the sorting does not work anymore. Can someone look at my below query and point out what I am doing wrong? Thanks. This is my first time posting to

Report query problem

Coming from an Oracle background I am struggling with the following report generation. This is a report which needs to be created using mySQL: Week of mm/dd/yy mm/dd/yy mm/dd/yy mm/dd/yy mm/dd/yy Total All Groups nn nn nn nn

Re: mysql sql question

At 12:54 -0700 7/4/04, bruce wrote: hi... i have two hypothetical tables create table owner ( -> name char(20) , -> ownerid int(10) auto_increment primary key); create table dog ( -> name char(20) , -> ownerid int(10), -> dogid int(10) auto_increment primary key); i'm curious as

mysql sql question

hi... i have two hypothetical tables create table owner ( -> name char(20) , -> ownerid int(10) auto_increment primary key); create table dog ( -> name char(20) , -> ownerid int(10), -> dogid int(10) auto_increment primary key); i'm curious as to how i'd go about inserting a

Re: date and time functions.

Date modification functions are listed in the manual here: http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html If you are just trying to add a year to a column try something like this. update table set col = col + interval 1 year; -Eric On Sun, 4 Jul 2004 18:22:04 +1000, Hari Yell

RE: User Logon Procedure Fails

I still get an error and think this line is to blame:   AND password=UserPassword('$_POST[TXT_UserPassword]')";   I’ve changed it to:   AND UserPassword=('$_POST[TXT_UserPassword]')";   And I still get erros but further down the code. I’ll work through those.   BTW: didn’t know th

User Logon Procedure Fails

Another day another problem. This time it appears that users are able to enter their details but I get a query execution error with the following section of code: /* Verify Login */   $sql = "SELECT UserFirstName,UserID,UserPassword FROM RegisteredMembers   WHERE UserID='$_POST[TXT_UserID]

Re: MySQL 4.1 - Full-Text using UTF-8

Mabye it is something connected to my.ini definitions? mysql> SHOW VARIABLES LIKE 'character%'; +--+ -+ | Variable_name| Value | +--+

MySQL 4.1 - Full-Text using UTF-8

Hi, How do I search and index a TEXT column to use the UTF-8 charset? Do I need to define the FULLTEXT index or the column definition in a special way? I tried to use it as usual as I use full-text search on English only, but it seems not to match... (it's not the ft_min_word_len or the 50% tresho

mysqld 4.0.20 ICC compiled by mysql.com quits with signal 11

>Description: I installed mysql 4.0.20 (ICC Intel Compiler compiled mysql, compiled by mysql.com) and when starting mysqld it immediately exits with signal 11 and wrote this into mysqld-log: 040703 23:24:30 mysqld started mysqld got signal 11; This could be because you hit a bug. It is also po

date and time functions.

Hi All, I trying to add one year to date function is there a good documentation on how we can manipulate on date function. Changing the format of dates for mysql. Thank you , Harry -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lis

Re: ANN: gtk2-gladexml_DBI_helper-0.1

On Sun, Jul 04, 2004 at 11:05:12 +1000, Daniel Kasak wrote: > [...] > The code is available here: > http://enthalpy.homelinux.org/code/gtk2-gladexml_DBI_helper-0.1.tar.bz2 > I'm not sure on the naming I've used at present. If someone has a better > name, feel free to offer say so. The Gtk2::Ex n