what are the logic sql commands?
404062
(m)\n\ngoto the following link for logic sql commands\n\nhttp://docs.hp.com/cgi-bin/doc3k/B3060190208.12319/75
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"
117633
I'm only answering this because I haven't seen anyone else.  I'm not an Oracle DBA, but I have extensive experience in SyBase.\n\n1) Look through your doc for a thing called sqlloader - this is the thing Oracle provides to do the job.  Basically, unloading a table using sqlloader takes the data in your table and writes it in a format that sqlloader can rewrite.\n\n2) If you are really good at PL/SQL, you can write you own unload/reload process (this is what I have to do to move data from one RDBMS to another, like from Oracle to Sybase).  Write a program that generates as output the SQL Insert statements needed to load your data.  In other words, it writes on Insert statement for every row that already exists.
281205
My experience with MySQL / Sybase / SQL Server when you DON'T have an ODBC complient data source is the create (in the native language of the source information) an output file of SQL insert statements.\n\nFor example, if the data source is three fields (F1, F2, and F3) that have the values 1, "a", and 3 in the first record, I'd create a program that reads from the source and outputs into a text file....\n\nINSERT INTO newfile (F1, F2, F3) VALUES (1, 'a', 3) GO\nINSERT INTO newfile (F1, F2, F3) VALUES (....\n\nThen, I'd just use the batch function of the SQL database to execute that text file as a SQL script.
61097
if this is a database question, then the correct answer is c
70564
http://dev.mysql.com/doc/refman/5.0/en/sql-syntax.html\nYour best bet is to Start with MySQL, which is an Open Source Implementation, then learn SQL and then Database Design, and shortly after you will be a full fledged DBA
742763
Go to the MySQL site, they have the best documentation there under the documentation section.  Here's the link:\nhttp://dev.mysql.com/doc/
739575
quite simple...\n\n\nCreating a FeedBack Form\n(using SQL Server or MS Access)
511517
Does this help:\n\nhttp://vyaskn.tripod.com/oracle_sql_server_differences_equivalents.htm\n\nhttp://www.quest-pipelines.com/newsletter-v7/0406_C.htm
862761
Not sure what you are trying to do. Email me @ lee.sanchez@gmail.com with some context please.  I know sql and access very well.  So let me know.\n\nYou have subqueries or dlookups as an option\n\nselect (select [field1] from table1 where field1>0) as field2
1047491
Use the IDENTITY property.\n\nfor example:\n\ncreate table employees\n(\nemp_id smallint identity(101,1) not null\nempname varchar(50) not null\n)\nGO\n\ncreates a 2 column table with an incrementing field called emp_id.  the numbering sequence starts at 101, and is incremented in units of 1
179507
www.sqlcourse.com\nwww.1keydata.com/sql/sql.html\nwww.w3schools.com/sql\nwww.geocities.com/SiliconValley/Vista/2207/sql1.html\nsqlzoo.net
870873
Well the easiest way is to use a straight out SQL method in access. Its not that a SQL method is hard but is just how you access the information in a table. Below is a link to a page which shows you a great straight forward example of using a few nested select statements or if you want to create an intermediate table to hold the results, that example is there too.\n\nHope this doesn't confuse you too much, but really if you take a look at it, you will find it makes sense. Just read it out loud.\n\nGood luck!
72241
This is how my shop writes coldfusion queries:\n\n<cfquery Datasource="#DatabaseName#" name="NameOfQuery">\nSELECT  field1, field2, field3\nFROM    Schema.tablename\nWHERE   somecondition = somecondition\n</cfquery>
1011783
Select {columns}\nfrom {tables}\nwhere {conditions}\n\nIt is the structure of a language meant to grapple with tables and columns instead of files and fields.
539787
You need to create a windows application or a command line application. then you can use the following\n\nImports System.SqlClient\n\nthen just use the library features to open a sql connection and specify a sql command and fill a dataset using that.
109303
Tom Kyte is a Oracle Guru and has site which you can check for any pl-sql questions - http://asktom.oracle.com/pls/ask/f?p=4950:1:\nAlso he has some books published regarding pl-sql which I have and are highly useful. Oracle has online documentation which is completely searchable and downloadable - http://www.oracle.com/pls/db92/db92.homepage \nThis has lot of details regarding commands with examples.\nFor sample code check this out -\nhttp://www.oracle.com/technology/sample_code/tech/pl_sql/index.html\n\nHope this gets you going. Let me know if you need more help. \n\nGood Luck !!