Home Askquestions Ask MySQL Questions online


Share on Google+Share on Google+

Ask MySQL Questions online

MySQL is an open source Relational Database Management System (RDBMS) used in web applications to contain and manage small to giant data in itself.

Ask MySQL Questions online


MySQL is an open source Relational Database Management System (RDBMS) used in web applications to contain and manage small to giant data in itself. It is very popular cross platform Structured Query Language (SQL) Database Implementation used in creating static to dynamic website and web applications.

Due to its scalability, flexibility and power, it is being popular day by day and the clients’ demand to development any database software using it is also increasing. The rising demand enhances the pressure and problem, which results several errors. In this move, we have initiated a new service ‘Ask Questions on MySQL’. Now you are free to ask any sorts of questions relating to MySQL under this service. You will get the most appropriate solution within two days of your questions.

Our experts have deep knowledge and strong experience on MySQL who can solve very complex problem very quickly, while our visitors who knows any appropriate solution can also post their suggestions and solutions. We will appreciate the efforts of them.

MySQL stands for My Structured Query Language, an open source RDMBS available under GNU General Public License at free of cost. It works on several operating system platforms including Windows, Linux, Mac OS, and Sun Solaris. All major programming languages with language-specific APIs include Libraries for accessing MySQL databases. The MySQL server and official libraries are mostly implemented in ANSI C/ANSI C++.


Liked it!  Share this Tutorial

Follow us on Twitter, or add us on Facebook or Google Plus to keep you updated with the recent trends of Java and other open source platforms.

Posted on: November 16, 2009

Ask Questions?    Discuss: Ask MySQL Questions online   View All Comments

Post your Comment

Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
Steve Bailey
April 6, 2011
MySql ODBC connector install error

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
September 28, 2011
MySQL ODBC error

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.
October 2, 2011
How to improve singil query performance in my sql?

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
February 4, 2012
15 minute interval count query

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
Jitendra Singh
August 30, 2012
i ask mysql question

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?
Jitendra Singh
August 30, 2012
I want a command of mysql to solve problems.

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.
Jitendra Singh
August 30, 2012
I have doubt in mysql. pls help me.

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.
September 21, 2012
MySQL Concurrent Access

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.
October 10, 2012
update record from updated record

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
October 30, 2012
Count same words in a single column

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.?
December 23, 2012
MySQL Inquiry

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
November 2, 2013
Beginning MySQl

Hello! I am a beginner in MySql and generally in programming. I wanted to create a database (Collection of Research Papers in PDF)of papers for my department in the university. I wanted this database to be distributed by a CD ROM, installable and i don't want it to be on-line. i wanted to create a new version each year, which will then be again distributed with a CD ROM. I heard MySql is one of the best database management software software, but i am not sure if it will give me an exe or web php application that can be easily accessed and searched on. So if any one has an idea how i should program it, please do help me
January 15, 2014
how to connect 2 computers with a single database

here is my situation: 1. I have 2 pc running on windows 7. 2. I have mysql 5.2 on both. 3. I have a database with one of the system 4. I need to access it through the other one.