' 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 are the privileges are
required..
please help..
Best Regards
Faizal S
GSM : 9840118673
Blog: http://oradbapro.blogspot.com
On Thu, Oct 1
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 are the privileges are
required..
please help..
Best Regards
Faizal S
GSM : 9840118673
Blog: http
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 are the privileges
are required..
please help..
Best Regards
Faizal S
GSM : 9840118673
Blog: http
'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 are the privileges
are required..
please help..
Best Regards
Faizal S
GSM : 9840118673
Blog: http://oradbapro.blogspot.com
this. i want to see only my default schema..
2. for created new mysql database or schema what are the privileges
are required..
please help..
Best Regards
Faizal S
GSM : 9840118673
Blog: http://oradbapro.blogspot.com
On Thu, Oct 1, 2009 at 11:09 AM, prabhat kumar
aim.prab...@gmail.com
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
GSM : 9840118673
Blog
): 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 Regards,
Prabhat Kumar
MySQL DBA
Datavail-India Mumbai
Mobile
...@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 points to
CATEGORY.CATEGORY_ID) SUBCATEGORY_ID
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: (URL_ID, CATEGORY_ID) CATEGORY
CATEGORY_ID (primary Key
; 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 points to URL.URL_ID) CATEGORY_ID (key which
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
Developer
---
Sent from HP IPAQ mobile device.
-Original Message-
From: Proemial proem...@gmail.com
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
: Proemial proem...@gmail.com
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 TIMESTAMP column.
I have a single value with a timestamp of '2008-03
Subject: Fwd: Help with Timestamp invalid value error
Currently set to:
NO_AUTO_VALUE_ON_ZERO,STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
On Fri, Sep 4, 2009 at 10:24 AM, John
Daisleyj...@butterflysystems.co.uk wrote:
What is your sql_mode set to?
I tried inserting that value
be helpful to me.
cheers
- Original Message -
From: John Meyer john.l.me...@gmail.com
To: BobSharp bobsh...@ntlworld.com
Cc: mysql@lists.mysql.com
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
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
Daisleyj...@butterflysystems.co.uk wrote:
Is your table innodb? If so i think
facilement
être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité
pour le contenu fourni.
From: bobsh...@ntlworld.com
To: mysql@lists.mysql.com
CC: john.l.me...@gmail.com
Subject: Re: Database design - help
Date: Fri, 4 Sep 2009 16:24:22 +0100
Hi
Thanks
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: Help
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
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 query that
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 query that
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 query that
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
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
@bluepolka.net
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:
use mysql;
update user set host = 'SomeBogusIP' where user = 'root
the
root entry in mysql.user to your liking, and then restart the
server without --skip-grant-tables.
viola!
Walter
On Wed, Aug 26, 2009 at 02:12, Joemysql@bluepolka.net
wrote:
We have an inaccessible MySQL v5.0.45 DB (w/Innodb) we
really need some help regaining access
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'
-
--
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't get into the DB
/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't get into the DB to fix it:
# mysql test
ERROR 1044 (42000
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
...@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
'open' invoices...
-- this should get a list of open (unpaid) invoices
without --skip-grant-tables.
viola!
Walter
On Wed, Aug 26, 2009 at 02:12, Joemysql@bluepolka.net
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
On Wed, Aug 26, 2009 at 02:12, Joemysql@bluepolka.net
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:
use mysql;
update user set
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
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
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 not working the code
, 2009, DAREKAR, NAYAN (NAYAN)
nayan.dare...@alcatel-lucent.com 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.
I have created one batch
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
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 want to
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
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 bboisv...@gmail.comwrote:
You'll have to iterate over your two lists of timestamps and build a
set of ORed conditional pairs:
sql = select ... from ...
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
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 jlyons4...@gmail.com wrote:
why not something like below. Assume you have 3 pairs
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
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,
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
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 +0100
From: andy-li...@networkmail.eu
To: defati
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
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 very much you have been really very helpful. All those
mistakes
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 having is that I dont know
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
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
how do I make sure the value of tbl1_id
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
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 can get
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
auto_increment value in tbl1
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 list
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
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 list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
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
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 General Mailing
the 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
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
Stefan,
On Sun, Mar 8, 2009 at 1:50 PM, Stefan Onken supp...@stonki.de 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.
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
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: Query Help
...@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 Name, Group Name
Log contains login, host, datetime of last login
Ben Wiechman b...@meltel.com 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
: mysql@lists.mysql.com
Subject: RE: Query Help
Ben Wiechman b...@meltel.com 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
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
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
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 server
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 lance.raym...@gmail.com 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
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
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
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 services for MySQL
Support
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,
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
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
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 ...
-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
I have a database with a 1:n relationship
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
Hi,
On Mon, Jan 26, 2009 at 11:29 AM, Vikram Vaswani bacc...@vsnl.com 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
-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 Jerry
Thanks for your input
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
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`),
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,
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'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
Hi All,
I got the following tables:
table items
+-+-++-+--+--+--+
| accountcode | invoicecode | invitemqty | packagecode | itemcode |
packagename | packagedesc |
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 r...@silverbackasp.com wrote:
Hi All,
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 tables people, organization, addresses
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
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 tables people, organization, addresses. and they are
linked to each other
-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
linked to each other with column
-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
p.first_name
From: Andy Shellam andy-li...@networkmail.eu
To: Lamp Lists lamp.li...@yahoo.com
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
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
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
From: Andy Shellam andy-li...@networkmail.eu
To: Lamp Lists lamp.li...@yahoo.com
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
601 - 700 of 7035 matches
Mail list logo