Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: DJDaveMark
- Content: Threads
- Order by date
-
Can it be One Statement or programming?
Hi all, I'm fairly new to SQL & I was wondered if there was a single SQL satement that would create something like the following table... race1 race2 race3 race4 a. person 9 8 8 8 b. person 5 5 4 1 c. person 9...- DJDaveMark
- Thread
- Replies: 4
- Forum: ANSI_SQL
-
Is my INSERT statement good ANSI_SQL
Hi all, Being a Java Programmer it's the first time I've designed a database and the queries. I just wondered if the following was ANSI_SQL or if I've added mySQL specific stuff. A quick yes or no would suffice. Any links would be much appreciated.START TRANSACTION; INSERT INTO `race` ( `time`...- DJDaveMark
- Thread
- Replies: 2
- Forum: ANSI_SQL
-
Generalise a mySQL query using a Transaction & variables
Hi all, I'm a Java Programmer who's taken on a website project by myself, therefore I've also had to design the database. It will be a mySQL database. I have already designed it and successfully tested that the queries are getting out what was required. Although I'm not sure how portable my...- DJDaveMark
- Thread
- Replies: 1
- Forum: ANSI_SQL
