Questions & Answers
Active Directory, AS/400, Backup, Business Intelligence, Career Development, CIO, CRM, Data Management, Database, DataCenter, Development, Hardware, IBM DB2, IBM iSeries, IT Strategy, Linux, Lotus Domino, Lotus Notes, Microsoft Access, Microsoft Excel, Microsoft Exchange, Microsoft Exchange 2003, Microsoft Exchange 2007, Microsoft Outlook, Microsoft Outlook 2003, Microsoft Outlook 2007, Microsoft Windows, Microsoft Windows 7, Microsoft Windows Server 2003, Microsoft Windows XP, Mobile, Networking, NPfIT, Oracle, OS, Routers, RPG, RPGLE, SAP, Servers, SQL, SQL Server, SQL Server 2005, Storage, Virtualization, Visual Basic, VoIP, VPN, Windows Server, Windows Server 2008 ...VIEW ALL TAGS
- Business Intelligence
- Career Development
- Cloud Computing
- Content Management
- Data Management
- Desktop Management
- Email Administration
- IT Strategy
- Lotus Domino
- Microsoft Exchange
- Microsoft Windows
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.
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.
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?
How can I open CCA files?
I am currently unable to log into my outlook-pop-up. It says someone else may be using it.
How can I download a video from YouTube
My telefunken phone can not turn on. What should I do?
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.
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.
How do I roll back in case the database changes all data to the same information?
How can I go about deleting Ubuntu from my system?
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...
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?
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?
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!
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?
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?
Our department has noticed that one of our MySQL databases is becoming unusable due to constant errors (sometimes manual errors). What's the process to remove it? One key - we would like to use the foreign keys again but if we can't, then we can't.
My partner and I can't seem to figure out how we can clear the MySQL query cache without restarting our server. It's a SQL Server too. Thanks for the help!
A coworker wants to me send me a .SQL file and I have to export / import that file to / from our MySQL database using the command line. What's the command to do that? Could I possible use mysqldump? Quick note: The file might have several constraints too.