• MongoDB: Auto-incrementing primary ID

    In MySQL - I was able to add an incrementing ID. But I still can't figure out how to do it in my other database (I'm using MongoDB). What's the process to do that?

    ITKE435,920 pointsBadges:
  • Cloud-based CRM Software for customer’s database

    I need to develop a customer’s database for clients. Can anyone recommend any Cloud-based CRM software for small business (Customer Relationship Management) that improves relation with new and existing customers? I know there is something to manage newsletters, few mail accounts, social media...

    darrenhayes7815 pointsBadges:
  • Remove numeric characters from MySQL string column

    In MySQL, is there a way for me to remove all the numeric characters from the string (in a column)? Thanks so much

    ITKE435,920 pointsBadges:
  • DATABASE FoxPro 2.6

    How to recover a damaged database file in Foxpro

    Prabhakaran20095 pointsBadges:
  • Reset MySQL stop words for full text search

    For MySQL, can I reset the stop word list for full text search? WAMP Server is already installed so that phpMyAdmin allows me access to MySQL. But I can't figure out how to reset it. What's the process?

    ITKE435,920 pointsBadges:
  • Calculate overall sum of SQL Server database sizes

    In my SQL Server, I need to find out how much space my databases are using. I tried using sys.databases but it's giving me separate results and I have to put that into Microsoft Excel and do the math there. Can I do this using T-SQL? Thanks so much.

    ITKE435,920 pointsBadges:
  • Exporting PostgreSQL database schema to XML format

    How can I go about exporting my PostgreSQL database schema to an XML format? Is there a certain code I have to use or a tool? Thank you.

    ITKE435,920 pointsBadges:
  • Store binary and image files in a database

    Does anyone know the best way for me to store binary / image files in a database? Also - I'm using SQL. Thanks!

    ITKE435,920 pointsBadges:
  • Change MongoDB database name

    Does anyone know of a way to change the database name in MongoDB? I can't find how to do it anywhere. Also, I don't want to change the entire database - just the name.

    ITKE435,920 pointsBadges:
  • Store .TXT files to MySQL server

    Would I be able to store files (TXT files) to my MySQL server? Is there a code for this? I appreciate the help.

    ITKE435,920 pointsBadges:
  • Microsoft Access 2013 Search Box

    I created a search text box that is on a form off a navigation form. The problem I am having is that I get a box saying "Enter Parameter Value" Forms!2frmHomeOwnerMain!txtSearch. It works fine when I bring up the form by its self, but when it is in the navigation form it does not. I believe I need...

    fubr69z15 pointsBadges:
  • How to get exact count of MySQL database rows

    Is there a way for me to get the exact count of all my MySQL database rows? I tried using the code below but it's not working because the tables are InnoDB. SELECT SUM(TABLE_ROWS) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'Tables'; What should I do? Thank you so much.

    ITKE435,920 pointsBadges:
  • Copy data from SQLite table columns

    I'm currently using SQLite and I have two tables (both of which have data in columns). Is there a way I can copy the data between both columns? Thank you so much.

    ITKE435,920 pointsBadges:
  • Removing unique constraints on MySQL table

    I recently created all of the unique constraints I needed for a table in MySQL database. But how can I show them? And, if possible, can I remove them if need be?

    ITKE435,920 pointsBadges:
  • Change MySQL database timezone

    For a MySQL database, is there a way for me to change timezone? We need to change it from EST to GMT. Is there a certain code I can use for this? Thank you.

    ITKE435,920 pointsBadges:
  • Any Certification for Mainframe Domain

    hi, i am mainframe domain in an IT Comany, i worked on COBOL, db2 ..etc can any one tell me, is there any certification for this specific domain?

    1768425 pointsBadges:
  • How to check if SQL row exists using PHP?

    How can I check if a SQL row exists using PHP? I'm currently using MySQL. Could I use PDO (PHP data object) to do this? Thank you so much.

    ITKE435,920 pointsBadges:
  • FoxPro 2.6 .DBF file lost

    My .DBF file is lost and I can see a .DIF file created in my database. How is .DIF file created from a .DBF file?

    urmila5 pointsBadges:
  • How to reset MySQL field to default value

    Does anyone know if there's a MySQL command that would reset a field to its default value? Basically, I don't want to write my default value several times in code in the database. Thanks!

    ITKE435,920 pointsBadges:
  • Export MySQL database in phpMyAdmin to PC

    I have a MySQL database in phpMyAdmin that has over a million records. I have to export it to my other PC but when I tried, it's only adding roughly 250,000 records into a .SQL file. What happened to the rest of the records? How can I do this efficiently?

    ITKE435,920 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.

Thanks! We'll email you when relevant content is added and updated.

Following