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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Returning last row
I know this is FAQ but I can't seem to get this to work. I need to return the last row in the table, I'm using auto_increment which is the 'priKey' column. 'beachName' is the name of the table , 'DATEOFFILE' is the column in the table that I need to return the last value for. The println outputs... -
Syntax problem
It keeps throwing a syntax error, I've been banging my head against a wall over it, can any one spot it? I trying to use AUTO_INCREMENT to create a primary key, the tutorial on the MySQL website I don't think is very clear? statement.executeUpdate("CREATE TABLE `"... -
Formatting a date from a String.
Hi, a little date format problem: $result2 returns a String date from MySQL in the form 2005-03-23, and it is inserted in to a table. I just want to take that String and date format it into a day of the week 'Wed' for example, and insert that instead? Any help would be appreciated, thanks... -
How to return from 'todays' date?
Just a little problem, this query is working..nearly... I just need it to return starting from the first instance of todays date, in the table? If anyone can help you'd be a lifesaver.... "SELECT * FROM Aberystwyth ORDER BY Date, Time LIMIT 20 "; example: "SELECT * FROM Aberystwyth... -
Java: Need to question MySQL whether or not a table is there or not
Stuck on this I can't find an answer on the forums: it's simple all I need to do is write a statement to ask if the database has a table with a particular name already.... e.g if (*****TableName = table already in DB) { statement.executeUpdate("INSERT INTO " + TableName +... -
Java and FTP access
Hi, I'm trying to write a class that can access an FTP server, with a log in and password, navigate to a file in the directory and grab some files. From what I can see there is no FTP support in the Java SDK API. I'm stuck can anyone give me any pointers? Thanks in advance.....
