O'Reilly Answers

Topics: mysql

Feed subscription    Email subscription    Questions Only Feed    Questions Only Email

Please sign in or register to post.

Please sign in or register to post.

• Begining mySQL for every day work and linking in and out of MS Excel

  Asked by komMWM : 11 March 2010 - 07:40 AM

  

  Answered by KBenson : Mar 17 2010 11:30 AM
  (Skip to the bottom if you are ONLY interesting in the MySQL portion of the question) There's a few basic questions that need to be answered before you can really decide where to start. These ar... full answer >

  Tags:

  • mysql
  • excel
  • web

  1Answer

  0Comments

  ---

• login system using roles from a MYSQL database error

  Asked by seaturtleftw : 22 January 2010 - 02:20 AM

  Tags:

  • login system
  • roles
  • mysql

  0Answers

  3Comments

  ---

• How do I write a CRON job to backup a mySQL Database?

  Asked by todisht : 18 January 2010 - 07:17 AM

  

  Answered by todisht : Jan 19 2010 06:45 PM
  I figured it out: mysqldump -u [your_username] -p[your_password] [your_database] | gzip > [your_path/filename].gz If you want to make the filename unique you can add the date to it like this: m... full answer >

  Tags:

  • web
  • mysql
  • cron
  • php

  1Answer

  0Comments

  ---

• Updating MySql database from SQL Server

  Asked by Binal : 18 December 2009 - 12:30 PM

  Tags:

  • SQL-Server
  • MySql
  • SSIS

  0Answers

  0Comments

  ---

• How to find duplicate records in MySQL across multiple columns

  

  By sarahkim : 09 November 2009 - 04:57 PM

  We have a MySQL 4 table of authors with separate first name and last name columns. I wanted to get a list of all possible duplicates (authors in the table with the exact same first name and last name...

  Tags:

  • mysql
  • duplicates

  0Votes

  0Comments

  ---

• How to Use SQL to Search for Keywords Without the LIKE Operator

  

  By andr3w : 27 October 2009 - 10:06 PM

  You can do a simple keyword search using the LIKE operator. Unfortunately, this can be slow. Fortunately, an efficient keyword search is available in many systems.Often you must store ...

  Tags:

  • sql server
  • postgresql
  • mysql
  • LIKE
  • sql
  • oracle
  • databases
  • data

  1Vote

  0Comments

  ---

• How to get a random sample in SQL

  

  By odewahn1 : 15 October 2009 - 06:36 AM

  It can be a real pain to develop and test queries against really big tables. So, rather than query the entire table, you can use a simple trick to select a random sample (a smaller subset). Here...

  Tags:

  • mysql
  • sql
  • databases
  • hacks

  0Votes

  0Comments

  ---

• How to Add and Delete users to a Web Database using PHP and MySql

  

  By MikeH : 02 October 2009 - 11:50 AM

  So if you want to learn how to add and delete users to a Web Database using PHP and Mysql, consider reading this chapter out of: Learning PHP, MySQL, and Javascript, 1st Edition I would no...

  Tags:

  • php
  • mysql
  • tables

  2Votes

  0Comments

  ---

• How to use events to schedule database actions in MySQL

  

  By pauldubois : 14 September 2009 - 10:49 AM

  If you want to set up a database operation that runs periodically without user intervention, create an event that executes according to a schedule.As of MySQL 5.1, one of the capabilities...

  Tags:

  • mysql
  • events
  • schedule
  • mark

  0Votes

  0Comments

  ---

• How to use a trigger to log changes to a table in MySQL

  

  By pauldubois : 14 September 2009 - 10:10 AM

  If you have a table that maintains current values of items that you track (such as auctions being bid on), but you’d also like to maintain a journal (or history) of changes to...

  Tags:

  • log
  • triggers
  • mysql
  • table

  0Votes

  0Comments

  ---