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

    ITKE346,030 pointsBadges:
  • What’s the better option for SQL Where clause: IN vs. OR?

    I'm working with my team on several huge databases and we need to know which would be a better option for us in the SQL Where clause: IN vs OR? Is there actually a difference between the two? Thanks so much.

    ITKE346,030 pointsBadges:
  • Where are my database files stored on my Android device?

    I've just created a SQLite database on my Android device. The program reads/writes to the database so the file has been created. Here's what the SQLiteDatabase.mPath is set to: db.mPath = "/data/data/dev.client.android/databases/clientDB.db" But my problem is when I'm browsing the directories on my...

    ITKE346,030 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.

    ITKE346,030 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!

    ITKE346,030 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...

    ITKE346,030 pointsBadges:
  • How to export a MySQL database to SQLite

    I apologize for the short question but can anyone help me export my MySQL database into a SQLite database? Thanks so much!

    ITKE346,030 pointsBadges:
  • Can I embed a PostgreSQL database?

    I'm not sure if this is possible but I'm trying to embed a PostgreSQL database. Several employees at our organization told me that it's not possible but I thought I would at least ask here. So basically, I'm looking for a PostgreSQL without the configuration / installation. Appreciate any advice.

    ITKE346,030 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?

    ITKE346,030 pointsBadges:
  • Copying my PostgreSQL database to our development server

    I'm trying to find the easiest way to copy my PostgreSQL database to our development server. What's the best way to do this? Would a dump and restore process work?

    ITKE346,030 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!

    ITKE346,030 pointsBadges:
  • How can I backup a SQLite database to my SD card?

    I'm trying to add a feature in my Android application that would automatically back up a SQLite database to my SD card. Is there a way to do this? Thank you very much.

    ITKE346,030 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.

    ITKE346,030 pointsBadges:
  • Would foreign keys be necessary to a database design?

    I'm pretty new to database design so I'm trying to figure out how important foreign keys really are for the design. I know they aid the programmer to manipulate data but say the person already knows how to do that. Are they really necessary then? Thanks.

    ITKE346,030 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.

    ITKE346,030 pointsBadges:
  • What’s a reasonable length for database fields?

    I've been designing a database table and I'm sorry if this is a stupid question but I need to know how long should a "firstname" be? For common fields (First name, last name and email address), what's a reasonable length for each? Appreciate the help.

    ITKE346,030 pointsBadges:
  • SELECT AND OMIT in RPGILE

    hI,GUYS,Actually select and omit used in lagical file to control the records,values like. But without key field how can i use these select and omit condition in logical file? And one more doubt is what is the exact uses of %SCAN,%SUBST, %SUBDT,%EOF,%CHECK,%COMMIT,%FOUND.Plese explain these

    abhisheka1385 pointsBadges:
  • Checking the version of SQL Server for a database using T-SQL

    Is there a way for me check what version of SQL Server I'm using for a database through T-SQL? Would there be some sort of stored procedure I can use? Thanks.

    ITKE346,030 pointsBadges:
  • Writing a unit test for files with database access

    I'm currently using PHP and Python and I'm trying to figure out how to write a unite test for several of my files. About 75% of my files needs database access so that's where the problem lies. What should I do here?

    ITKE346,030 pointsBadges:
  • How to store an IP address in MySQL

    Could anybody tell me what the right field type would be for storing an IP address in MySQL? Also, what's the right way to store it too?

    ITKE346,030 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