Just curious as it is not mentioned. Can Category ID also have multiple
event id ?
--
Cheers
Dhaval Jaiswal
On 01/03/2011 5:53 PM, Wagyu Beef wrote:
Hey guys,
Am a newbie here and need a little help.
Part of the database consists of two tables events and categories which
look like this
Oh yeah, forgot to mention that. Yes, one event will have multiple
categories. And one category can be applicable to multiple events.
On Tue, Mar 1, 2011 at 8:33 PM, Dhaval Jaiswal
jaiswal.dha...@enzenglobal.com wrote:
Just curious as it is not mentioned. Can Category ID also have multiple
2011/03/01 20:23 +0800, Wagyu Beef
Part of the database consists of two tables events and categories which
look like this
+---+-+
| eventID | eventName |
+---+-+
| 1 | Event A
Thanks all... I got this to work! Much appreciated..
And thanks for patience with a newbie!
--
Patrice Olivier-Wilson
http://biz-comm.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
E-mail: je...@gii.co.jp
Web site: www.the-infoshop.com
-Original Message-
From: Patrice Olivier-Wilson [mailto:b...@biz-comm.com]
Sent: Friday, September 10,
On 9/10/10 12:31 PM, Jerry Schwartz wrote:
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
E-mail: je...@gii.co.jp
Web site: www.the-infoshop.com
Thank you!
--
Patrice Olivier-Wilson
http://biz-comm.com
--
Thanks again for assistance. FYI, I did track this thread down
http://ask.metafilter.com/57007/Missing-commas-in-CSV-file
(exerpt:
Maybe there is a space or something in the 14th column of the first 15 rows.
posted by. on February 14, 2007
It's a bug in Excel (not something you did
-Original Message-
From: Patrice Olivier-Wilson [mailto:b...@biz-comm.com]
Sent: Sunday, September 27, 2009 10:19 AM
Cc: 'mysql'
Subject: Re: Newbie question: importing cvs settings
Back again... I have 192 records to import, and tried my extra line at
the end hoping for a work around
Jerry Schwartz wrote:
[JS] This is just a shot in the dark, but Excel can be rather surprising when
it puts out a CSV file. Depending upon the data, and exactly how you've
specified the export, it can put double-quotes in unexpected places.
If you leave out the 17th line of data what
:02 AM
To: 'mysql'
Subject: Re: Newbie question: importing cvs settings
Yep, typo ...:-(
I did some screen shots of 2 tests. A workaround solution is to make a
final entry in the csv file that I don't really need. Then everything up
to that point gets imported ok using CSV method. The LOAD DATA
Back again... I have 192 records to import, and tried my extra line at
the end hoping for a work around, but nope, it failed at line 17 again.
Invalid field count in CSV input on line 17.
Anyone have an idea why this might be happening?
Patrice Olivier-Wilson wrote:
Yep, typo ...:-(
I
(CMDBA)
Certified MySQL 5 Developer (CMDEV)
IBM Cognos BI Developer
Telephone +44 (0)7812 451238
Email j...@butterflysystems.co.uk
-Original Message-
From: Patrice Olivier-Wilson [mailto:b...@biz-comm.com]
Sent: 27 September 2009 15:19
Cc: 'mysql'
Subject: Re: Newbie question: importing
I assume you mean csv not cvs!
What is the error you get when the import fails? What version of MySQL are
you using? Can you post the output of SHOW CREATE TABLE for the table you
are trying to load the file in to and a sample of the csv which is failing
to load?
Do you get the same error if you
Yep, typo ...:-(
I did some screen shots of 2 tests. A workaround solution is to make a
final entry in the csv file that I don't really need. Then everything up
to that point gets imported ok using CSV method. The LOAD DATA method
did not enter anything.
My earlier assumption about line 17
The online help for mysql administrator is here:
http://dev.mysql.com/doc/administrator/en/index.html
OlinData: Professional services for MySQL
Support * Consulting * Administration
http://www.olindata.com
On Fri, Feb 20, 2009 at 7:17 AM, Jeff Murdock jeff_murd...@yahoo.com wrote:
This is on
Jeff,
For starters, it looks like you need a value for VARCHAR. Try the
same statement but with VARCHAR(255) .
On Fri, Feb 20, 2009 at 1:17 AM, Jeff Murdock jeff_murd...@yahoo.com wrote:
This is on a Mac OS X (v10.5.6) system in case that matters.
1. - MySQL Administrator Help button
Either use reply to all, or manually enter the list email address in the to
field.
There are two general feelings about list operation:
1) all replies should go to the list
2) all replies should default to the sender
This list is configured as #2 (I prefer #1 myself)
Thanks,
David Ruggles
CCNA
Thanks Sebastian, that did the trick.
The full command I use is:
$mysqli = new mysqli(., $username,$password,
$database,null,/tmp/mysql.sock);
Regards,
JC
Sebastian Mendel wrote:
John Comerford schrieb:
Hi Folks,
I have a database running on Window XP, that I want to disable network
John Comerford schrieb:
Thanks Sebastian, that did the trick.
The full command I use is:
$mysqli = new mysqli(., $username,$password,
$database,null,/tmp/mysql.sock);
there is no need for the socket, their are no sockets on windows
$mysqli = new mysqli('.', $username, $password, $database);
Hi Sebastian,
I did read somewhere that sockets was not valid for windows, and
'/tmp/mysql.sock' doesn't resolve to anything on my machine. But I have
tried the following commands:
$mysqli = new mysqli(., $username,$password, $database);
or
$mysqli = new mysqli(., $username,$password,
John Comerford schrieb:
Hi Sebastian,
I did read somewhere that sockets was not valid for windows, and
'/tmp/mysql.sock' doesn't resolve to anything on my machine. But I have
tried the following commands:
$mysqli = new mysqli(., $username,$password, $database);
or
$mysqli = new
Hi Sebastian,
That was it alright. I commented out the socket lines from mysql.ini
(restarted it) and changed my php command to:
$mysqli = new mysqli(., $username,$password, $database);
and all seems to be working fine now.
Thanks again for your help, much appreciated.
Regards,
John
John Comerford schrieb:
Hi Folks,
I have a database running on Window XP, that I want to disable network
connections to and enable 'named pipes'. I am running MySQL 5.0.27
and my.ini looks like...
[...]
I can connect to the DB using the GUI tools if I set my pipe name to
Hello.
Please, I don't need comments telling me that I'm missing the semicolon
or that comments such as doesn't work are worthless. I know there's
something inherently wrong with this query (obviously . . . since it
doesn't give me the results that I am looking for). Does anyone havea
Analyst
Taylor, Bean Whitaker Mortgage Corp
-Original Message-
From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 06, 2005 6:52 AM
To: mysql@lists.mysql.com
Subject: Re: Newbie Question: listing open issues regardless of project
Hello.
Please, I don't need comments
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 06, 2005 6:52 AM
To: mysql@lists.mysql.com
Subject: Re: Newbie Question: listing open issues regardless of project
Hello.
Please, I don't need comments telling me that I'm missing the
semicolon
or that comments such as doesn't work
Systems Analyst
Taylor, Bean Whitaker Mortgage Corp
-Original Message-
From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 06, 2005 6:52 AM
To: mysql@lists.mysql.com
Subject: Re: Newbie Question: listing open issues regardless of project
PROTECTED]
Sent: Tuesday, December 06, 2005 11:03 AM
To: mysql@lists.mysql.com
Subject: Re: Newbie Question: listing open issues regardless of project
Hello.
So it is clear now, that you should have 16 columns and to build
dynamically the column headings. The usual way to do such things
in SQL
Kraer, Joseph wrote:
snipped
I thought that IF
statements would do the job, but I get a syntax error (1064).
Obviously, they are not the way to go. Nevertheless, here's the
complete query so you can get an idea of where I want to go:
Your if statement is wrong.
The syntax is:
if (
Kraer, Joseph wrote:
I am trying to update a couple of rows in a table by doing the
following:
update table
set column5 = number1
where column 1 = number2
and column1 = number3
This appears to be correct syntax.
but it is not working.
We can't help you if you don't tell us what you mean
I guess that the problem is the reserved word table
Try it:
Update `table`
Set column5=number1
where column 1 = number2
and column1 = number3
But the sintax is ok
Regards!
-Mensaje original-
De: Kraer, Joseph [mailto:[EMAIL PROTECTED]
Enviado el: Miércoles, 30 de Noviembre de 2005
Kraer, Joseph [EMAIL PROTECTED] wrote on 11/30/2005 11:58:56 AM:
I am trying to update a couple of rows in a table by doing the
following:
update table
set column5 = number1
where column 1 = number2
and column1 = number3
but it is not working. I tried listing the conditions separated
Hi,
In your query you try to update on the condition column 1 = number2 and
column1 = number3.
I think what you want is column 1 = number2 or column1 = number3 .
If you use and it will try and found a record in column which has a value =
number2 and at the same time = number3.
hth,
melanie
Business Systems Analyst
Taylor, Bean Whitaker Mortgage Corp
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 30, 2005 12:13 PM
To: Kraer, Joseph
Cc: mysql@lists.mysql.com
Subject: Re: Newbie Question on Update
Kraer, Joseph
Hello.
I'm not a PHPMyAdmin guru, but at least LOAD DATA LOCAL feature (if it is
present in PHPMyAdmin) can be disabled due to some security reasons. See:
http://dev.mysql.com/doc/refman/5.0/en/load-data-local.html
Joe Herman wrote:
To those thinking of answering this question,
Joseph
update table
set column5 = number1
where column 1 = number2
and column1 = number3
but it is not working. I tried listing the conditions separated by
commas (where column 1 = number2, column1 = number3) and also didn't
work. What am I doing wrong?
No commas in the WHERE clause. WHERE ...
Hello.
I'm not PHPMyAdmin guru, but at least LOAD DATA LOCAL feature (if it is
present in PHPMyAdmin) can be disabled due to some security reasons. See:
http://dev.mysql.com/doc/refman/5.0/en/load-data-local.html
Joe Herman wrote:
To those thinking of answering this question,
Jeffrey G. Ubalde wrote:
Good day list!
I would just like to ask a somewhat not so intelligent question. What
is the downside of indexing almost all of the fields in a table? Is it
advisable?
Indexes have to be built... so if you did that, for every query that
alters the data many
I would just like to ask a somewhat not so intelligent question. What
is the downside of indexing almost all of the fields in a table? Is it
advisable?
Indexes have to be built
They also consume disk space, so if you're tight on hard drives, they
might put you over the top.
--
Scott
Subject: Re: Newbie Question
Jeffrey G. Ubalde wrote:
Good day list!
I would just like to ask a somewhat not so intelligent question. What
is the downside of indexing almost all of the fields in a table? Is it
advisable?
Indexes have to be built... so if you did that, for every query
In one case I do need to jump back and forth between databases that
are on different physical servers. What's the most efficient way to
handle this?
On Aug 2, 2005, at 11:14 AM, Devananda wrote:
Brian Dunning wrote:
My RaQ4 is throwing the Too many connections error. Now, it is
Brian Dunning wrote:
In one case I do need to jump back and forth between databases that are
on different physical servers. What's the most efficient way to handle
this?
On Aug 2, 2005, at 11:14 AM, Devananda wrote:
Brian Dunning wrote:
My RaQ4 is throwing the Too many connections
on one level, the test database is there just have something to log into
after intall to prove it's working.. some init.d startup scripts (I'm
thinking RedHat here) try to log into the database as an authenticated
user after each start up and when doing a 'status' call just to make
sure it's
You need to do a join on the tables,
Simplest way is
Select * from gardens a, state b where a.state_id = b.id
Assuming id in the state table is actually what your planning on joining on.
Try to do it on the mysql command line before doing in code to make sure you
actually have the data you
On Tuesday, February 22, 2005 22:08, jsf wrote:
This may be more of a PHP question than a MySQL question but here
goes:
I have a small database with two tables in it. It's a database of
Botanical Gardens in the US.
Table 1 contains the botanical gardens and has 8 fields:
(I'm
At 19:32 +0100 12/13/04, Alina Bikowska wrote:
Description:
When I try to call mysql_init() several times in
my program it finishes with segmentation fault.
This happens in different places of my program but always in mysql_init().
This is the gdb output:
#0 0x007ba6ae in malloc_consolidate ()
Hello.
Cardinality of index is updated by running ANALYZE TABLE or
myisamchk -a. See:
http://dev.mysql.com/doc/mysql/en/SHOW_INDEX.html
I've created a table with several indexes as follows:
$query = CREATE TABLE `data_raw` (
id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
run_id VARCHAR(20)
It's not a simple question at all.
Your users actually DON'T talk to the database, your PHP application does.
Your users converse with your PHP code. Your web server will have one
layer of authentication just to allow the user to view the pages your site
is composed of. Assume for a second
The answer is you create one user for the PHP (webserver) process to
use.
Then you keep track of user permissions in your application code. This
probably involves creating your own user table within your own database
and storing users of your site there. Then in the other tables you
associate
Hi.
You may read:
http://dev.mysql.com/doc/mysql/en/JOIN.html
http://dev.mysql.com/doc/mysql/en/SELECT.html
There is a good description.
Searching in more than two tables (3 in my example) may be done
in such way:
select t1.* from t1,t2,t3 where t1.a=t2.a and t1.b=t3.b
But
Carolina wrote:
using mysql version 4.0.13
- **total newbie here**... something as simple as renaming a
database...i've not found anything relating to that on the mysql site
or anywhere else. what i have found is that in order to do this, i'd
have to shutdown and restart the mysql database in
At 11:16 -0500 10/7/04, gerald_clark wrote:
Carolina wrote:
using mysql version 4.0.13
- **total newbie here**... something as simple as renaming a
database...i've not found anything relating to that on the mysql site
or anywhere else. what i have found is that in order to do this, i'd
have to
As I mentioned in my post, I did wind up using a perl script, and I will
continue down that path in the future. I was mainly wondering about limits
to the mysql client for quick-n-dirty testing (as someone who is learning
MySQL, as opposed to developing for a production environment).
Thanks
On Wed, 29 Sep 2004 10:05:29 -0400, Ted Byrne [EMAIL PROTECTED] wrote:
Is the apparent line length limit a restriction imposed by the client? (And
does it apply if you are piping or redirecting output from another process
or a file?)
It sounds like you should either be using a scripting
Good binary storage article w/ sample code:
http://php.dreamwerx.net/forums/viewtopic.php?t=6
On Mon, 27 Sep 2004 16:47:37 -0500, Jack Taffar [EMAIL PROTECTED] wrote:
Is it possible to store an excel file into a blob field in mysql? If so how
do I go about importing the file into the blob
Many thanks for your reply Tom.
I will read it more closely over the week-end, but wanted to say thanks
straight away.
Kerry
-Original Message-
From: Tom Horstmann [mailto:[EMAIL PROTECTED]
Sent: 20 August 2004 15:52
To: 'Kerry Frater'; 'MySQL List'
Subject: RE: newbie question
Hi Kerry,
The problem is more fundamental with the scrolling through
the records/rows of Master. [..] It is not sensible to allow
200 million pieces of data to be transferred to the Delphi PC
to build a local Dataset to scroll through.
[..]
Getting the first row is easy
select * from
You created a nearly infinite loop!! Relax, it's a mistake we ALL have
made. ;-D
You start you loop at 1000 and keep increasing your numbers by 1 until they
become less than 10 (which should never happen). Eventually you will reach
the max value for @x's datatype then it should fail with an
[EMAIL PROTECTED] wrote:
Hi folks.
I've got MySQL running on a W2K dev box and want to run it on a production
Linux box.
Being new to Linux, I'm wondering what's the difference between the version
of MySQL that ships with a Linux distro and downloading it from the MySQL
website.
By way of
Don't quote me on this but I don't think it makes a difference what
datatypes you use with multiple languages (I never even considered it with
English, Japanese and Korean) as long as the field is large enough to handle
the multiple bytes. You might wish to check out the Unicode support pages
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 10, 2004 11:29 PM
To: Ian Izzard
Cc: Rocar Peças; [EMAIL PROTECTED]
Subject: Re: Newbie question on Comparing fields in 2 tables?
An equivalent, but slightly simpler, query would be
SELECT sw.pcname, sw.product
FROM software sw, keywords kw
Mr. Izzard,
We have these tables:
Table software
- pcname char(..)
- product char(..)
Table keywords
- id int(..)
- seachname char(...)
and you want to pick out the pcname from the software table, where the
An equivalent, but slightly simpler, query would be
SELECT sw.pcname, sw.product
FROM software sw, keywords kw
WHERE sw.product RLIKE kw.Searchname
RLIKE is for regular expression pattern matching. Regular expressions,
unlike LIKE patterns, don't have to match the whole string, so there
Donny Simonton [EMAIL PROTECTED] writes:
But as a manager, the first thing I do is ask for code examples, as well as
table structures. I don't even need to see a resume once I look at
somebody's code and table structures.
Unfortunately I will have to disagree with you on this one. Having
Dear Brad,
Your problem is too much experiences not the lack of skills.
I am in the same situation...it is very frustating.
Regards,
Bernard
On Monday 23 February 2004 11:14, Brad Eacker wrote:
Donny Simonton [EMAIL PROTECTED] writes:
But as a manager, the first thing I do is ask for code
Bernard Clement [EMAIL PROTECTED] writes:
Your problem is too much experiences not the lack of skills.
I am in the same situation...it is very frustating.
Bernard,
It appears I'm not the only one :( Though such an observation
makes me wonder if it may be a case of age discrimination being
, 2004 12:10 AM
Subject: Re: Newbie question
- Original Message -
From: Walt [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, February 19, 2004 8:00 AM
Subject: Newbie question
I need a little advice on where to get started. I want to create a db and
simple form
program are definitely your best
bets from the technologies you mentioned.
Just my two cents worth,
Rhino
- Original Message -
From: Walt [EMAIL PROTECTED]
To: Rhino [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Sunday, February 22, 2004 2:45 PM
Subject: Re: Newbie question
I recently
-Original Message-
From: Walt [mailto:[EMAIL PROTECTED]
Sent: Sunday, February 22, 2004 1:46 PM
To: Rhino; [EMAIL PROTECTED]
Subject: Re: Newbie question
I recently graduated from college, BS in computer science, I am familiar
with a variety of languages including C++, Java, VB
' [EMAIL PROTECTED]; 'Rhino' [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Sunday, February 22, 2004 4:15 PM
Subject: RE: Newbie question
As a manager of over 20 programmers, I would say from a web point of via PHP
would be your best bet. Everybody who graduates today can program in Java
are in might only be looking for C
programmers, so you become a C programmer.
Just my opinion.
Donny
-Original Message-
From: Walt [mailto:[EMAIL PROTECTED]
Sent: Sunday, February 22, 2004 7:52 PM
To: Donny Simonton; 'Rhino'; [EMAIL PROTECTED]
Subject: Re: Newbie question
Those
From: Walt [EMAIL PROTECTED]
To: Donny Simonton [EMAIL PROTECTED], 'Rhino' [EMAIL PROTECTED], [EMAIL
PROTECTED]
Date: Sun, Feb-22-2004 5:54 PM
Subject: Re: Newbie question
Those were my exact thoughts being a former cne and msce. I know how to write the
code whatever form I want
- Original Message -
From: Walt [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, February 19, 2004 8:00 AM
Subject: Newbie question
I need a little advice on where to get started. I want to create a db and
simple form that will populate the db. Which language is best? What
Rhino [EMAIL PROTECTED] wrote:
I'm confused. According to your note and to a passage I found in the manual,
InnoDB support is installed in all 4.0.x versions of MySQL, which should
obviously include my 4.0.11 install. Yet SHOW_VARIABLES LIKE 'have_innodb'
returned NO. Why? It would appear that
Please, reply to the mailing list, not to me directly.
Date: Sat, 14 Feb 2004 09:11:14 -0500
From: Rhino [EMAIL PROTECTED]
To: Egor Egorov [EMAIL PROTECTED]
Subject: Re: Newbie Question
Thanks Egor! I ran the query you suggested and it said 'NO' so the server
was apparently configured without
On Feb 16, 2004, at 6:18 AM, Egor Egorov wrote:
Please, reply to the mailing list, not to me directly.
How many times do we have to see this sort of comment before the list
administrators realize that not setting the Reply-to: header to the
list address is doing the community a great
: Egor Egorov [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, February 16, 2004 6:18 AM
Subject: Re: Newbie Question
Please, reply to the mailing list, not to me directly.
Date: Sat, 14 Feb 2004 09:11:14 -0500
From: Rhino [EMAIL PROTECTED]
To: Egor Egorov [EMAIL PROTECTED]
Subject: Re
, February 16, 2004 8:50 AM
Subject: Re: Newbie Question
On Feb 16, 2004, at 6:18 AM, Egor Egorov wrote:
Please, reply to the mailing list, not to me directly.
How many times do we have to see this sort of comment before the list
administrators realize that not setting the Reply-to: header
-
From: Ed Leafe [EMAIL PROTECTED]
To: MySQL List [EMAIL PROTECTED]
Sent: Monday, February 16, 2004 8:50 AM
Subject: Re: Newbie Question
On Feb 16, 2004, at 6:18 AM, Egor Egorov wrote:
Please, reply to the mailing list, not to me directly.
How many times do we have to see this sort
PROTECTED]
To: Rhino [EMAIL PROTECTED]
Cc: mysql [EMAIL PROTECTED]
Sent: Friday, February 13, 2004 6:44 PM
Subject: Re: Newbie Question
might be as simple as putting a space after your closing parenthesis on
the create table statement.
either that, or your mysql install somehow doesn't have innodb
[EMAIL PROTECTED]
To: Rhino [EMAIL PROTECTED]
Cc: mysql [EMAIL PROTECTED]
Sent: Friday, February 13, 2004 6:44 PM
Subject: Re: Newbie Question
might be as simple as putting a space after your closing parenthesis on
the create table statement.
either that, or your mysql install somehow doesn't
, February 16, 2004 1:18 PM
Subject: Re: Newbie Question
well, somewhere the documentation for mysql indicates that you need
mysql-max in order to get InnoDB support. we made a special point of
making sure we got the mysql-max binary specifically because of InnoDB.
Really? Could you point it out
Rhino [EMAIL PROTECTED] wrote:
I'm new to MySQL but I have extensive experience with DB2 so I'm getting
quite confused about how MySQL is supposed to work.
I am using MySQL 4.0.11 on a Linux server running RedHat 9.2. I am
trying to create a pair of InnoDB tables that are related to one
might be as simple as putting a space after your closing parenthesis on
the create table statement.
either that, or your mysql install somehow doesn't have innodb table
support. have you edited your my.cnf file and enabled the innodb
parameters, specifically log and data files?
Rhino wrote:
On Wednesday, February 11, 2004, at 03:29 PM, Keith Warren wrote:
I want to be able to track how many times any particular record is
returned from a search, and I have two ideas about how to do this. But
because I have little experience with MySQL, I may be totally off base.
This database is
on 12/29/03 9:54 AM, Dave G wrote:
$wsQuery = SELECT improvwsid FROM improvws WHERE wsdate ' . $today
. ' AND wsdate ' . $sevenDays . ' AND cancelled = 0;
$wsResult = mysql_query($wsQuery);
$wsid = mysql_result($wsResult, 0, improvwsid);
$emailQuery = SELECT members.email AS email,
One extra join will do it. You're looking for all improvws in
the next seven days that aren't cancelled, right?
Yes... thank you. I see where I was going wrong now. The extra joins I
needed were to match the wsid to the member.id by matching both to where
they appear in the attend table.
Why do you want to store the results of a calculation?
Don't store the results of a calculation, instead do the calculation when
you are retreiving data.
For example SELECT field1, field2, field1 + field2 AS sum_of_the_two_fields
FROM your_table
Also, it is a good idea to give good names to your
On 27 Dec 2003, at 08:59, daryl hansen wrote:
How do I make Field3 a calculation, which equals 2 if fields 1 2
where values set to 1? Any pointers in the right direction would be
sincerely appreciated.
Take a look at 6.3.1.3 and 6.3.1.4 in the MySQL documentation for
logical operators and
On 27 Dec 2003, at 21:04, daryl hansen wrote:
I can't find anything in the manual about proper syntax for this when
creating a table. All I want is my Price field to equal the total of
my Adults and Children fields. Can someone please draw me a
picture?
CREATE TABLE Cart (
ID bigint
You need to set up the initial privileges. Just follow the directions here:
http://www.mysql.com/doc/en/Default_privileges.html
Note: you shouldn't need to run mysql_install_db if you installed the rpm.
(I think)
-Original Message-
From: James Marcinek [mailto:[EMAIL PROTECTED]
Sent:
Hi Peter,
You can probably safely have at least 1000-2000 tables in a single
database.
Hope that helps.
Matt
- Original Message -
From: peter
Sent: Friday, November 28, 2003 12:03 PM
Subject: newbie question
Hi
I am a webdesigner/hosting reseller
my question is this:
I am
- Dathan Vance Pattishall
- Sr. Programmer and mySQL DBA for FriendFinder Inc.
- http://friendfinder.com/go/p40688
---Original Message-
--From: joffrey leevy [mailto:[EMAIL PROTECTED]
--Sent: Wednesday, November 12, 2003 9:58 AM
--To: [EMAIL PROTECTED]
--Subject: newbie question on
I guess that's because you don't have the privilege to create a database.
Make sure you're using the *right* account to create the database.
cheers,
feng
- Original Message -
From: ddonahoe [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, October 06, 2003 4:17 PM
Subject: Newbie
On Fri, 29 Aug 2003 01:02:57 -0400 (EDT)
Jordan Morgan [EMAIL PROTECTED] wrote:
Hi,
I'm very new to MySQL. I normally use MS Access but my project needs
MySQL. I'm able to set a field(categoryID) in table A(product) a lookup
field to another table(category) in Access but I can't find
On Tue, 26 Aug 2003 17:00:16 -0400
Nicola Hartland [EMAIL PROTECTED] wrote:
When I do the tests on frontpage, it doesn't seem to do anything.
what test are you talking about?
On the Mysqladmin it tells me that my odbc driver 3,.51 not found is that a problem
and how do I get the driver?
you
When I do the tests on frontpage, it doesn't seem to do anything.
what test are you talking about?
I am reading the Book PHP and MYsql for dummies and it talks of a test you can do to
see if PHP and SQL are talking with each other.
On the Mysqladmin it tells me that my odbc driver 3,.51 not
On Wed, 27 Aug 2003 09:33:38 -0400
Nicola Hartland [EMAIL PROTECTED] wrote:
I am reading the Book PHP and MYsql for dummies and it talks of a test you can do to
see if PHP and SQL are talking with each other.
hmm..
you will have to excuse my ignorance what Is a mysql_*;function as I said I
track here? What would be the correct way to design this db?
Thanks for the help.
Brent
-Original Message-
From: Adam Fortuno KOVICK [mailto:[EMAIL PROTECTED]
Sent: Friday, August 01, 2003 2:13 PM
To: [EMAIL PROTECTED]
Cc: MySQL List
Subject: Re: RE: Newbie question...memo field
Brent
Its doesn't look like you are starting the process as root. Turn into
root then start the process. Then exit turn back into you're user
account and use mysql.
Regards,
A$
- Original Message -
From: Jbo [EMAIL PROTECTED]
Date: Thursday, July 31, 2003 10:26 pm
Subject: Newbie question
1 - 100 of 208 matches
Mail list logo
