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

    ITKE413,320 pointsBadges:
  • Change data path for existing SQL Server database

    My SQL Server has between 15-20 databases running on it. Now, because I'm running out of space, I'm looking to move my data path to another drive. How can I go about doing this? What SQL command should I use?

    ITKE413,320 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.

    ITKE413,320 pointsBadges:
  • How to get number of fields in SQL Server database

    Would I be able to get the number of fields in my SQL Server database with some sort of SQL statement? I'm talking about all the entries in my database. Thank you.

    ITKE413,320 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.

    ITKE413,320 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?

    ITKE413,320 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!

    ITKE413,320 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...

    ITKE413,320 pointsBadges:
  • Best format to store images in SQL Server database

    For my SQL Server database, what's the best format to store images? Would binary be the best bet? Thanks so much.

    ITKE413,320 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!

    ITKE413,320 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!

    ITKE413,320 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...

    ITKE413,320 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.

    ITKE413,320 pointsBadges:
  • How to get list of tables in Microsoft Access database through C#

    I just opened a connection to a Microsoft Access file through C# but would there be a way for me to retrieve a list of tables that exist in the Access database? I appreciate the help.

    ITKE413,320 pointsBadges:
  • DB2: Decrease column length

    Can I decrease the column length in DB2? In one of my columns, it's currently defined as VARCHAR(80). I want to move it to VARCHAR(60). How can I do that?

    ITKE413,320 pointsBadges:
  • Error when accessing MySQL database through web admin console

    For the past week, I've been trying to access a MySQL database through the web admin console. But I keep getting this strange error message: SQL select table_schema,table_name from information_schema.views where table_schema = ? failed : Got error 28 from storage engine. What should I do?

    ITKE413,320 pointsBadges:
  • Can two foreign keys reference the same primary key that is team table and fextures table having team a and team b referencing the team table primary

    Can two foreign keys reference the same primary key on another table. That I have team table attributes (Team_id, Team_name, Team_captain) and fixtures table having this attributes (Fixtures_id, fixture_time, fixture_date, fixture_venue, 1team_id, 2team_id). My question is this: Is it possible for...

    jupake15 pointsBadges:
  • Loading image into MySQL database from Excel file

    I have an excel file that contains an image in the first col. When I save it to an csv format, the excel program creates two images ( 1 small, 1 large) for each line in the excel file. How do I load both the file data and the large image into my mysql database?

    Wlm49hv5 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