1
  • how to return entire table records using mysql database functions

    how to return entire table records using mysql database functions

    Danyind5 pointsBadges:
  • MYSQL database high availability

    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.

    Chetanm145 pointsBadges:
  • Starting a session in MySQL

    how to start a session in my sql?

    98672129495 pointsBadges:
  • How to secure MySql server?

    How to secure a MySql server for webhosting?

    Ashishagw5 pointsBadges:
  • Put date time into 15 interval value in MySQL

    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

    Iamjeannie30 pointsBadges:
  • Keep the “first” value using groupby – MYSQL

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

    Iamjeannie30 pointsBadges:
  • Migrate MYSql database to SQL 2005

    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?

    Karl Gechlik9,860 pointsBadges:
  • Get data from one MySQL datebase server to another in real time

    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    

    Chetanm145 pointsBadges:
  • Need help with documentation on a time tracker project

    i m workin on a project - time tracker. its my 1st one. m a newbie n have no idea about documentation. can someone plz brief me how it wil b done? thanx

    Novicebeginner5 pointsBadges:
  • Using Right() inside SQL Join

    I need to join two tables where one table uses 0809 as data in the field and the other table uses 200809. Can this be done? Can I use a Right() statement in the join? Thanks

    JeffCreek15 pointsBadges:
  • Count/Sum Question

    Hi I have a field with only 2 values. 0 and -1. I am interested in counting the -1's that occur only if they occur 4 or more times consecutively. Therefore, if the output were 0, 0, -1, -1, 0 the output would be 0. However, if it were 0,0,-1,-1,-1,-1,-1, 0, 0, -1,-1,-1,-1 the sum would be 9. Help...

    Chhmusic15 pointsBadges:
1

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