honestly... i don't even know. =( i'm new to mysql...
how would i check?
-jg
-Original Message-
From: Jasper Bryant-Greene [mailto:[EMAIL PROTECTED]
Sent: August 20, 2005 2:18 AM
To: mysql@lists.mysql.com
Subject: Re: need help with foreign keys, new to mysql
Yes but is the MySQL
Le vendredi 19 août 2005 à 21:09 -0500, John Gonzales a écrit :
Hi John,
#1005 - Can't create table '.\mydatabase\comments.frm' (errno: 150)
I've seen this error before.
now before i go and do something stupid, i thought i might ask for some help
on this issue :D both my blog and
.
-Original Message-
From: Thurgood Alex [mailto:[EMAIL PROTECTED]
Sent: August 20, 2005 3:22 AM
To: John Gonzales
Cc: mysql@lists.mysql.com
Subject: Re: need help with foreign keys, new to mysql
Le vendredi 19 août 2005 à 21:09 -0500, John Gonzales a écrit :
Hi John,
#1005 - Can't create table
John Gonzales wrote:
i am creating my own little blog and i am trying to create a comments table
that uses the primary key of my blog table as a foreign key. i've tried the
only two ways that i know how and both ways yielded the same error:
#1005 - Can't create table '.\mydatabase\comments.frm'
Sorry to reply to my own message, but I meant to add that you can read about
defining foreign key constrints in the manual
http://dev.mysql.com/doc/mysql/en/innodb-foreign-key-constraints.html.
Michael
Michael Stassen wrote:
There are a few possibilities here:
1. Both tables must be InnoDb.
check the permissions on the mysql data dir, may be the user mysql or
who ever runs mysql does not have sufficient privileges
Kishore Jalleda
On 8/19/05, John Gonzales [EMAIL PROTECTED] wrote:
i am creating my own little blog and i am trying to create a comments table
that uses the primary key
Hi Shreedjhar,
Are you aware of this paper ?
http://www.fabalabs.org/research/papers/FabalabsResearchPaper-OSDBMS-Eval.pdf
It may perfectly answer most of your questions.
Best regards
Nils valentin
Tokyo / Japan
http'//www.be-known-online.com
On Saturday 18 June 2005 22:01, madderla
At 09:01 AM 6/18/05, madderla sreedhar wrote:
Isn't MySql supports large amounts of data to be stored in
databases. What is the maximum number of records that
can be handled or stored in Mysql. Is there any limit. If i
want to store large amounts of data then is it necessary
to migrate to
Hi,
all binary docs can be inserted in blob columns.
see this link for a php insert method :http://www.phpcs.com/code.aspx?ID=30945
this is mysql doc : http://dev.mysql.com/doc/mysql/en/blob.html
Mathias
Selon madderla sreedhar [EMAIL PROTECTED]:
Sir ,
Iam working on Mysql5.0 version.
Can
Cory Robin [EMAIL PROTECTED] wrote on 16/06/2005 08:09:22:
I need to speed up a search, big time.
I have an application that searches for records on a date field. If it
doesn't find an exact date match, it keeps searching adjacent days until
it
finds a certain amount of records.
The
[EMAIL PROTECTED] wrote on 06/16/2005 11:30:10 AM:
Cory Robin [EMAIL PROTECTED] wrote on 16/06/2005 08:09:22:
I need to speed up a search, big time.
I have an application that searches for records on a date field. If
it
doesn't find an exact date match, it keeps searching adjacent
[EMAIL PROTECTED] wrote on 16/06/2005 16:29:46:
[EMAIL PROTECTED] wrote on 06/16/2005 11:30:10 AM:
Cory Robin [EMAIL PROTECTED] wrote on 16/06/2005 08:09:22:
I need to speed up a search, big time.
I have an application that searches for records on a date field. If
it
At 03:09 AM 6/16/05, Cory Robin wrote:
I need to speed up a search, big time.
I have an application that searches for records on a date field. If it
doesn't find an exact date match, it keeps searching adjacent days until it
finds a certain amount of records.
The problem now is, I'm using my
Ashok
is it possible to embed that dll
file with my project itself, rather than adding the
path to env path var. when i'll try to run that means
it never ask for the path. Is it possible?
There are 3P tools which do that (Google for embed dll), but wouldn't
it be simpler to put the dll in
well - that was what I tried first - but that does not work because that
returns the latest date for which the task_id has a record as Assignment.
(It is like it picks up the max date from all records that have
name_rec_type as Assignment)
But I wanted was if the date corresponding to the
OK - I have found the cause of the inconsistency -
Whenever I have more than one record which has name_rec_type as 'Assignment'
I do not get any results (I get an empty result)
But if I have only one Assignment record then it returns the correct row.
Question is: How can I overcome this - I
SOLVED:
I changed my query to include max(t1.dt_aud_rec) instead of t1.dt_aud_rec.
I had guessed that it required just a tweak here and there...
Does anybody have any other suggestions apart from this??
Thanks,
Anoop
On 6/2/05, Anoop kumar V [EMAIL PROTECTED] wrote:
OK - I have found the
Hi,
Try just :
SELECT id_secr_rqst task_id, MAX(dt_aud_rec) AS latest
FROM isr2_aud_log WHERE
name_rec_type = 'Assignment' AND id_secr_rqst
='TASK23C6054B9D416C08:1284FD4:103FB047DF1:-7ECF'
GROUP BY id_secr_rqst
;
++-+
| task_id
http://dev.mysql.com/doc/mysql/en/mysql-config.htmle=9888
If you have questions, try http://dev.mysql.com/doc/mysql/en/index.html
first as you will often find the answer there. BTW this manual is for the
latest version that you are using.
Hi,
Iam using Mysql5.04
What does it mean,
To
Hello.
in this,is mysql_config file is same as my.ini and
On Unix mysql_config reports various settings that may
be needed when using the MySQL client library. Read in
the PHP documentation how to install extensions for Windows
binaries of PHP.
madderla sreedhar [EMAIL
Are you getting a MySQL error?
On 5/17/05, madderla sreedhar [EMAIL PROTECTED] wrote:
Hi,
Iam using php 5.0, IIS 5.0, Mysql 5.04 ,win2000 NT
and IE as web browser and executed the php
script,but got a fatal error describing that
undefined fuction mysql_connect() in the file and
not
Iam using php 5.0, IIS 5.0, Mysql 5.04 ,win2000 NT
and IE as web browser and executed the php
script,but got a fatal error describing that
undefined fuction mysql_connect() in the file and
not getting the desired output.
This is not a MySQL problem/issue. The error undefined function
[snip]
in it, it gives fatal error undefined function
Mysqli_connect() on line no etc.,, in browser.
IS that correct, can I use Mysqli functions in
this because I am using Mysql 5.04 (beta) version
in PHP documentation it was told that those who
are
using Mysql 4.0 or higher can use Mysqli in
[snip]
I read the instalation document particulary but I didn't understand it.
They told --with-mysql
[=dir] configuration option where it is found or where I should type
that please give details so that mysql will works And on thing I want to
know is I want MYSQLI (extenstion of MYSQL ) in php
It seems like you got the same problem' as me :
Php (? ) do not have the librairies include, and you need to run a kink of
daemon in order to make t works.
Under linux, it is just a question of the good rpm to install (for me it was
php-mysql-4.3.9-3.i386.rpm).
Under windows, you'll need to
The folks at http://us4.php.net/mailing-lists.php can help you.
In PHP 5, MySQL is no longer enabled by default, nor is the MySQL
library bundled with PHP.
http://us4.php.net/manual/en/faq.databases.php#faq.databases.mysql.php5
kgt
CIKALA Frédéric ROSI/SIPROD wrote:
It seems like you got the
madderla sreedhar [EMAIL PROTECTED] wrote on 05/02/2005 03:10:07 AM:
Can u please execute the following procedure in MySql
and tell me where I had gone wrong because on my
system the same code is giving error near line
:= 'TRUE'
CREATE PROCEDURE cart_items_validate
(IN mcustid INT
Madderla,
1. Var assignments need SET, ie SET mvariable = ...
2. Missing semicolon after 'TRUE'
PB
-
madderla sreedhar wrote:
Can u please execute the following procedure in MySql
and tell me where I had gone wrong because on my
system the same code is giving error near line
:= 'TRUE'
Shawn, Madderla,
Don't you need to DECLARE the variable "mvalidate" before you can
use it?
It's declared as OUT mvalidate varchar(10).
PB
-
[EMAIL PROTECTED] wrote:
madderla sreedhar [EMAIL PROTECTED] wrote on 05/02/2005 03:10:07 AM:
Can u please execute the following
Original Message
Subject: Re: Need help w/ re-starting Replication
From: Atle Veka [EMAIL PROTECTED]
Date: Fri, April 29, 2005 5:20 pm
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
On Fri, 29 Apr 2005 [EMAIL PROTECTED] wrote:
I set up replication and it was working fine
Your questions (this one and the other one that you posted at the same time)
are not very clear so I am really not sure what you want.
However, if you are asking about creating a package for your Java source
code, this has nothing to do with MySQL: there is no special technique for
creating a
Hi Sreedhar, all!
madderla sreedhar wrote:
--- Joerg Bruehe [EMAIL PROTECTED] wrote:
Hi!
[[...]]
The manual states clearly:
Stored procedures and functions are a new feature
in MySQL version 5.0.
(At the proper place: 19 Stored Procedures and
Functions)
Sreedhar, if you have a follow-up
On Fri, 29 Apr 2005 [EMAIL PROTECTED] wrote:
I set up replication and it was working fine but I re-created my master
database (droped and created empty tables) and now my replication
doesn't work. I checked the status of master and slave and they think
they are in sync but when I add a new
Hi!
madderla sreedhar wrote:
Hi,
Iam looking to migrate an Oracle database to MySQL and
trying to write a simple stored procedure in MySQL 4.1
The manual states clearly:
Stored procedures and functions are a new feature in MySQL version 5.0.
(At the proper place: 19 Stored Procedures and
Hello.
Have you ran mysql_init_db on a new data directory?
store the tables that store grants and such, but how to we get those
created for the new instance. We've been all over the MySQL.com docs
It is unclear for me. You may specify the datadir for every new
instance. See:
Dinesh,
A stored func returns a scalar. To return multiple values, use an sproc
declaring the INOUT variables you need, pick up their values in
the calling code after the sproc has executed.
Peter Brawley
http://www.artfulsoftware.com
-
Anchan, Dinesh wrote:
Hi,
I am
function;
Thank you for your help
Dinesh
From: Peter Brawley [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 07, 2005 12:24 PM
To: Anchan, Dinesh
Cc: mysql@lists.mysql.com
Subject: Re: Need help in Stored procedures and functions
Dinesh,
A stored func returns
Cc: mysql@lists.mysql.com
Subject: Re: Need help in Stored procedures and functions
Dinesh,
A stored func returns a scalar. To return multiple values, use an sproc
declaring the INOUT variables you need, pick up their values in the
calling code after the sproc has executed.
Peter
PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 07, 2005 4:03 PM
To: Anchan, Dinesh
Cc: mysql@lists.mysql.com; [EMAIL PROTECTED]
Subject: RE: Need help in Stored procedures and functions
Anchan, Dinesh [EMAIL PROTECTED] wrote on 04/07/2005
03:44:07 PM:
Peter,
Thank you for your reply
Cc: mysql@lists.mysql.com
Subject: Re: Need help in Stored procedures and functions
Dinesh,
A stored func returns a scalar. To return multiple values, use an sproc
declaring the INOUT variables you need, pick up their values in the
calling code after the sproc has executed.
Peter Brawley
http
---
From: Rhino
Subject: Re: Need help coverting MDB SQL
Sent: Mar 26 2005 10:26:58
- Original Message -
From: Ricky Groleau
To:
Sent: Saturday, March 26, 2005 10:13 AM
Subject: Need help coverting MDB SQL
Hello,
I have tried and i have failed. I am
Dinesh,
Do you have something like
DELIMITER |
before the CREATE PROCEDURE call, and
|
DELIMITER ;
after it?
Peter Brawley
http://www.artfulsoftware.com
-
Anchan, Dinesh wrote:
Hi,
I am looking to migrate an Informix database to MySQL and trying to
write a simple stored
but i will get there.
Thanks for your help.
Dinesh
From: Peter Brawley [mailto:[EMAIL PROTECTED]
Sent: Friday, April 01, 2005 12:03 PM
To: Anchan, Dinesh
Cc: mysql@lists.mysql.com
Subject: Re: Need help with Stored Procedures iin MySQL 5.0.3-beta
Dinesh,
Do
]]
Sent: Friday, April 01, 2005 12:03 PM
To: Anchan, Dinesh
Cc: mysql@lists.mysql.com
Subject: Re: Need help with Stored Procedures iin MySQL
5.0.3-beta
Dinesh,
Do you have something like
DELIMITER |
before the CREATE PROCEDURE call, and
|
DELIMITER ;
after it?
Peter Brawley
http
it to my sever, but I am lost..is
it the IP or web address? Where is SQL hidden on a linux/apache server?
---Original Message---
From: Rhino
Subject: Re: Need help coverting MDB SQL
Sent: Mar 26 2005 10:26:58
- Original Message -
From: Ricky Groleau
To:
Sent: Saturday, March 26, 2005
- Original Message -
From: David Blomstrom [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Tuesday, March 29, 2005 11:29 PM
Subject: Need Help with 813-MDB File
I acquired a CD-ROM that lists many thousands of
animal species. The main file is a 813-MB MDB file.
I'm not sure if
Is there a description of tables anywhere on CD-ROM for Access database.
Mikhail
-Original Message-
From: Rhino [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 30, 2005 9:10 AM
To: David Blomstrom; mysql@lists.mysql.com
Subject: Re: Need Help with 813-MDB File
- Original Message
.
Mikhail
-Original Message-
From: Rhino [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 30, 2005 9:10 AM
To: David Blomstrom; mysql@lists.mysql.com
Subject: Re: Need Help with 813-MDB File
- Original Message -
From: David Blomstrom [EMAIL PROTECTED]
To: mysql
PROTECTED]
Sent: 30 March 2005 06:23
To: mysql@lists.mysql.com
Subject: RE: Need Help with 813-MDB File
Thanks for both your tips. I discovered by chance that
Navicat (which I have) will do the conversion - very
easily. Whether or not it will be a success is hard to
say; it's loaded nearly 3
David Blomstrom wrote:
I acquired a CD-ROM that lists many thousands of
animal species. The main file is a 813-MB MDB file.
I'm not sure if it's a spreadsheet or database, but
it's apparently designed to work with Microsoft
Access, which I THINK is a spreadsheet. (I don't have
it.)
I have just
DB Tools software will convert the file for you. You can download it at
http://dbtools.com.br/EN/index.php. All you have to do is download and
install the FreeWare version and then use the TOOLS DAO Import Wizard.
J.R.
-Original Message-
From: David Blomstrom [mailto:[EMAIL PROTECTED]
Thanks for both your tips. I discovered by chance that
Navicat (which I have) will do the conversion - very
easily. Whether or not it will be a success is hard to
say; it's loaded nearly 3 million rows so far, with
over 8,000 errors recorded.
But I'm going to download DB Tools, as I have frequent
David Blomstrom wrote:
Thanks for both your tips. I discovered by chance that
Navicat (which I have) will do the conversion - very
easily. Whether or not it will be a success is hard to
say; it's loaded nearly 3 million rows so far, with
over 8,000 errors recorded.
3 million records in an
I have been using SQLyog for quite some time now to
import data from Access and SQL Server database.
www.webyog.com
Regards,
Karam
--- Ricky Groleau [EMAIL PROTECTED] wrote:
Hello,
I have tried and i have failed. I am trying to help
out a non-profit site in their move. The old site
. There must be
some documentation on how to use MDB files and get data from them.
Rhino
- Original Message -
From: Ricky Groleau
To: Rhino ; Ricky Groleau ; mysql@lists.mysql.com
Sent: Saturday, March 26, 2005 10:35 AM
Subject: Re: Need help coverting MDB SQL
- Original Message -
From: Ricky Groleau [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Saturday, March 26, 2005 10:13 AM
Subject: Need help coverting MDB SQL
Hello,
I have tried and i have failed. I am trying to help out a non-profit site
in their move. The old site had a
..is it the IP or
web address? Where is SQL hidden on a linux/apache server?
---Original Message---
From: Rhino
Subject: Re: Need help coverting MDB SQL
Sent: Mar 26 2005 10:26:58
- Original Message -
From: Ricky Groleau
To:
Sent: Saturday, March 26, 2005 10:13 AM
Subject
on how to use MDB files
and get data from them.
Rhino
- Original Message -
From:
Ricky Groleau
To: Rhino ; Ricky Groleau ; mysql@lists.mysql.com
Sent: Saturday, March 26, 2005 10:35
AM
Subject: Re: Need help coverting MDB
SQL
Microsofts Acesss that makes ASP
PROTECTED]
Sent: 26 March 2005 19:28
To: Ricky Groleau; mysql@lists.mysql.com
Subject: Re: Need help coverting MDB SQL
Sorry, I don't know how to help you with this; I've never really worked
with MDB files or ASPs. I have no experience with the tools that you are
using to extract data
-Original Message-
From: Daevid Vincent
Sent: Friday, February 11, 2005 14:32
To: mysql@lists.mysql.com
Subject: Need help with historic aggregation of data
I need to get the aggregate data from various tables for a report.
The idea is that we audit devices daily on a schedule,
select test, max(audit_date)
from your_table
where device = 1
group by test
order by 1
--- Daevid Vincent [EMAIL PROTECTED] wrote:
I need to get the aggregate data from various tables
for a report.
The idea is that we audit devices daily on a
schedule, and also allow users
to audit the
You should *ALWAYS* indicate which version of MySQL you are using when you
ask this sort of question; the answers is almost always it depends: if you
are using 3.x, do X, if you are using 4.0.x do Y, if you are using 4.1.x do
Z. It's a lot of work to list all of those options and most people won't
On 1/20/05 11:16 AM, Rhino [EMAIL PROTECTED] wrote:
You should *ALWAYS* indicate which version of MySQL you are using when you
ask this sort of question; the answers is almost always it depends: if you
are using 3.x, do X, if you are using 4.0.x do Y, if you are using 4.1.x do
Z. It's a lot
Mike Zornek [EMAIL PROTECTED] wrote on 01/20/2005 11:01:38 AM:
I have the following query which will get me all of the emails for my
current membership:
SELECT email.email_address
FROM member, email
WHERE
member.member_primary_email_id = email.email_id
AND member.member_standing !=
Cc: Rhino [EMAIL PROTECTED]
Sent: Thursday, January 20, 2005 11:26 AM
Subject: Re: Need help forming SQL query
On 1/20/05 11:16 AM, Rhino [EMAIL PROTECTED] wrote:
You should *ALWAYS* indicate which version of MySQL you are using when
you
ask this sort of question; the answers is almost
There is one record in the Events table for each event that an organization
is promoting. For each event, there could be 0 to 'n' files that give more
information about the event, such as pictures, audio clips, or whatever. I
want to display all the information about the event, including all
- Original Message -
From: Rhino [EMAIL PROTECTED]
To: mysql mysql@lists.mysql.com
Sent: Thursday, December 30, 2004 9:03 AM
Subject: Need help with SELECT
I am trying to think of SQL that will let me show a one to many
relationship
as a single row in a result set. They say a picture
Grant Giddens wrote:
I have a new project I'm working for and I was
wondering if anyone could help me optimize my selects
for speed. I have a table with about 500,000 entries.
The table structure I'm using is (via my PHP
commands):
$sql = CREATE TABLE $store_data_table (
Your original query (implicit INNER JOINs):
SELECT teu.name, eca.owner_id, ece.value
FROM typed_enterprise_unit teu,
e_contact_association eca,
e_contact_entry ece
WHERE teu.unit_id=eca.owner_id
and eca.entry_id=ece.entry_id
and eca.type_id=68
and
Are you assuming that all months have 30 days? You can use the same syntax
with INTERVAL 1 MONTH
I would also format the date comparison to use the same precision that the
DATE_ADD function outputs.
So,
DATE_ADD(table.date, INTERVAL 1 MONTH) = DATE_FORMAT(CURDATE(), '%Y-%m-%d')
I might be off
Redmond Militante wrote:
hi
i need advice on a query i'm trying to do. i'm trying to find
entries with that are about to expire. entries expire if their date
of submission is older than 60 days. i want to find all entries with
a date of submission greater than 30 days, or those that are going
David Perron wrote:
Are you assuming that all months have 30 days? You can use the same syntax
with INTERVAL 1 MONTH
True.
I would also format the date comparison to use the same precision that the
DATE_ADD function outputs.
Why would you do that? The date column contains a DATE. CURDATE()
awesome. thank you!
[Wed, Aug 25, 2004 at 06:27:38PM -0700]
This one time, at band camp, David Perron said:
Are you assuming that all months have 30 days? You can use the same syntax
with INTERVAL 1 MONTH
I would also format the date comparison to use the same precision that the
select name
from mytable a
where changedate
(select changedate
from mytable b
where a.name=b.name
and a.changedate != b.changedate);
or:
select name
from mytable a
where exists
(select * from mytable b
Hi Claire,
On Mon, 23 Aug 2004 14:52:29 -0700 (PDT), Claire Lee [EMAIL PROTECTED] wrote:
Hi,
Here's a table of mine
namedate changeDate
n1d1 cd1
n2d1 cd3
n2d2 cd1
n4d1 cd2
n1d2 cd5
n5d1
You were so very close to getting what you wanted!
What is causing the problem is the comma (,) in your FROM clause. MySQL
permits two methods of declaring an INNER JOIN. The first is by using the
keyphrase INNER JOIN the second is with a comma in your table list. Here
is how to rephrase your
To get http://www.google.com/; out of the URL, you can do this:
LEFT( referer, LENGTH( SUBSTRING_INDEX( referer, '/', 3 ) ) + 1 )
If you don't care about the trailing slash, you can use just the
SUBSTRING_INDEX() portion:
SUBSTRING_INDEX( referer, '/', 3 )
Using the LENGTH() function just helps
Just a follow-up oops...
I misread the manual page when verifying the SUBSTRING_INDEX() syntax.
It states that it returns everything before _count_ instances of the
delimiter, so naturally if you feed it a value that exceeds the actual
instances of the delimiter, you get back the whole
On 15 Jul 2004 at 6:27, Patrick Drouin [EMAIL PROTECTED]
wrote:
I'm having a hard time with the following query. It
retrieves about 3K rows from a few tables. One of them
contains over 40M rows. When run on a 3Ghz server with
1G of RAM it returns the rows in more than 1 mini. I
don't think
Bonjour Arnaud,
--- Arnaud [EMAIL PROTECTED] wrote:
On 15 Jul 2004 at 6:27, Patrick Drouin
Your indexes look good, but I see that you have some
varchar fields.
Maybe
you could run an optimize table on these tables?
I'm running it at the moment, I will follow-up on the
list when it's done.
What version of MySQL are you using? Have you checked the cardinality on
these tables?
-Original Message-
From: Patrick Drouin
To: [EMAIL PROTECTED]
Sent: 7/15/04 8:27 AM
Subject: Need help optimizing query
Hello everyone,
I'm having a hard time with the following query. It
retrieves
Hello Victor,
What version of MySQL are you using? Have you
checked the cardinality on
these tables?
Problem solved! Optimizing the table brought the query
time down to 17 secs Wow!
Thanks for the input Victor and merci to Arnaud for
the quick fix.
Patrick
It sounds like you are missing indexes.
Please post the results of -
SHOW CREATE TABLE ImportLiebermansStep3Add;
- and -
SHOW CREATE TABLE ProductsOld;
- and we can tell you if you have enough indexes or not.
Yours,
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Jeff
Why are you doing a LEFT JOIN instead of a INNER JOIN
right now you are getting all rows from first table regardless of match
condition so all of the rows for
a.ProductID FROM ImportLiebermansStep3Add
are being returned
try the inner join instead
Martin
- Original Message -
From: Jeff
man i didnt even know you can do this
AND s.date q.date
i assumed that goes in a where clause ?
-Original Message-
From: news [mailto:[EMAIL PROTECTED] Behalf Of Harald Fuchs
Sent: Wednesday, May 26, 2004 8:01 PM
To: [EMAIL PROTECTED]
Subject: Re: need help with a complicated join
:
Sent by: newsFax to:
[EMAIL PROTECTED]Subject: Re: need help with a
complicated join
rg
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; news
Subject: Re: need help with a complicated join
Harold, you win the EUREKA prize of the month!
I had forgotten all about that silly algebraic trick. This answers another
person's post from last week. (I will try to find it again) also looking
At 14:07 -0500 on 05/25/2004, [EMAIL PROTECTED] wrote about need
help with a complicated join:
I am trying to come up with a query that takes two tables, one with
non-split-adjusted historical stock prices, and one with information on
splits, for instance:
CREATE TABLE quotes (
symbol
You are beyond the realm of SQL. What you would need for something like
this is a dynamically-generated case statement that would apply different
multipliers based on the date of the quote you are trying to adjust. For
those quote values that exist BEFORE multiple splits you must adjust by the
Why not try to create a full text index on the column?
-Original Message-
From: jeroen clarysse
To: [EMAIL PROTECTED]
Sent: 4/16/04 9:00 AM
Subject: Need help with indexing !
Using mysql 3.23.53, i have a table with approx 1.000.000 records, and
only 3 columns. One of these (called
That did it. I really do appreciate all of the help that I received from you
and the list.
Thanks again. :)
-Original Message-
From: Michael Stassen [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 06, 2004 7:52 PM
To: Marvin Cummings
Cc: [EMAIL PROTECTED]
Subject: Re: Need help creating
Hi, the table name and the column names dont have to be inclosed by ' '.
Carlos
Original Message Follows
From: Marvin Cummings [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Need help creating table...
Date: Tue, 6 Apr 2004 12:29:48 -0400
_
From: Marvin Cummings
Marvin Cummings writes:
I attempt to create this table from the command line and get the following
error:
Marvin,
the use of the ' [single quote] appears to be your problem. I've
been able to create the table on 4.0.18 using the following syntax:
CREATE TABLE nuke_zc_ads
(
ad_id
Looks like you are using backticks instead of single quotes on your
column names. You don't really need the quotes on your table name or
column names anyway, so I'd just remove them.
On Tue, 2004-04-06 at 09:29, Marvin Cummings wrote:
_
From: Marvin Cummings [mailto:[EMAIL
Marvin Cummings wrote:
I attempt to create this table from the command line and get the following
error:
Error 1064 (42000): You have an error in your SQL syntax. Check the manual
that corresponds to your MySQL version for the right syntax to use near
''ad_id' smallint(5) unsigned NOT NULL
Sorry. I can imagine how frustrated you must be.
In mysql 5, condition is a reserved word, so the person who told you to
remove the quotes was wrong, at least for that column. (In his defense,
CONDITION is relevant to stored procedures, so it isn't a reserved word for
versions prior to 5, as
Marvin Cummings wrote:
Sorry for this easy question but I'm kind of a newbie and I'm wondering if
someone could assist me with creating a new table for a postnuke module? I
need to copy the following content into a table I create named nuke_zc_ads:
(
`ad_id` smallint(5) unsigned NOT NULL
sounds like you need a join.
Select * from Poll, poll_votes where (Poll.poll_id = poll_votes.poll_id) and
(poll_votes.user_ID = WHATEVER);
But I'm still a beginner so
Respectfully,
Ligaya Turmelle
Anders Gjermshus [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Hi.
I'm having
I think you need the DISTINCT operator.
Assuming you haven't seen it, it works like this. Let's say that your query
asks for a list of all the job titles in your employee table, where the job
title is one of the columns of that table. The employee table looks like
this:
EMPNO NAME JOB
1
If you are wanting a checkbook like display then each entry is either a
debit or credit and each is on its own line.
Your query will display this. I would add an ifnull to display a zero
when the the debit/credit is null.
Original Message
On 3/2/04, 10:50:15 AM, charles kline [EMAIL
201 - 300 of 524 matches
Mail list logo