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 |
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 multi
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 th
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
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
--
My
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 1
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 wrong.)
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 happ
>-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 lin
6, 2009 11: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
base Administrator (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: N
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 did
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 w
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
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 wrote:
> This is on a Mac OS X (v10.5.6) s
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 wrote:
> This is on a Mac OS X (v10.5.6) system in case that matters.
>
>
>
> 1. - MySQL Administrator Help button says:
>
> HELP
>
> H
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
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 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 =
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:
> 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, $dat
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 netwo
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
> '
[mailto:[EMAIL 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 s
ately, time is running out.
>
> TIA,
>
> Joseph "Tito" Kraer
> Business Systems Analyst
> Taylor, Bean & Whitaker Mortgage Corp
>
> -Original Message-
> From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, December 0
uot;Tito" Kraer
> Business 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: listin
ss 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
Hello.
> Ple
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 h
Kraer, Joseph wrote:
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 ( condition, va
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. WHE
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, T
seph "Tito" Kraer
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 Questio
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,
mela
"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 condition
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 1
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 by
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, The
PROTECTED]>
Cc:
Sent: Monday, November 14, 2005 8:19 PM
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 fiel
> > 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.
--
Sco
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 index
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" erro
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
getti
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 ali
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'
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 need
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 th
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 it
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 using
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 shut
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 orde
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 fo
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 script
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 b
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"'
S
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
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 error
[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 example:
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 o
assen [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, keywor
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 is
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
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 be
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 co
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. Havi
---Original Message
> From: "Walt" <[EMAIL PROTECTED]>
> To: "Donny Simonton" <[EMAIL PROTECTED]>, "'Rhino'" <[EMAIL PROTECTED]>, <[EMAIL
> PROTECTED]>
> Date: Sun, Feb-22-2004 5:54 PM
> Subject: Re: N
market you 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
ROTECTED]>
To: "'Walt'" <[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 vi
.
Donny
> -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 variet
no opinion.
Overall, I'd say a Java servlet or a Perl 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]>; &l
<[EMAIL PROTECTED]>
Sent: Friday, February 20, 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
- 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? W
"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 appe
"mysql" <[EMAIL PROTECTED]>
Sent: Monday, 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 specifi
is" <[EMAIL PROTECTED]>
To: "Rhino" <[EMAIL PROTECTED]>; "mysql" <[EMAIL PROTECTED]>
Sent: Monday, February 16, 2004 11:15 AM
Subject: Re: Newbie Question
its possible it was never installed for some reason. did you install the
mysql binary? you may sim
appreciate it.
Rhino
- Original Message -
From: "Jeff Mathis" <[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
o
- Original Message -
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, no
"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 of comm
ification ;-)
Rhino
- Original Message -
From: "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 Fe
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 disservice
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
&g
"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
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:
I'
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
> 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. Prev
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 A
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 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 bi
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 a
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: Sa
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
- 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 questio
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: New
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 fin
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
>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 no
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
atement, temp);/*Quotes Close*/
}
else /*else filed has no value*/
{
append_insert(4,"NU
is 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,
Maybe but give us more information. I know you moving
1 - 100 of 216 matches
Mail list logo