Greetings,
I’m receiving the following error while trying to compile /install
the Mysql odbc connector on AIX 5.3.
exec(): 0509-036 Cannot load program myodbc-installer because of the following errors:
rtld: 0712-001 Symbol __pth_init was referenced
from module myodbc-installer(), but a runtime definition
of the symbol was not found.
rtld: 0712-002 fatal error: exiting.
The environment is set as follows:
LD_LIBRARY_PATH="/ODBCDriverManager/lib"
export LD_LIBRARY_PATH
./myodbc-installer
Versions:
AIX 5.3
unixODBC-2.3.0
MySQL -connector-odbc-5.1.8-aix5.3-powerpc-64bit
Hi,
Anyone who can give me an advise about this error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[MySQL][ODBC 5.1 Driver][mysqld-5.0.51a-community-nt]Incorrect integer value: '' for column 'ss_sysid' at row 1
/dashboard/includes/lang/en.asp, line 5
Is there a problem with the ODBC or the version conflicts?
Thanks.
I can not able to see the following query result. start running before 10 hrs. I try to fix the problem by adding index for both tables I used and also I enabled mysql query catch. For information
I used mac os X, processor 2.66 GHz intel core I7, 4 GB memory 1067 MHz DDRS. and mysql version : 5.5.14;
no of records in fileinfo : 495,557 and fileConnection: 6,298,732.
create table SelectedFileLinksChilds as
select sp.*,fl.file_id as parent_file_id,fl.commit_id as parent_commit_Id ,fl.parent_id as p_Parent_id
FROM fileInfo sp
left join fileConnection fl
on sp.file_id = fl.parent_id ;
Thank you in advance
I am a novice when it comes to SQL. I am basically able to build reports using the query builder but have been asked to do something more complex.
Essentially I have a table with two columns, DateAdded and Name. The "Name" column contains a list of system names and "DateAdded" contains the date/time the system was updated.
Name DateAdded
CME 05/10/2010 11:44
Routing Rules 05/10/2010 11:54
WFM 05/10/2010 11:54
Avaya 05/10/2010 12:04
CME 05/10/2010 12:04
Avaya 05/10/2010 12:04
CME 05/10/2010 12:04
Routing Rules 05/10/2010 12:04
WFM 05/10/2010 12:04
Avaya 05/10/2010 12:54
I need to produce a stored procedure that returns the number of changes per 15 minute interval per system.
CME Routing Rules WFM Avaya
11:30 1
11:45 1 1
12:00 2 1 1 2
12:15
12:30
12:45 1
I have been given the following code to help. It seems to return the number of changes, but does not split it down by system. The person who gave me the code is not available to help me further - can anyone assist.
ALTER procedure [dbo].[ChangesByIntervalGK]
@in_date datetime
as
begin
declare @timesteps table (interval varchar(5), howmany int)
declare @num int
select @num = 0
while @num < 96
begin
insert into @timesteps values (convert(varchar(5), dateadd(minute, @num*15, 0),8), 0)
select @num = @num + 1
end
select innerquery.interval, max(innerquery.howmany) howmany from
(
select * from @timesteps
union
select
convert(varchar(5), dateadd(minute, datediff(minute,0,Addeddate) / 15 * 15, 0), 8) interval,
count(*) howmany
from ConfigurationItemLatest
where Addeddate between @in_date and dateadd(day, 1, @in_date)
group by convert(varchar(5), dateadd(minute, datediff(minute,0,Addeddate) / 15 * 15, 0), 8)
) innerquery
group by innerquery.interval
end
Create a query to display all the data from the employees table. Separate each column by a comma. Name the column THE_OUTPUT.
What is the command of this question?
For each employee, display the employees last_name, and calculate the number of months between today and the date the employees was hired. Label the columns months_worked. Order your results by the number of months employeed. Round the number of months up to the closet whole number.
Note: Your Results will differ.
Create a query to display the last_name and salary for all employees. Format the salary to be 15 characters long, left-padded with Rs.. Label the column SALARY.
What is the command of this question.
Hello,
I would like to know, how many concurrent user can be access MySQL database? How about the maximum data and transction can be reached in this database?
Hope to hear from you soon.
Thanks in advance.
UPDATE members a
INNER JOIN members b
on a.Recommended_By = b.ID
set a.Node = CONCAT_WS('(',b.ID,')',b.Node)
this statement to update node column from same table, but the problem is i have to execute many times to get the correct:
example :
ID Recommended_by Node
1
2 1 1
3 2 2
but i need it to be , and it done after execute many times
ID Recommended_by Node
1
2 1 1
3 2 1,2
The problem that the server i'm using does not support stored procedure , so i have to repeat the statement many times with while or loop , i dont know how
Hi, i need to write a Query to count the number of same words in one field of a table.
For example, let me give my Table & its contents.
Table: Calllog
Enquiry
------------------
PF,LOAN,LEAVE
LOAN,PF
PF,LEAVE
-----------------
Result should be as follows
EnquiryType Count
---------------------
PF 3
LOAN 2
LEAVE 2
---------------------
Can anyone help.?
Hi guys,
I have a database that looks like below. I would like to please help me
with a"query" that can select the "book" with the "Maximum Viewed Times/Most viewed" in each category.
I would like the results to be like:
RESULTS FORMAT:
Category Book Times_viewed
Mathematics mainil 54333
Biology amen 3321
Literature shill 4481
Physics cron 9283
etc......
"
TABLE FORMAT:
id Categories, Books, times_viewed creator_id
1. Mathematics camanw 3355 7
2. Mathematics maonil 54334 1
3. Biology wanten 930 6
4. Literature matayo 938 1
5. Biology bolin 732 3
6. Mathematics simsi 1123 4
7. Physics cron 9283 9
8. Biology amen 3321 10
9. Literature dolla 24 5
10. Literature shill 4481 2
11. Physics rand 223 6
12. English maseo 12 12
13. English poiha 5 39
14. Literature kinmoa 858 24
15. Mathematics blasb8 65532 5
16. English imei 2324
MySql ODBC connector install error Steve Bailey April 6, 2011 at 10:04 PM
Greetings, I’m receiving the following error while trying to compile /install the Mysql odbc connector on AIX 5.3. exec(): 0509-036 Cannot load program myodbc-installer because of the following errors: rtld: 0712-001 Symbol __pth_init was referenced from module myodbc-installer(), but a runtime definition of the symbol was not found. rtld: 0712-002 fatal error: exiting. The environment is set as follows: LD_LIBRARY_PATH="/ODBCDriverManager/lib" export LD_LIBRARY_PATH ./myodbc-installer Versions: AIX 5.3 unixODBC-2.3.0 MySQL -connector-odbc-5.1.8-aix5.3-powerpc-64bit
MySQL ODBC errorkim September 28, 2011 at 1:22 PM
Hi, Anyone who can give me an advise about this error: Microsoft OLE DB Provider for ODBC Drivers error '80004005' [MySQL][ODBC 5.1 Driver][mysqld-5.0.51a-community-nt]Incorrect integer value: '' for column 'ss_sysid' at row 1 /dashboard/includes/lang/en.asp, line 5 Is there a problem with the ODBC or the version conflicts? Thanks.
How to improve singil query performance in my sql?tmc October 2, 2011 at 12:15 PM
I can not able to see the following query result. start running before 10 hrs. I try to fix the problem by adding index for both tables I used and also I enabled mysql query catch. For information I used mac os X, processor 2.66 GHz intel core I7, 4 GB memory 1067 MHz DDRS. and mysql version : 5.5.14; no of records in fileinfo : 495,557 and fileConnection: 6,298,732. create table SelectedFileLinksChilds as select sp.*,fl.file_id as parent_file_id,fl.commit_id as parent_commit_Id ,fl.parent_id as p_Parent_id FROM fileInfo sp left join fileConnection fl on sp.file_id = fl.parent_id ; Thank you in advance
15 minute interval count querysprotson February 4, 2012 at 10:13 PM
I am a novice when it comes to SQL. I am basically able to build reports using the query builder but have been asked to do something more complex. Essentially I have a table with two columns, DateAdded and Name. The "Name" column contains a list of system names and "DateAdded" contains the date/time the system was updated. Name DateAdded CME 05/10/2010 11:44 Routing Rules 05/10/2010 11:54 WFM 05/10/2010 11:54 Avaya 05/10/2010 12:04 CME 05/10/2010 12:04 Avaya 05/10/2010 12:04 CME 05/10/2010 12:04 Routing Rules 05/10/2010 12:04 WFM 05/10/2010 12:04 Avaya 05/10/2010 12:54 I need to produce a stored procedure that returns the number of changes per 15 minute interval per system. CME Routing Rules WFM Avaya 11:30 1 11:45 1 1 12:00 2 1 1 2 12:15 12:30 12:45 1 I have been given the following code to help. It seems to return the number of changes, but does not split it down by system. The person who gave me the code is not available to help me further - can anyone assist. ALTER procedure [dbo].[ChangesByIntervalGK] @in_date datetime as begin declare @timesteps table (interval varchar(5), howmany int) declare @num int select @num = 0 while @num < 96 begin insert into @timesteps values (convert(varchar(5), dateadd(minute, @num*15, 0),8), 0) select @num = @num + 1 end select innerquery.interval, max(innerquery.howmany) howmany from ( select * from @timesteps union select convert(varchar(5), dateadd(minute, datediff(minute,0,Addeddate) / 15 * 15, 0), 8) interval, count(*) howmany from ConfigurationItemLatest where Addeddate between @in_date and dateadd(day, 1, @in_date) group by convert(varchar(5), dateadd(minute, datediff(minute,0,Addeddate) / 15 * 15, 0), 8) ) innerquery group by innerquery.interval end
i ask mysql questionJitendra Singh August 30, 2012 at 4:04 PM
Create a query to display all the data from the employees table. Separate each column by a comma. Name the column THE_OUTPUT. What is the command of this question?
I want a command of mysql to solve problems.Jitendra Singh August 30, 2012 at 4:35 PM
For each employee, display the employees last_name, and calculate the number of months between today and the date the employees was hired. Label the columns months_worked. Order your results by the number of months employeed. Round the number of months up to the closet whole number. Note: Your Results will differ.
I have doubt in mysql. pls help me. Jitendra Singh August 30, 2012 at 4:40 PM
Create a query to display the last_name and salary for all employees. Format the salary to be 15 characters long, left-padded with Rs.. Label the column SALARY. What is the command of this question.
MySQL Concurrent Accessnawal September 21, 2012 at 1:14 PM
Hello, I would like to know, how many concurrent user can be access MySQL database? How about the maximum data and transction can be reached in this database? Hope to hear from you soon. Thanks in advance.
update record from updated recordikrami October 10, 2012 at 5:16 PM
UPDATE members a INNER JOIN members b on a.Recommended_By = b.ID set a.Node = CONCAT_WS('(',b.ID,')',b.Node) this statement to update node column from same table, but the problem is i have to execute many times to get the correct: example : ID Recommended_by Node 1 2 1 1 3 2 2 but i need it to be , and it done after execute many times ID Recommended_by Node 1 2 1 1 3 2 1,2 The problem that the server i'm using does not support stored procedure , so i have to repeat the statement many times with while or loop , i dont know how
Count same words in a single columnVenkataRavi.CR October 30, 2012 at 5:51 PM
Hi, i need to write a Query to count the number of same words in one field of a table. For example, let me give my Table & its contents. Table: Calllog Enquiry ------------------ PF,LOAN,LEAVE LOAN,PF PF,LEAVE ----------------- Result should be as follows EnquiryType Count --------------------- PF 3 LOAN 2 LEAVE 2 --------------------- Can anyone help.?
MySQL Inquirymutebi December 23, 2012 at 5:39 AM
Hi guys, I have a database that looks like below. I would like to please help me with a"query" that can select the "book" with the "Maximum Viewed Times/Most viewed" in each category. I would like the results to be like: RESULTS FORMAT: Category Book Times_viewed Mathematics mainil 54333 Biology amen 3321 Literature shill 4481 Physics cron 9283 etc...... " TABLE FORMAT: id Categories, Books, times_viewed creator_id 1. Mathematics camanw 3355 7 2. Mathematics maonil 54334 1 3. Biology wanten 930 6 4. Literature matayo 938 1 5. Biology bolin 732 3 6. Mathematics simsi 1123 4 7. Physics cron 9283 9 8. Biology amen 3321 10 9. Literature dolla 24 5 10. Literature shill 4481 2 11. Physics rand 223 6 12. English maseo 12 12 13. English poiha 5 39 14. Literature kinmoa 858 24 15. Mathematics blasb8 65532 5 16. English imei 2324
Post your Comment