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 table WHERE condition
Check to see if the result set is non-empty.
2) SELECT COUNT(*) AS cnt FROM table WHERE
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
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
, 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 click
I have been having problems with my email, and I wanted to test to this
list.
Thanks,
nick
: Testing Email
INSERT INTO a VALUES (NOW()) ?
Regards,
Chris.
- Original Message -
From: Renato Golin [EMAIL PROTECTED]
To: Nicholas Vettese [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Friday, August 25, 2006 4:31 PM
Subject: Re: Testing Email
Nicholas Vettese wrote:
I have been
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: mysql@lists.mysql.com
Sent: Wednesday, August 09, 2006 3:30 PM
Subject: Re: cell colors PHP/MySQL
On Wednesday 09 August
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:
script
$query = ALTER profile (acct_type, username, firstname, lastname, email,
addr1, city, state,
to use `userid`?
Thanks,
nick
- Original Message -
From: Miles Thompson [EMAIL PROTECTED]
To: mysql@lists.mysql.com
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 at the MySQL Table
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. input type=checkbox
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
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: mysql@lists.mysql.com
Sent: Friday, July 07, 2006 1:12 PM
Subject: Re: Rekall
On
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
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
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
. 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.html
Nicholas
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
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:
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,brHow to see all tables in connected database?brthx
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
what I read.brbrbrOn Tuesday, January 20, 2004, at 03:16 PM, Nicholas
wrote:brbrbr Hello Everyone,brbr I downloaded and installed thebr
mysql-standard-4.0.17-apple-darwin6.8-powerpc.dmgbr file from the mysql web site to
my ibook runningbr Mac OSX Version 10.1.5 on it.brbr I read
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
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...
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
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
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 PROTECTED]
To: Nicholas Elliott
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
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
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
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
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
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
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
as the last
name increases. Follow? Here:
Elliott, Nicholas
Smith, Bob
After Finding Elliott, Nicholas, the Query would _not_ find Bob Smith, even
though 'Smith''Elliott', because 'Bob' is not greater that 'Nicholas'.
So, whats the best way to rewrite this? Perhaps a Concat?
SELECT id, first, last
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
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
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 b
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]
Cc:
-
From: Mark [EMAIL PROTECTED]
To: Nicholas Elliott [EMAIL PROTECTED]; Benjamin Pflugmann
[EMAIL PROTECTED]; Brent Bailey
[EMAIL PROTECTED]
Cc: Octavian Rasnita [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, December 26, 2002 10:56 AM
Subject: Re: Hiding the password
- Original Message
it 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: Octavian Rasnita [EMAIL PROTECTED]; [EMAIL PROTECTED
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 PROTECTED]
Sent:
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
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, 2002
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
]# /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
-
Before posting, please
?
Nick
--
For technical support contracts, visit https://order.mysql.com/?ref=mnle
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Nicholas Leippe [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Spanish Fork, Utah USA
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
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
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
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
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 following
each
other?
INSERT INTO table1(column1) SELECT column1a FROM table2 WHERE
[something
understand what I'm missing and possibly why
this approach does not work.
Thanks,
Nicholas Berry
Systems Engineer
RagingWire Telecommunications, Inc.
916.286.4048 ph
916.921.4148 fax
[EMAIL PROTECTED]
www.ragingwire.com
-
Before
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
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 give
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
= 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 done
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
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$
- Original Message -
From: [EMAIL PROTECTED]
To: Arthur Fuller [EMAIL PROTECTED]
Sent: Wednesday, August 28, 2002 1:57 PM
Subject: [Fwd: RE: MS Access and mySQL]
wodya think?
Original Message
From: Nicholas Stuart [EMAIL PROTECTED]
Subject: RE: MS Access and mySQL
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
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
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
windows.
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, July 23, 2002 1:47 PM
To: [EMAIL PROTECTED
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),
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
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
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
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
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
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
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
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 meaning. See
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 anywhere (more specifically, the web).
Nicholas
-
Before posting
On Wednesday 16 Jan 2002 8:35 pm, Hamlin Nicholas-qa568 wrote:
I can't get table-specific grants to work.
snip
Have you flush privileges ?
Yes. That didn't change it.
Nicholas
-
Before posting, please check:
http
would be appreciated so that I can make sure that some unsuspecting user
doesn't throw some value in their entry that will cause the system not to work for
them. Or maybe there's a better way of going about this?
Nicholas Hamlin
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 that
be 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
, 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 archive)
To request this thread
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 Technolgies
86 matches
Mail list logo