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

    ITKE1,043,135 pointsBadges:
  • Database for HTML storage

    I'm looking for a database (especially open source) that I can use for storing HTMLs. At the very least, something that would store XPath queries too. What should I look out for?

    ITKE1,043,135 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.

    ITKE1,043,135 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!

    ITKE1,043,135 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.

    ITKE1,043,135 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?

    ITKE1,043,135 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.

    ITKE1,043,135 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?

    ITKE1,043,135 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!

    ITKE1,043,135 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.

    ITKE1,043,135 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.

    ITKE1,043,135 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?

    ITKE1,043,135 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.

    ITKE1,043,135 pointsBadges:
  • Convert MySQL string to date

    I have a MySQL string column that is currently acting as a date and I have to select it as a date too. How can I do that? In simplier terms - I need to convert it over to a date.

    ITKE1,043,135 pointsBadges:
  • Updating MySQL column with NULL value

    In MySQL, is it possible to update a column with a NULL value. I tried several different times and all I have gotten is an empty string. Do I have to use a syntax?

    ITKE1,043,135 pointsBadges:
  • Merging two MySQL tables

    I need to merge two different MySQL tables (that have the same data structure). The biggest difference is that the primary keys are different on each table. What's the process here?

    ITKE1,043,135 pointsBadges:
  • How to SELECT last MySQL table row

    Would I be able to SELECT my last row in a MySQL table? I'm currently adding data and have to retrieve a value from the previous row. Appreciate it!

    ITKE1,043,135 pointsBadges:
  • Allow MySQL remote connection

    I recently installed MySQL on my own machine (not my company's) and I'm looking to allow remote connections. I have to connect from an external source. What's the best way to do it?

    ITKE1,043,135 pointsBadges:
  • MySQL error message: Server has gone away

    Our office server processes many files and sends the reports to our remote MySQL server. But over the past week, it's been stopping halfway through with this error message: 2006, mysql server has gone away None of us have seen this before. What changes to we have to make on our end?

    ITKE1,043,135 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