Hi,
I know the title is confusing, but I have a column in which all rows are zero except one, which is equal to "1". I would like a formula to set a cell equal to the next column in that row (which is equal to 1).
For example, take the following data (seperated into two columns):
0 | Bob
0 |...
Hi,
I'm at work, and I left my computer to go to eat lunch. For some reason, when I returned all of my files in My Documents on my local drive were automatically deleted. Does anyone know why this could have possibly occured? No one else had access to my computer while I was gone.
I was wondering about the filtering sequence that MySQL performs on AND gates. For example, consider the following query:
select *
from expl_table
where ColA > 30
and ColB < 15;
Does MySQL first select rows where ColA > 30, and then further filter the resultset for ColB < 15, or does it...
I want a mechanism for recording the history of our employees' salaries. Using this mechanism, I should be able to easily obtain a salary given an employee's ID and a date. Any suggestions?
I am creating a temporary table which is simply a copy of two tables joined together, excluding rows which meet a certain criteria. For some reason, it is much faster for me to make a full copy of the joined tables, and then delete from the table the rows which meet the criteria, than it is to...
Yes I am sending email to the Network Solutions domain, but I am directly connected to the internet, so I don't want to use a relay. I just want to send mail directly.
I have an "employees" table which records which department each employee has worked in, and the date that each employee started working in their departments. Since it is possible for an employee to change departments, a single employee can have several records in this table. For example...
I am running Linux Fedora Core 5. I re-installed sendmail, and then restarted the sendmail service, and then ran the script shown in my first post again. But username@domain.com still isn't receiving the email. Here is what I see in the maillog now:
Mar 31 10:16:25 localhost sendmail[19026]...
When I run tail -f /var/log/maillog, I see:
Mar 30 10:21:38 localhost sendmail[7919]: 12UGLcmM007919: from=local_user, size=55, class=0, nrcpts=1, msgid=<200703301621.12UGLcmM007919@localhost.localdomain>, relay=local_user@localhost
Mar 30 10:21:38 localhost sendmail[7919]: 12UGLcmM007919...
I wrote the following simple bash script to send mail:
#!/bin/bash
SUBJECT="testsubj"
EMAIL="username@domain.com"
EMAILMESSAGE="/tmp/emailmessage.txt"
echo "testbody">$EMAILMESSAGE
/bin/mail -s "$SUBJECT" "$EMAIL" < $EMAILMESSAGE
The script runs fine (no errors are returned), but...
Sorry, I meant to say that having all 4 columns included in a unique key means that 2 rows (not columns) cannot have the same combination of all 4 columns.
I have a tab-delimited .txt file with 3 columns, which I want to import into a table with 4 columns. All of the table's 4 columns are included in a unique key. The .txt file looks like this
Bob Billy 23945
Adams John 34535
Smith Chris 34593
The column headings for the...
This might be a Linux question, as it has to do with where MySQL stores its database tables when you install it in a Linux based OS (Cent OS).
I want to put the MySQL tables and database information on a separate hard drive. I'm thinking the easiest way to do this is to mount the folder where...
Thanks for all your advice... it works now after adding the quotes as Tony suggested. I also changed the datatype to date. Tony, I can't believe I missed where 1989 came from.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.