now (more securely) implemented has 'broken' the sample
code.
=when you've had a 'play', come back and let us know how much things are
improved,
=dn
> On Wed, 20 Nov 2002 DL Neil wrote :
> >Pallavi,
> >
> > > mysql> load data infile
Guenter,
Nice piece of analysis!
As it happens WinMySQLadmin v1.4 under Win2000 fares little better,
apparently gobbling up VM until... (Bug Report posted 20Nov2002 shortly
after midnight UTC - as yet unacknowledged)
[won't attach here (not correct list procedure), so will forward private
copy sep
Hi Trask,
> Can anyone tell me how to set the following parameters in mySQL 3.23? I'm
> new to MySQL and am setting up a BBS. MySQL is installed and running OK.
>
> Database Server Hostname / DSN:
> Database Name:
> Database Username:
> Database Password:
> Prefix for tables in database:
Welco
Hello Tarik,
The DISTINCT option will sort this out for you.
=dn
> I got two tables containing following data :
>
> table1
> --
> id
> --
> 2
> 3
> 2
> 2
>
> table2
> --
> id | label
> --
> 1 | one
> 2 | two
> 3 | three
> 4 | four
>
> I would like to select table2's rows th
Hey Alex
> select captain from stats where captain > 0 and number = '23' group by
> number;
>
> this returns a 1 for any player with the number that matches being a
> captain, however it display a 1 is it possible to make that 1 displayed as
a
> C on my page?
MySQL allows an IF() within the SELE
rom: "Jeff Kilbride" <[EMAIL PROTECTED]>
> To: "Alex Behrens" <[EMAIL PROTECTED]>; "MYSQL"
<[EMAIL PROTECTED]>
> Sent: Sunday, November 24, 2002 5:08 PM
> Subject: Re: displaying a letter based on a query value
>
>
> > select i
Mark,
Are you working from the command line or using a tool (which)?
MySQL version nr?
Are you running WinMySQLadmin (the traffic lights in the System Tray)?
=dn
> I'm running MySQL as a service on win2k and trying to insert data into a
> database. Each time I try to do this I receive the foll
Jim,
> Situation.. main table in a relatively small database. Table contains
> approx 370K rows. Table is indexed on the unique identifier. New table,
> fresh import of clean data.
>
> Querying on a single field... run from the command line, returns 3 rows,
> run from phpMyAdmin, returns 3 rows.
Grant,
> I need help. I am building a database for a small college that wants to be
> able to update their program information for each department through an
> web/gui program.
>
> I've decided to use, MYSQL, Apache, PHP and FreeBSD as the OS. (I built my
> web page this way)
>
> Here's my QUESTI
Tim,
Normally PHP/MySQL doesn't run as "mine", even if that is your Windows login
name - but it is possible...
Use command line.
Log on as root.
Check localhost privileges for user "mine".
(good coverage in the manual)
Regards,
=dn
> I have been trying to get mysql db to run but keep
> getting acc
Chandra,
> I need some help in finding the time/day difference
> as i want to know the session times
> is there a way/function to calculate time difference
> in mysql
Self help - from the foot of each list msg:
> -
> Before pos
ata. Imagine that presented as a single screen-load and ask if it
seems appropriate for the application...
> That file idea of your is interesting I will have to sleep on it. Thanks
for
> your input. I'm a one man team developing this and I've been sinful. This
is
> the time God&
er mine.
=are you able to gain access at the command line (with mine/mine2)?
=BTW: now that we all know your pswd, I trust this is not an Internet-facing
machine!
=Idle curiousity: what will the gulf db contain?
=Regards,
=dn
> --- DL Neil <[EMAIL PROTECTED]> wrote:
> > Tim,
&g
> Is it possible for mySQL to recognize and compare dates written in this
> format: MM/DD/YY?
=the short answer is yes and no: "yes" it can be done by combining various
SQL/MySQL functions, but "no" there is no easy 'built-in' method.
> I know standard date format for mySQL is YYY-MM-DD, but I n
Hi Haksun,
Cross-join works perfectly on 3.23.53-max-nt under Win2000 SP2, both from
command line and MySQL Control Center 0.8.6-alpha.
Regards,
=dn
> Hi all,
>
>
>
> I found this join problem using mysql 3.23.53-max-nt (on WinXP).
>
> It works fine on MySQL 3.23.52-log (on Linux).
>
>
>
> Could
t;
> > > 1 4 1 4
> > >
>
>
> If that is the case, is this a Win-XP specific bug?
> Can someone running versions other than MySQL 4.0.5-beta on XP verify if
> it is a bug please?
>
> Thanks!
>
>
> Haksun
>
> > -Original Message
Hi Kath,
Are the MySQL machine, the Linux machine, and the client you are using all
the same machine?
Which timezone is Linux set to?
Which timezone is your local/client machine in, and/or set to?
Please advise,
=dn
> hi, which date does mysql use to calculate CURDATE()? I have a master
> databas
Hi Beauford,
You are on the right track. Yes you should remove the songs to a separate
table. If you merely duplicate the first example (below) in two tables you
have created a "one-to-many" relationship between the Album table and the
Songs table - one album has many songs on it. Your query code
Alex,
This is a specialised question! Unfortunately, in my experience, it comes
down to the phrase YMMV (your mileage might vary) and thus requires you to
experiment with your data/machine combinations/etc - good job MySQL makes
this quite easy!
Can I assume that you have done your (manual) homew
maps filter fodder: MySQL
> Hi Terence,
>
> > Is there a way to sort records based on a particular column, varchar(3),
> > which contains days of the week, mon, tue, wed, thu, fri, sat, sun
> >
> > I need the order to be mon, tue, wed, thu etc.
> >
> > Select day_of_week from my_timetable
> > ord
??
> 3C3S??
> 4D4T??
> 5E 5V ??
>?
>?
>?
>
> Select * from employees left outer join dept on employees.emp_DepId =
> dept.dep_id where dept.dep_id is null
>
> (Subselect would be easier if MySQL supported it!)
Likely easier to write, but equally likely to be more expensive to run
(on any tbl of realistic size)
NB Comment only pertinent a
RD,
> How can I set auto-increment in mysql to start counting at say 5
rather
> than 1
The manual is your friend.
Enter auto_increment into the search facility. Read 6.5.3 CREATE TABLE
Syntax - which illustrates the answer, or move on to the better description
in the next 'hit' 6.5.4 ALTER
Hi George,
> I am about to start the planning process in moving my FileMaker/Lasso/PHP
> site over to MySQL/PHP.
> Before I get too far down the road, should I be using InnoDB or MyISAM
> tables? The service is initially going to be hosted on WinNT but may move
> over to Linux later.
=main respon
Hi Justin,
> I'm after a little help/advice with indexing...
> I have a table for measuring hits on each page within a site:
> year month page hits
>
> basically, my php script looks for a row matching this year (2002), this
> month (12) and this page (something.php). if it finds it, increment by
hanges is 'enough'! (now apply
this to customer records and people changing addresses and you'll see
why/which is the 'industry standard' approach).
=however the ultimate answer to your question is: if it works for you/your
users, then it is 'right'!
> Than
- Original Message -
From: <[EMAIL PROTECTED]>
To: "DL Neil" <[EMAIL PROTECTED]>
Sent: Tuesday, December 03, 2002 1:05 PM
Subject: Re: Re: Select and count duplicates
> Your message cannot be posted because it appears to be either spam or
> simply off topic
Sam, heads up!
MySQL list members don't want this = spam!
=dn
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, December 03, 2002 4:54 PM
Subject: Time&Date in SQLServer7
> Hi
>
> I am inserting a Time like 06:00 from my code to a
Thanks for the quick response. Excellent support
=you must have some 'magic touch'!
=a bunch of us held a conversation on the list trying to run this fault
down, and culminating in a bug report. We weren't even acknowledged... Quite
dispiriting. Obvious suggested work-around was to get hold
Felix,
> Is is it possible to write an aggregation function which returns
> more than one row?
Yes - if I have understood your requirement correctly.
It would have been helpful if you had given some idea of the
application/what you want to achieve. Here's an example from out of my
imagination:
Oganes,
> I have the following create table, and I get the following error when I create it.
> It used to work before. Can anyone help?
>
> CREATE TABLE PROTOCOL_GROUPING(
> PROTOCOL_GROUPING_ID MEDIUMINT(20),
> GROUP_NAMEVARCHAR(50)NOT NULL,
> PROTOCOL_ID
Hi Oliver,
> I would like to obtain the time in GMT in mySQL.
>
> CURRENT_TIMESTAMP returns the local time
> SHOW VARIABLES returns a list of variables, one being TZ which is "EST" on
> my system
>
> But how can I get the time in GMT???
MySQL is time-neutral, that is to say, if you ask it the t
Nesh,
> With all of the benchmark test I have used the same DB structure, same
> TABLE structure, and finally same iterations.
>
> This probably means that Solaris I/O is really poor, or there is some other
> explanation (like changing some kernel parameters to get Solaris working
> well with
Oliver,
It's early in the morning over here, so that's my excuse for feeling confused...
> >> select FROM_UNIXTIME(UNIX_TIMESTAMP(),
> >> '%Y %D %M %h:%i:%s %x');
> >> UNIX_TIMESTAMP() returns the number of seconds since '1970-01-01
> 00:00:00' GMT
> >> Convert this to a dat
Dear Hayan,
> Which of the following SQL queries is faster and better
> "select thefield from thetable group by thetable"
> Or
> "select distinct thefield from thetable"?
> and WHY?
=if you use the MySQL command line to issue a query, a summary report follows any
output giving number of rows
a
Hi Peter,
> I am working on a search logging script to count the most popular word or
> phrases searched for.
>
> Table
>
> I could add a line for each search, and aggregate the results for reports,
> but I was wondering about the following which would keep table sizes down.
>
> | search word
Hi Bob,
> Hi, I currently have a very large MS SQL7 database that I need to put on the
> web. My plan is to use PHP and MySQL to accomplish this. Currently I have a
> Visual Basic front end on the MS SQL7 Server. I would like to have my VB
> program write The MS SQL7 server data to a MYSql databa
Bob,
I've posted this back onto the list because there are others here who will be much
more able to assist.
> Clarification:
>
> I currently have 22 NT workstation that send data to various tables in a
> SQL7 database running on a NT sever. The visual basic front end organizes
> this data in t
Nick,
> I don't think ...
> Am I talking rubbish?
An admission and then an invitation??? Boy you must some masochist!
You asked a question, it was answered (and there's usually more than one way to skin
the proverbial cat); and
then you appear to argue.
"Thinking" is not as good as "testing":
Nick,
> Well I /hadn't/ tested as I wasn't sure that my DB design wasn't flawed,
> I was expecting someone to say 'well if you want to do that you need to
> design like this..' No matter.
Again: if you use the native-MySQL/command line, or an administration/management
package, you will be able
Hi Andrea,
> I am really new at PHP & MySQL, so please bear with me.
welcome to our happy band...
> I am using the mysql_insert_id function but continually receive an error,
> and hoping someone can point me in the right direction to resolve this.
>
> My error:
> Warning: Supplied argument is n
Hai,
Where? Here!
> is there any support of sys_date in mysql which is strong feature in oracle
> 8.x . i am using MYSQL 3.23 server version .
Short answer: RTFM 6.3.4 Date and Time Functions
Don't have an Oracle book with me, please refresh my memory of the exact output from
sys_date/you r
Hi Christo,
> How can I take info from one table and print it into a txt file.
> the table is (NAME)
> and all the names in it I want to print out to a file name virtusertable.
Would SELECT ... INTO OUTFILE 'file_name' suit you?
(MySQL manual: 6.4.1 SELECT Syntax)
Regards,
=dn
---
Hi Paul,
> I want to dump the contents of one table in to another table
> which has the same structure in MySQL, with just one column type changed
> from VARCHAR to TEXT. Whats the best way to do this?
Would INSERT...SELECT suit you?
=dn
--
Paul,
> > > I want to dump the contents of one table in to another table
> > > which has the same structure in MySQL, with just one column type changed
> > > from VARCHAR to TEXT. Whats the best way to do this?
> >
> > Would INSERT...SELECT suit you?
>
> Yes, but it's a big table. Is there a w
MySQL manual A.5.7 Problems with floating point comparison
=dn
- Original Message -
From: "Gerald Clark" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: 08 February 2002 15:24
Subject: Re: Problems with select
> 15.8 has no exact binary representation, so
Hello André
> I am playing hard with mysql, cause my ultimate objective is to make a big
> databank for a game.
>
> I notice that i cant find a way to make relations beteen tables.
> Must i do it also with PHP ?
Just to confuse you, the mathematical jargon for table is "relation"...
May I sug
Hi Jim,
Welcome to our relatively?relationally happy band.
> This is my first post to the list. I've been working on MySQL now for about a
> week and really like it. I have a question that I can't find in any of the
> books or how-tos.
A whole week and no post...
> When I add a line to my custo
Ferreira,
[I have posted this back to the list. There are many others who will be able to help -
some from Portugal. Also
I have noticed questions and comments from many people working on
collections/libraries of CDs, videos, books,
etc]
> Thack for all that knowleg... ( wisdonw )
> pardon my e
Keith,
> I have the below query that returns the correct records but the
> POINTFUND.description field is all NULL while it has values in the table.
> Any idea why? Thanks.
>
> SELECT
>
> RACES.RACE_ID,
> RACES.sequence,
> TYPES.typelong,
> SCHEDULE.event,
> SCHEDULE.date,
> PARTY.lname,
> POINT
Hello Almar
> I have a question about a query. We have a guestbook and I want to do some
> statistics for the messages in it. So I've created a query that looks like
> this.
>
> select hour(msg_date_time), count(*)
> from messages
> where user_id = 'almar'
> group by hour(msg_date_time)
>
> It re
Bob,
> > There are some RDBMS-es that implement SQL to the point of apparently setting up a
>construct that links
tables -
> > foreign key based data integrity being the first example that springs to (my)
>mind. However relational logic
> > suggests that the way to set up a linkage between tabl
Hello mike
> I've been reading about TIME _FORMAT in the mysql manual. Does this only
> work
> with a manually entered time?
> SELECT TIME_FORMAT('13:45:00','%h:%i') as time FROM table_name;
>
> I tried this,
> SELECT TIME_FORMAT('column_name','%h:%i') as time FROM table_name;
> to format my ti
Hello James,
> Basically the problem I am having is how best to handle multiple values for
> a specific column, in this case the values in question are coming from an
> HTML SELECT MULTI box processed by PHP.
>
> The way I have been doing this so far is to have a delimited value stored
> in a var
Greetings
> i an doing my assignment using mysql to establish a database!!
> i already create the table and insert the data,
> but i don't know how to create a export file,
> anyone can help me!!
Check out the online manual (4.8.5 mysqldump, Dumping Table Structure and Data), or
take a look a
Rich,
> How does one go about removing one of two identical records in a MySQL
> database? My mistake in an earlier database was not applying a unique
> number to each record (1, 2, 3, ---). I know it's possible to use the
> DISTINCT operator to show only one of the identical records in a resul
Hello Odhiambo,
> Please allow me to request for help with the table below.
> mysql> select * from relay_ip;
>
>+-+++-+-+
> | rei_aid | rei_uname | rei_domain | rei_ip | rei_ts
>
Nick,
> I don't think ...
> Am I talking rubbish?
An admission and then an invitation??? Boy you must some masochist!
You asked a question, it was answered (and there's usually more than one way to skin
the proverbial cat); and
then you appear to argue.
"Thinking" is not as good as "testing":
Hi Bob,
> Hi, I currently have a very large MS SQL7 database that I need to put on the
> web. My plan is to use PHP and MySQL to accomplish this. Currently I have a
> Visual Basic front end on the MS SQL7 Server. I would like to have my VB
> program write The MS SQL7 server data to a MYSql databa
MySQL manual A.5.7 Problems with floating point comparison
=dn
- Original Message -
From: "Gerald Clark" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: 08 February 2002 15:24
Subject: Re: Problems with select
> 15.8 has no exact binary representation, so
Ferreira,
[I have posted this back to the list. There are many others who will be able to help -
some from Portugal. Also
I have noticed questions and comments from many people working on
collections/libraries of CDs, videos, books,
etc]
> Thack for all that knowleg... ( wisdonw )
> pardon my e
Hi Jim,
Welcome to our relatively?relationally happy band.
> This is my first post to the list. I've been working on MySQL now for about a
> week and really like it. I have a question that I can't find in any of the
> books or how-tos.
A whole week and no post...
> When I add a line to my custo
Hi,
> thanks!!
=my pleasure.
> i think the dumping commnad is a shell command! am i right?
> if it is can you tell me how to change command header
> mysql> to shell>
> or tell me where i misunderstood.
=when people talk of a "shell command", I tend to assume they are talking about Unix
comman
Dear Hayan,
> Which of the following SQL queries is faster and better
> "select thefield from thetable group by thetable"
> Or
> "select distinct thefield from thetable"?
> and WHY?
=if you use the MySQL command line to issue a query, a summary report follows any
output giving number of rows
a
Hello Almar
> I have a question about a query. We have a guestbook and I want to do some
> statistics for the messages in it. So I've created a query that looks like
> this.
>
> select hour(msg_date_time), count(*)
> from messages
> where user_id = 'almar'
> group by hour(msg_date_time)
>
> It re
Bob,
> > There are some RDBMS-es that implement SQL to the point of apparently setting up a
>construct that links
tables -
> > foreign key based data integrity being the first example that springs to (my)
>mind. However relational logic
> > suggests that the way to set up a linkage between tabl
Bob,
I've posted this back onto the list because there are others here who will be much
more able to assist.
> Clarification:
>
> I currently have 22 NT workstation that send data to various tables in a
> SQL7 database running on a NT sever. The visual basic front end organizes
> this data in t
Hi Andrea,
> I am really new at PHP & MySQL, so please bear with me.
welcome to our happy band...
> I am using the mysql_insert_id function but continually receive an error,
> and hoping someone can point me in the right direction to resolve this.
>
> My error:
> Warning: Supplied argument is n
Hello mike
> I've been reading about TIME _FORMAT in the mysql manual. Does this only
> work
> with a manually entered time?
> SELECT TIME_FORMAT('13:45:00','%h:%i') as time FROM table_name;
>
> I tried this,
> SELECT TIME_FORMAT('column_name','%h:%i') as time FROM table_name;
> to format my ti
Keith,
> I have the below query that returns the correct records but the
> POINTFUND.description field is all NULL while it has values in the table.
> Any idea why? Thanks.
>
> SELECT
>
> RACES.RACE_ID,
> RACES.sequence,
> TYPES.typelong,
> SCHEDULE.event,
> SCHEDULE.date,
> PARTY.lname,
> POINT
Hello James,
> Basically the problem I am having is how best to handle multiple values for
> a specific column, in this case the values in question are coming from an
> HTML SELECT MULTI box processed by PHP.
>
> The way I have been doing this so far is to have a delimited value stored
> in a var
Hi Christo,
> How can I take info from one table and print it into a txt file.
> the table is (NAME)
> and all the names in it I want to print out to a file name virtusertable.
Would SELECT ... INTO OUTFILE 'file_name' suit you?
(MySQL manual: 6.4.1 SELECT Syntax)
Regards,
=dn
---
Rich,
> How does one go about removing one of two identical records in a MySQL
> database? My mistake in an earlier database was not applying a unique
> number to each record (1, 2, 3, ---). I know it's possible to use the
> DISTINCT operator to show only one of the identical records in a resul
Hai,
Where? Here!
> is there any support of sys_date in mysql which is strong feature in oracle
> 8.x . i am using MYSQL 3.23 server version .
Short answer: RTFM 6.3.4 Date and Time Functions
Don't have an Oracle book with me, please refresh my memory of the exact output from
sys_date/you
Hello Nuno,
> I'm trying to make a query with only one command but I can't see how to do
> it.
>
> Supose that are 2 tables like:
>
> table QA table QB
> ref text ref text
> --- ---
> a1 texta1 b1 textb1
> a2 texta2 b2 textb2
> a3 texta3 b3 textb3
>
> and there is a
re values in POINTFUND.TYPE_ID that match TYPES.TYPE_ID. The obvious
> solution to this is to create a query that joins POINTFUND and TYPES and
> then use that query in the above query insead of the POINTFUND table (I hope
> that makes sense). Unfortunatelly there doesn't seem t
Dan,
[I've cc-ed this to the list and to Rich - who asked the original question]
> You can do the following to remove duplicates:
>
> - create table foo as select distinct cols from
> table_name_containing_duplicates;
> - drop table_name_containing_duplicates;
> - alter table foo rename to table_
Hi Paul,
> I want to dump the contents of one table in to another table
> which has the same structure in MySQL, with just one column type changed
> from VARCHAR to TEXT. Whats the best way to do this?
Would INSERT...SELECT suit you?
=dn
--
Roger,
> * DL Neil
> > Mysqldump is a command that is typed at the MySQL command
> > line - just as you would SELECT...
> huh? mysqldump is a command line utility... it can not be entered in the
> mysql monitor, it must be entered on the unix/linux/dos prompt.
>
> &g
Paul,
> > > I want to dump the contents of one table in to another table
> > > which has the same structure in MySQL, with just one column type changed
> > > from VARCHAR to TEXT. Whats the best way to do this?
> >
> > Would INSERT...SELECT suit you?
>
> Yes, but it's a big table. Is there a w
Hello André
> I am playing hard with mysql, cause my ultimate objective is to make a big
> databank for a game.
>
> I notice that i cant find a way to make relations beteen tables.
> Must i do it also with PHP ?
Just to confuse you, the mathematical jargon for table is "relation"...
May I sug
Hello Robert,
> Hello experts, I've got a small problem with an sql query here that's got
> me completely stuck.
>
> In my MySQL database I've got two tables here that have identical design,
> e.g.
> table 'detail' - columns sales-order, quantity, part-number, price,
> date-sent
> and
> table 'ar
Hi Abdul,
Can Mysql ignore alphabet , like 'the' when
ORDERING a name.
A sample :
I have a table (first_name) :
- The test.
- Falcon
- The Armageddon
- Battle
When ordering it will be :
Battle
Falcon
The Armageddon
The test.
Can it be like this :
The Armageddon
Battle
Falcon
The test.
Hi Stanley,
> I am trying to upload a CSV file directly to the database using command
>
> strSQL = "load data infile '" & strFNPath & "' into table products"
> where , strFNPath =>Path of the file
>
> But its not working correctly ,it uploads some data and then seem to stop
> or enter values in t
Keith,
> I got it! What you said about replacing one JOIN with another is what did
> the trick. After a little trial and error (maybe a little more than a
> little) I got the results I needed. Thanks for the help. In case you're
> still curious I am modeling short track racing here in New Yor
Andreas,
If anyone else is interested, I have solved the problem in stepwise/tutorial fashion
below (best viewed using a
fixed font).
If anyone is skilled in the user of FROM...JOINs, (I'm sure Andreas, and) I'd welcome
a critique/any
improvements!
I have taken a look at this problem, and bein
Hi Catalina,
I have a servlet in which I connect through a mysql driver to the
database. The servlet has a string that represents the date in the
format 'MM/DD/YY'.
When I am trying to insert this date, I get sometimes the correct date,
sometimes I get the '-00-00'.
Here is the code:
Str
Brent,
> >What Rick said is absolutely correct and you probably are obsessing about
> >something that doesn't matter. But I would venture you are using an
> >auto-number field as the primary key when you could easily change it to a
> >function something similar to: set ID = MAX(ID) + 1.
>
> Kei
Once tables are CREATEd, the name is listed in SHOW tables using lower case
characters, regardless of the case
used in the CREATE command.
Using upper case table names in RENAME results in the error.
Workaround: Using lower case equivalent table names works, regardless of the case used
in the C
SubbaReddy M
> I am afraid it's not a bug, rather a syntax error.
> please follow the syntax to rename the table:
>
> mysql> alter table X1 rename as X2;
Why do you say this?
Manual entry:
6.5.5 RENAME TABLE Syntax
RENAME TABLE tbl_name TO new_table_name[, tbl_name2 TO new_table_name2,...]
.
Egor,
Yours/this arrived in my InBox whilst I was addressing the original msg - please see
my other reply/ies.
Error still occurs when running as Administrator on WinNT and root under MySQL
- definitely no access/permission issues.
Lower case works (please see earlier reply).
If I/my NT PC can
Bryan,
I apologise, did I mistakenly call you Brent earlier!?
> Indeed. I have a relatively large (few dozen) number
> of tables that are accessed via PHP and a web
> interface. The script pulls information from these
> tables to generate pull-down menus. It would be nice
> if these pull-down men
George/Rick, a quick addition.
It is not clear from the question: do you want to have the timestamp updated, or do
you want to leave it be?
RTFM:
6.2.2.2 The DATETIME, DATE, and TIMESTAMP Types
...
The TIMESTAMP column type provides a type that you can use to automatically mark
INSERT or UPDAT
Richard,
> I'm stumped -- which isn't saying much because I'm hardly a scientist.
> I am struggling to write a query that will tell me how many times a new
> volunteer ( defined as a volunteer who has never worked a shift ) did
> not show up for his shift (first shift). From my data I would
> ev
Luie,
> Wouldn't replace change all the entries in your table row, same effect as update?
> I believe the question is how to test which entry in a form has a new value and
>replace/update only that value
in the table.
> If I have a form...
>
> __
> |Employee Reco
Hi Kevin,
> I'm converting a database from a filesharing based technology to mySQL. The
> database has its own column type called Sequence which is the same as using
> the AUTO_INCREMENT property. I'd like to use AUTO_INCREMENT if possible but
> I'm not really sure what I can do with it - can any
Richard,
> Does anyone know what is wrong with this syntax...
>
> Select H.FinishCode, L.RowID
> From CallHistory As H, BD2.CallList As L
> Where (H.CallTime in(Select MAX(CallTime) From CallHistory Where H.RowID =
> L.RowID)
> AND H.RowID = L.RowID);
Sub-selects not (yet) permitted by MySQL (
David,
> How would you use a temporary table? Is that the most efficient way?
Use SELECT INTO temp_tbl to replace the sub-select clause.
Rewrite the existing SELECT into a join with the temp_tbl.
Is there another way?
=dn
> Richard,
>
> > Does anyone know what is wrong with this syntax...
Clive,
I've added a timestamp field to a table and when viewing the data stored in the field
it looks like this .
19970523091528
.. but when I view the data in Access or Macromedia Dreamweaver it looks like this
05/23/1997 09:15:28
.. is there any way to make Access/Dreamwe
Hi Geoff,
> Apols for being dense but I have basic problem with
> MySQL for Win98.
Perhaps not "dense", just baffled by 'new' terminology.
You appear to have downloaded the source code.
If you want to download MySQL and not have the extra, compile, step to negotiate, then
find the *-win.zip
opt
1 - 100 of 319 matches
Mail list logo
