Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

Swap contend of 2 rows in a table

Comment:

Is it possible to swap the contends of 2 rows of mysql databse using a single query( swap the item except the id) www.geoshrad.com

MySQL Partial Search

mysqld-nt.exe consumes mo...

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: I have a table with one column " otname " table1.otname contains multiple rows of alpha-numeric string resembling the following data sample: 11.10.32.12.U.A.F.3.2.21.249.1 2001.1.1003.8281.A.LE.P.P 20...

Summary: Two separate queries are not needed. That's what OR is for. In a SQL type database it would go something like this (assuming the names of the columns are C1, C2, & C3): SELECT * FROM table_name WHERE ...

Summary: Hi All, I'm trying to write a script to generate rows in a table from arrays and sub-arrays. Its all working lovely but i've come up against a problem... all i want to do is store the full array strin...