Questions & Answers

  • Query/400: Subtract one date from another

    I only want my calculate to use number of business days.

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

    ITKE434,515 pointsBadges:
  • I have old .OST file which became corrupt! What should I do to repair OST?

    I have laptop running Windows 7 and I have old .OST file which became corrupt! What should I do to repair OST?

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

    ITKE434,515 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?

    ITKE434,515 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!

    ITKE434,515 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.

    ITKE434,515 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.

    ITKE434,515 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?

    ITKE434,515 pointsBadges:
  • How do I open CCA files?

    How can I open CCA files?

    ProfMichaelK5 pointsBadges:
  • Unable to log into Outlook

    I am currently unable to log into my outlook-pop-up. It says someone else may be using it.

    Jessie15 pointsBadges:
  • Download YouTube video

    How can I download a video from YouTube

    sdfgbsg5 pointsBadges:
  • Re-register my Windows Phone ID and password

    Last month I bought a Nokia Lumia 630. At the same time, the salesman had set my email and password. But I've already forgotten my password and tried many times already. How can I re-register my Windows Phone with a new ID and password? Thanks and regards.

  • My smartphone won’t turn on

    My telefunken phone can not turn on. What should I do?

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

    ITKE434,515 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.

    ITKE434,515 pointsBadges:
  • SQL database rollback query

    How do I roll back in case the database changes all data to the same information?

    twatonny015 pointsBadges:
  • How to delete Ubuntu

    How can I go about deleting Ubuntu from my system?

    Ashirbad5 pointsBadges:
  • Should the design cycle of new products include an analysis of security vulnerabilities?

    Black Hat 2013 was a tension filled affair. In addition to National Security Agency Director General Keith B. Alexander defending U.S. surveillance of American citizens, claiming it's a necessity in a world threatened by what he called "terrorists among us," SeungJin "Beist" Lee showed attendees...

    Chris Leonard4,300 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?

    ITKE434,515 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