• 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:
  • Which database is better: MySQL or NoSQL?

    We are e-learning company and have a product based on client server model. We are currently using MySQL but facing problems with the installation as it takes longer time to install all the prerequisites. Is there a better way or better database option available? Switching to NoSQL-Mongo DB will be...

    RyanHaris5 pointsBadges:
  • Access MySQL on Linux from phpmyadmin on Windows

    Hi, First I'll describe my setup: Server 1: Windows server 2003 IIS 6 PHP 5.4.33 phpMyAdmin 4.2.9 Server 2: Ubuntu Server 14.04.1 MySql 5.5.38 PHP 5.5.9 I installed phpMyAdmin on my Windows server and configured it with two servers login. I can login to MySQL on my Windows Server and edit databases...

    sevynos35 pointsBadges:
  • Is it possible to run a query on two tables in two physical databases using MySQL?

    I understand that an Oracle database allows users to query on several physical databases. Does anyone know if there's a MySQL equivalent? I'm trying to run a query on two tables (which are in two different physical databases). Would it be possible to do this in MySQL?

    ITKE350,815 pointsBadges:
  • Limit the number of rows returned by an Oracle query

    Would there be a way to make an Oracle SQL query behave like it contains a MySQL limit clause? So, for example, here's what I can do in MySQL: select * from sometable order by name limit 20,10 This allows me to get the 21st to the 30th rows (meaning skip the first 20, give the next 10). The rows...

    ITKE350,815 pointsBadges:
  • How to import simple spreadsheet into MySQL database?

    I have a simple spreadsheet (only 2 columns) that I need imported into a MySQL database. I can convert the spreadsheet into whatever format I need to (comma delimited), but I need the MySQL commands that will import it. Does anybody know how to do this?

    Ingram871,285 pointsBadges:
  • What’s the difference between horizontally and vertically scaling a database?

    I'm working with two different databases (NoSQL and MySQL) and we're looking to measure the scalability of each database. What's the difference between vertically and horizontally scaling each one? I would appreciate any help.

    ITKE350,815 pointsBadges:
  • How to rename a MySQL database quickly

    How would I be able to rename a MySQL database quickly? Most of the time, I usually just dump the database and re-import it with a new name. But since this is a huge database, this isn't possible. Can anyone help me here?

    ITKE350,815 pointsBadges:
  • Bundling MySQL Community Edition

    Is it free to Bundle the MySQL Community Edition within our Product or along with our Product CD/DVD? Do we need expose the source of whole application software or product to the community? Our product is our main bread/butter of the company. Let me know what options are avaliable and how to do it.

    Rajeshbs45 pointsBadges:
  • Can System Center manage applications like MySQL running on Windows or Linux?

    Can System Center manage applications like MySQL running on Windows or Linux? This question was asked during the Microsoft System Center live chat on IT Knowledge Exchange in January 2010.

    ITKE350,815 pointsBadges:
  • Can we split a column in MySQL?

    In MySQL, we have a column that has comma separated data, like this: 1,2,3 3,2,1 4,5,6 5,5,5 So we're trying to run a search that would actually query each value of the CSV string individually. 0<first Is there a way to do this in MySQL? Thanks so much.

    ITKE350,815 pointsBadges:
  • Update statement with inner JOIN query isn’t working in Oracle

    We have a query that works fine with MySQL. For the past few days, we've been trying to get it to work in Oracle but keep getting the following error: SQL Error: ORA-00933: SQL command not properly ended 00933. 00000 - "SQL command not properly ended" Here's the query we're using: UPDATE table1...

    ITKE350,815 pointsBadges:
  • Free online practice exercises on SQL/Oracle

    I would like to know is there any website which offers free practice exercises on SQL/Oracle queries? Preferably advanced level queries. Thanks, Kruti

    Kpatel0 pointsBadges:
  • How to I insert a table if it doesn’t exist in a MySQL database?

    In a MySQL database, I'm trying to do the following query: INSERT INTO table_listnames (name, address, tele) VALUES ('Rupert', 'Somewhere', '022') WHERE NOT EXISTS ( SELECT name FROM table_listnames WHERE name='value' ); But it keeps returning the same error. I don't want to insert a record if the...

    ITKE350,815 pointsBadges:
  • How can I find duplicate records in a MySQL database

    I'm trying to pull out duplicate records in a MySQL database. I've already figured out how to do it this way: SELECT address, count(id) as cnt FROM list GROUP BY address HAVING cnt > 1 This is what it results in: 100 MAIN ST 2 But I need to do a pull that shows each row that has a duplicate,...

    ITKE350,815 pointsBadges:
  • Deleting multiple rows in MySQL

    We have a table with the following fields: id (Unique) url (Unique) title company site_id We now need to remove rows that have the same title, company and site_id. We've figured out one way to do it: SELECT title, site_id, location, id, count( * ) FROM jobs GROUP BY site_id, company, title,...

    ITKE350,815 pointsBadges:
  • Can I select 10 rows randomly in MySQL?

    What's the best way to write a query that can select 10 rows randomly from a total of 800,000.

    ITKE350,815 pointsBadges:
  • Can I replicate the ROW_NUMBER() in MySQL?

    Does anyone know of a way, in MySQL, to replicate a SQL Server function "ROW_NUMBER()?"  Here's my example: SELECT col1, col2, ROW_NUMBER() OVER (PARTITION BY col1, col2 ORDER BY col3 DESC) AS intRow FROM Table1 With this, I would be able to add a condition to limit "intRow" to 1 to get a single...

    ITKE350,815 pointsBadges:
  • How to create a MySQL pivot table

    I currently have a MySQL table that looks like this: company_name action pagecount ------------------------------- Company A PRINT 3 Company A PRINT 2 Company A PRINT 3 Company B EMAIL Company B PRINT 2 Company B PRINT 2 Company B PRINT 1 Company A PRINT 3 But now I need to run a SQL query to get...

    ITKE350,815 pointsBadges:
  • How to check if a table exists in MySQL without throwing an exception

    Does anyone know if there's a way to check if a table exists in MySQL (possibly through PHP) without throwing an exception? It's not beneficial for me to parse the results of "SHOW TABLES LIKE." There must be some sort of query I can use.

    ITKE350,815 pointsBadges:

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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following