• 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:
  • 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:
  • 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,195 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,195 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,195 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,195 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,195 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,195 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,195 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,195 pointsBadges:
  • Exporting a SQL database to MySQL

    I have a MS SQL .BAK database that I need to convert to MySQL. I was able to import the database but not actually export to MySQL. A friend of mine told me to use MySQL Migration Toolkit but it's been replaced by MySQL Workbench. Can I use this tool to migrate the database? Or is there another way...

    ITKE350,195 pointsBadges:
  • Can I set a default storage engine on MySQL database?

    I'm currently working on writing a SQL query to create a MySQL database with several default options including: character set and collation. I'm trying to figure out if I can actually set the default storage engine for tables in the database to InnoDB. Does anyone know if that's possible? Thanks so...

    ITKE350,195 pointsBadges:
  • How can I get the size of MySQL database?

    Say my MySQL database is called v3...how would I be able to get the size of it? Thank you!

    ITKE350,195 pointsBadges:
  • How can I see all the open connections in a MySQL database?

    I just administrative permissions on our MySQL database so I need to figure out how I can see all the open connections in that specific database. Can anyone point me the right way here?

    ITKE350,195 pointsBadges:
  • Does the physical size of our MySQL database affect its performance?

    We have a large database that has over 15 million records and takes up about 2 GB. We're worried now that it's going to affect the performance of our MySQL database. Should the physical size of our database matter to the performance? Should we just go in and clear some of the data out? Thank you!

    ITKE350,195 pointsBadges:
  • What’s the best way to store latitude / longitude pairs in a MySQL database?

    I currently have a MySQL database and I'll be doing a bunch of calculations on latitude / longitude pairs. What's the best way to store these in my database? Thanks so much.

    ITKE350,195 pointsBadges:
  • How many rows are too much in a MySQL database?

    We have a MySQL InnoDB that has over a million records. Is that too much to hold? Can my database handle that many records? We're curious because some of our queries are slower with a table that has 1,000,000 rows than one with 100 rows.

    ITKE350,195 pointsBadges:
  • What’s the best MySQL database field type for an URL?

    I've been trying to store an URL in a MySQL database but I'm running into an issue the field. What's the best way to define a field that will hold the URL for an undetermined amount of time. Thanks so much.

    ITKE350,195 pointsBadges:
  • Creating a new database with MySQL WorkBench

    I'm fairly new to the MySQL universe but I've recently installed MySQL Workbench and now I would like to create a database using it. How can this be done? I've noticed several "MySQL Schemas" being displayed in the Overview tab. Are those the existing datatbases? Thanks so much.

    ITKE350,195 pointsBadges:
  • MySQL database: Maximum number of records in a table

    For MySQL database, I was wondering what would be the maximum number of records I could add to a table. I was thinking of adding millions of of records to the table but I was wondering if there's a limit. What's the best way to handle this? Thank you.

    ITKE350,195 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