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

    ITKE828,765 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.

    ITKE828,765 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!

    ITKE828,765 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?

    ITKE828,765 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.

    ITKE828,765 pointsBadges:
  • Connect Visual Studio 2013 with MySQL database

    I'm currently using Visual Studio 2013, but for some reason, I can't find MySQL database in the choose data source dialog window. I have MySQL connector and installer installed. Do I need something else?

    ITKE828,765 pointsBadges:
  • Finding relations between MySQL tables

    How can I find the relations between all of my MySQL tables? My database has roughly 100 - 200 tables and I need to find out their relation. Is this actually possible? Thanks!

    ITKE828,765 pointsBadges:
  • Where can I find the SQL file after MySQL dump?

    After successful connection using SSH and entering right login credentials, I'm not able to find out the backup SQL file. Any help would be really appreciated.

    AjitK292,445 pointsBadges:
  • Make SQL Server primary key AUTO INCREMENT

    In SQL Server, I have a database with a table and the primary key is titled 'ID'. Is there a way I can make it AUTO INCREMENT? Thanks so much.

    ITKE828,765 pointsBadges:
  • How to clean and restart CouchDB

    Does anyone know the command to clean CouchDB? Also - after it's cleaned, I have to restart it too. What's the command for that?

    ITKE828,765 pointsBadges:
  • Compare SQL Server and Oracle databases

    Our department currently has an SQL Server database and Oracle database. One of the tables is labeled 'Inventory' - which has thousands of rows from both databases and it will continue to grow over time. Now, here's what we need to do: We have to compare the Oracle data to the SQL Server data so we...

    ITKE828,765 pointsBadges:
  • Create foreign key in Oracle using ON UPDATE CASCADE

    I'm working with both Oracle and SQL Server. And in SQL, I created a foreign key with the ON UPDATE CASCADE option. So basically, whenever I update the column in the primary key - all of the other foreign keys (in tables) will be updated too. But I'm not sure how to do this in Oracle. Can someone...

    ITKE828,765 pointsBadges:
  • Convert MySQL syntax to PostgreSQL

    Does anyone know if there's a tool that can help me convert a MySQL syntax to PostgreSQL? Would mysqldump be an option for me? Thank you.

    ITKE828,765 pointsBadges:
  • Check MySQL databases using Command Line Client

    I'm fairly new to MySQL - specifically creating new databases. I've created several tables using MySQL WorkBench but I need to check them using the Command Line Client. How can I use the command line? Thank you so much.

    ITKE828,765 pointsBadges:
  • How to store a MySQL database in source control

    My department is currently working on an application and we have to store our MySQL database in source control. What's the best way to do that? We were thinking of having two different files: Script for the tables Inserts for the sample data Would that be a good way to do it? Thank you very much.

    ITKE828,765 pointsBadges:
  • Deleting views from MySQL database

    I'm trying to delete all views from my MySQL database. How can I do that? I'm stuck. Is there a query I can use? Thank you so much.

    ITKE828,765 pointsBadges:
  • dBASE Program Result File

    Created a program to extract certain records from a file. What do I need to put in program to create a new file with the results?

    curley20165 pointsBadges:
  • Storing XML data in MySQL database

    How can I go about storing my XML data into a MySQL database? It's pretty complex data so I want to make sure it's done the right way. Do I have to use foreign keys?

    ITKE828,765 pointsBadges:
  • List Microsoft Access database tables using SQL

    Would there possibly be a way to list all of my tables in a Microsoft Access database using SQL? I know how to do it in SQL Server but not sure of the command in Access. Thanks!

    ITKE828,765 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