Sign UpAds
Welcome New Members!
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
What's the best twitter module for showing twitter feeds in a column?
What's the best twitter module for showing twitter feeds in a column?
|
|
|
How can I batch set the value for one column for every row in a table?
How can I batch set the value for one column for every row in a table?
|
|
|
How can you change a column with SQL so it isn't auto-incrementing anymore?
How can you change a column with SQL so it isn't auto-incrementing anymore?
|
|
|
Is it poss to get year only from datetime column?
Is it poss to get year only from datetime column? like YEAR(datetime_col)
|
|
|
Is it possible to add a new column at the beginning of a table?
Is it possible to add a new column at the beginning of a table?
|
|
|
How do you add the results of a column?
How do you add the results of a column? I am writing a web game. I am trying to query the users score. What is wrong with this: SELECT ADD(`my_Bible_trivia_knowledge_questions_answered`.`score`) AS
|
|
|
What does PQgetvalue return if the row/column our outside the limits?
What does PQgetvalue return if the row/column our outside the limits?
|
|
|
How do I get the maximum value for a column without getting the whole column?
How do I get the maximum value for a column without getting the whole column?
|
|
|
How to retrieve all the column names in a table?
How to retrieve all the column names in a table?
|
|
|
What would be the reason for a non-null column accept a null value?
What would be the reason for a non-null column accept a null value?
|
|
|
Is there a function to take a column and turn it into a string?
Is there a function to take a column and turn it into a string? like array_to_string but for the result of a single column
|
|
|
Can I somehow specify a default value for a column if a SELECT returns NULL?
Can I somehow specify a default value for a column if a SELECT returns NULL? I want to do something like "INSERT INTO ⦠SELECT x (IF NULL x = 0) FROM y;
|
|
|
Is there an easy way I can get the latest date from 2 columns?
Is there an easy way I can get the latest date from 2 columns? Like, to get the latest from one column I'd use SELECT MAX(Date) FROM MyTable
|
|
|
What's the best way to return nested datasets?
What's the best way to return nested datasets? (Need a dataset that returns a bunch of rows with each row containing a sub-dataset in a certain column)
|
|
|
Is there a way to make a boolean-sudo column in a query?
Is there a way to make a boolean-sudo column in a query?
|
|
|
Where can I find a table by column explanation of the drupal database?
Where can I find a table by column explanation of the drupal database? I need to do some surgery and want to be as careful as possible
|
|
|
How come this is returning 0 instead of a negative number on a signed column?
How come this is returning 0 instead of a negative number on a signed column? IFNULL(serId.value, (-1* p.id)) AS titleId
|
|
|
What is the best column type to hold 1000 characters of free text?
What is the best column type to hold 1000 characters of free text?
|
|
|
Change Column Length, lose data in MySQL?
If I change, say the description column properties, to be varchar(50) instead of varchar(30) will I lose that column's data?
|
|
|
Is there a nice way to group by a date from a timestamp column in Postgresql?
Is there a nice way to group by a date (yyyy-mm-dd) from a timestamp column?
|
