• Storing PDF files in MySQL as BLOBs

    Experts, Can you please help me? I need to store several PDF files into MySQL as BLOBs. How can I do that using PHP? You are the best!

    ITKE827,895 pointsBadges:
  • How can I load CSV files into MySQL Workbench?

    I have several CSV files that need to be added into my database in MySQL Workbench. Is there a way to load them in? Is there a specific command I should use? Any help is appreciated.

    ITKE827,895 pointsBadges:
  • 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:
  • 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...

    ITKE827,895 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:
  • 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:
  • Upload image from Excel sheet into MySQL

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

    BatulBohra5 pointsBadges:
  • MySQL 5.7 database: Table has crashed and last repair failed

    I have MySQL database, but two days ago, I stumbled upon an issue - Table is crashed and last repair failed. I don't know how to solve this issue. I need to get MySQL recovery tool.

    heraturs15 pointsBadges:
  • MySQL: Look for top 3 in each group

    I know this has been discussed MANY MANY times, but I've used all the previous answers and still have issues. In my table we have to look for top 3 in each group and show ties. So if there is a tie it should return more than 3 rows. I have a working MS Access query, but MySQL doesn't use TOP and...

    DanielKYantis5 pointsBadges:
  • New to php/mySQL having an issue with Mac OSX

    I'm following the lynda.com video series on php with mySQL and have run into a hangup. When I install mysql and I'm checking to make sure it's all running, pointing a browser to http://localhost gives me the apache is running page, but going to http://localhost/~(myusername)/, I get an error saying...

    Kjtriplett15 pointsBadges:
  • Check to see if MySQL table field exists

    Would it be possible for me to check to see if a specific index exists on a MySQL table field? What command do I have to use?

    ITKE827,895 pointsBadges:
  • Convert CSV file to MySQL table

    How can I convert my CSV file to my MySQL table? Furthermore - the first row of my data needs to be used as the column names. Thank you so much.

    ITKE827,895 pointsBadges:
  • Can I connect JavaScript to MySQL?

    My apologizes if my question appears short but it's to the point. Would I be able to connect JavaScript with MySQL? If not, is there some sort of work around?

    ITKE827,895 pointsBadges:
  • How can I save a PHP array to a MySQL field?

    How can I save a PHP array to a MySQL field? And, once that is done, would it be possible to get it in array form? Thanks for all the help.

    ITKE827,895 pointsBadges:
  • Deleting all records from MySQL table using phpMyAdmin

    I'm currently using a WAMP server. When I'm trying to delete all of my records in a MySQL table using phpMyAdmin, it keeps deleting only one record at a time. I need to delete all the records. How can I do that?

    ITKE827,895 pointsBadges:
  • Halt running MySQL query

    Each day, I usually connect to MySQL from a Linux shell. Every once in a while, by accident, I run a query that's way to big and I have to stop it. When I tried Ctrl+C - it stopped all of MySQL and I have to reconnect. Can I just kill this one specific query? Thank you so much.

    ITKE827,895 pointsBadges:
  • Oracle In Linux

    How can I able to get and work with Oracle in Linux platform. I am using RedHat Linux 9.0.

    Samachar0 pointsBadges:
  • Maximum MySQL query size

    Hi experts, Does anyone know what the maximum size is for a MySQL query? I noticed that when it's too long on our server, it takes forever. Thanks!

    ITKE827,895 pointsBadges:
  • Converting MySQL timestamp to datetime

    How would I be able to convert a MySQL timestamp to datetime? Is there a specific command I have to use? Thanks so much.

    ITKE827,895 pointsBadges:
  • Unable to remote connect to MySQL server

    I can't figure this out for the life of me but I'm not able to connect remotely to my MySQL server. This is the error I'm getting: ERROR 1045 (28000): Access denied for user So what am I doing wrong? Can someone help me?

    ITKE827,895 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