mysql connection using jsp
how cna i connect mysql database with my login form using jsp in linux operating system?

Answer Question   |  October 12, 2010  10:05 AM
Java Web developers, JSP, Linux OS, MySQL

Do Businesses still need SQL Server?
With all the upgrades to MySQL, has SQLServer needed to step up its game or do you think business still needs SQLServer?

Answer Question   |  May 3, 2010  9:44 PM
MySQL, SQL Server 2008 R2

SQL query
I have two database tables of employee where employee table maintains EMPNO,ENAME,JOB,MANAGER,HIREDATE,SALARY,COMMISION ,DEPTNO and department table maintais details of DEPTNO,DNAME,LOCATION. questions are : 1)Display the first four rows of employee table. 2)Display the empno,ename from row 2 to row 5. 3) Display the empno,ename for employee of 2nd row 4) Display details of all even [...]

Answer Question   |  April 20, 2010  3:58 PM
MySQL, MySQL admin, MySQL query

MySQLi and PHP problem with code
Can someone please tell me what I’m doing wrong with this particular line of code. echo "<td colspan=3>{$Row['areaCode'] . '-' . $Row['prefix'] . '-' . $Row['lineNumber']}</td></tr>"; I know that the concatenation operator is the . ‘areaCode’ ‘prefix’ and ‘lineNumber’ are all fields in a table within an SQL database. any help would be appreciated. Thanks [...]

Answer Question   |  April 9, 2010  10:02 PM
Concatenate, Database, MySQL, PHP, table

Ajax based multiserver GUI for MySQL?
I am looking for Web 2.0 product that allows me to manage multiple MySQL servers at the same time. I did found one proct that seem to do the job, but I would like to compare it with some other ones! (the product is located at http://novaquantum.com )

Answer Question   |  March 30, 2010  7:32 PM
Ajax, MySQL, MySQL admin

passing array as parameter to stored procedure in mysql
how to passing array as parameter to stored procedure in mysql?

Answer Question   |  April 9, 2010  6:53 AM
MySQL, MySQL Query Browser

Can System Center manage applications like MySQL running on Windows or Linux?
Can System Center manage applications like MySQL running on Windows or Linux? This question was asked during the Microsoft System Center live chat on IT Knowledge Exchange in January 2010.

Answer Question   |  March 4, 2010  2:36 PM
Linux, Microsoft System Center, MySQL, System Center, Windows

Best way to create a District/Precinct Map where districts change color based on MySQL or Access data
I have a image of a city divided into 500+ subdivisions. I need to vusualize data by changing the color of a subdivision. Data can be in a MySQL Db, Access, whatever. Example: if subdivision 1 has completed a report, color of subdivision 1 = green, if not = red. The data is updated often [...]

Answer Question   |  March 1, 2010  8:50 PM
MySQL

Sql Query For My sql
I have two database tables Employee and salary    Where Employee maintains details about employee And the salary table maintains data about Payroll entry.             Iwant the query for Select the employees who have not got salary for a particular month I have already tried this select employee.empid , salary.empid , employee.name  from  salary  , [...]

Answer Question   |  June 2, 2010  10:15 AM
MySQL, SQL Query

MySQL Access Denied error
I have installed mysqlcc-0.9.4-win32. After giving user name, password etc and add connection, connection is sucessfully added. But when trying to connect to the website the following error is displayed ERROR 1045: Access denied for user ‘epfkeral_epfkera’@’117.206.11.168′ (using password: YES)   How to solve this problem.

Answer Question   |  February 23, 2010  4:17 PM
MySQL, MySQL Access Denied error

what is different from MSSQL, MYSQL and Oracle 11g?
what is different from MSSQL, MYSQL and Oracle 11g? Which one is the best for 15000 transaction daily?

Answer Question   |  January 17, 2010  2:55 PM
MSSQL, MySQL, Oracle 11g Database

best solution for integrating longitude and latitude into another Database in mySQL
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

Mysql syntax
Hi Have a table: budget When I try this: MySql: insert into budget values (’Department A’,1,2,200) Department A represents:A Department called A 1 represents: a courseno from table course 2 also represents: a courseno from table course It doesnt work … Any suggestions…. ?

Answer Question   |  November 4, 2009  9:59 PM
Data Tables, MySQL, tables

Constraints (MySql,tables,null,PK,FK etc)
Hi all(waves) noob here ( ) ( yes you might look down upon me) ( ) never the less….:)  Quick question: Tables made so far: department values (depno,dname) course values values (courseno) How would I create a table eg “Table budgets”…with values of two budgets (£100 and £200) for courses. 1.Courses are managed by departments. [...]

Answer Question   |  January 23, 2010  7:52 PM
constraints, foreign key, MySQL, NOT NULL, NULL, primary key, tables

MySQL database size
Is there a limit on database size for MySQL? my database is getting on the large zise will this effect proformance?

Answer Question   |  October 26, 2009  5:45 PM
MySQL, PHP, PHP Coding, SQL, SQL Database

multi-use of the database
Hello . I’ve developed a local website using xampp , and I want to access the mysql database in it to develop a J2SE application. Is it possible ? if so could you give me the right keywords to search since I kept trying every single word that could pop into my mind . Thank [...]

Answer Question   |  January 23, 2010  7:10 PM
Java Database Connectivity, MySQL, NetBeans, xampp

Foreign key constraints support in MyISAM
Are foreign key constraints supported in MyISAM of MySQL? I have created a table using InnoDB, declaring the foreign key, and now I want to convert that table to MyISAM. Is it possible, and if so, how can I do it?

Answer Question   |  October 20, 2009  8:03 PM
InnoDB, Linux, MyISAM, MySQL, Open source software

SQL related tables
I have 2 tables one with all my products and their accociated details and another with comments on the products. Product table 1 prodID, title, description, price Comments table 2 commID, prodID, comment I would like to export this to a single XML file, thus an XML element for each product from table 1 with [...]

Answer Question   |  October 19, 2009  7:10 AM
MySQL, MySQL 5.0, PHP, SQL Related Tables, SQL tables

Plans and Guidelines for a Web Application Project
Hello there fellow users, I have been entrusted with the task of designing and implementing a financial system for a charity foundation where I live. The charity foundation requires its work (addition and retrieval of records, for example) to be done online, using a web app. The app connects to a database server for storage [...]

Answer Question   |  October 13, 2009  1:17 AM
Apache, ASP.NET, Java, MySQL, Web application deployment, Web development

abt the server
is it possible to make my personal computer to act both as client and server for the purpous of doing project like php-mysql-apache and for deployinf j2ee also

Answer Question   |  October 12, 2009  1:46 AM
Apache, MySQL, PHP