>>> On Thu, Oct 1, 2009 at 12:08 PM, F.A.I.Z.A.L wrote:
>>>
>>>> thanks kumar..
>>>>
>>>> now its working
>>>>
>>>> i have another doubt
>>>>
>>>> i created an user with limited privilege on part
privilege on particular schema.
>>> schema name: test
>>>
>>> *mysql> create user 'test'@'%' identified by 'test';
>>> mysql> grant select,insert,update,delete,create,drop on test.* to 'test'@
>>> '%
test.* to 'test'@
>> '%';*
>>
>> after that i login with 'test' user using mysql query browser. but i can
>> able to see other schemas like 'information_Schema' and 'test_schema'
>> created by other
st' user using mysql query browser. but i can
> able to see other schemas like 'information_Schema' and 'test_schema'
> created by other.
>
> how can i avoid this. i want to see only my default schema..
>
> 2. for created new mysql database or schema what a
x27;test'@
'%';*
after that i login with 'test' user using mysql query browser. but i can
able to see other schemas like 'information_Schema' and 'test_schema'
created by other.
how can i avoid this. i want to see only my default schema..
2. for created ne
Access denied for user 'root'@'localhost' (using
> password: NO)
>
>
> Can someone please help me understand why I am not able to login from root?
>
>
> Best Regards
> Faizal S
> GSM : 9840118673
> Blog: http://oradbapro.blogspot.com
>
--
Best
Hi
iam getting the following error while login into mysql server.
andd141# mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: NO)
Can someone please help me understand why I am not able to login from root?
Best Regards
Faizal S
G
john.l.me...@gmail.com
Sent: Friday, September 04, 2009 6:09 PM
Subject: RE: Database design - help
> given the following table layouts
URLs:> URL_ID (primary key for URL)> URL_TEXT>> URL_CATEGORY> URL_ID
(key which points to URL.URL_ID)> CATEGORY_ID (key which
lworld.com ; mysql@lists.mysql.com
Cc: john.l.me...@gmail.com
Sent: Friday, September 04, 2009 6:09 PM
Subject: RE: Database design - help
> given the following table layouts
> URLs:> URL_ID (primary key for URL)> URL_TEXT>> URL_CATEGORY> URL_ID
> (key which
: Database design - help
> given the following table layouts
> URLs:> URL_ID (primary key for URL)> URL_TEXT>> URL_CATEGORY> URL_ID
> (key which points to URL.URL_ID)> CATEGORY_ID (key which points to
> CATEGORY.CATEGORY_ID)> SUBCATEGORY_ID> PK: (
Mysql doesn't store sub-second values.
try
2008-03-09 02:56:34
Instead of
2008-03-09 02:56:34.737
Regards,
Gavin Towey
-Original Message-
From: Proemial [mailto:proem...@gmail.com]
Sent: Friday, September 04, 2009 8:37 AM
To: John Daisley
Cc: mysql@lists.mysql.com
Subject: Re: Fwd:
n seulement et n'aura pas n'importe
quel effet légalement obligatoire. Étant donné que les email peuvent facilement
être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité
pour le contenu fourni.
> From: bobsh...@ntlworld.com
> To: mysql@lists.mysql.com
&
I had already tried that, actually. Produces the same error. I
should have mentioned that as well, sorry!
The version is 5.1.34
thanks for the help, btw!
Martin
On Fri, Sep 4, 2009 at 11:14 AM, John
Daisley wrote:
> Is your table innodb? If so i think the 'STRICT_TRANS_TABLES'
helpful to me.
cheers
- Original Message -
From: "John Meyer"
To: "BobSharp"
Cc:
Sent: Monday, August 31, 2009 4:56 PM
Subject: Re: Database design - help
BobSharp wrote:
As a complete newbie in MySQL, I need a database
to store URLs related to Tenpin Bowling
bile +44(0)7812 451238
Email j...@butterflysystems.co.uk
Certified MySQL 5 Database Administrator (CMDBA)
Certified MySQL 5 Developer
Cognos BI Developer
---
Sent from HP IPAQ mobile device.
-Original Message-
From: Proemial
Sent: Friday, September 04, 2009 3:39 PM
To: mysql@list
>
>
>
> -Original Message-
> From: Proemial
> Sent: Friday, September 04, 2009 2:27 PM
> To: mysql@lists.mysql.com
> Subject: Help with Timestamp invalid value error
>
> I run a process which loads a series of timestamped data into a table.
> I use the TI
Developer
---
Sent from HP IPAQ mobile device.
-Original Message-
From: Proemial
Sent: Friday, September 04, 2009 2:27 PM
To: mysql@lists.mysql.com
Subject: Help with Timestamp invalid value error
I run a process which loads a series of timestamped data into a table.
I
I run a process which loads a series of timestamped data into a table.
I use the TIMESTAMP column.
I have a single value with a timestamp of '2008-03-9 2:56:34.737'
which fails on insert with 'incorrect datetime'. Days before, and
after work. Hours later in the day work. I thought it might be
AndrewJames schrieb:
> Hey,
>
> i have a table called users which has my users in it, each have a uid
> field.
> I also have a stories table which has stories in it each with a sid field
> for each story but also a uid field so i know which user the story
> belongs
> to.
>
> i want to write a que
AndrewJames schrieb:
> Hey,
>
> i have a table called users which has my users in it, each have a uid
> field.
> I also have a stories table which has stories in it each with a sid field
> for each story but also a uid field so i know which user the story
> belongs
> to.
>
> i want to write a quer
AndrewJames schrieb:
> Hey,
>
> i have a table called users which has my users in it, each have a uid
> field.
> I also have a stories table which has stories in it each with a sid field
> for each story but also a uid field so i know which user the story
> belongs
> to.
>
> i want to write a quer
Hey,
i have a table called users which has my users in it, each have a uid field.
I also have a stories table which has stories in it each with a sid field
for each story but also a uid field so i know which user the story belongs
to.
i want to write a query that will display the story depending
BobSharp wrote:
As a complete newbie in MySQL, I need a database
to store URLs related to Tenpin Bowling.
There are several Categories ... Equipment Manufacturers,
Organistations, (UK) ProShops, (UK) Bowling Centres, Personal
Websites, Misc., Coaching & Instructional websites, etc.
There
As a complete newbie in MySQL, I need a database
to store URLs related to Tenpin Bowling.
There are several Categories ... Equipment Manufacturers, Organistations,
(UK) ProShops, (UK) Bowling Centres, Personal Websites, Misc., Coaching &
Instructional websites, etc.
There will be some sub-
> >
> > On Tuesday 25 August 2009 @ 18:17, Walter Heck - OlinData.com
> > wrote:
> >> Hey Joe,
> >>
> >> stop the server, start it with --skip-grant-tables, change the
> >> root entry in mysql.user to your liking, and then restart the
>
ithout --skip-grant-tables.
>>
>> viola!
>>
>> Walter
>>
>> On Wed, Aug 26, 2009 at 02:12, Joe
> wrote:
>> > We have an inaccessible MySQL v5.0.45 DB (w/Innodb) we
>> > really need some help regaining access to. While attempting
>>
When you are in without the flag , issue the following:
Select current_user();
It should return root.
Then do this:
Grant all privileges on *.* 'root'@'%' identified by 'letmein'
It should work If you did not mess too much with grant tables.
Claudio
Il giorno 26 ago, 2009 4:36 m., "Todd Lyons"
>> On Wed, Aug 26, 2009 at 02:12, Joe
> wrote:
>> > We have an inaccessible MySQL v5.0.45 DB (w/Innodb) we
>> > really need some help regaining access to. While attempting
>> > to adjust/add remote user access, we accidentally did the
>> > following
our liking, and then restart the
> server without --skip-grant-tables.
>
> viola!
>
> Walter
>
> On Wed, Aug 26, 2009 at 02:12, Joe
wrote:
> > We have an inaccessible MySQL v5.0.45 DB (w/Innodb) we
> > really need some help regaining access to. While attempt
You have to reset the permissions.
http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html
Carlos
On 8/25/2009 7:12 PM, Joe wrote:
We have an inaccessible MySQL v5.0.45 DB (w/Innodb) we really
need some help regaining access to. While attempting to
adjust/add remote user access
lly
> need some help regaining access to. While attempting to
> adjust/add remote user access, we accidentally did the
> following:
>
> use mysql;
> update user set host = 'SomeBogusIP' where user = 'root';
>
> Now, we can't get into the DB to fix it:
We have an inaccessible MySQL v5.0.45 DB (w/Innodb) we really
need some help regaining access to. While attempting to
adjust/add remote user access, we accidentally did the
following:
use mysql;
update user set host = 'SomeBogusIP' where user = 'root';
Now, we can&
: mysql@lists.mysql.com
> From: c...@hosting4days.com
> Subject: Basic SQL Query Help Needed
> Date: Tue, 25 Aug 2009 16:21:45 -0700
>
> I have a basic invoice table with related line items table
>
> Goal :I'd like to get ALL the related line items - for ALL the
>
I have a basic invoice table with related line items table
Goal :I'd like to get ALL the related line items - for ALL the
'open' invoices...
-- this should get a list of open (unpaid) invoices
$query_invoice = "SELECT DISTINCT ID from invoices where status =
'open'"
-
--
Saturday, August 8, 2009, DAREKAR, NAYAN (NAYAN)
> wrote:
>> Hi Guys,
>>
>> I need a help, as i am new to mysql and i want to create a batch file that
>> can truncate table and Load (LOAD DATA INFILE) one .csv file which is
>> generated every 2min into that table.
You have to execute each command using the mysql command:
@echo off
mysql -u root -ppass --database test truncate table t1
mysql -u root -ppass --database test load data infile
On Saturday, August 8, 2009, DAREKAR, NAYAN (NAYAN)
wrote:
> Hi Guys,
>
> I need a help, as i am new to
Hi Guys,
I need a help, as i am new to mysql and i want to create a batch file that can
truncate table and Load (LOAD DATA INFILE) one .csv file which is generated
every 2min into that table.
I have created one batch file where i can only able to login into databse,
further my commands are
I am creating surveys for our website and want store questions and answers
in a database. I found a tutorial that was useful, however it only gave
structure for a single question with one answer. My surveys need to be more
comprehensive than a poll question, and so I need some help with the
What about sub selects. As I see it you only care about the highest
and lowest order of results in each list.
Sorry, in am on a mobile so I can nit make a test case, and this will
be pseudo SQL.
Select * from table where start <= (select foo) and ( select foo) ...
Also look at the "between
abhishek@gmail.com (Abhishek Pratap) writes:
> I am kind of stuck with this query , cant expand my thinking. May this is a
> limitation. Here it is
>
> I have a database with many cols two of which are start and end position for
> an event.
>
> Now I have a list of event time stamps, I wan
then either build the statement by way of a program like a perl script or
select all records with a start time after the min start time of all in your
list and an end time less than the max end time in your list then filter
them further either in a program or a store procedure.
On Fri, May 8, 2009
Abhi,
I might not be understanding the problem but could you use the max
and min timestamp values and use something like
SELECT * FROM TABLE WHERE start BETWEEN max AND min AND end BETWEEN max AND min
or
SELECT * FROM TABLE WHERE START IN (1,2,3,4,5) AND END IN(1,2,3,4,5)
I might be complet
Hi Jim
Unfortunately I have thousands of such points. So explicit statement calling
will be very expensive both computationally and in terms of writing..
Thanks,
-Abhi
On Fri, May 8, 2009 at 12:37 PM, Jim Lyons wrote:
> why not something like below. Assume you have 3 pairs of start/end
> time
why not something like below. Assume you have 3 pairs of start/end
timestamps and you want to find everything within those 3 time periods:
select * from table_name where start >= start1 and end <= end1
union
select * from table_name where start >= start2 and end <= end2
union
select * from table_
aah okie I think I was trying to get too clever. Guess that won't work ...
Thanks,
-Abhi
On Fri, May 8, 2009 at 12:34 PM, Barney Boisvert wrote:
> You'll have to iterate over your two lists of timestamps and build a
> set of ORed conditional pairs:
>
> sql = "select ... from ... where 1 = 0"
> f
Hi All
I am kind of stuck with this query , cant expand my thinking. May this is a
limitation. Here it is
I have a database with many cols two of which are start and end position for
an event.
Now I have a list of event time stamps, I want to find all the info once the
current event time stamp
> Date: Mon, 20 Apr 2009 13:03:14 +0100
> From: andy-li...@networkmail.eu
> To: defati...@hotmail.com
> CC: mysql@lists.mysql.com
> Subject: Re: Need help with mysql prob
>
> Hi Alugo,
>
> abdulazeez alugo wrote:
> >
> > Hi Andy,
> > Thank you ver
Hi Alugo,
abdulazeez alugo wrote:
Hi Andy,
Thank you very much you have been really very helpful. All those
mistakes you pointed at in the script about the apostrophe and others,
are simple mistakes I just made in the rush of typing the message; and
yes $conn is the result from mysql_connect
> Date: Mon, 20 Apr 2009 08:06:05 +0100
> From: andy-li...@networkmail.eu
> To: defati...@hotmail.com
> CC: mysql@lists.mysql.com
> Subject: Re: Need help with mysql prob
>
> Hi,
>
> abdulazeez alugo wrote:
> >
> >> Date: Sun, 19 Apr 2009 23:19:56
Hi,
abdulazeez alugo wrote:
Date: Sun, 19 Apr 2009 23:19:56 +0100
From: andy-li...@networkmail.eu
To: defati...@hotmail.com
CC: mysql@lists.mysql.com
Subject: Re: Need help with mysql prob
Hi Alugo,
Hi Andy,
Thanks for your prompt response. However, since tbl1_id has an
> Date: Sun, 19 Apr 2009 23:19:56 +0100
> From: andy-li...@networkmail.eu
> To: defati...@hotmail.com
> CC: mysql@lists.mysql.com
> Subject: Re: Need help with mysql prob
>
> Hi Alugo,
> > Hi Andy,
> >
> > Thanks for your prompt response. However, s
Hi Abdul-
you may want to check this thread out regarding the same issue...
http://www.webmasterworld.com/php/3565843.htm
On Apr 19, 2009, at 3:23 PM, abdulazeez alugo wrote:
Hi guys,
I'm having a really terrible problem with my mysql coding and I'ld
appreciate any help I
Hi Alugo,
Hi Andy,
Thanks for your prompt response. However, since tbl1_id has an auto_increment value in tbl1, mysql is actually generating the values for it automatically.
Ah, I see your point. I'm guessing by your code you're using PHP? If
so call mysql_insert_id() after you've inser
> Date: Sun, 19 Apr 2009 22:50:20 +0100
> From: andy-li...@networkmail.eu
> To: defati...@hotmail.com
> CC: mysql@lists.mysql.com
> Subject: Re: Need help with mysql prob
>
> Hi,
> > Now I have successfully created a relationship between the two tables but
>
Hi,
Now I have successfully created a relationship between the two tables but how
do I make sure the value of tbl1_id in tbl1 is equal to the value of tbl1_id in
tbl2???
MySQL handles this for you. Simply INSERT the value into tbl1, then
INSERT the value of tbl1_id in tbl2. Then try INS
Hi guys,
I'm having a really terrible problem with my mysql coding and I'ld appreciate
any help I can get on this cause it's really driving me crazy.
I have two tables and I've succeeded in creating a one to many relationship
between both table but the problem I'm h
ion.collation_server=33/*!*/;
>> DROP DATABASE `prod_db3`
>> /*!*/;
>> DELIMITER ;
>> # End of log file
>> ROLLBACK /* added by mysqlbinlog */;
>> /*!50003 SET completion_ty...@old_completion_type*/;
>>
>> This has occured once a day for the past 3 days.
/* added by mysqlbinlog */;
/*!50003 SET completion_ty...@old_completion_type*/;
This has occured once a day for the past 3 days.
Is there any way to track this down further to which mysql account is
being used?
Should I suspect foulplay or network intrusion?
Appreciate any insight and help.
Thanks,
John
3 SET completion_ty...@old_completion_type*/;
This has occured once a day for the past 3 days.
Is there any way to track this down further to which mysql account is
being used?
Should I suspect foulplay or network intrusion?
Appreciate any insight and help.
Thanks,
John
--
MySQL General Mailing List
For
Hi
You can make a backup of the original table and recreate the table and
import. That will help you ASAP
Muthukumar Selvarasu,
Project Manager, Webmaster Ltd.
-Original Message-
From: Gary Smith [mailto:g...@primeexalia.com]
Sent: Thursday, March 19, 2009 7:25 AM
To: Valentin Ionescu
column after that.
From: Valentin Ionescu [colibry...@yahoo.com]
Sent: Wednesday, March 18, 2009 11:27 AM
To: mysql@lists.mysql.com
Cc: wi...@lists.mysql.com; mysql-h...@lists.mysql.com
Subject: Please help me.
Hi!
My name is Valentin and I am writing to
ried to do like:
alter table documents_ex drop column Journal_ex_ID
or
alter table documents_ex drop foreign key Journal_ex_ID
or
alter table documents_ex drop key Journal_ex_ID
I receive the same error 150 and I don't know what to do.
Please help me.
Best regards.
--
MySQL
Stefan,
On Sun, Mar 8, 2009 at 1:50 PM, Stefan Onken wrote:
> Hello,
>
> I am bit puzzled about combining mysql fulltext search into our
> current search:
>
> I am not able to combine a fulltext search with other selections,
> please see http://pastebin.com/m23622c39 for full details. The
> momen
Hello,
I am bit puzzled about combining mysql fulltext search into our
current search:
I am not able to combine a fulltext search with other selections,
please see http://pastebin.com/m23622c39 for full details. The
moment I am using "...where a=2 OR match (bla) AGAINST ('foo') mysql
is not u
: mysql@lists.mysql.com
Subject: RE: Query Help
"Ben Wiechman" wrote on 02/10/2009 01:30:14 PM:
> Thanks for the input! That is close to what I need, however not exactly.
It
> will give me the last time a user logged into the host in question but I
> want to prune users who hav
"Ben Wiechman" wrote on 02/10/2009 01:30:14 PM:
> Thanks for the input! That is close to what I need, however not exactly.
It
> will give me the last time a user logged into the host in question but I
> want to prune users who have since logged into a different host.
Basically
> find out how man
00 sec)
-Original Message-
From: Ben Wiechman [mailto:b...@meltel.com]
Sent: Tuesday, February 10, 2009 11:32 AM
To: mysql@lists.mysql.com
Subject: Query Help
I keep hacking at this but haven't been able to get it right yet.
I have two tables
Userinfo contains a login, User's Na
he host in question the information is
returned. This produces too many results as some of those users have since
migrated to a different access point.
-Original Message-
From: Andrew Wallo [mailto:theme...@microneil.com]
Sent: Tuesday, February 10, 2009 12:05 PM
To: Ben Wiechman
Subject: Re:
I keep hacking at this but haven't been able to get it right yet.
I have two tables
Userinfo contains a login, User's Name, Group Name
Log contains login, host, datetime of last login
What I need to do is return user information (userinfo.name/groupname) of
users that have logged into
Hi Dave,
that's easy. Either install
http://www.phpmyadmin.net/home_page/index.php on the server, the best
tool to manage a mysql server.
Or use XAMPP, a complete package from
http://www.apachefriends.org/en/index.html
Guenther
Dave Stevens wrote:
> Hello all,
>
> I have set up a little serve
Dave,
Log in as the user you intend to set up for them. Issue the following:
show grants;
select @@sql_mode;
If you aren't sure how to interpret the information I will direct you
to the manual: http://dev.mysql.com/doc/refman/5.0/en/
Side note: I would upgrade. 5.0.45 has some pretty serious
Hello all,
I have set up a little server and am pitching to an organization to host their
upcoming new site. The box is Centos 5.2 up to date and mysql 5.0.45. The
requirements below must be met but I don't know how to verify their status.
Can someone point me in the right direction. Will read
You didn't get a response on this one because you didn't really ask
any questions :-)
Baron
On Thu, Jan 29, 2009 at 4:38 PM, lance raymond wrote:
> Man, the forums are good, but lists are just so much easier! Anyway, I left
> post unanswered now and I need to get this problem solved, so I am ho
Man, the forums are good, but lists are just so much easier! Anyway, I left
post unanswered now and I need to get this problem solved, so I am hoping
this list is more direct.
Basically a fc5/mysql4 server is having hard drive errors. We had a
slightly newer/faster server, so I staged it with ce
ad
information. Sometimes there's no click through to a lead contact, and
sometimes there's a click through with no follow up. Sometimes both.
Does that help?
-Micah
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Micah,
>each item in `a` has a 1 to 1 relationship to `b`,
>and each item in `c` has a 1 to 1 relationship with `b`.
>Sometimes these correspond, i.e. there's a row in `b`
>that relates to both `a` and `c`, but not always.
So in a given b row, the b_id value might match an a.a_id, a c.a_id, or
Hi,
I'm somewhat stumped by how to set up a single query that does the
following. Currently I'm accomplishing this through multiple queries and
some PHP 'glue' logic, but it should be possible in a single query I
think, and it's bugging me that I can't figure it out. If anyone has any
ideas,
I don't think so unfortunately. He says in his first mail:
> I'm using an excel library that accepts a SELECT as input and generates an
> XLS file with the records as output.
So, probably csv is not going to help him, which is a shame :)
Walter
OlinData: Professional se
I think what you are looking for is something like this:
-
SELECT
CONCAT(A.FIELD1,',',GROUP_CONCAT(B.FIELD2))
FROM
TABLE1 A LEFT JOIN TABLE2 B
ON A.ID=B.ID_TABLE1
-
Hi,
I did consider a procedure but the problem is that the client is still using
MySQL 4.x, which afaik doesn't support stored procedures. An upgrade is not
something they can do at this point, as they're using s shared host so the
server isn't really under their control.
I think what you're r
>-Original Message-
>From: blue.trapez...@gmail.com [mailto:blue.trapez...@gmail.com] On
>Behalf Of Vikram Vaswani
>Sent: Monday, January 26, 2009 11:29 AM
>To: Jerry Schwartz
>Cc: mysql@lists.mysql.com
>Subject: Re: Help with formatting of 1:n relationship
>
>
Hi,
On Mon, Jan 26, 2009 at 11:29 AM, Vikram Vaswani wrote:
> Hi Jerry
>
> Thanks for your input on this!
>
>
>>> I'm using an excel library that accepts a SELECT as input and generates
>>> an XLS file with the records as output. I'd like to use this where
>>> possible. However I don't know if it
Hi Jerry
Thanks for your input on this!
I'm using an excel library that accepts a SELECT as input and generates
an XLS file with the records as output. I'd like to use this where
possible. However I don't know if it's possible to write a SELECT that
compresses a 1:n relationship into a single
>-Original Message-
>From: blue.trapez...@gmail.com [mailto:blue.trapez...@gmail.com] On
>Behalf Of Vikram Vaswani
>Sent: Monday, January 26, 2009 7:02 AM
>To: mysql@lists.mysql.com
>Subject: Help with formatting of 1:n relationship
>
>Hello all
>
&g
Hello all
I have a database with a 1:n relationship as follows:
Item (1)
fld1
fld2
...
Item_info (n)
-
fld1
fld2
...
My client wants me to export these linked records into an Excel file in
the following format.
item.fld1 item.fld2 ... item_info.fld1 item_info.fld2 ...
item_inf
On Mon, 19 Jan 2009, Duane Hill wrote:
I have two tables defined:
CREATE TABLE `tga_body` (
`body_id` int(10) unsigned NOT NULL auto_increment,
`blob_pos` mediumint(8) unsigned NOT NULL,
`file_id` int(10) unsigned NOT NULL,
`blob_id` int(10) unsigned NOT NULL,
PRIMAR
I have two tables defined:
CREATE TABLE `tga_body` (
`body_id` int(10) unsigned NOT NULL auto_increment,
`blob_pos` mediumint(8) unsigned NOT NULL,
`file_id` int(10) unsigned NOT NULL,
`blob_id` int(10) unsigned NOT NULL,
PRIMARY KEY USING BTREE (`body_id`),
b wrote:
I'm having some difficulty getting my head around a particular query.
I'd like to make this a view once I get something working. However, all
I've been able to come up with uses a sub-query. So, no view on the
horizon.
I have 3 tables:
users
id,
(etc. the usual)
disciplines
i
I'm having some difficulty getting my head around a particular query.
I'd like to make this a view once I get something working. However, all
I've been able to come up with uses a sub-query. So, no view on the horizon.
I have 3 tables:
users
id,
(etc. the usual)
disciplines
id,
name (
The error is not in the join, but in the fact that you have two invoices
with the same invocecode. The items are retrieved and displayed for both
invoices.
If this is correct, select distinct should solve your problem.
On Mon, Jan 12, 2009 at 5:59 PM, Ron wrote:
> Hi All,
>
> I got the followi
Hi All,
I got the following tables:
table items
+-+-++-+--+--+--+
| accountcode | invoicecode | invitemqty | packagecode | itemcode |
packagename | packagedesc |
+-+--
Hello all,
I get this error when compiling:
Object file format error in: /usr/sw: read_cur_obj_info: File is not a
regular file
I have the same thing in /usr/sw as you'd find in /usr/local
I'm using gcc 4.0.2 and the tru64 native compiler.
I tried taking off a few configure directives, such as
From: Andy Shellam
To: Lamp Lists
Cc: mysql@lists.mysql.com
Sent: Wednesday, December 17, 2008 2:48:31 PM
Subject: Re: need help with query...
Hi,
>
> Hi Andy,
> the reason I can't use this because fields (columns) in select statement
&
Hi,
Hi Andy,
the reason I can't use this because fields (columns) in select
statement (p.first_name, p.last_name,...) are actually dynamically
created. In my project different client will select different fields
to be shown. 99% will select first_name, and last_name, but some don't
care abo
Jerry Schwartz wrote:
-Original Message-
From: Andy Shellam [mailto:andy-li...@networkmail.eu]
Sent: Wednesday, December 17, 2008 3:29 PM
To: Lamp Lists
Cc: mysql@lists.mysql.com
Subject: Re: need help with query...
Hi Afan
Why not prefix your field names with the table name?
select
From: Andy Shellam
To: Lamp Lists
Cc: mysql@lists.mysql.com
Sent: Wednesday, December 17, 2008 2:29:08 PM
Subject: Re: need help with query...
Hi Afan
Why not prefix your field names with the table name?
select
p.first_name AS person_first_name
>-Original Message-
>From: Andy Shellam [mailto:andy-li...@networkmail.eu]
>Sent: Wednesday, December 17, 2008 3:29 PM
>To: Lamp Lists
>Cc: mysql@lists.mysql.com
>Subject: Re: need help with query...
>
>Hi Afan
>
>Why not prefix your field names
>-Original Message-
>From: Lamp Lists [mailto:lamp.li...@yahoo.com]
>Sent: Wednesday, December 17, 2008 2:57 PM
>To: mysql@lists.mysql.com
>Subject: need help with query...
...snip...
>I have let say 3 tables people, organization, addresses. and they are
>link
n Dec 17, 2008, at 2:56 PM, Lamp Lists wrote:
I hate when somebody put in Subject line something like I just did
but after 15 minutes to try to be specific just with one short
sentence - I gave up. So, you can hate me - I understand (though,
help with my problem too) :-)
I have let say 3
On Dec 17, 2008, at 2:56 PM, Lamp Lists wrote:
I hate when somebody put in Subject line something like I just did
but after 15 minutes to try to be specific just with one short
sentence - I gave up. So, you can hate me - I understand (though,
help with my problem too) :-)
I have let
601 - 700 of 7359 matches
Mail list logo