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

    ITKE440,550 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.

    ITKE440,550 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?

    ITKE440,550 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.

    ITKE440,550 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?

    ITKE440,550 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.

    ITKE440,550 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!

    ITKE440,550 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.

    ITKE440,550 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?

    ITKE440,550 pointsBadges:
  • How to get list of MySQL database constraints

    Would I be able to get my list of constraints from my MySQL database? What SQL query should I use? Thank you so much.

    ITKE440,550 pointsBadges:
  • How to import MySQL database dump to SQL Server

    I currently have a SQL file that's from a MySQL dump. It contains a bunch of things including: Tables, definitions and all the data. Is there a way to convert all of this to a SQL Server database?

    ITKE440,550 pointsBadges:
  • How to find total number of columns in MySQL table

    I'm looking to find the total number of columns in a MySQL table. Would the code below work or do I need something else? select count(*) from tablename Thanks!

    ITKE440,550 pointsBadges:
  • Maximum length of MySQL table name

    I have a straight to the point question that I'm confused about. In MySQL, what's the maximum length for a table name? I read it might be 64 characters but I want to make sure. Thank you.

    ITKE440,550 pointsBadges:
  • Best way to copy a MySQL table

    Does anyone happen to know the fastest / best way to copy a MySQL table? I created this code below but not sure if it will work: CREATE TABLE copy LIKE original; INSERT INTO copy SELECT * FROM original; Also - would the indexes be re-created? That's my primary concern. Thank you.

    ITKE440,550 pointsBadges:
  • How to duplicate MySQL table

    I'm trying to duplicate a MySQL table - but the new table has to be empty. After that, then I have to copy the data structure from the existing table to the new one. How can I go about doing that?

    ITKE440,550 pointsBadges:
  • When does MySQL database view get updated?

    I currently have this view in MySQL: CREATE VIEW blah AS SELECT columnA FROM tableA But I need to see this specific view gets updated. How can I see that? Appreciate the help.

    ITKE440,550 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.