I'm writing a DB to manage books & dvd's for the library.
So after they added more books/dvd's, they press the print button and all newly added entries are printed.
That is, as it prints all 'printed = false' entries, which (false) is the default value for that field for each new entry.
Anyway, its been several years since my last (my)sql queries, i'm very rusty, further as its access, it might be diffrent as well..
Main issue is, it error's on "UPDATE" and "ALTER" has a syntax error.
Specific part (its vba):
Note that "Gedruckt" is the fieldname and "tblBuchDruck" is the table's name
Thank you in advance
Made a sysback tape backup on our 595 running 4.1.5 but when trying to do a restore discovered that rmt0 not in bootlist(s).
Tried to alter both the normal and service bootlists but system wont respond to F7(commit).
Erased the service boolist then tried alter again, same result. Now have... (2 Replies)
I want to look into a folder to see if there are any folders within it. If there are, I need to check inside each folder to see if it contains a .pdf file
So
If /myserver/myfolder/
contains a folder AND that folder conatins a .pdf file
do X
Else
do Z
I may have multiple folders and... (4 Replies)
Hi All,
I have the following sql query
select abcd from udbadm.log where xyz='1'.
I have 16k queries similar to this with different values for xyz.
I want to print the values of 'abcd' for each row.
I have the following perl code, but not sure how i can print that particular... (1 Reply)
Hello everyone.
I'm stuck with an error message that neither I nor any of my computer science peeps can understand. The program I wrote is meant to be a simple decimal to binary converter, but with this message it's more complicated than I thought.
Here's the code:
#include <iostream>... (2 Replies)
Hello everyone.
I'm stuck with an error message that neither I nor any of my computer science peeps can understand. The program I wrote is meant to be a simple decimal to binary converter, but with this message it's more complicated than I thought.
Here's the code:
#include <iostream>... (3 Replies)
I have this script:
#!/bin/sh
for file in "$@"
do
ext=${file##*.}
base=${file%.*}
num=${base##*v}
zeroes=${num%%*}
num=${num#$zeroes} #remove leading zeros, or it uses octal
num=$((num+1))
base=${base%v*}
new=$(printf... (4 Replies)
Hello,
I am newbie on mysql and trying to edit my database from terminal under linux.
What I need to do is to change the information written in a cell in table.
Let me explain what I tried:
$ mysql -u mysqluser -p
$ show databases;
$ USE catalogue;
$ show tables ;
$ select * from... (2 Replies)
I have a problem at make step to install a downloaded package consisted of different programs.
In file included from kcdbext.cc:16:0:
kcdbext.h: In member function �char* kyotocabinet::IndexDB::get(const char*, size_t, size_t*)’:
kcdbext.h:1281:14: error: cannot convert �bool’ to... (3 Replies)
Discussion started by: yifangt
3 Replies
LEARN ABOUT SUSE
alter_view
ALTER VIEW(7) SQL Commands ALTER VIEW(7)NAME
ALTER VIEW - change the definition of a view
SYNOPSIS
ALTER VIEW name ALTER [ COLUMN ] column SET DEFAULT expression
ALTER VIEW name ALTER [ COLUMN ] column DROP DEFAULT
ALTER VIEW name OWNER TO new_owner
ALTER VIEW name RENAME TO new_name
ALTER VIEW name SET SCHEMA new_schema
DESCRIPTION
ALTER VIEW changes various auxiliary properties of a view. (If you want to modify the view's defining query, use CREATE OR REPLACE VIEW.)
You must own the view to use ALTER VIEW. To change a view's schema, you must also have CREATE privilege on the new schema. To alter the
owner, you must also be a direct or indirect member of the new owning role, and that role must have CREATE privilege on the view's schema.
(These restrictions enforce that altering the owner doesn't do anything you couldn't do by dropping and recreating the view. However, a
superuser can alter ownership of any view anyway.)
PARAMETERS
name The name (optionally schema-qualified) of an existing view.
SET/DROP DEFAULT
These forms set or remove the default value for a column. A default value associated with a view column is inserted into INSERT
statements on the view before the view's ON INSERT rule is applied, if the INSERT does not specify a value for the column.
new_owner
The user name of the new owner of the view.
new_name
The new name for the view.
new_schema
The new schema for the view.
NOTES
For historical reasons, ALTER TABLE can be used with views too; but the only variants of ALTER TABLE that are allowed with views are equiv-
alent to the ones shown above.
EXAMPLES
To rename the view foo to bar:
ALTER VIEW foo RENAME TO bar;
COMPATIBILITY
ALTER VIEW is a PostgreSQL extension of the SQL standard.
SEE ALSO
CREATE VIEW [create_view(7)], DROP VIEW [drop_view(7)]
SQL - Language Statements 2010-05-14 ALTER VIEW(7)