What Is The Best Way To Store XML File In MySQL?
I would like to store XML files in MySQL. What is the best solution:
1. Convert it to string and store it as CLOB/text
2. Serialize it and store as byte array
3. Flatten it out and create one column per element, each column is VARCHAR
View Complete Forum Thread with Replies
Sponsored Links:
Related Messages:
Store Results To A File
I am brand new to mysql and have a very basic question, but i can't find the answer in the manual. I am doing a query of a database: select * from mydatabase and I want to store the results in a file. Is there a command to do this?
View Replies !
View Related
Max_allowed_packet To Store A Sound File
I used sqlyog GUI for mysql and I want to store sound file in my database. I used oracle before using mysql. I know sql. So the problem is that I want to store sound file I made a blob and trying to store sound file but mysql gives an error message max_allowed_packet bigger so tell me the solution.
View Replies !
View Related
Can MySQL 4.0.14 Store HTML
You need the following: Database Web Server Server-Side Scripting Language I would suggest using AMP (Apache, MySQL & PHP). If you want to know more about how these work in conjunction I would suggest the excellent book: "Web Database Applications" by Oreilly. It is the perfect beginners guide for this area.
View Replies !
View Related
What Is The Best Way To Store A Date In MySQL DB?
I have a table (contacts) with a list of people I know. It holds info like email address and birthdays. Right now, I have the birthday saved across three fields- day, month, and year. The day and month fields hold values like '02' and the year field holds a four-digit number, like '2007'. I know MySQL has a 'DATE' field type, and I would feel that is probably the best way to store the information I have. My question is this: I have some PHP code that checks to see if any of my contacts has a birthday today (as seen below) $today = date("d/m"); $query = "SELECT * FROM `contacts` WHERE CONCAT(DAY,'/',MONTH) = '".$today."'"; How could I do this if I stored the date in a single, YYYYMMDD field?
View Replies !
View Related
How To Store Microseconds In Mysql?
I'm running into a issue with mysql. I'm trying to store a date in my table with the format " 2008-12-22 08:56:15:33" with the bold being micro/milli seconds. There seems to have to be a way around this if its not possible. The reason is because I use the dateAdded column I created to as a SELECT critera in one of my queries?
View Replies !
View Related
Is It Good To Store Html-formatted Data In Mysql Tables?
I always thought it is best to keep as much html as you can out of your stored data, in order to have flexible data. I am working now on a user friendly news-editor where the user can add news and format the text as wished (put links, bold/underline/italic etc..). I am however a bit struggling with how I should proceed with this data. Do I just store it in the appropriate Mysql table and let it come out on the appropriate front-end news page? And not bother about the html in it? What if a user messes with the html? Should I strip all tags before storing it in the database and add them again while retrieving it on the news-page? If so, I know how to convert a few things, but not everything (like links, bold/underline..). Or are there other solutions? Thanks!
View Replies !
View Related
Store Friend Matrix In MySQL (was "Need Help In MySQL")
I am making an website for dating online. Each members can have a list of friends. If I have n members in my website, each member can have max of n friends so we have a nxn matrix (dimensions of the matrix are certainly variable. They are changed as time goes). Right? And my problem is how to store the matrix in MySQL (I need a DB structure to store it, it can be changed later so it must be easy to modify: edit, add, remove items/cells). Who has a good solution for this problem?
View Replies !
View Related
Incorrect Key File For Table Error When Upgrading From MySQL 4 To MySQL 5
I have installed MySQL 5.0.67 yesterday. Previously we were using 4.0. On the development server, testing server, and training server this upgrade went smooth. The only thing I did there was run mysql_fix_privilege_tables. But yesterday, after doing this same thing on production server, something went wrong, at least with one database. While I was in the office things looked fine. But this morning I noticed error messages like: 090119 16:29:04 [ERROR] /usr/local/mysql5/bin/mysqld: Incorrect key file for table './questionnaire/answers.MYI'; try to repair it I tried: repair table answers but then I got the following error message: 090120 8:49:21 [ERROR] /usr/local/mysql5/bin/mysqld: Table './questionnaire/current_answers' is marked as crashed and should be repaired
View Replies !
View Related
How To Store
An user fills a form. My script generates a reference, call it REF. There's also another value which is the same for each REF, call it REF2. The script also generates a date value, which should be stored for each form filled and may have different values for the same REF, call it DATE. Then there's three more values which are come from what's filled in the form, so values may vary for the same REF, call them VAR1, VAR2 and VAR3. When I search the database, I will look for REF. To sum up, each REF2 is always the same for one given REF; and DATE, VAR1, VAR2 and VAR3 need to be findable when I have the REF value. By the way, all of these are VARCHARs (but for DATE which is a, well, DATE).
View Replies !
View Related
Store PDF In DB?
I am writing a web application that is actually an application for a school, causes some word confusion... Anyway, applicants need to be able to upload PDF statements and letters of recommendation and such. The applicant can re-upload the file multiple times with corrections, but only the most recent version will be kept. When the application is finished the PDF will be accessed a few dozen times by various reviewers. For easy backup/maintenance/organization it would make my life much simpler to store the PDFs directly in the database, however I gather that there may be problems with this. The only stats I can find seem to worry about scaling with dynamic content being loaded for thousands of visitors, however I don't need to worry about that as only a few dozen folks will want to view any given file, over several weeks. Aside from scaling is there any other reason to avoid storing the PDFs in a BLOB? Will the performance hit be that significant?
View Replies !
View Related
Log-error File 'not Found' But This Same File Being Written To?!
I recently put up a message board and I get around 150+ hits a day so far. I've recently had some people sign up with my board but unfortunately, no one seems to be posting (they're just lurking around). I'm currently doing some promotions in the hope that others will post (like giving away a Lord of the Rings poster to all users who has 20 posts or more). Of course, my board has only been up for less than a month (3 weeks to be exact) so I know I need to be patient but I would appreciate any advice you can give me on how to turn lurkers into posters.
View Replies !
View Related
Format To Store IP
I need to keep a database of IPs and check if a new IP is there or not. I was wondering what's the most efficient way to store an IP in a database to make searching most efficient. Would it be better to hash the IP or just keep it as it is or some other way perhaps?
View Replies !
View Related
Store Currency
is double(6,2) probably the best way to go about it? (6 is just a guess, you could go higher I suppose) what's the best way to re-add zero padding when you retrieve it? ie, 52.70 will become 52.7
View Replies !
View Related
How To :: Store Images
I'm new to MySQL and wanted to know if I could store the images in the DB...not the location but the images.How can I do it? I need this info. urgently.. using the blob or mediumlob column type is fine but how do I transfer the images to tables?
View Replies !
View Related
Store Multiple Ids
I am trying to figure out the best way to organize some tables. This is the problem ID | Name | TransIDs 1 | Bleh | 2,3,5,6 ---- How should I do multple transids? I searched in the forum and most people did this ,2,3,5,6, - which I actually did a couple weeks ago but I don't know if that is the best way to go about it.
View Replies !
View Related
Store DB For Each Domain
if there is a way to set up MySQL server to keep DB's for one user in it's home folder? I wonder how those virtual (shared) hosting companies set it up? What I mean is say if I have two users (domains) on the server they will have all their files in their home folders. /home/domain1.com/ /home/domain2.com/ I ask this because I find it neat to have all the files for one domain in one place - mostly for backup.
View Replies !
View Related
Store An Array
I'm using PHP to acces my MySQL database; Now, I would like to store an array in the database. I was very suprised to see that there is no array-type field (samen with boolean? why didnt they make a boolean field?!). Anyone an idea how I can save and recover my array from the db
View Replies !
View Related
|
TRACKER
