• Is MySQL table supports both foreign keys and partitions?

    I have one table like employee (emp_no,emp_name,dept_id). This table contains the foreign key relation with deportment table (dept_id). Now I want to do partition on emp_no field in employee table. Is it possible or not?

    lakshmilogica15 pointsBadges:
  • Is there a way to validate a CSV string in .NET?

    Hi experts, Does anyone know if there's a way for me in .NET that would validate my CSV string? Is there something in C# that would help? Thanks, Doug

    ITKE1,012,075 pointsBadges:
  • How to show progress of CSV file to MySQL upload

    My CSV file is very large (Millions of files) and I'm currently loading it into MySQL. I'm using the LOAD DATA INFILE command. But I feel that this is taking way too long. Is there a way for me to see the progress of the upload? I tried SELECT COUNT(*) but it keeps giving me a 0 count. What should...

    ITKE1,012,075 pointsBadges:
  • How to convert Microsoft Excel spreadsheet to CSV programmatically

    Does anyone know of an easy way (possibly a Unix script or command) to convert my Microsoft Excel spreadsheet to CSV? Thank you very much!

    ITKE1,012,075 pointsBadges:
  • Convert CSV string in ASP.NET

    For ASP.NET - can I convert a CSV string into a string[] or possibly a list? In the data - there are no commas if that makes it easier. Thank you!

    ITKE1,012,075 pointsBadges:
  • Write output of Fortran program in CSV format

    Sorry if this question is confusing but I have a Fortran program and I need to write the output in a CSV format. That way - I can open the file in Excel to plot my data. Thanks!

    ITKE1,012,075 pointsBadges:
  • Export/Import database with large blobs in MySQL

    Hi, we are having trouble exporting and importing databases with blobs in mysql. We have a development environment and a production environment both running mysql-5.0.45 and want to dump databases with blobs from one to the other. We have tried with many options but nothing works. When importing...

    jailall101785 pointsBadges:
  • How does middleware support database communication

    Hello, I'm new here. I want to know how middleware supports communication between databases.

    saifnaik5 pointsBadges:
  • How to convert CSV file into DBF file

    Would I be able to convert my CSV file into a DBF file using Python? Perhaps a script would work for this? Thanks so much.

    ITKE1,012,075 pointsBadges:
  • Converting JSON file to CSV file using Ruby

    My teammate in my department needs to convert our JSON file to a CSV file using Ruby. What's the best way to do that? Thanks very much.

    ITKE1,012,075 pointsBadges:
  • How to connect TMG to Wi-Fi

    I would be grateful if you could answer my questions. How do I connect TMG to access point for connect smartphones to the internet without set proxy on mobiles? In fact, I want to connect to the internet directly by smartphone without set proxy setting on phone. I don't want any authentication on...

    TMGTMG5 pointsBadges:
  • Data synchronization/integration between two web applications

    Real time synchronization of two web applications is required. The scenario is that there is an E-commerce website which will display a super market products on its website plus E-commerce website has its own products too. The super market's  inventory management system will be in real  time...

    maha1235 pointsBadges:
  • Retrieving data from AS/400 tables with PHP?

    I think I will die! Does anyone know how to get data from a table on AS/400 displayed with PHP through ODBC? I'm starting to go mad. I tried ODBC drivers (iSeries Access client, Client Access). Nothing helps. I have Apache server as localhost on my machine and PHP installed and that works fine. The...

    Avrelivs80 pointsBadges:
  • Impacts of cloud computing on database management

    How does cloud computing apply to database management?

    anesumutizwa955 pointsBadges:
  • How to read items from a text file and save in-memory database at regular intervals by Spring Batch?

    I have a situation that I need to read the items from a text file and store in the in-memory database (say HSQLDB). The text file contains 40 lines with a group of 4 items say: A : 100 B : 200 C : 300 D : 400 A : 500 B : 600 C : 700 D : 800 A : 900 B : 1000 C : 1100 D : 1200 .... .... A : 3700 B :...

    Puneet Nebhani5 pointsBadges:
  • Creating a new database using an MDF file

    My database saves as MDF. I want to know what are the steps to restore or create a new database using a MDF file? I tried to restore as usual but it shows an error. Please help.

    Thrstorm5 pointsBadges:
  • CSV format isn’t opening up correctly in Internet Explorer

    I currently have a JSON object that's turned into an array, followed by a CSV format (file). For Internet Explorer - it keeps opening up a new window. I don't want that. I need the file to download or have the 'save file' window to appear. Anyone know why this is happening?

    ITKE1,012,075 pointsBadges:
  • Upload image from Excel sheet into MySQL

    How can I upload image from my Excel sheet to MySQL Database?

    BatulBohra5 pointsBadges:
  • Run a macro on Access database on a server

    I need to run a macro in an Access database on a server. What do I need on server to run .mde? Do I need Access?

    saxmanmiller5 pointsBadges:
  • TMS configuration during migration to HEC

    Hi all, We are migrating to HANA Enabled cloud from On-Premise landscape. Current landscape is D->Q->R->P After phase two, R and D will be on HEC and rest on-premise. Trans directory is set as D. OS/DB will be changed to Linux/Sybase from Windows/SQL. Please let me know if TMS...

    BASIS125 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