Whats the query if first loin and second login were from two different
tables.
I have a table like as follws
Emp_id, first_login , second_login
1 02/10/0904/11/09
2 03/10/0904/11/09
3 04/10/0905/11/09
4 05/10/0906/11/09
5 06/10/09
2 06/10/09
Hello Ilya,
I think store files in DB has no complicated reasons, just for
convenience. For example, I might make files automatically be
backup-ed, and no budget for an independent backup solution. Thanks.
Cui
2010/2/11 Ilya Kazakevich :
> Hello John,
>
> There was a joke in russian PHP club:
The odbc connector of mysql reports it does not support LAST_INSERT_ID nor
does it seem to report back that it supports unicode.
For the last_insert_id I have a workaround by issuing a Select
last_insert_id() after an insert, however for working with unicode I have not
found a solution.
this i
Hello John,
There was a joke in russian PHP club: "why strore images in database? Are
you going to have a full text search on them?"
IMHO:
Storing files in DB is probably bad idea.
Here are some advantages of storing files on filesystem:
1) Theoretically it takes more time to load data from data
John G. Heim wrote:
About 5 years ago,...
then the selection committee asked me to add something ...
Then the next year, the graduate school changed their ...
Then they started taking letters of recommendation ...
One might think of this as scope-creep, but really, given the
length of time ove
About 5 years ago, I was asked to write a php app for my department. The app
keeps track of graduate school applicants to my department at the
university. The main data elements are the scores each professor gives to
each applicant. There are only about 400 applicants each year so even with
all
Dear Sir,
Thank you for advising me generally, how to approach/in what cause we need to
approach!
I will follow your advise very strictly here after. I will try to find out
solutions my self first and if not, i ll write to the experts.
Thank you so much for making me to understand the helping
You also need to NOT YELL AT PEOPLE, and GO LOOK AT THE CRYSTAL REPORTS
MANUALS.
On Wed, Feb 10, 2010 at 11:58 AM, Vikram A wrote:
> Hi,
>
> As stated
> http://dev.mysql.com/tech-resources/articles/vb-blob-handling.html
>
> I have stored image using the following.
>
> CREATE TABLE files(
> file_
Hi!
SQL Maestro Group announces the release of Code Factory for MySQL
10.2, a powerful Windows GUI solution aimed at the SQL queries and
scripts development.
The new version is immediately available for download at
http://www.sqlmaestro.com/products/mysql/codefactory/download/
Please note that b
What is the basic functionality of the MyISAM, InnoDB etc ?
http://dev.mysql.com/doc/refman/5.0/en/storage-engines.html
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusD
Hi,
What is the basic functionality of the MyISAM, InnoDB etc ?
Vikram A
The INTERNET now has a personality. YOURS! See your Yahoo! Homepage.
http://in.yahoo.com/
Hi,
As stated http://dev.mysql.com/tech-resources/articles/vb-blob-handling.html
I have stored image using the following.
CREATE TABLE files(
file_id SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
file_name VARCHAR(64) NOT NULL,
file_size MEDIUMINT UNSIGNED NOT NULL,
file MEDIUMBLOB NOT
13 matches
Mail list logo
