i'm sorry, not default_storage , but storage_engine
:D...
masdi2t
Last Activity: Apr 24 '07, 05:21 AM
Joined: Jul 27 '06
Location:
-
see ur system variables
SHOW VARIABLES LIKE '%default%'
find default_storage system variable and than change it to engine type u like using SET command or just write it on ur my.cnf/my.ini file.
rgds....Leave a comment:
-
how about SHOW CREATE TABLE command...Leave a comment:
-
I think thats impossible mission :D
we can not shrink database file size (cmiiw).
but u can recreate ur database to get ur wish done.
use mysqldump to dump ur database, drop ur old database, create new database than restore ur dump (but, its wise to backup ur copy of ur database before)...Leave a comment:
-
base on my own experience, thus error told us tha we have error in foreign key area. maybe u specify on delete set null on not null column or something like that. just check ur foreign key design.
or for ur testing, u can create table c without any foreign key
cmiiw...Leave a comment:
-
if the only problem is your postgres service then u can create your new postgres service. use pg_ctl
C:> pg_ctl register -N service_name -U os_user -P os_user_passwor d -D data_directory
ex:
C:> pg_ctl register -N my_pg8.0 -U pgUser -P pgPasswd -D "D:\Data\pg 8.0"...Leave a comment:
-
try this
IF (TG_OP = 'INSERT') THEN
SOME SELECT STATEMENT
ELSEIF (TG_OP = 'UPDATE') THEN
SOME SELECT STATEMENT
ELSEIF (TG_OP = 'DELETE') THEN
SOME SELECT STATEMENT
END IF;...Leave a comment:
-
try this
CREATE TRIGGER ......
....
DECLARE
CURSOR cur IN SELECT column_name FROM user_tab_cols WHERE table_name = ora_dict_obj_na me;
sQuery VARCHAR2(1000);
BEGIN
FOR data IN cur LOOP
-- double single quote in UPDATE text
sQuery := 'INSERT INTO auditor_table VALUES (' || ':NEW.' || data.column_nam e || ', :OLD.' || data.column_nam e || ', ''UPDATE'')';
EXECUTE...Leave a comment:
-
lastrow:
SELECT * FROM your_table WHERE rownum=1 ORDER BY your_auto_incre ment_field DESC
lastcolumn (i don't get it why you need this information). this is the last column's name, not column's data
SELECT coumn_name FROM user_tab_cols WHERE table_name = your_table AND column_id = (SELECT max(column_id) FROM user_tab_cols WHERE table_name = your_table)...Leave a comment:
-
maybe your inside select produce more than 1 row:
select sum(b.value_dr_ agg)from dat b where b.start_dte='01-dec-2006'
check it first...Leave a comment:
-
masdi2t replied to problem to write connect user command inside the procedure any other option is therein OracleCONNECT is SQLPLUS comment, not SQL command. i think u can execute SQLPLUS command with EXECUTE IMMEDIATE (this statement just for SQL command only)
cmiiw...Leave a comment:
-
can you show us thus error message. and could you tell us more clearly about what tool you working with...Leave a comment:
-
use MERGE instead of UPDATE...Leave a comment:
-
for top row just use the magic column rownum
SELECT * FROM your_table WHERE rownum <= 10;
if you want bottom row you can order it before (using ORDER BY your_field DESC)...Leave a comment:
-
thus should change...Leave a comment:
-
try cache your delimiter character with ;;
DELIMITER ;;
DROP PROCEDURE IF EXISTS `tableselect` ;
CREATE PROCEDURE `tableselect`()
....
DEMIMITER ;...Leave a comment:
-
this is the step:
1. shutdown your mysql server (clean shutdown).
2. copy your data directory (all your data including your ib_logfile, ibdata).
3. open your mysql configuration file (my.cnf) and make some update on it.
a. adjust your datadir to your new directory (for myisam).
b. if you use innodb storage engine, make this modification too:
i. modify innodb_data_hom e_dir to your new directory....Leave a comment:
-
this is an example (using mysqldump):
mysqldump --user=<user_name > --password=<passw ord> --lock-all-tables \
--all-databases > <output_directo ry>/<output_file>
execute your script with cron in Linux or task scheduler in Windows or with your own scheduler program....Leave a comment:
-
try this
UPDATE table-2, table-1 SET table-2.value = table-1.value
WHERE table-1.id=table-2.id AND table-2.id=2;...Leave a comment:
-
or maybe
SELECT DATE_FORMAT(vDa te,'%b-%Y-%m'), ID FROM TEST
ORDER BY vDate DESC;
i guess it will work if your 'vDate' is Date/ Timestamp field...Leave a comment:
No activity results to display
Leave a comment: