1
  • How long does a MySQL query take?

    When I'm running a specific query in MySQL - I want to see how long it's running for. Is that possible? Basically, just the time takes. Thank you so much.

    ITKE435,895 pointsBadges:
  • GROUP BY MySQL

    Hi, I have started working with a MySQL databse. I need a query that will either make use of "DISTINCT" or "GROUP BY" but that selects the record that has the highest 'VersionNumber' Can anybody suggest how I would achieve this? Thanks in advance.

    LewisT5 pointsBadges:
  • SQL selecting multiple rows from same column based on different column values

    I have am joining a table (object_restrictions) that has three columns: (object_type), (object_restriction_ID) and (object_restriction). I would like to join the table on (object_restriction_id) but select multiple rows based on the value in the column (object_type) and have them listed as separate...

    edsonk4510 pointsBadges:
  • Querying against Views vs Tables

    I have a view that combine several tables, so that the view presents more information that each table taken individually. I want to write an "INSERT INTO ... SELECT ... FROM xxx" query. Should I use the View in that "FROM xxx" or should I expand what the view shows? What's better in terms of...

    Artaxerxes25 pointsBadges:
  • MSQL Auditing

    Hello. I'm dot.net developer, and i'm working a lot with MSQL. My current task is when some user executes select query on database, i should "catch" the query data. What do i mean is if select query is "select * from UsersTbl where UserID = 5", i have to get  '5'. Does somebody have any idea...

    Dimon745 pointsBadges:
  • Starting a session in MySQL

    how to start a session in my sql?

    98672129495 pointsBadges:
  • pagination using MySql

    can anybody get any query for pagination using MySql.. any helps are welcome

    NetDeveloper90 pointsBadges:
  • Need help with documentation on a time tracker project

    i m workin on a project - time tracker. its my 1st one. m a newbie n have no idea about documentation. can someone plz brief me how it wil b done? thanx

    Novicebeginner5 pointsBadges:
  • MySQL brain teaser

    This has been driving me crazy. I’m trying to come up with an UPDATE query in MySQL that will remove the second blank space in a name and close the gap.   Example: O Brien, John E should become OBrien, John E   A simple REPLACE (name, ‘ ‘,’’) where SUBSTRING (name,2,1) like “ “...

    Michael Morisy8,588 pointsBadges:
  • SQL query

    I have two database tables of employee where employee table maintains EMPNO,ENAME,JOB,MANAGER,HIREDATE,SALARY,COMMISION ,DEPTNO and department table maintais details of DEPTNO,DNAME,LOCATION. questions are : 1)Display the first four rows of employee table. 2)Display the empno,ename from row 2 to...

    Srividya5 pointsBadges:
  • SQL join two counts on same table

    I have two different SQL statements that each is a count on the same table, but a count of different columns. I'm trying to combine them into a single statement, but am having trouble doing so.  The two statements are:  SELECT photoIDWinner as photoID, count(primaryID) as countWin FROM `rankRaw`...

    Shantheman15 pointsBadges:
  • Get user input in MySQL query

    How can i get user input in any mysql query at runtime.

    Prashant.expert25 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following