Topics: python

python Feed    python Open Questions Feed    python Email    Open Questions via Email

Please sign in or register to post.

Please sign in or register to post.

• How to use sequence generators as counters in MySQL

  

  By pauldubois : 11 September 2009 - 06:04 PM

  If you’re interested only in counting events, use a sequence-generation mechanism that uses just one row per counter.AUTO_INCREMENTcolumns are useful for generating sequences across a ...

  Tags:

  • ruby
  • python
  • counter
  • sequence generator
  • sql
  • mysql
  • java

  0Votes

  0Comments

  ---

• How to obtain result set metadata in MySQL

  

  By pauldubois : 11 September 2009 - 04:24 PM

  If you want to know things about the result set, such as the column names and data types, or how many rows and columns there are, use the appropriate capabilities provided by your API.For sta...

  Tags:

  • php
  • ruby
  • python
  • perl
  • metadata
  • mysql
  • java

  1Vote

  0Comments

  ---

• How to obtain the number of rows affected by a statement in MySQL

  

  By pauldubois : 11 September 2009 - 01:15 PM

  Sometimes the row count is the return value of the function that issues the statement. Other times the count is returned by a separate function that you call after issuing the statem...

  Tags:

  • php
  • python
  • ruby
  • perl
  • statement
  • rows
  • myslq
  • java

  0Votes

  0Comments

  ---

• How to clone a table in MySQL

  

  By pauldubois : 10 September 2009 - 02:08 PM

  If you need into create a table that has exactly the same structure as an existing table, use CREATE TABLE ... LIKE to clone the table structure. If it’s also necessary to copy s...

  Tags:

  • java
  • php
  • python
  • ruby
  • perl
  • table
  • clone
  • mysql

  0Votes

  0Comments

  ---

• How to identify NULL values in result sets in MySQL

  

  By pauldubois : 10 September 2009 - 01:52 PM

  If your query result includes NULL values, but you're not sure how to tell where they are, your API probably has some special value that represents NULL by convention. You just have to know w...

  Tags:

  • java
  • php
  • python
  • ruby
  • perl
  • API
  • NULL
  • sets
  • result
  • mysql

  1Vote

  1Comment

  ---

• How to handle special characters and NULL values in MySQL

  

  By pauldubois : 09 September 2009 - 12:53 PM

  If you need to construct SQL statements that refer to data values containing special characters such as quotes or backslashes, or special values such as NULL, or you are constructing statements using ...

  Tags:

  • mysql
  • ruby
  • perl
  • python
  • java
  • php

  0Votes

  0Comments

  ---