That can work, if performance is of no concern. Otherwise it will become
miserably slow.
Von: Fehmi Noyan ISI mailto:fnoyan...@yahoo.com>>
Antworten an: Fehmi Noyan ISI mailto:fnoyan...@yahoo.com>>
Datum: Dienstag, 30. Juli 2013 01:54
An: Benjamin Stadin
mailto:benjamin.sta...@heidelberg-mobil.
On 2013.07.29 6:08 PM, Roman Fleysher wrote:
Thank you, SQLiters, for confirmation. Yes, the set up is unusual. I have a
table which essentially maps existing column names to the names the users want
to see.
columnRenameTable(table, column, showAS)
The goal was to use this mapping for
SELECT
Many Thanks for comment.
I shall agree with your view.
>Could be many rows in many tables were corrupted. If SQLite3 knew exactly
what had >been corrupted it could just go and fix it without even needing
your help.
Here i am thinking of getting details about table & infected
row,SQLite3 doesn't
> I was going to say, try using a SQL prepared statement.
>
> For example, in Postgres you can write something like this:
>
> execute format( 'SELECT %I FROM table that has that columnName',
>(SELECT columnName FROM columnNameTable WHERE condition how to
> select limit 1) );
>
> But I don
Thank you, SQLiters, for confirmation. Yes, the set up is unusual. I have a
table which essentially maps existing column names to the names the users want
to see.
columnRenameTable(table, column, showAS)
The goal was to use this mapping for
SELECT table.column AS showAS FROM table;
when displ
On 2013.07.29 5:32 PM, Roman Fleysher wrote:
Dear SQLiters,
I think the answer to my question is "NO", but may be I missed something...
Can column name come from a table, i.e. from another select? Example:
SELECT (SELECT columnName FROM columnNameTable WHERE condition how to select
limit 1)
F
You should be able to craft the query outside of the database and then
treat it like a normal query. You have to be very careful about doing
this, and it generally isn't a good idea.
If you do take this approach, make sure that you properly sanitize the
column names, especially if they are provide
On 7/29/2013 8:32 PM, Roman Fleysher wrote:
I think the answer to my question is "NO", but may be I missed something...
Can column name come from a table, i.e. from another select? Example:
SELECT (SELECT columnName FROM columnNameTable WHERE condition how to select
limit 1)
FROM table which h
Dear SQLiters,
I think the answer to my question is "NO", but may be I missed something...
Can column name come from a table, i.e. from another select? Example:
SELECT (SELECT columnName FROM columnNameTable WHERE condition how to select
limit 1)
FROM table which has that columnName;
Or this i
The approach I am using to compare tableA_old and tableA_new is;
typedef struct container_t {
// a structure to pass parameters into callbacks
} container;
static int callback_2(){
// compare two values in the resulting table if they are different
// write them into a resulting file
}
If you like ruby, I have another idea to get you going (maybe without
needing to write much code):
- Use a registered function to SQLite to create MD5 or SHA1 keys for rows
in the table. Here is a ruby snippet that registers a SHA1 function:
http://www.copiousfreetime.org/articles/2009/01/10/writi
EXCEPT query gave the different rows in tables, but what I am after is the
different values for existing records.
The column names are exactly the same, however the number of rows may differ
(with most of the records are the same).
From: Simon Slavin
To: Gene
INSERT OR IGNORE INTO table (word, confidence) VALUES (:word,
:initialconfidence - :confidenceincrement);
UPDATE table SET confidence=confidence+:confidenceincrement WHERE word=:word;
Still two statements but does not require application "help" and the rowid is
stable ...
Assuming that :initia
On 29 July 2013 12:57, Navaneeth.K.N wrote:
> Hello,
>
> I am trying to optimize the SQL calls that my application makes. I
> have a scenario where words are inserted into a table. Now each word
> will have a column called "confidence". There is a unique primary key
> on "word".
>
> When inserting
On 29 Jul 2013, at 12:57pm, Navaneeth.K.N wrote:
> When inserting a word, first I check if the words exists by performing
> a "select" query. If it exists, I fire an update query to increment
> the confidence for that word. If word is not available, I fire an
> insert query to insert the word.
Dear All,
Can you please help me in solving below error.When I am compiling sqlite
3.6.12 on UCLINUX.
Error : database locked
or
Can you please assist me in executing sqlite 3.6.12 on UCLINUX.
--
Thanks & Regards,
Mohammed Aijas
+91-9642933393
___
sql
Hello,
I am trying to optimize the SQL calls that my application makes. I
have a scenario where words are inserted into a table. Now each word
will have a column called "confidence". There is a unique primary key
on "word".
When inserting a word, first I check if the words exists by performing
a
On 29 Jul 2013, at 12:36pm, Fabian Klebert
wrote:
> Wouldn't
>
> SELECT * FROM table1
> EXCEPT
> SELECT * FROM table2
>
> solve this problem?
> I think it does for the example provided. Not sure if it would work in
> real-world environment.
There are two elements: making sure the same rows
Wouldn't
SELECT * FROM table1
EXCEPT
SELECT * FROM table2
solve this problem?
I think it does for the example provided. Not sure if it would work in
real-world environment.
-Ursprüngliche Nachricht-
Von: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
Im Auft
To be fair to me, the example had the same column names. If the two tables
have the same column names, then having a bit of extra code to tag on the
column name + "_1" might have worked. As my first reply answered,
untested. ;)
On Mon, Jul 29, 2013 at 6:46 AM, Clemens Ladisch wrote:
> Simon S
On 29 Jul 2013, at 10:21am, techi eth wrote:
> Reference from below link gave me hint about integrity check failure case
> recovery by Export/Import of database.
>
> Please let me know is this is correct & way to handle integrity failure
> check.
This is not the correct way to handle integrity
Simon Slavin wrote:
> On 29 Jul 2013, at 4:03am, Fehmi Noyan ISI wrote:
>> One point I forgot to mention; the number of columns is unknown.
>
> There is no way in SQL to say "Give me the contents of all the columns of a
> row of table in an unambiguous format.".
Well, just "give me" could be don
Yes, it turned out that achieving the goal with C code is much simpler than
using SQL statements (I also take my limited sql knowledge into account)
Now, I'll have two sqlite3_exec() calls, one of which is invoked by first
call's callback function. This led having some natsy C structs around to
On 29 Jul 2013, at 4:03am, Fehmi Noyan ISI wrote:
> One point I forgot to mention; the number of columns is unknown.
There is no way in SQL to say "Give me the contents of all the columns of a row
of table in an unambiguous format.".
It would be possible to write the code you want in SQLite,
Reference from below link gave me hint about integrity check failure case
recovery by Export/Import of database.
Please let me know is this is correct & way to handle integrity failure
check.
http://blog.niklasottosson.com/?p=852
http://community.spiceworks.com/how_to/show/1468-how-to-fix-corrup
25 matches
Mail list logo