My issue is actually in Excel. I'm hoping someone could help me...
I need to total the values in column B for "Emily". Is there a way other
than =SUM (B1+B2+B4+B7)?
--
Emily | 1
-
Emily | 5
-
Greg | 2
-
Bob | 7
-
Emily | 4
---
Hello,
What is the best method to check if (one or more) row exists (note:
primary key is auto inc and table engine is InnoDB - but what if these
were not true) ?
1) SELECT * FROM WHERE
Check to see if the result set is non-empty.
2) SELECT COUNT(*) AS cnt FROM WHERE
Check to see if the f
I am looking for a book that will help me understand PHP/MySQL, and the
way that they work together. My biggest problem is multi-valued
selections, and INSERTING them into the database. A book with great
examples like that would be a huge help. Also, any websites that could
do the same would be
, 2006 9:15 AM
To: mysql@lists.mysql.com
Subject: Re: Problems Updating Database
At 08:22 AM 9/6/2006, Nicholas Vettese wrote:
>I have a registration script that inserts data into the database, and
>then emails you an activation code to activate your account. The
>problem is that when I
I have a registration script that inserts data into the database, and
then emails you an activation code to activate your account. The
problem is that when I click on the link in the email, the account does
not get updated. The portion of the script that has a problem is this:
$query = "UPDATE
: Testing Email
INSERT INTO a VALUES (NOW()) ?
Regards,
Chris.
- Original Message -
From: "Renato Golin" <[EMAIL PROTECTED]>
To: "Nicholas Vettese" <[EMAIL PROTECTED]>
Cc:
Sent: Friday, August 25, 2006 4:31 PM
Subject: Re: Testing Email
> Nicholas V
I have been having problems with my email, and I wanted to test to this
list.
Thanks,
nick
Hello to all!
has anybody got any ideas how i can speed up the following query?
it's so awfully slow (about 1 second).
the "test_item" table is the main problem. currently, it has
about 108.000 entries.
is it normal that it takes so long? and if it isn't, how can i
optimize the query? i've got
Wouldn't using a 'switch' statement work better? Just please do not ask me
to show an example. :)
- Original Message -
From: "Chris White" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, August 09, 2006 3:30 PM
Subject: Re: cell colors PHP/MySQL
On Wednesday 09 August 2006 12:24 pm, Bri
ould be the best way to use `userid`?
Thanks,
nick
- Original Message -
From: "Miles Thompson" <[EMAIL PROTECTED]>
To:
Sent: Thursday, August 03, 2006 10:42 AM
Subject: Re: Alter Problem
At 11:12 AM 8/3/2006, Nicholas Vettese wrote:
I am working on a script that looks
I am working on a script that looks at the MySQL Table, checks to see if there
are any matches, and if there are, alter the table to add the requested
information. Here is the code I am using:
$query = "ALTER profile (acct_type, username, firstname, lastname, email,
addr1, city, state, zip, n
I am trying to allow a user to use checkboxes for multiple selections, and I am
trying to get the database to record the choices made by the user. I am using
a VARCHAR(250), but I am guessing that may be wrong. Also, other than adding a
"[]" to the end of the 'name' (e.g. Alternative), what do
I am looking to create a database that holds the location of images on my
server. I was wondering if anyone could help me understand if I am doing it
correctly, and if I either need to add, change or remove something from the
current table code.
img_idINTNOT NULL auto_increment PRIMARY
If I have a file that is in a spreadsheet format, how can I dump that into a
MySQL database, using PHP MyAdmin?
Thanks,
Nick
If you are using an apt-based system, type 'apt-cache search mysql' That
should bring up some programs you can install from.
nick
- Original Message -
From: "Daniel da Veiga" <[EMAIL PROTECTED]>
To:
Sent: Friday, July 07, 2006 1:12 PM
Subject: Re: Rekall
On 7/7/06, Timothy Murp
Hello all,
I am trying to get this script to INSERT a couple of records into my DB, but
I am getting these errors. I know the second warning has nothing to do with
MySQL, so I will work on figuring out that portion later today.
Warning: mysql_fetch_array(): supplied argument is not a valid M
If I have a multiple choice on a form and want to store that in my DB, then how
should I set up my table? I have been reading up on these, but everyone seems
to have a different opinion on how to accomplish this task. What I am looking
to do give the user a few options to check when submitting
Hello,
My name is Nick, and I am a new MySQL user. My hope is not to become a PITA,
so I will make sure that any question is straight and to the point with the
information needed to answer the question.
My skill in MySQL is pretty low, and I am looking to build a website for
myself that
Hi,
I read the suggested section, but I'm not sure whether I can actually do
any debugging with the pre-compiled Windows MySQL server. Is it possible
to turn on debugging with the pre-compiled binaries on Windows?
I'm also not sure what the difference is between libmysql.lib and
mysqlclient.
I can try. Any other ideas?
Gleb Paharenko wrote:
Hello.
Are you sure that mysql.exe is the same version as the server?
Check if you're able to connect to 3.23.xx server using API. What value
does your MYSQL_SECURE_AUTH option have? See:
http://dev.mysql.com/doc/mysql/en/mysql-options.ht
I am have trouble connecting to the MySQL server 4.1 using the API,
though I have no trouble connecting using the same parameters from the
command line mysql.exe.
I'm using server version 4.1.10 on Windows Server 2003, which was
started with --old-password (to ensure back compatibility with leg
Hi Daniel,
You are not alone in your quest to successfully start the mysqld
server on a Mac OSX platform. I am having similiar difficulty
on my ibook...
--- On Thu 01/22, Daniel Lahey < [EMAIL PROTECTED] > wrote:
From: Daniel Lahey [mailto: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Date: We
mysql> SHOW TABLES;
Hope this helps.
~~Nick
--- On Wed 01/21, Seena Blace < [EMAIL PROTECTED] > wrote:
From: Seena Blace [mailto: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Date: Wed, 21 Jan 2004 13:03:51 -0800 (PST)
Subject: SELECT
Hi,How to see all tables in connected database?thx -seena
ut that is
just what I read.On Tuesday, January 20, 2004, at 03:16 PM, Nicholas
wrote:>> Hello Everyone,>> I downloaded and installed the>
mysql-standard-4.0.17-apple-darwin6.8-powerpc.dmg> file from the mysql web site to
my ibook running> Mac OSX Version 10.1.5 on it.>
Hello Everyone,
I downloaded and installed the
mysql-standard-4.0.17-apple-darwin6.8-powerpc.dmg
file from the mysql web site to my ibook running
Mac OSX Version 10.1.5 on it.
I read the documentation on the mysql site and it
said to do the following next:
shell> cd /usr/local/mysql
shell> s
I'm running 3.23.58 on a Red Hat Fedora Core 1 box with the latest
updates, (as of a couple days ago). I was using webmin to change the
permissions on the database so I could access it from another box. Now,
no matter who or what I log in as I can't access anything. If I try to
go to the comman
Hi Mike,
You have to start the mysql server before you
can run the client. Try running "mysqld_safe --user=mysql"
from /usr/bin or /usr/local/bin, depending on where
you installed it.
To see if it is running currently on your machine,
try this: ps -ef | grep mysqld
Hope this helps...
~~Ni
Hello Everyone,
I downloaded and installed the
mysql-standard-4.0.17-apple-darwin6.8-powerpc.dmg
file from the mysql web site to my ibook running
Mac OSX Version 10.1.5 on it.
I read the documentation on the mysql site and it
said to do the following next:
shell> cd /usr/local/mysql
shell> s
That did it -- show table status lists the upper limit as approx 1TB now =].
I'm still curious about the InnoDB issues, but now at least I can avoid it
and work with the original plan!
Thanks,
Nick Elliott
- Original Message -
From: "Dan Nelson" <[EMAIL PROTECT
Hey all,
I've been experimenting with the best way to store a large (~100GB) of data for
retrieval. Essentially, I'm storing 9 variables for approximately 1,000,000 locations
a day for the last ten years. This can work out at around 4MB a variable a day - but
not all variables are always presen
Remember that this is a binary XOR, not a logical XOR. Mysql does have a
binary XOR operator, the '^' operator. So 'ipAddress1 ^ ipAddress2' is the
binary XOR between the two values. The binary AND is the '&' operator and
the binary OR is the '|'. Just don't confuse them with the AND operator
a
Hi
About Entity Relationship Diagrams: I use Graphviz to generate ERD's on
the fly, from the database. Graphviz is very cool:
http://www.research.att.com/sw/tools/graphviz/
Graphviz draws graphs from files written in its language (called 'dot')
Your PHP script (or language of choice) needs to get
Quick question about the license issue that I thought of while reading
through the Interbase Vs. MySQL threads.
If I develop a program that uses MySQL for my company and it is only used
for internal use, never repacked and sold/distributed outside the company
what type of license aggrement is that
I'd recommend a column of type SET.
Read about it here: http://www.mysql.com/doc/en/SET.html
Basically, if your list of product types is static, this may be a good bet. The SET
type can store any combination of 64 members,
stored as bits.
To list all items int a product type, you might use some
Ok I'm stumped on what I think should be a somewhat simple query. What I
have so far is a list of names that is in a list of projects AND in a the
main contact list by doing the following query:
SELECT p.name, p.company FROM contacts c, projects p WHERE
CONCAT(c.firstName, " ", c.lastName) = p.name
The biggest problem is if you want to do this from a remote pc, that pc
will need access to the server itself and the mysql client tools. It
sounds as if this pc is not on your LAN and I doubt the hosting service
will be willing to expose there database to the internet so you can do a
backup. If yo
I've been reading every e-mail I could find within this list that talked
about ReiserFS within the last year and I've found very little information
on is ReiserFS really better than ext3. I did find that almost everyone
said that ReiserFS handled large amounts of files much better than ext2 or
ext
;$previouslast' AND first > 'previousfirst'
", we're falsly stating that the first name _must_ increase along with the
last name, where in reality the first name may decrease, so long as the last
name increases. Follow? Here:
Elliott, Nicholas
Smith, Bob
After Find
Actually, had I read your (second?) email properly, I would've suggested
something slightly different. (I guess, to get a 0, rather than count(*) it
should've been a count(startyear)).
Instead of a LEFT JOIN, which will create NULL rows for any years that don't
have a project, do a straight JOIN u
Sounds to me like you'll need to join for that -- and list all the years you
are interested in in another table. Try this?
SELECT y.Year, count(*) FROM Year as y LEFT JOIN projects ON
project.startyear<=y.Year AND project.endyear>=y.Year GROUP BY y.Year;
This will give you a count of 0 for any y
Hey there,
Does anyone know why a query would take a very long time (>15 minutes) from
my CGI script, yet takes less than a second if I cut-and-paste into my
console?
The query itself amounts to this:
SELECT ((a.PRECIP>(0.00*AVG(b.PRECIP/100, a.DATE
FROM clim_data AS a
LEFT JOIN clim_data as
t was.
Ah well. I figured that out right after I sent out my last email... turns
out 511 didn't work (551 did, of course).
Sorry! =]
Nick Elliott
- Original Message -
From: "Mark" <[EMAIL PROTECTED]>
To: "Nicholas Elliott" <[EMAIL PROTECTED]>
Cc: "
sword.
Nick Elliott
- Original Message -
From: "Mark" <[EMAIL PROTECTED]>
To: "Nicholas Elliott" <[EMAIL PROTECTED]>; "Benjamin Pflugmann"
<[EMAIL PROTECTED]>; "Brent Bailey"
<[EMAIL PROTECTED]>
Cc: "Octavian Rasnita&quo
Does the CGI-script need to be world-readable, or just world-executable?
All my perl CGI scripts are set up that way, so while anyone can run it,
only I can read the source code
- Original Message -
From: "Benjamin Pflugmann" <[EMAIL PROTECTED]>
To: "Brent Bailey" <[EMAIL PROTECTED]>
C
Lenz,
Thanks, I downloaded it and it all works fine now, the whole bin directory
is statically linked.
Nickg
-Original Message-
From: Lenz Grimmer [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 18, 2002 2:46 PM
To: Nick
Cc: [EMAIL PROTECTED]
Subject: Re: MySQL 3.23.54-max GLIBC er
Alternatively, use the IF() function --
SELECT IF(captain=0, "C", "") from stats where captain > 0 and number = '23'
group by number;
Or something similar.
Nick
- Original Message -
From: "Insanely Great" <[EMAIL PROTECTED]>
To: "Alex Behrens" <[EMAIL PROTECTED]>; "MYSQL" <[EMAIL PROTE
So essentially, you want to put an index on part of the column, and not the
whole column, right? As in, an index on just the date part, and not the time
part. (Or both -- it seems like you want it to do both at the same time).
Much like you can with a char column -- put a char on the first 2 letter
Wouldn't you need if
(!mysql_query("INSERT INTO table(field) VALUES('$var')")) die("Always die");
?? (Put the $var in single quotes, as it's a text field)
Nick Elliott
- Original Message -
From: "Erumba Gotha Henri" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, November 19,
Hey folks,
I've looked around, but haven't seen anything similar to _quite_ the problem
I have. The symptoms are thus: memory usage for each mysqld process in top
creeps up to around 13%, 274MB, and stays there, no matter what I set my
config to.
79 processes: 76 sleeping, 3 running, 0 zombie,
I want to alleviate some activity from my drives by changing the
group_home_dir & arch_dir variables for Innodb to a ram disk drive,
/dev/shm/. Other than loosing all transactions that were taking place
during a box crash, are there any problems with this? If the box crashes
(which shouldn't happ
it is. I'll look into
this further. Is this causing problems for your application?
What version are you using?
Nick
--
For technical support contracts, visit https://order.mysql.com/?ref=mnle
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Nicholas Leippe <[EMAIL PROT
r stopping it:
[root@chimp etc]# /sbin/service mysqld stop
Stopping MySQL:[FAILED]
I can only stop the daemon with:
[root@chimp etc]# mysqladmin -p shutdown
Thanks in advance,
nicholas calugar
-
I know it's not very important in normal day to day operations, but does
anyone know what each thread does within mysqld with Innobase installed?
It'd be nice to know what Innobase is doing when a process is pinned at 100%
of the cpu..if it's doing cleanup from a huge update, etc.
1655 ttyp1
'ifnull(i.photographer,"6")'
then the correct result is produced.
Can someone please help me understand what I'm missing and possibly why
this approach does not work.
Thanks,
Nicholas Berry
Systems En
>
> I'm probably going to have to do the alternate technique regardless. =\
>
> On Tuesday, September 10, 2002, at 05:23 PM, Nicholas Stuart wrote:
>
>>> From my experince this is not possible.
>> Is there any reason why you can not simply do two inserts foll
>From my experince this is not possible.
Is there any reason why you can not simply do two inserts following each
other?
INSERT INTO table1(column1) SELECT column1a FROM table2 WHERE [something]
INSERT INTO table1(column2) VALUES(valueFromMemory)
(as if you didnt know that already) =D
There shoul
DB independent? As in an entire list of tables in your MySQL server? Or as
in independent from MySQL to say MS SQL Server? If the later then I'm sure
each db as some form of query to get a list of tables, just look it up. I
don't think there would be a unified way simple because each db is
complet
You would have to do something like:
SELECT * FROM users WHERE CONCAT(firstname, " ", lastname) = "John Smith"
That should get you what you want.
If your taking your DB from MS SQL to MySQL only a few queries will port
directly over. You have to be careful that you follow the MySQL syntax and
func
Hello Richard,
I just went through something similar with upgrading from 3.23.49 to 4.03.
The reason you can't connect to MySQL is
>020908 15:53:33 mysqld ended
This should obviously not be here.
Check the error logs to see if they say anything important and/or helpful
there. Most likely found un
I had this problem to but was never able to find what was causing it. The
way I got around it was by doing execute statements like:
connection.execute("INSERT INTO .")
That way I avoided VB handling the updates and it worked. But since Josh
pointed this little problems "solution" out I might g
simply
be
> high praise for MyODBC, but my Access app has no difficulty at all
talking
> to the database.
>
> Arthur
>
> - Original Message -
> From: <[EMAIL PROTECTED]>
> To: "Arthur Fuller" <[EMAIL PROTECTED]>
> Sent: Wednesday, August 28, 2002 1:57
True you could, but then that way you will loose portability if Jon (for
whatever reason) decides to move to another type of DB. Never used
libmySQL so I dont know how the speed is, but assume its as fast if not
faster then ODBC.
ODBC has the plus of being user friendly and of being an M$ Universa
I would strongly urg you not to use Access as the front end. The biggest
problem is that the Jet Engine/Access backend is pretty much completly
different then MySQL and you will run into problems with table structure
and the like. Also, using access as the front end has been extremly slow
when eve
S-SQL = indexs will be used on tables mentioned in the JOIN clause
and they will not in MYSQL
-Original Message-
From: Nicholas Stuart [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 28, 2002 9:40 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: MS Access and mySQL
I have been there
I have been there done that with old access data, but no forms. Your
plans should be focused around what you know and what your systems are
tied to. Since its an NT box you could go with pretty much any language
ie java/vb/c++. VB would be the obvious choice for ease of transfering
the Access VBA
Heh...ya I knew I fogot to do something. You would think that would be an
install step.
Next task is recompilling the apache httpd as it doesnt like not having
the libmysqlcleint.so.10 file which is now libmysqlcleint.so.11
thx for the tip. =D
-Nick
louie miranda said:
> Add the mysql lib path
First thing I would do is update your mysql. That version is very old and
probably does not support a lot of stuff you are looking for. After that I
would go and download the newest JDBC drivers from:
http://www.mysql.com/downloads/api-jdbc.html
-Nick
marco said:
> Hello everybody
> I'm just
Check out http://www.dbtools.com.br/EN/ I use it to import from access to
mysql. By the sounds of it though you have some dirty data which may or
may not need to be cleaned before going through there program. The only
real problem I had was that working with old dirty data is a pain since a
lot of
Aye, I forgot to mention to lock the db before backing up...my bad. But
again the idea is the same just schedule win2k to do it.
-Nick
Ed Carp said:
>> >> On windows you could simply copy the entire data directory with a
>> Scheduled job. Copying the files should be all you need to do for
>> win
On windows you could simply copy the entire data directory with a
Scheduled job. Copying the files should be all you need to do for windows.
For a cleaner, and what most people would say is a better way you could
schedule a batch file to run mysqldump that would dump the data and
structure to a fi
Thanks, that was simple enough...guess I just couldnt think of that.
Thanks again!
-Nick
Gordon said:
> Try round(value*4,0)/4
> Worked on the samples I tried
>
>> -Original Message-
>> From: Nicholas Stuart [mailto:[EMAIL PROTECTED]]
>> Sent: Tuesday,
Ok here's the problem. Trying to write a select statement to be able to
round a set of numbers to the nearest quarter of an inch. Here is what I
have so far:
*-*
SELECT
CONCAT(ROUND(inside_length + (wall_thickness * 2), 0),'\'
Had a wierd problem with my first slave.
Slave 1 has MySQL 4.02 on win 2000
Slave 2 has MySQL 3.23.49(?) or some where arond there on win nt 4
Master has MySQL 3.23.51 on Linux RH 7.2
Slave 2 and master appear to be running with out problems. How ever after
making several table drops to the maste
Hello all. I have been trying to add a second slave to my server but have
come up to a hopefully easy problem. The first slave is up and running
fine, but after copying down the master info to the second slave when I go
to start it it is trying to read the original logs which were/are being
used f
Hello and good morning all! I'm running into a problem when trying to test
mysql on Red Hat Linux. I have the server up and running just fine with no
problems, but when I go to run ./mysql-test-run it spits back the
following.
TEST USER SYSTEM ELAPSEDRESULT
--
There has been some work done on this by the folks at
http://www.icarz.com/mysql/They have a dll that can be used to replace ADO for mysql.
Haven't
personally used it, but they say its faster.-Nick
Efren Pedroza said:
> Maybe I'm goin to ask something stupid, but I've to do it, MySQL++ API
> can
Never got any replies from the list with suggestions from my last post so
I thought I would give another cry for help.To recap:
Master Server - Win NT 4.0 mysql 3.23.49-nt-log dual pII 600
Slave Server - Win 2k mysql 4.0.1-alpha-max-nt p4 2.0
Procedure: Followed the manual to set up the slave mas
Environment:
MySQL Version 3.23.42
FreeBSD 4.4
ISAM table of about 300,000 rows and 10 columns
with a column structured as varchar(50) upon which
exists a FULLTEXT index
Behavior:
The query
select * from tablename where match(column_name)
against('tree');
selects seven records.
The query
Thanks
This is not clear from the manual. - Works fine now though.
Benjamin Pflugmann wrote:
>
>Hi.
>
>You have to use backticks (`) instead of single quotes (') as in
>
>CREATE TABLE TEST (`ID` INTEGER)
>
>When MySQL has been started with --ansi, double quotes (") will have
>the same meanin
Hi,
I'm using MySQL version 3.23.37 which works fine. However I am
currently trying to convert a MS Access database to MySQL and some of
the column names have embedded spaces i.e. "First Name". Now according
to the manual MySQL supports quoting of identifiers (for the above
reason), I can
>On Wednesday 16 Jan 2002 8:35 pm, Hamlin Nicholas-qa568 wrote:
>> I can't get table-specific grants to work.
>>
>
>
>
>Have you "flush privileges" ?
Yes. That didn't change it.
Nicholas
---
command denied to user: 'dummy@localhost' for table 'watch'
What am I doing wrong? I have about 9 tables inside of MyDataBase, and I only want
two tables, 'watch' and 'user', to be updatable by anyone with an existing account who
can log in from anyw
Easier yet, when using DBI::mysql, is:
my $IncrementedID = $dbh->{'mysql_insertid'};
When executed after the INSERT command.
Nicholas
-Original Message-
From: Rick Emery [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 16, 2002 9:28 AM
To: 'Ben Curran'; [E
It should be PrintError (capital 'E').
ie.
---
$dbh = DBI->connect($dsn, $user, $pwd,{PrintError =>
0, RaiseError => 1});
Nicholas
-Original Message-
From: Investor [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 15, 2002 2:43 PM
To: [EMAIL PROTECTED]
Subje
Sinisa Milivojevic writes:
>
>ALTERing will completely break security and permission systems and
>will even prevent MySQL from proper functioning.
>
Can you give me an example? I'm having no problems with security even after adding
these columns. Users only have access to the dbs and tables th
I change the
"reminder" column, on the same account, to be "Yes-yesyes" and the account still
works? Is there some limitation to using the keyword "job"? The column "full_name"
resides before "job"
found,
even though the file is there. Any thoughts?
I figured I would ask here before asking the PHP list because they never
seem to be of much help.
Nicholas
-
Before posting, please check:
http://www.mysql.com/manual.php
ce tar ball, it
compiles, and the configure script doesn't give the same error.
Nicholas
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archi
We're considering hiring a PHP/MySQL web developer. You must live in
the Portland, OR, metro area. Please respond off-list to me with a
resume/portfolio if interested.
Thank you.
Nick
--
Nicholas A. Zukin
Web/Database Developer
ODI Techno
Hi All,
I have a JOIN statement:
SELECT d.*, b.invoice_id FROM domain_info d LEFT JOIN billing_info b ON
d.domain_id=b.domain_id
WHERE billing_cycle = '12' OR billing_cycle = 'Z' OR billing_cycle = 'C'
GROUP BY domain_name
In addition to the fields this statement returns, I would also like it
t
90 matches
Mail list logo
