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

    ITKE440,735 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.

    ITKE440,735 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.

    ITKE440,735 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?

    ITKE440,735 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.

    ITKE440,735 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.

    ITKE440,735 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!

    ITKE440,735 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?

    ITKE440,735 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.

    ITKE440,735 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

    ITKE440,735 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:
  • Using LIMIT query in Microsoft Access 2007 database

    For Microsoft Access 2007 - I have created several queries in my database. But for some reason, it's giving me an error when I use LIMIT in my query. How can I correctly using LIMIT in my queries?

    ITKE440,735 pointsBadges:
  • MySQL command to find table in database

    For MySQL - does anyone know of a command that I can use to help me find one particular table in all the databases? I hate to admit this - I forgot where the table is. Thank you so much.

    ITKE440,735 pointsBadges:
  • Change MySQL database to read-only

    For my MySQL database, I have to change one of my tables to read-only to every single user. What's the process to do that? Thanks!

    ITKE440,735 pointsBadges:
  • Storing an image in MySQL database

    I'm trying to store an image in MySQL database but I can't figure out the process. I already have a table (with BLOB datatype) but that's how far I have gotten. Can someone help me out?

    ITKE440,735 pointsBadges:
  • How to automate getting the .CSV file from IFS folder to local desktop

    I am working on tool which extract the data from physical files based on some condition and creates a .CSV file in IFS folder. I want to automate the process to get the CSV file to local Desktop and should save the file in specified location in local system. Is there any way to open the .CSV files...

    Richapd5 pointsBadges:
  • Getting field names of Microsoft Access database table

    Would it be possible for me to get the field names of my Microsoft Access database table? Is there a SQL query I can use? Thank you.

    ITKE440,735 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.