Joined tables still not working

I am having a problem with a query that joins the following tables. I want to create a query that would tell me how many Manhours have been alloted for a particular project (32) by category and how many hours (from the Tasks table) have actually been used for this project and category. The data ta

RE: Problem with joins and query

: "Luis Lebron" <[EMAIL PROTECTED]> > Select M.Catid, sum(M.Hours) as allotedhours, sum(T.Hours) as usedHours > >From Manhours as M, Tasks as T > Where M.ProjectId=32 > AND T.ChargeNum=M.ChargeNum > AND T.EmployeeID=M.EmployeeID > AND T.Catid=M.Catid > Group by

Problem with joins and query

I am having a problem with a query that joins the following tables. I want to create a query that would tell me how many Manhours to a particular project (32) by category and how many hours (from the Tasks table) have actually been used for this project and category. Manhours mid| ProjectId

Insert select query problem

I am try to copy a couple of fields from one table to another. Here is my query Insert into users_test (firstName, lastName) Select firstName, lastName from users; The users table has 1,263 rows. However, only 1 row is inserted into users_test. If I perform the following query Insert into use

Question on slow queries

I just started logging slow queries. Today I found the following lines in the slow query log. # Query_time: 14 Lock_time: 0 Rows_sent: 293 Rows_examined: 293 use storyboards; SELECT /*!40001 SQL_NO_CACHE */ * FROM `rwt_screens`; What exact does the third line mean? thanks, Luis R. Lebron S

RE: Creating random data in a test table based on an existing tab le

Thanks for the help. I tried your suggestion but only got 1 row inserted in the test table. Luis -Original Message- From: Olof Tjerngren [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 11, 2003 3:01 AM To: Luis Lebron Cc: Mysql (E-mail) Subject: Re: Creating random data in a test table

Creating random data in a test table based on an existing table

I have an users table for a php application that I am programming. The current users table has about 1500 records. I would like to create a test table (i.e. users_test) with 10,000 records based on random data from the first table (i.e. random first name combined with a random last name, etc...). I

Secure way of storing passwords in the database

Any suggestions of a "secure" way of storing membership passwords (for a website) in a mysql database? Should I use sha, aes, des??? thanks, Luis R. Lebron Sigmatech, Inc

RE: Issues with Mysql 4.0 and PHP in a production environment

Anything that breaks a script (unsupported functions, changes, etc.) or that causes performance problems. thanks, Luis -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] Sent: Thursday, November 06, 2003 4:09 PM To: Luis Lebron Cc: Mysql (E-mail); Php-General (E-mail

Issues with Mysql 4.0 and PHP in a production environment

Are there any issues with running PHP 4.3.X and Mysql 4.0 in a production environment? thanks, Luis R. Lebron Project Manager Sigmatech, Inc

RE: Compiling MySQL 4

True, but the compilation options stated --without-readline . So what is going on? -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] Sent: Thursday, November 06, 2003 1:25 PM To: Luis Lebron Cc: Mysql (E-mail) Subject: Re: Compiling MySQL 4 On Thu, Nov 06, 2003 at 01:01

Compiling MySQL 4

I am trying to compile MySQL 4.x on a Red Hat 8.0 but I'm getting the following error /usr/bin/ld: cannot find -lreadline collect2: ld returned 1 exit status make[2]: *** [mysql] Error 1 make[2]: Leaving directory `/usr/src/mysql/mysql-4.0.16/client' make[1]: *** [all-recursive] Error 1 make[1]: L

Deleting from multiple tables

I am working on some database tables to handle messages on an intranet. One table looks like this msg_id | subject | message | date there is another table used to track senders and recipients that looks like this msg_id | sender_id | recipient_id | Now what I would like to do is delete any

Updating age based on date of birth

I have a table that contains a date of birth (date) and a age field. How can I create an update query that would calculate the correct age (from the date of birth) and update the age field? I tried doing it with php but ran into problems with persons born before 1969. thanks, Luis R. Lebron Sigm

Select query question

I have a test results table that looks like this student_id test_id score 1 1 90 1 1 100 1 1 80 2 1 95 2 1 85 2 1 75