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

    ITKE352,565 pointsBadges:
  • How can I browse a SQLite database in Android

    I'm an Android user and I was wondering if there's a way to browse SQLite databases on my smartphone / view the data in the databases. I've been using SoftTrace but I was wondering if there was a mobile way to do it.

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

    ITKE352,565 pointsBadges:
  • Character limit for a column in an Oracle database

    I'm looking to store different postal codes in my Oracle database. I believe the column will be a VARCHAR2. I know the U.S. codes are 9 and Canadian codes are 7. Would 32 characters be efficient enough for the limit in the column? Or should I go higher? Thanks!

    ITKE352,565 pointsBadges:
  • Joining tables from a different SQLite database

    In one of my applications, I currently use a SQLite database and it's been working great. But I've been adding new functions and features so I'll need a second database and I'm having trouble with joining tables from a different database. How can I do this?

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

    ITKE352,565 pointsBadges:
  • How to store images in a MongoDB database

    Would it possible to store images in a MongoDB database rather than just text? Should I create an array of images in the database? If that's possible, can I do the same for videos?

    ITKE352,565 pointsBadges:
  • Deleting all records from a database in a Ruby on Rails application

    How would I be able to delete all of my records, in one of my database tables on a Ruby on Rails application. I'm looking for a way not to do it through SQL.

    ITKE352,565 pointsBadges:
  • How can we store hours and minutes in a SQL Server database?

    My partner and I would like to store times in our SQL Server database but we only need to store hours and minutes. We already know we could use "DATETIME" and ignore the rest of the data but is there an easier way to do this? Thanks so much.

    ITKE352,565 pointsBadges:
  • How to encrypt a SQLite database

    I understand that Android uses SQLite database to store data but now I need to encrypt a SQLite database but I'm not sure how this can be done. What's the process to do so? My friend mentioned SQLCipher, would that work?

    ITKE352,565 pointsBadges:
  • Best database option for a .NET application

    My team is has been developing a small application with C# in .NET and we're looking to use a small light weight database (that doesn't use a ton of resources). What would be the best option for us?

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

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

    ITKE352,565 pointsBadges:
  • What’s the best way to store tags in a database?

    My teams is in the process of implementing a tagging system on our website but we have a big question: What's the most efficient way to store the tags in a database, so they can be searched and filtered? We've come up with this so far: Table: Items Columns: Item_ID, Title, Content Table: Tags...

    ITKE352,565 pointsBadges:
  • Importing a web page to a database

    How we can import a web page (the full content of the web page) into the particular database? That means you create your own search engine and storing the web page in to the created search engine database.

    ptnaveenraj20 pointsBadges:
  • What’s the best way to create flat file database structures?

    Would anybody be able to share some of the best ways / practices for creating flat file database structures in PHP? From what my partner and I have learned, these frameworks are more of ways to implement SQL-like query syntax. We were also told SQLite is the way to go here. Is that true? Thanks so...

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

    ITKE352,565 pointsBadges:
  • How to duplicate MySQL database

    Would it be possible for me to duplicate my entire MySQL database on a Linux server? I already know I can export / import but the database has over 25 MB so it's not the best solution. Can I use "MySQLdump" or just directly duplicate the database files?

    ITKE352,565 pointsBadges:
  • How to rename a MongoDB database

    I just realized there's a typo in my MongoDB database name and I need to change the name ASAP. I've tried to copy and delete it like this: db.copyDatabase('old_name', 'new_name'); use old_name db.dropDatabase(); Would there be a command to rename it?

    ITKE352,565 pointsBadges:
  • VB.NET code to search if a record already exists or not

    Hi! I need a fresher..I want a VB.net code to search record from SQL database table by using two fields of table as a condition i.e client name and client code before saving any new record and if record already exist in table it give me message for that. I'm sending you the code. Please help...

    Sachinm10 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