• Should I use MEDIUMBLOB to store large files in MySQL database?

    I need to store user uploaded files to our database (and I can't use a file system). The files are all different types and I'm running into a problem deciding if I should use "MEDIUMBLOB" to store these as binary data. And this problem arises from the files having various file sizes. I understand I...

    ITKE361,695 pointsBadges:
  • How can I store large hashes in MySQL?

    I'm trying to store a bunch of 512-bit SHA-2 hashes into a MySQL table. In an effort to save space, I'm looking to store them in binary form, instead of a string of hex digits. I'm also using ORM so this will inflate them to any object / structure I choose. I know I could split them up using eight...

    ITKE361,695 pointsBadges:
  • MySQL: What’s the downside of storing images in the database?

    I'm looking at using MySQL for my database so I need some opinions on the disadvantages of storing images inside of it. Is it not as efficient as storing images on a server? Does it take longer for the images to download vs. disk storage? Thanks for all the input!

    ITKE361,695 pointsBadges:
  • What factors are there for MySQL database size estimation?

    We have an application database (which includes a table for users). Here's the setup: 1Kbyte of data per user that's based on counting fields * typelength and about 100 things of the same size that belongs to a user (about 0.5 Kbyte). This leads to around 51 Kbytes of data per user. Now, we're...

    ITKE361,695 pointsBadges:
  • What’s the best option for storing graphs in persistent storage?

    I'm wondering what would be the best way for me to store my graphs in persistent storage (for analysis, search, clustering, etc.). I'm considering NEO4J but I'm looking what other options are available to me. Would Cassandra or MySQL work for me? Thanks for the help.

    ITKE361,695 pointsBadges:
  • What’s the best network connection?

    Hello! I have and old client-server application written in Visual Basic 6. My database is MySQL 4.0. It has 10 concurrent clients under the same LAN. I need to make a new android application to run on tablets. The new app must connect via Mobile Internet to my old client-server application (or...

    Vfafou10 pointsBadges:
  • How can I pass tablename as a parameter in MySQL stored procedure?

    my SQL stored procedure is like this.... ALTER PROCEDURE [dbo].[Sp_InsertDataMaster] @_ImageID int, @_Stat bit, @_tablename nvarchar(200) AS begin declare @strTemp nvarchar(max) set @strTemp = 'Insert into ' + @_tablename + '(ImageID,Status) values ('+ convert(nvarchar(5),@_ImageID) +','+...

    Minal45 pointsBadges:
  • Merging columns in SQL Server database

    Hi everyone! In my SQL Server database, I'm trying to merge the following: [TicketID], [Person] T0001 Alice T0001 Bob T0002 Catherine T0002 Doug T0003 Elaine Into this: [TicketID], [People] T0001 Alice, Bob T0002 Catherine, Doug T0003 Elaine Now, I know there's the function "GROUP_CONCAT" for MySQL...

    ITKE361,695 pointsBadges:
  • MySQL syntax

    Hi, Have a table budget When I try this: MySQL: insert into budget values (’Department A’,1,2,200) Department A represents:A Department called A 1 represents: a course no from table course 2 also represents: a course no from table course. It doesn't work. Any suggestions?

    Ak1bo78150 pointsBadges:
  • Dynamic Case Management Open Source

    What's the best DCM software or library open source to implement in a php and MySQL project?

    glorenz15 pointsBadges:
  • MySQL stored procedure debugger tool

    Hi, I am looking for a MySQL stored procedure debugger tool for Ubuntu (Unix). Can someone help?

    Perfsid5 pointsBadges:
  • Java CSV reader (+charts)

    Hello there, I'm trying to create a Java web application which will do the following: -upload .CSV files -store them in a database -will display charts depending on the content of the .CSV file Any ideas? It HAS to be in JAVA! Thanks in advance, Peter

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

    jailall101735 pointsBadges:
  • Which config file does MySQL use?

    Hi, I'm having trouble with MySQL. My OS is IBMi V7R1. We are using MySQL 5.0.45 with zend server 5.6.0. The problem is that the MySQL server works fine in qp2term(shell) but ends immediately after start with zend server. Also, when I check the defaults config file for MySQL I get this message:...

    jailall101735 pointsBadges:
  • Problem to storing records at SAP DB from MySQL

    I'm using JCO for connecting SAP through jsp-Servlet. I want to store all MySQL Records to SAP DB. What will I Do?

    Mavric10 pointsBadges:
  • Recovering the MySQL database

    In the process of editing my database, I accidentally deleted the MySQL database. I thought I recovered it, but when I opened MySQL Query Browser, it was not there. Is there an easy way to recover it for good?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL TAGS

    Why am failling when am using mysql to create database and am using the exactly tags?

    Abcdefg071541520 pointsBadges:
  • Pass table name to procedure including fields

    I want to do the following with a procedure: I have per user that has the same structure. The only difference is the table name. I need to be able to pass the table name to a procedure and retrieve data for that table. At the moment I have this: sp_getdata(id, givendate datetime,tablename...

    Sonyadba5 pointsBadges:
  • Get MYSQL data on iSeries

    Datas are on a Linux server = mysql database and I want to transfert some datas to a DB2 database on iseries. At this time, I go throw Excel but sure we can do better !!...

    Fredolatama5 pointsBadges:
  • create database using java

    How to create database (not table) using java? For example, I want to create database in MSAccess, MySQL, Oracle etc.

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

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following