Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

ACCESS To MySQL

 
Mathias Nilsson
Ranch Hand
Posts: 107
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Ranchers!
I want to switch from MS ACCESS 2000 to MySQL. I do not use embedded sql in
java, only queries saved in access( some kind of stored procedures ).
Many of my queries uses IIF() functions istead of CASE...WHEN. Since
MySQL don't support stored procedures, yet, then what shall i do to
make the queries work in MySQL.
// MAthias
 
m hoque
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi
sorry but as far as I know you don't have any other way then writing the queries in you application cause as you know mysql don't support stored procedure or views yet.
 
Mathias Nilsson
Ranch Hand
Posts: 107
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Ok!

The how do you do a search in mySQL. Let's say a user can write in
a name , from and to date and so on in a form and then click the search button. If the user dosn't write anything all records from the database will be retrived. If he writes a name the a like statement should be supplied. If doing this in a stroed procedure you write

How do you do this in mySQL without having to do


// Mathias
[ November 10, 2003: Message edited by: Mathias Nilsson ]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic