• pagination using MySql

    can anybody get any query for pagination using MySql.. any helps are welcome

    NetDeveloper90 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:
  • 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...

    MargraveMathan10 pointsBadges:
  • MySQL brain teaser

    This has been driving me crazy. I’m trying to come up with an UPDATE query in MySQL that will remove the second blank space in a name and close the gap.   Example: O Brien, John E should become OBrien, John E   A simple REPLACE (name, ‘ ‘,’’) where SUBSTRING (name,2,1) like “ “...

    Michael Morisy8,323 pointsBadges:
  • help me create trigger update column

    CREATE  TRIGGER Trigger_UPDATE_BIENLAI_TIENNOP ON BIENLAI FOR UPDATE,INSERT,DELETE AS IF (@@ROWCOUNT = 0) BEGIN PRINT ' TABLE is null' RETURN END IF UPDATE(TIENNOP) BEGIN UPDATE BL1 SET BL1.TIENNOP = BL3.TIENNOP FROM BIENLAI BL1,DELETED BL2,INSERTED BL3  WHERE BL1.SOBL = BL2.SOBL AND (BL3.TIENNOP...

    2110805 pointsBadges:
  • AUTO INCREMENT

    We created a File with an Auto Increment Field using MYSQL statements through PHP. I have no Idea how to do this using DDS statements or settings.

    Steyn15 pointsBadges:
  • 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?

    ITKE344,995 pointsBadges:
  • 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...

    Srividya5 pointsBadges:
  • mysqldatetime exception

    mysqldatetime exception i am using MySql  with c# in my window application , In code i think everything is fine , when i made a latest patch for the given installer it throwing an exceptuon at client side " Cannot perform '<=' operation on MySql.Data.Types.MySqlDateTime and System.String." when...

    ITKE344,995 pointsBadges:
  • passing array as parameter to stored procedure in mysql

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

    Itprofession5 pointsBadges:
  • 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...

    PatOswalt115 pointsBadges:
  • php and mysql

    How can we create a family tree map using php and mysql?

    Sanasher5 pointsBadges:
  • 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 )

    Mysqldba5 pointsBadges:
  • Creating forms with PHP and MySQL

    Using PHP and MySQL, I am trying to create a table form which can input multiple data within the form. When the space row provided is not enough, I want to add in another function which can help add rows in the same table. How can I do this?

    MarkG7135 pointsBadges:
  • 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.

    ITKE344,995 pointsBadges:
  • 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 and the...

    Vshilov5 pointsBadges:
  • 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)  ...

    Adwaith100 pointsBadges:
  • 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 you very much .

    Hanai5 pointsBadges:
  • 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...

    Ak1bo78150 pointsBadges:
  • 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?

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

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following