This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC and the fly likes MySQL equivalent to Oracle's Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "MySQL equivalent to Oracle Watch "MySQL equivalent to Oracle New topic
Author

MySQL equivalent to Oracle's "select * from dual;"

Jim Atharris
Greenhorn

Joined: Jan 07, 2008
Posts: 28
Hello All,

I'm new to MySQL and need MySQL's equivalent to the common "test" SQL statement that people use for Oracle:

select * from dual;

Thanks,Jim
Susanta Chatterjee
Ranch Hand

Joined: Aug 12, 2002
Posts: 102
I think it is

- Susanta
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: MySQL equivalent to Oracle's "select * from dual;"
 
Similar Threads
Getting the value of a sequence using JDBC ...
Check Database is running / not
System TimeStamp
Oracle Pivot table
Database Failover