Can someone tell me what the proper syntax is to ensure that the data type
of "sum(ia)" is created in the schema?
The following syntax produces a schema of:
"CREATE TABLE theTest(company varchar(21), ia);"
Thank you,
Marc
//--
Greetings,
I'm a newbie trying to compile SQLite on Mac OS X.
When running the configure script for 2.8.15, the script stops after a
while with this message:
configure: creating ./config.status
config.status: creating Makefile
sed: 14: "/^[]*VPATH[]*=/{
s/ ...": bad flag in substitute
On Oct 30, 2004, at 2:08 PM, Tomas Franzén wrote:
I'm a newbie trying to compile SQLite on Mac OS X.
When running the configure script for 2.8.15, the script stops after a
while with this message:
Do you have the developer tools installed? That's about all I can think
might be the problem.
Hi,
First let me say that I am new to sqlite. My situation is this, I have
two tables in an sqlite 3.0.8 database. One table (Master) is a list of
biographical data about baseball players: firstname, lastname, hometown,
etc. The second table (Batting) is comprised of each players stats: hits,
home
Angelo Brigante, Jr. wrote:
SELECT master.nameLast, sum(batting.hr)
FROM master,batting
WHERE master.playerid = batting.playerid
GROUP BY master.nameLast, batting.playerid
HAVING sum(batting.hr) > 500
ORDER BY sum(batting.hr) DESC;
In both postgresql and Microsoft Access 2000 this query takes 2 and
D. Richard Hipp wrote:
What's the schema? Do you have an index?
CREATE TABLE Master ( playerID text, managerID text, hofID text,
birthYear integer, birthMonth integer, birthDay integer,
birthCountry text, birthState text, birthCity text,
deathYear integer, deathMonth integer, deathDay integer,
d
I would like to have the default for a date field be the current date. Right
now, I am using a post-insert trigger and modify the date; but I was hoping to
be able to use the 'default' clause of the table schema.
However, this statement is not parsed by SQLite:
CREATE TABLE a ( b datetime DEFAUL
7 matches
Mail list logo