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

    ITKE827,960 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.

    ITKE827,960 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.

    ITKE827,960 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!

    ITKE827,960 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.

    ITKE827,960 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.

    ITKE827,960 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.

    ITKE827,960 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.

    ITKE827,960 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?

    ITKE827,960 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.

    ITKE827,960 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.

    ITKE827,960 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!

    ITKE827,960 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?

    ITKE827,960 pointsBadges:
  • MySQL: How to create InnoDB database

    In MySQL, I recently tried to create a InnoDB database type. This is the query I tried but didn't work: CREATE DATABASE "mydd" ENGINE = InnoDB My configuration says InnoDB is enabled. What else can I do? Thank you.

    ITKE827,960 pointsBadges:
  • Delete duplicate records in MySQL database

    One of our clients asked us to delete duplicate records in a SQL Server database and a MySQL database. We did it in SQL but MySQL is giving us issues. It says the format of the query is not correct. Does anyone know of a way to do this? Thank you so much!D

    ITKE827,960 pointsBadges:
  • Filtering a Record Selector (Microsoft Access)

    I need help figuring out how to filter a combobox that serves as a record selector. I set up a box that provides clients name & need it to filter them by agents assigned to each customer once the filter is set but, i cant get it to filter out customers under other agents. I would prefer a...

    mmorrison35 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