sql command help..!!!?
918322
CREATE TABLE cus_tmp as (SELECT * FROM members WHERE tel_hp LIKE '% - %');\n\nAll you are missing is the ().\n\nEnjoy -
271669
Take a look at this site. It explains what i think you need.\n\nhttp://dev.mysql.com/doc/refman/5.0/en/insert-on-duplicate.html\n\nHope this helps
254134
I believe Access SQL supports the TOP keyword as below.  This will allow you to easily limit the number of records.\n\nSelect TOP field1, field2, field3\nfrom mytable1 m1 left join mytable2 m2\n on m1.field1 = m2.field4\nwhere field1 = 'value'
828970
dim db as database\ndim rs as recordset\ndim strSQL as string\ndim strA as string\ndim strB as string\ndim strC as string\n\nset db = currentDB\n\nstrSQL = "Select fieldA, fieldB, fieldC from Table1 where FieldD = fieldvalue"\n\nset rs = db.openrecordset(strSQL, dbOpenDynaSet)\n\nif not rs.EOF then\nstrA = rs!fieldA\nstrB = rs!fieldB\nstrC = rs!fieldC\n\nend if
54440
hi , you dont need cursor \ntry this:\n\n-----------------------------------------------\n\nCREATE PROCEDURE test_sp\n\n@username1char(10),\n@username2char(10)\n\nAS\n\nDECLARE \n\n@UserTempTableTABLE ([ID] char(10),\n [USERNAME] char(10),\n [NAME] char(10),\n [ADDRESS] char(10))\n\nINSERT INTO @UserTempTable\nSELECT[ID],\n[USERNAME],\n[NAME] ,\n[ADDRESS]\nFROM    Table1\nWHERE[USERNAME] = @username1\n\nINSERT INTO @UserTempTable\nSELECT[ID],\n[USERNAME],\n[NAME] ,\n[ADDRESS]\nFROM    Table2\nWHERE[USERNAME] = @username2\n\n\nSELECT [ID],\n[USERNAME],\n[NAME] ,\n[ADDRESS]\nFROM@UserTempTable\nGO\n\n-----------------------------------------------
147561
You could use the split function to get each part of the date and re format it as you want :\n\nie\n\n<?php\n// Delimiters may be slash, dot, or hyphen\n$date = "04/30/1973";\nlist($month, $day, $year) = split('[/.-]', $date);\necho "Month: $month; Day: $day; Year: $year<br />&#92;n";\n?>\n\nSource --> http://uk2.php.net/split\n\nAs for connecting to the database using odbc etc , I have never done that , Just search on google, there are plenty of examples.\n\nGoogle is your friend :)
1062183
We're going to call your row "numbers" and your table "table" for this example.  The SQL code would look like this:\n\nSELECT SUM(numbers)\n   FROM table;\n\nThere you go.
971270
try these link baby..hope it work\nhttp://www.dizzay.com/dizzaymysql/index.asp
200035
Assuming you grabbed an array named $row from your results set:\n\n<input type="text" name="myTB" id="myTB" value="<? echo $row['data']; ?>" />
254436
write a script in sql*plus:\n\nSET echo OFF\nSET verify OFF\nSET feedback OFF\nSET pagesize 0\nSET linesize 180\n\nspool DROP.SQL\n\nSELECT 'drop table &&1' || '.' || table_name || 'CASCADE CONSTRAINTS;'\nFROM ALL_TABLES\nWHERE owner = '&&1';\nspool OFF;\n\nSave this as create_drop.sql, then run with\n\nSQL>@@create_drop USER\n\nwhere USER is the user you want to drop, then run drop.sql\n\nSQL>@@drop\n\nGOOD LUCK
1007349
add a hidden field\n<input type="hidden" name="num_inputs" value="how_many_inputs_you_have">\n\nthen when submitted\n$i = 1;\n$sSql = "INSERT INTO table (name, age) VALUES";\nwhile ($i < $num_inputs) {\nif ($_POST[$name.$i] != "" && $_POST[$age.$i] != "") {\n$sSql .= "('".$_POST[$name.$i]."' , '".$_POST[$age.$i]."')";\n$i++;\n}\n}\nexecute query here\n\n$name.$i would get evaluated to name1, name2 etc, and if statement checks if both of them are empty. operation .= means "stick whats on the right to whatever was in left variable"
440330
Use 'bcp' (bulk copy) command available in SQL Server.
99695
What do you mean?\nMaybe "SQL command with two criteria?"?\n\nIn this case if you mean the condition "WHERE" you joint each condition with "AND".\nExample:"SELECT * FROM table WHERE field0 = 'value0' AND field1 = 'value1';"
76070
Actually when you're in Excel you can add a Visual Basic line that makes a SQL query that selects one random name. I don't know the particulars, but I know it's really really easy and it's literally one line of code or two.\nYou could also have two excel files, and one of them acts as a "filter" of sorts, by bringing "external data" from the second one and filtering with the SQL statement.
83897
try this out:\n\nhttp://dev.mysql.com/doc/
621012
sql stands for sequentia query language\n\nif you want to delete some row from a table\n\ndelete * from tablename where <columnname> = 1\n\nor if its character\ndelete * from tablename where <columnname> = 'dd'\n\nif u want to delete entire table\ncommand will be\n\ndelete * from <table name>
182030
Try Eventum - it's a free open source tool that is really easy to use and offers lots of cool options:\n\nhttp://eventum.mysql.org/wiki/index.php/Main_Page