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

    ITKE366,175 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...

    ITKE366,175 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...

    ITKE366,175 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.

    ITKE366,175 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!

    ITKE366,175 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.

    ITKE366,175 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...

    ITKE366,175 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.

    ITKE366,175 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!

    ITKE366,175 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...

    ITKE366,175 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?

    ITKE366,175 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!

    ITKE366,175 pointsBadges:
  • Generating a whole database script in MySQL Workbench

    Would there be a way to generate a whole database script in MySQL Workbench? I'm trying to take the whole database so where would I find the file? Also, I would write the data to the text file (Like SQL Server). Appreciate the help.

    ITKE366,175 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.

    ITKE366,175 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.

    ITKE366,175 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.

    ITKE366,175 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.

    ITKE366,175 pointsBadges:
  • Can I do a MySQL dump by a SQL query?

    Can I do a "mysqldump" by a single SQL query? What I basically mean is that I want to dump the whole database. Thanks so much!

    ITKE366,175 pointsBadges:
  • How to find all occurrences of a URL in a MySQL database

    A friend of mine has been having trouble dealing with his MySQL database. He's been trying to locate all occurrences of a URL in the database but he doesn't know where to start. He wants to search all of the tables / fields. Appreciate the help.

    ITKE366,175 pointsBadges:
  • Deleting and creating databases in Neo4j

    Would it be possible to delete / create several databases in Neo4j (like MySQL)? If I can't do that, would I be able to delete all the nodes / relationships of an existing graph so I can get a clean setup for testing? Thanks so much.

    ITKE366,175 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