+61 417 268 665 - Mobile
+61 8 8408 4259 - Fax
-Original Message-
From: Mark Phillips [mailto:[EMAIL PROTECTED]
Sent: Thursday, 22 December 2005 5:21 PM
To: mysql@lists.mysql.com
Cc: Logan, David (SST - Adelaide)
Subject: Re: Need Help Connecting
David,
How do I do that?
Thanks
8 8408 4259 - Fax
-Original Message-
From: Mark Phillips [mailto:[EMAIL PROTECTED]
Sent: Thursday, 22 December 2005 5:21 PM
To: mysql@lists.mysql.com
Cc: Logan, David (SST - Adelaide)
Subject: Re: Need Help Connecting
David,
How do I do that?
Thanks!
Mark
On Wednesday 21
+61 417 268 665 - Mobile
+61 8 8408 4259 - Fax
-Original Message-
From: Mark Phillips [mailto:[EMAIL PROTECTED]
Sent: Thursday, 22 December 2005 5:36 PM
To: Logan, David (SST - Adelaide)
Cc: mysql@lists.mysql.com
Subject: Re: Need Help Connecting
David,
This is what I got:
[EMAIL
Hello.
You may use these queries:
select flight_id
,baseline*tan(radians(angle)) as attitude
from flights
where (baseline*tan(radians(angle))) =
( select max(baseline*tan(radians(angle)))
from flights f2);
I forgot to copy the list as well
Mark
-- Forwarded Message --
Subject: Re: Need Help with a query
Date: Sunday 11 December 2005 06:47 pm
From: Mark Phillips [EMAIL PROTECTED]
To: Rhino [EMAIL PROTECTED]
Rhino,
My apologies for leaving out the version of mysql. I agree
Umit tas wrote:
hello i'm umit Tas;
i have a problem.
i'm writing programme in visual basic 6.0 but i must use MySQL server.
i'm installed MySQL server and executing my program (no problem) but my
problem is :
MySQL must be installed A computer and my programme must be installed
B
Umit tas wrote:
hello i'm umit Tas;
i have a problem.
i'm writing programme in visual basic 6.0 but i must use MySQL server.
i'm installed MySQL server and executing my program (no problem) but my
problem is :
MySQL must be installed A computer and my programme must be installed
B
Umit tas [EMAIL PROTECTED] wrote on 12/02/2005 04:59:15 AM:
hello i'm umit Tas;
i have a problem.
i'm writing programme in visual basic 6.0 but i must use MySQL server.
i'm installed MySQL server and executing my program (no problem) but my
problem is :
MySQL must be installed A
',pswrd:'123456',host:'10.0.0.2'(not
localhost)
but i can't do it
From: [EMAIL PROTECTED]
To: Umit tas [EMAIL PROTECTED]
CC: mysql@lists.mysql.com
Subject: Re: important! help plsss
Date: Fri, 2 Dec 2005 10:11:41 -0500
Umit tas [EMAIL PROTECTED] wrote on 12/02/2005 04:59:15 AM
atachments
but MySQL and programme must have different computers.( i can't do
this
connections)
From: [EMAIL PROTECTED]
To: Umit tas [EMAIL PROTECTED]
CC: mysql@lists.mysql.com
Subject: Re: important! help plsss
Date: Fri, 2 Dec 2005 10:35:55 -0500
First - always CC: the list
sorry :( but thanks.
From: [EMAIL PROTECTED]
To: Umit tas [EMAIL PROTECTED]
CC: mysql@lists.mysql.com
Subject: Re: important! help plsss
Date: Fri, 2 Dec 2005 13:29:35 -0500
Sorry, but no.
a) I do not accept attachments from people I do not know.
b) I will help you to learn how to use
Hi,
Try with mysql -u root first, the installation process doesn't create a
password.
You can then use mysqladmin -u root password 'newpassword' to set it.
You can find out all about the security/permissions system here :
http://dev.mysql.com/doc/refman/5.0/en/privilege-system.html
Regards
Hello. I am a complete newbie here and to the world of Linux MySQL.
I am trying to create a LAMP server
I have installed RedHat Enterprise Linux AS 4 - update 2 on my server and
it seems to work ok.
I downloaded MySQL 5.0 and now want to install that
I read somewhere that I need to
I spent several minutes looking at your question and your data model and
nothing jumped out at me that precluded you from determining the quantity of
the this vendor's items sold via this data model. I might have missed
something though.
I'm a little concerned that your LineItem table appeared to
I would first try refactoring your SQL to use INNER JOIN statements
instead of the comma separated lists you are currently using. I would also
not use any subqueries. Test this and see if it works for you:
SELECT SUM(li.quantity) as qtysoldytd
FROM LineItem li
INNER JOIN Sales sa
on
For me, it looks as if you confused the order of join and where. It should be:
select ... from ... join ... where ... order by ...
Stefan
Am Sunday 23 October 2005 13:21 schrieb Grant Giddens:
Hi,
I keep getting errors on this query and I'm not sure
why. I'm using mysql version 4.0.22.
--- Kishore Jalleda [EMAIL PROTECTED] wrote:
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
I agree with Kishore, to elaborate his answer a little
longer I would ask the following.
- is
ps, I meant to delete the note from my draft
folder... sorry
Enrique Sanchez.
Enrique Sanchez Vela
email: [EMAIL PROTECTED]
-
It's often easier to fight for one's ||We live in the outer space
[EMAIL PROTECTED] wrote on 10/18/2005 06:28:03 AM:
Hello,
CREATE TABLE t (
dt datetime
)
Please assume this is the table structure and contains thousands of
records.
And I want to list them only last 12 months (that mean last 1 year)
records
exactly.
For that I tried using the
R,
I tried using the following query, but it list sometimes 13 months
when the current date is in the middle of the month.
SELECT * FROM t WHERE DATE_ADD(dt, INTERVAL 1 YEAR) = NOW();
Try...
DATE_ADD( dt, INTERVAL
IF(YEAR(NOW())%40 AND YEAR(NOW())%100=0,366,365)
DAY ) = NOW()
grKumaran wrote:
Hello,
CREATE TABLE t (
dt datetime
)
Please assume this is the table structure and contains thousands of
records. And I want to list them only last 12 months (that mean last 1
year) records exactly.
For that I tried using the following query, but it list sometimes 13
[EMAIL PROTECTED] wrote:
lets say i have two tables:
module
-
VARCHAR module_name
INTEGER module_id
module_config
INTEGER module_id
VARCHAR config_name
VARCHAR config_value
config item names and values are rather arbitrary and depend on the module.
each module can
[EMAIL PROTECTED] wrote on 10/11/2005 01:27:12 PM:
lets say i have two tables:
module
-
VARCHAR module_name
INTEGER module_id
module_config
INTEGER module_id
VARCHAR config_name
VARCHAR config_value
config item names and values are rather arbitrary
m i l e s wrote:
Hi,
I have an odd situation where I was handed just bad data, and while I
have cleaned it up to the best of my ability one hurdle remains.
I have a situation where I have the following example in a field:
Canna ÒBengalÒ.
Note the odd chrs Ò in the field ? I need to
Kane Wilson wrote:
I wanted to check the following condition and if it is
success i wanted to display a massage.I tried as
follows. but no luck. nothing displayed.
$dbQuery = results;
$result = mysql_query($dbQuery) or die(Couldn't get
file list);
if (!isset($result))
{echo NULL;}
Hello.
$dbQuery = results;
Have you forgotten to put '$' before the 'results'? Do you
have display_errors = On in your php.ini?
Kane Wilson [EMAIL PROTECTED] wrote:
hi ,
I wanted to check the following condition and if it is
success i wanted to display a massage.I
Hi!!
$dbQuery = select * from table where 1 ;
$result = mysql_query($dbQuery) or die(Error trying to execute the query:
.mysql_error());
If(mysql_num_rows($result)1){ //also: ==0 works
echo NULL;
-Original Message-
From: Kane Wilson [mailto:[EMAIL PROTECTED]
Sent: Wednesday,
Sorry for not replying as quickly as I usually do, I ran into some other
server issues. Please take a look at my comments to your post.
-Original Message-
From: Michael Stassen [mailto:[EMAIL PROTECTED]
Sent: August 20, 2005 11:11 PM
Cc: John Gonzales; mysql@lists.mysql.com
Subject: Re
On Wed, 2005-08-24 at 06:11 -0500, John Gonzales wrote:
CREATE TABLE `journal` (
`journal_id` int(10) unsigned NOT NULL auto_increment,
`journal_category` int(10) unsigned NOT NULL default '1',
`journal_datetime_created` timestamp NOT NULL default CURRENT_TIMESTAMP,
Pat Adams wrote:
On Wed, 2005-08-24 at 06:11 -0500, John Gonzales wrote:
CREATE TABLE `journal` (
`journal_id` int(10) unsigned NOT NULL auto_increment,
[snip]
CREATE TABLE comments
(
comment_id INT,
comment_journal_id INT,
INDEX jrn_id (journal_id),
Here you are defining an index
Wow, thanks both of you. It worked... =)
-Original Message-
From: Roger Baklund [mailto:[EMAIL PROTECTED]
Sent: August 24, 2005 9:17 AM
To: mysql@lists.mysql.com
Cc: [EMAIL PROTECTED]
Subject: Re: need help with foreign keys, new to mysql
Pat Adams wrote:
On Wed, 2005-08-24 at 06:11
Balazs Bagi [EMAIL PROTECTED] wrote on 08/24/2005 05:10:55 AM:
Hi there, I'm kind of new to joining two tables. Please bear with me
with this simple example. I have three tables.
Guests is a list of guests that are coming to the party. The primary
key of this table is 'id' and the
John thegimper wrote:
This is what i need:
Posted by gogman on Monday May 5 2003, @10:42am on the mysql website:
MySQL defaults to an 'OR'. Example: 'dog cat' = 'dog OR cat'. Most fulltext
search engines default to an 'AND'. These include: AltaVista, Fast Search,
[snip]
Unfortunately the item field has got data with quotes around it. IE
KP-00310. I
need to clean up the data and have the field contain just KP-00310.
Since I
have
10,000 records, I need a update statement or something to clean that up.
Any ideas ?
[/snip]
Darryl,
Unfortunately the item field has got data with quotes around it.
IE
"KP-00310". I need to clean up the data and have the field contain
just KP-00310. Since I have 10,000 records, I need a update
statement or something to clean that up.
To remove all double quotes: UPDATE tablename
Svensson [EMAIL PROTECTED]
CC: [EMAIL PROTECTED]
Subject: Re: Please help me: Boolean fulltext searches, AND instead of
OR
Date: Wed, 23 Mar 2005 22:32:49 +0100
Hi!
On Mar 23, Jessica Svensson wrote:
Is there any way i can get results with AND instead of OR?
Trying to search for black
!!
From: Sergei Golubchik [EMAIL PROTECTED]
To: Jessica Svensson [EMAIL PROTECTED]
CC: [EMAIL PROTECTED]
Subject: Re: Please help me: Boolean fulltext searches, AND instead
of
OR
Date: Wed, 23 Mar 2005 22:32:49 +0100
Hi!
On Mar 23, Jessica Svensson wrote:
Is there any way i can
i am logged in as root
-JG.
-Original Message-
From: Kishore Jalleda [mailto:[EMAIL PROTECTED]
Sent: August 19, 2005 10:35 PM
To: John Gonzales
Cc: mysql@lists.mysql.com
Subject: Re: need help with foreign keys, new to mysql
check the permissions on the mysql data dir, may be the user
Yes but is the MySQL daemon running as root? I hope it isn't...
Jasper
John Gonzales wrote:
i am logged in as root
-JG.
-Original Message-
From: Kishore Jalleda [mailto:[EMAIL PROTECTED]
Sent: August 19, 2005 10:35 PM
To: John Gonzales
Cc: mysql@lists.mysql.com
Subject: Re: need
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
Jason Chan wrote:
Jason Chan wrote:
I have a student Table and a SubjectGrade table
Create Table Student(
StudentID INT NOT NULL,
StudentName VARCHAR(30)
)
Create Table SubjectGrade(
StudentID INT NOT NULL,
Subject VARCHAR(30) NOT NULL,
Grade CHAR(1)
)
let's say have following record in
I am using mysql 4.0.25 with no subquery support : (
Jason Chan [EMAIL PROTECTED] ¦b¶l¥ó news:[EMAIL PROTECTED]
¤¤¼¶¼g...
I have a student Table and a SubjectGrade table
Create Table Student(
StudentID INT NOT NULL,
StudentName VARCHAR(30)
)
Create Table SubjectGrade(
StudentID INT NOT NULL,
Select s.StudentID, s.StudentName from Student s, SubjectGrade sg where
s.StudentID = sg.StudentID and sg.Subject = 'Maths' and sg.Subject = 'Chem'
and sg.Grade = 'A'
The key here is using the aliases for the tables. The linking of the tables
comes in the s.StudentID = sg.StudentID statement.
Jason Chan wrote:
I have a student Table and a SubjectGrade table
Create Table Student(
StudentID INT NOT NULL,
StudentName VARCHAR(30)
)
Create Table SubjectGrade(
StudentID INT NOT NULL,
Subject VARCHAR(30) NOT NULL,
Grade CHAR(1)
)
let's say have following record in SubjectGrade
1
Select s.StudentID, s.StudentName from Student s, SubjectGrade sg where
s.StudentID = sg.StudentID and sg.Subject = 'Maths' and sg.Subject = 'Chem'
and sg.Grade = 'A'
Take a close look at the WHERE clause: sg.Subject = 'Maths' and
sg.Subject = 'Chem' will never return a result - how could the
Jason Chan wrote:
I have a student Table and a SubjectGrade table
Create Table Student(
StudentID INT NOT NULL,
StudentName VARCHAR(30)
)
Create Table SubjectGrade(
StudentID INT NOT NULL,
Subject VARCHAR(30) NOT NULL,
Grade CHAR(1)
)
let's say have following record in SubjectGrade
1
Jason Chan wrote:
I am using mysql 4.0.25 with no subquery support : (
Jason Chan [EMAIL PROTECTED] ¦b¶l¥ó news:[EMAIL PROTECTED]
¤¤¼¶¼g...
I have a student Table and a SubjectGrade table
Create Table Student(
StudentID INT NOT NULL,
StudentName VARCHAR(30)
)
Create Table SubjectGrade(
Alternatively, use an IN list for the subject, then use a HAVING clause
to limit the results to students with 2 matching rows, like this:
SELECT StudentID, StudentName
FROM Student s
JOIN SubjectGrade sg ON s.StudentID = sg.StudentID
WHERE sg.Subject IN ('Maths', 'Chem')
AND
Jason Chan wrote:
I have a student Table and a SubjectGrade table
Create Table Student(
StudentID INT NOT NULL,
StudentName VARCHAR(30)
)
Create Table SubjectGrade(
StudentID INT NOT NULL,
Subject VARCHAR(30) NOT NULL,
Grade CHAR(1)
)
let's say have following record in SubjectGrade
1Maths
Arno Coetzee wrote:
Jason Chan wrote:
I have a student Table and a SubjectGrade table
snip
I want to find out students who have got A in both Maths and Chem
How the SQL look like?
select s.StudentID , s.StudentName
from Student as s , SubjectGrade as sj
where s.studentID = sj.studentID
I havn't write my schema clearly , (StudentID, Subject) is the key of
SubjectGrade
Philippe Poelvoorde [EMAIL PROTECTED] ???
news:[EMAIL PROTECTED] ???...
Alternatively, use an IN list for the subject, then use a HAVING clause
to limit the results to students with 2 matching rows, like this:
So i have to write 3 join if I have 3 conditions and so on, right?
Scott Noyes [EMAIL PROTECTED] ???
news:[EMAIL PROTECTED] ???...
Select s.StudentID, s.StudentName from Student s, SubjectGrade sg where
s.StudentID = sg.StudentID and sg.Subject = 'Maths' and sg.Subject =
'Chem'
and sg.Grade =
SELECT s.StudentID, StudentName
FROM Student s
JOIN StudentGrade sg1 USING (StudentID)
JOIN StudentGrade sg2 USING (StudentID)
WHERE
sg1.Subject = 'Maths' AND sg1.Grade = 'A'
AND sg2.Subject = 'Chem' AND sg2.Grade = 'A'
So i have to write 3 join if I have 3 conditions and so on,
Jason Chan wrote:
I have a student Table and a SubjectGrade table
Create Table Student(
StudentID INT NOT NULL,
StudentName VARCHAR(30)
)
Create Table SubjectGrade(
StudentID INT NOT NULL,
Subject VARCHAR(30) NOT NULL,
Grade CHAR(1)
)
let's say have following record in SubjectGrade
Thanks Scott!
Scott Noyes [EMAIL PROTECTED] ???
news:[EMAIL PROTECTED] ???...
SELECT s.StudentID, StudentName
FROM Student s
JOIN StudentGrade sg1 USING (StudentID)
JOIN StudentGrade sg2 USING (StudentID)
WHERE
sg1.Subject = 'Maths' AND sg1.Grade = 'A'
AND sg2.Subject = 'Chem' AND
m i l e s [EMAIL PROTECTED] wrote on 08/08/2005 03:10:21 PM:
Hi,
IS the following query counting cumulative (see below **) pHITS or is
it counting individual counts for each user for a particular day. Im
not skilled enough to answer this question myself. My instinct says
that its
Miles,
IS the following query counting cumulative (see below **) pHITS or is
it counting individual counts for each user for a particular day. Im
not skilled enough to answer this question myself. My instinct says
that its counting cumulative values and NOT individual counts for each
Shawn,
Took me a bit to digest what you were sayin but if I get it the way
you splain'd it
then the following should work:
++
SELECT
cmc_search_members.PropertyName AS pNAME,
cmc_search_members.PropertyEmail AS pEMAIL,
m i l e s [EMAIL PROTECTED] wrote on 08/08/2005 05:05:46 PM:
Shawn,
Took me a bit to digest what you were sayin but if I get it the way
you splain'd it
then the following should work:
++
SELECT
cmc_search_members.PropertyName
Hi Siegfried,
I think you've run into bug #8732:
...
Description:
if you do a INSERT INTO table (col_list) SELECT ... ON DUPLICATE KEY
UPDATE and
refer to the same column in the col_list and in the UPDATE clause, it
will bail
out, doesn't seem like it should, since not listing the column in
Hi Jocelyn,
you're right of course. I didn't read the original post
closely enough (it's early in the morning here...).
I missed that SELECT wasn't used.
Regards,
/Johan
[EMAIL PROTECTED] wrote:
Hi Johan,
I don't think it's its problem, since MySQL returns a You have an error
in your
Hi,
Are you using MySQL-4.1 ? (ON DUPLICATE KEY syntax has been introduced
in 4.1)
Regards,
Jocelyn
Siegfried Heintze wrote:
Thanks for deciphering that terrible message, Shawn. I accidentally must
have hit the paste key too many times.
Anyway, here is my new insert statement:
INSERT
On 6/26/05, 2wsxdr5 wrote:
Can someone tell me why this query works...
SELECT UserKey
FROM(
SELECT UserKey, Count(GiftKey) Gifts
FROM Gift
Group BY UserKey
) GC
WHERE GC.Gifts = 3
Why this construction and not simply:
SELECT UserKey
FROM Gift
GROUP BY UserKey
HAVING Count(GiftKey) =
Will this work?
GROUP BY maxtime, user
ORDER BY maxtime DESC
comex wrote:
I have a table:
create table example(time datetime, username varchar(255));
timeusername
2005-06-21 15:58:02 user1
2005-06-21 14:58:02 user1
2005-06-21 11:57:51 user2
2005-06-21 10:57:51 user1
comex [EMAIL PROTECTED] wrote on 06/21/2005 11:07:35 AM:
I have a table:
create table example(time datetime, username varchar(255));
timeusername
2005-06-21 15:58:02 user1
2005-06-21 14:58:02 user1
2005-06-21 11:57:51 user2
2005-06-21 10:57:51 user1
2005-06-21
Basically it boils down to the fact that with SQL you have to use some other
way of telling
each group apart other than position (or interposition, as you say in your
example). The fact
that you have entries in your table from user1, user1, user2, user1, user2,
user3, and user1
doesn't
comex [EMAIL PROTECTED] wrote on 06/21/2005 12:46:00 PM:
Basically it boils down to the fact that with SQL you have to use
some other way of telling
each group apart other than position (or interposition, as you say
in your example). The fact
that you have entries in your table from
How would you like to see that information GROUPed and what does that
grouping represent (physically). In essence, I am asking you to describe
what information you are determining by the grouping process, what does each
GROUP mean to you?
Grouping just means that somebody visited twice in a
On 6/21/05, comex wrote:
I have a table:
create table example(time datetime, username varchar(255));
Please tell me you didn't actualy use time as identifier :)
timeusername
2005-06-21 15:58:02 user1
2005-06-21 14:58:02 user1
2005-06-21 11:57:51 user2
2005-06-21 10:57:51
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
[EMAIL PROTECTED] wrote on 06/01/2005 11:49:35 AM:
I have two tables, cutting out the extra stuff they boil down to:
users:
userID int,
username varchar(11),
realname varchar(40)
logins:
ID int,
lastLogin timestamp
So, what I am doing is:
select user.id, username, realname,
Hello all,
My question is if unix Epoch time started on January 1st 1970 ,and mysql uses
the same implementation of time , what is the logic mysql developers have
used to offset it by 30 odd years that is the max date for mysql is 2068 and
not 2038 18th January, i work in a Financial services
Hi,
try this :
mysql select * from users;
++--+-+
| userID | username | realname|
++--+-+
| 1 | toto1| toto1 toto1 |
| 2 | toto2| toto2 toto2 |
| 3 | toto3| toto3 toto3 |
| 4 | toto4| toto4 toto4 |
Digvijoy Chatterjee [EMAIL PROTECTED] wrote on 01/06/2005
17:13:25:
Hello all,
My question is if unix Epoch time started on January 1st 1970 ,and
mysql uses
the same implementation of time , what is the logic mysql developers
have
used to offset it by 30 odd years that is the max date
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
Hello.
See:
http://lists.mysql.com/mysql/180308
Ashok Kumar [EMAIL PROTECTED] wrote:
[-- text/plain, encoding 7bit, charset: us-ascii, 11 lines --]
Hello Friends,
I wrote one simple pgm to connect and disconnect the database in
TC(Windows). when compiling the program, it's
Hello.
In my previous post I gave you a link to the thread where had
been described how to create the my_global.h. Have you tried that?
Hi,
U replied me without any contents. pls help me by giving some tips.
Thanks and Regards,
Ashok Kumar.P.S.
--
For technical
401 - 500 of 1409 matches
Mail list logo