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

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

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

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

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

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

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

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

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

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

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

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

    ITKE440,705 pointsBadges:
  • How to import MySQL database dump file in Java

    Is there a way for me to import my MySQL database dump file programmatically in a Java program? I've tried the below code but nothing is working. Connection conn = dbConnectionSource.getConnection(); Statement stmt = conn.createStatement(); stmt.execute(FileUtils.readFileToString(new...

    ITKE440,705 pointsBadges:
  • How to encrypt my database

    With all these hacks going around, I need my database to be very secure (particularly my hard disk). But I'm not sure which databases support encryption. Can someone help me out? If it's not possible, are there other ways I can encrypt my database. Thanks!

    ITKE440,705 pointsBadges:
  • Compact Microsoft Access database in VBA

    My apologizes for the brief question but, in Microsoft Access, can I compact my current database using VBA? Thanks!

    ITKE440,705 pointsBadges:
  • SQL Server 2012 error message when restoring database

    I keep getting this odd error message in SQL Server 2012 when I'm trying to restore a backup that was made from a previous version. Here's the error message I'm getting: System.Data.SqlClient.SqlError: Directory lookup for the file "C:\PROGRAM FILES\MICROSOFT SQL...

    ITKE440,705 pointsBadges:
  • MS Access 2007: 15 years of contract

    Hello, I'm a student in an intern program right now. My organization give me a MS Access file that contain information of contract workers. They asked me to separate which of the workers that almost work for 15 years and make a reminder for user 6 months before due date. My department scope is...

    Vencro25 pointsBadges:
  • MySQL: Get last deleted ID

    In MySQL, is there a way for me to get the actual last deleted ID after a row has been deleted? Perhaps a command / query that's similar to getting the last inserted ID. Thanks.

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