• 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,...

    ITKE352,565 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.

    ITKE352,565 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...

    ITKE352,565 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...

    ITKE352,565 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.

    ITKE352,565 pointsBadges:
  • Creating forms with PHP and MySQL

    Using PHP and MySQL, I am trying to create a table form which can input multiple data within the form. When the space row provided is not enough, I want to add in another function which can help add rows in the same table. How can I do this?

    MarkG7135 pointsBadges:
  • odbc as/400 connect to mysql

    I am trying to figure out how to get data from the as/400 into mysql

    Sunnyday25 pointsBadges:
  • Storing GPS coordinates in a MySQL database

    We have a MySQL database that carries both longitude and latitude (GPS data). Here's how it's stored: column type ------------------------ geolat decimal(10,6) geolng decimal(10,6) Here's our question: Do we really need a data type that's large as "decimal(10.6)" to properly store the data?

    ITKE352,565 pointsBadges:
  • How can I my MySQL database file working?

    I was recently given a MySQL database file and now I need to restore it as a database on Windows Server 2008. I've been trying to use MySQL Administrator but I keep getting this error: The selected file was generated by mysqldump and cannot be restored by this application. What should I do to get...

    ITKE352,565 pointsBadges:
  • Visual Basic 2012 time format for label link to database

    I am new to programming and i was trying to figure out how to display a label i have as 12 hour format from the current 24 hour format. currently the label pulls the data from a Mysql database but display as 24 hour format since that's how Mysql stores it. all i want to do is have the label display...

    jafranklin775 pointsBadges:
  • How to do auto-increment values in PostgreSQL

    My department is switching over from MySQL to PostgreSQL and we need some help with auto-incrementing values. We saw in the PostgreSQL document that the datatype "serial" should work but we keep getting errors. Thank you very much.

    ITKE352,565 pointsBadges:
  • MySQL: How to restrict certain tables from mysqldump

    Does anyone know of a way to restrict certain tables from the mysqldump command? I'm using the following syntax that only dumps table1 and table2: mysqldump -u username -p database table1 table2 > database.sql Would there be way that I can dump all the others, except for table1 and table2? Would...

    ITKE352,565 pointsBadges:
  • Can I import a single MySQL database using a mysqldump?

    Does anyone if it would be possible to actually import a single database from an all databases mysqldump? I've already tried modifying the file manually but it didn't work. Are there any command line options to do this? We're removing a ton of databases but we need the option to restore one if need...

    ITKE352,565 pointsBadges:
  • Deleting a MySQL database through a Linux shell command

    For my MySQL database, I constantly update the schema files and then delete / recreate the database so our new schema is created. I do this by MySQL Query Browser, login and then delete the database. Now I'm looking to delete the database through a Linux shell command in Ubuntu.

    ITKE352,565 pointsBadges:
  • What’s the difference between create database and create schema in MySQL?

    For one of my projects, I'm looking to use a "information_schema" database and metadata but I'm still wondering if there are any actually differences between the "create schema" command and the "create database" command in MySQL. What are the differences (if there are any at all)? Thanks!

    ITKE352,565 pointsBadges:
  • How to remote connect to a ClearDB Heroku database

    How would I be able to perform a remote connection my ClearDB MySQL database (on Heroku) using the MySQL Query Browser? Basically, I'm trying to get a URL, port, login and password. Thanks so much.

    ITKE352,565 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...

    ITKE352,565 pointsBadges:
  • Should I store data in MYSQL as JSON?

    Should I actually store data in MySQL as JSON? A friend of mine did this and and it actually made their database's performance better and decreased latency. He's also told me that storing data as JSON makes everything easier. But is it easy to delete /edit data stored as JSON? Thanks.

    ITKE352,565 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!

    ITKE352,565 pointsBadges:
  • Can I write a case insensitive query for MySQL and PostgreSQL?

    I've been running a MySQL database locally for our development team but it's been deploying to Heroku which currently uses PostgreSQL. Heroku has been handling most everything I need but we use PostgreSQL for case-insensitive statements. What would be the best way for me to write a case-insensitive...

    ITKE352,565 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