Hi I have started working with a mySQL databse. I need a query that will either make use of “DISTINCT” or “GROUP BY” but that selectes the record that has the highest ‘VersionNumber’ Can anybody suggest how I would achieve this? Thanks in advance.
Answer Question | June 22, 2012 8:10 AM
MySQL, MySQL Database, MySQL query
I want to do the following with a procedure: I have per user that has the same structure. The only difference is the table name. I need to be able to pass the table name to a procedure and retrieve data for that table. At the moment I have this: sp_getdata(id, givendate datetime,tablename varchar(200)) BEGIN [...]
Answer Question | May 16, 2012 5:55 AM
MySQL, MySQL Database
Why am failling when am using mysql to create database and am using the exactly tags?
Answer Question | May 27, 2012 6:54 AM
MySQL, MySQL Database
Hello Guys, I can create simple views for MYSQL Database tables but I am unsure on how to create a view for the following requirement: I want to create a view which restricts staff user access to a specific table between working hours of 13:00 – 14:00. I have been told that this can be [...]
Answer Question | March 27, 2012 8:58 PM
MySQL, MySQL Database, Oracle
Hello everyone! please help me about transfering MYSQL DATABASE from one computer to another….. I am a student and got to show a project on JDBC. I am using Windows 7 os and Mysql server 5.1.. Thank you.
Answer Question | February 28, 2012 10:09 AM
Mysql 5.1, MySQL Database, Windows 7 OS
I have cent os based LAMP system. My question is that, what is the best way to make mysql database high availability. As per me database clustering is a good option can you please suggest me.
Answer Question | March 31, 2012 8:45 AM
CentOS, LAMP, MySQL, MySQL Database, MySQL functions
Hi everyone, in general, I’ve been asked by my manager to find out about running a mysql db on a cloud (like this one) — has anyone done this, and what do you think are the security issues that can come up when doing so? More specifically, IT has questioned me about how auditing would work [...]
Answer Question | March 31, 2012 3:54 PM
Database security, MySQL, MySQL Database, SQL Database Security
How do I add a Mysql database server to my win 2008 r2 domain. Firstly do I install the Mysql on another Win 2008 box then join to DNS. I also need to add a Apache web server which will be in the DMZ. I need to install the following MySql database on a seperate [...]
Answer Question | April 11, 2011 6:47 AM
Database, DNS, LAN, MySQL Database, Networking, Server Architectures, Windows Server 2008
I have a simple spreadsheet (only 2 columns) that I need imported into a mysql database. I can convert the spreadsheet into whatever format I need to (comma delimited), but I need the mysql commands that will import it. Does anybody know how to do this?
Answer Question | February 12, 2011 2:49 AM
Linux databases, MySQL, MySQL Community Edition, MySQL Database
hello everyone Maybe my previous question was not the correct question to ask. I am in the middle of making an application upgrade which includes DB structure upgrade with keeping Data “data loss is not accepted here”. I have a complex DB structure in my application which depends “in some cases heavily depending” on database specific features. [...]
Answer Question | January 25, 2011 7:42 AM
Java/J2EE, JBoss application server, MySQL Database, Oracle, SQL Server, SQL Server 2005, WebLogic Server, WebSphere Application Server
What is the easiest way in DW to allow users to upload a picture to my website. I don’t know much coding so …how can it be done using the functionality of DW. I am using a MYSQL database.
Answer Question | January 17, 2012 3:30 PM
MySQL, MySQL Database, SQL
This week’s free IT book is your complete guide to planning, configuring, managing and troubleshooting NX-OS in enterprise environments: NX-OS and Cisco Nexus Switching. For your copy of this great resource for Next-Generation Data Center Architectures, simply answer one of five questions below and provide a link to your answer in the discussion area of [...]
Answer Question | November 15, 2010 4:15 PM
Cisco Routers, Giveaways, IT Books, ITKE, ITKE Contests, Linux firewalls, MySQL Database, SonicWALL, Symantec Backup Exec 12
Hello I would be grateful if you could advise me on a security issue I have on my network security. I have a web application on linux with my data stored on a mysql database on the same server (actually it is a sugarcrm) The sugarcrm which contains information about my clients is used by [...]
Answer Question | November 15, 2010 1:34 PM
Firewalls, IDPS, IDS, Linux applications, MySQL Database, Network security
does any one know if mysql have a function where I can convert datetime value into : 15 mins interval for example : 03NOV2010:00:00:02 –> 0-15 03NOV2010:00:16:02 –> 15-30
Answer Question | November 4, 2010 10:19 PM
MySQL, MySQL admin, MySQL Database, MySQL functions
Input : col1 col2 a 1 b 1 c 2 d 2 I would like to : Create the new colX to get the first value in col1 group by col2 and save the value in colX results : col1 col2 colX a 1 a b 1 a c 2 c d 2 c [...]
Answer Question | October 15, 2010 7:51 PM
GROUP BY statement, MySQL, MySQL Database, MySQL functions
We need to migrate a MySql database from one host to another. Will a simple backup and restore work? Are there references to the database inside itself? Will this work?
Answer Question | October 19, 2010 7:20 PM
Backup and restore, Host management, MySQL, MySQL backup, MySQL Database
We are looking to migrate from MySql to a full blown iteration of SQL 2005. Are there tools in place that will allow us to migrate our data and tables or are we on our own for getting our data into the MS database?
Answer Question | September 21, 2010 3:14 PM
MySQL, MySQL Database, MySQL functions, SQL, SQL 2005, SQL Server 2005, SQL Server migration, Windows
hi I am useing mysql database, I want to create one more database which I want to get updated in real time from the remote mysql database server. kindly help me in this. Thanks
Answer Question | September 17, 2010 4:59 PM
MySQL, MySQL 5.0, MySQL Database, MySQL functions
I have databases with longititude and latitude and one with Business Info – What is the best solution for getting the longitude/latitude into the Business Database? or Do I even need to merge them?
Answer Question | December 17, 2009 8:26 PM
Database management, MySQL, MySQL Database
Hi! I m new to php and MySQL database. I want to know how whether php provides any class for datagrid
Answer Question | February 14, 2011 4:57 PM
DataGrid, MySQL Database, PHP/MySQL