On Thu, 4 Apr 2002, Doug Bishop wrote:
> Try:
>
> mysql_connect("localhost", "user", "password");
> $query = "SHOW TABLES;";
> $result = mysql_db_query("databasename", $query);
> $i = 0;
> while ($row = mysql_fetch_array($result))
> {
> $tableNames[$i] = $row[0];
> $i++;
> }
> for ($
Hi,
Yes I have checked the Docs. And even tried to make the entries in the .ini
file. But when I doing so the database is not starting. There is no error
what so ever. When removed the entires for innodb the data base starts
properly.
Rajeev
- Original Message -
From: "Jeremy Zawod
I have got a backup script that locks the MySQL tables then use cp(unix) to
copy the tables.
It then tar, then zips them up.
So my queston is what is the minimum privileges that this MySQL back user
needs just to lock tables?
Thanks
Simon Green
--
Live
On Wed, 3 Apr 2002, Nick Arnett wrote:
>
>
> > -Original Message-
> > From: Doug Bishop [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, April 03, 2002 10:13 PM
> > To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> > Subject: RE: Table statistics
> >
> >
> > Try:
> >
> > > mysql_connect("local
* andy thomas
> Is there a command I can give in the mysql client to find the number of
> rows in a table or, better still, the number of rows in all the
> tables in a database?
The "normal" way: SELECT COUNT(*) FROM table
To get all tables in one statement... this is a hack, I'm not sure it wil
On Thursday, 4. April 2002 10:42, andy thomas wrote:
> Yes but this is PHP code that can only be run through a suitable web
> server, browser, etc - I want a command line solution like mysqlshow ...
> or from within the mysql client itself.
You can also run PHP from the commandline without any w
On Thu, 4 Apr 2002, denonymous wrote:
> From: "andy thomas" <[EMAIL PROTECTED]>
>
> > Is there a command I can give in the mysql client to find the number of
> > rows in a table or, better still, the number of rows in all the tables in
> > a database?
>
>
> To return the # of rows in a table:
>
Was wondering has any 1 used DTS in SQL Server 2000 to insert table from a
SQL server table into a mysql table
Disclaimer & Confidentiality Notice
This email, together with any attachments, is for the exclusive and
confidential use of the addressee(s). Any other distribution, use or
reproduction
On Thu, 4 Apr 2002, Georg Richter wrote:
> On Thursday, 4. April 2002 10:42, andy thomas wrote:
>
> > Yes but this is PHP code that can only be run through a suitable web
> > server, browser, etc - I want a command line solution like mysqlshow ...
> > or from within the mysql client itself.
>
>
For the inbound connection on port 3306 of MySQL Server, how do I restrict
the connection to some IP addresses something like 1.2.3.*
What do I need to do in my.cnf file?
Thanks in advance.
NOBBY
-
Before posting, please che
On Thu, 4 Apr 2002 16:23:09 +0600
"Tshering Norbu" <[EMAIL PROTECTED]> wrote:
> For the inbound connection on port 3306 of MySQL Server, how do I restrict
> the connection to some IP addresses something like 1.2.3.*
>
> What do I need to do in my.cnf file?
>
> Thanks in advance.
you are playin
Hello all,
I am having the mysql log file which is having all the queries which
affects the data base.
I have to restore those queries in the table in some remote server.
Is that possible.
Any ideas are welcome.
Thanks in advance
--
Regards,
Charitha
---
On Thu, 4 Apr 2002 16:05:57 +0530 (IST)
Charitha <[EMAIL PROTECTED]> wrote:
>
>
> Hello all,
>
> I am having the mysql log file which is having all the queries which
> affects the data base.
> I have to restore those queries in the table in some remote server.
> Is that possible.
YAP !!! ;-)
* Tshering Norbu
> For the inbound connection on port 3306 of MySQL Server, how do I restrict
> the connection to some IP addresses something like 1.2.3.*
>
> What do I need to do in my.cnf file?
Nothing, this is done from the client.
http://www.mysql.com/doc/G/R/GRANT.html >
--
Roger
---
Thanks for the info I'll give it a try. Ya, I suppose I should have
mentioned my front end. It
just happens to be ASP and VBSCRIPT so your method should work fine. I did
look through the
manual but was really sure what to look for.
I'll have to try this out though...thanks
again.
-Nick
> Hi Nic
-Original Message-
From: [EMAIL PROTECTED]
To: Rochester, Dean
Sent: 4/3/02 4:26 PM
Subject: Re: How can I set a char(2) column to always stay 2 chars?
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must
May the gods of mySQL please forgive me. I just joined the list last night,
and thought, in seeing the question, I could provide a possible solution. I
was unaware that there was only one acceptable answer, and that all posts
had to be pre-checked. In the future I shall not make such a mistake aga
I have a MySQL database containing records from several years. I want to
calculate counts of records for each year and separate values for a couple
of other fields. Each record contains a date-field, date. I tried putting
the function YEAR(date) into a GROUP BY section, but this didnot work.
---
SankaraNarayanan,
Thursday, April 04, 2002, 10:04:14 AM, you wrote:
SM> I am using Visual Basic application to insert and
SM> update records in MySQL database.
SM> MySQL 3.23 is installed in Windows 2000 Server.
SM> I am running my VB application from my Windows 95
SM> machine with MyODBC 2.50 f
Tshering,
Thursday, April 04, 2002, 1:23:09 PM, you wrote:
TN> For the inbound connection on port 3306 of MySQL Server, how do I restrict
TN> the connection to some IP addresses something like 1.2.3.*
TN> What do I need to do in my.cnf file?
Nothing.
You should use 'host' table in the 'mysql' d
João,
Wednesday, April 03, 2002, 10:31:44 PM, you wrote:
JPV> is there any way to make mysqldump dump every insert as a single insert
JPV> instead of making INSERT INTO ... VALUES (...), (),(...) and so on ?
JPV> I read the manual and there is sth about -e wich as I understood means
JPV>
Martin,
Wednesday, April 03, 2002, 5:45:00 PM, you wrote:
MM> would anyone please explain me what are these error messages?
MM> 020327 12:29:26 mysqld started
MM> 020327 12:29:26 Warning: listen() on TCP/IP failed with error 98
MM> /usr/local/mysql/bin/mysqld: ready for connections
MM> /usr
chiou%2dguey,
Wednesday, April 03, 2002, 9:47:50 PM, you wrote:
c2l> I am trying to store a .gz file in a BLOB field in a mysql database. I have
c2l> tried two commands :
c2l> 1. Insert into mytable values('1', 'file1.gz');
c2l> 2 Insert into mytable values('1,','\'file1.gz\'');
c2l> These two
Richard,
Thursday, April 04, 2002, 2:42:52 AM, you wrote:
RC> create table test select * from summary_rts union select * from
RC> summary_rts_old;
RC> ERROR 1114: The table '#sqld70c_b4_0' is full
RC> Can someone please help me figure out what is wrong with this. It was
RC> working fine up
Patrice,
Thursday, April 04, 2002, 4:41:24 AM, you wrote:
P> MySQL Version: 3.23.49
P> OS: Win 98
P> Query 1: select length ('abc') returns
P> You have an error in your SQL syntax near '('abc')' at
P> line 1
P> Query2: select length('abc') returns 3: OK
P> Note the space between the 'h' and '(
I finally got the log-bin to work. You CANNOT put an extension.
log-bin = /mysql/log/replication
Eric Baines
I have the following query:
select *, max(event_date) as high, min(event_date) as low from schedule
where event_date between '2002-03-01' and '2003-04-30' group by
week_ending,meeting_id order by name, event_date, start_time
If I order by event_date, start_time, name, I get the proper results.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
At Donnerstag, 4. April 2002 12:23 Tshering Norbu wrote:
> For the inbound connection on port 3306 of MySQL Server, how do I restrict
> the connection to some IP addresses something like 1.2.3.*
>
> What do I need to do in my.cnf file?
I let the fire
I have a Mysql table with a char(2) column, name is Dependents. I want the
value that I insert to always be to places. I have tried
Insert into Table1 Dependents values '02';
but it inserts 2 in the Dependents column
How do I make it insert 02?
Thanks
Dean-O
Hello!
I have a problem with replication, sometimes (daily) the slave server
crashes
and restarts itself. I have entered "skip-slave-start" into my.cnf and this
makes
the server get back online but of course without relplication running. This
leads
me to believe that the master do something wrong
Will the data in this field always be numbers? you could just use TINYINT(2)
UNSIGNED ZEROFILL
-Original Message-
From: Rochester, Dean [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 04, 2002 8:56 AM
To: MySQL (E-mail) (E-mail)
Subject: How do you set the char format for a column in Mys
I have a mysql table like this
mysql> describe reports;
+-+-+--+-++---+
| Field | Type| Null | Key | Default| Extra |
+-+-+--+-++---+
| rptdate | date| | PRI | -00-00 | |
| id | int(11
* Rochester, Dean
> I have a Mysql table with a char(2) column, name is Dependents.
> I want the value that I insert to always be to places. I have tried
>
> Insert into Table1 Dependents values '02';
>
> but it inserts 2 in the Dependents column
Really? It is not valid SQL...
mysql> create ta
I know that is not valid sql, but it was the jist of what I was inserting.
I got it figured out. I am using Java to create this sql statement and
there is a decimal formatting object in java, so I used that to format the
variable that I am inserting and bingo, fixed.
Thanks for you gray matter
Do MySQL server administrators recommend running a cron script daily
to isamchk?
Is there any other things that should be run daily to keep MySQL
running top-notch? If so, does anyone have any pointers to a script
that has already been developed?
Thanks.
--
<-
From: "Rochester, Dean" <[EMAIL PROTECTED]>
> I have a Mysql table with a char(2) column, name is Dependents. I want
the
> value that I insert to always be to places. I have tried
>
> Insert into Table1 Dependents values '02';
>
> but it inserts 2 in the Dependents column
>
> How do I make it
At 9:14 -0500 4/4/02, George Smith wrote:
>I have a mysql table like this
>mysql> describe reports;
>+-+-+--+-++---+
>| Field | Type| Null | Key | Default| Extra |
>+-+-+--+-++---+
>| rptdate | date|
All
Could someone please update me as to when the 3.23.50 version of
MySQL/InnoDB will be released ?
We are experiencing issues with the loss of foreign key constraints when
using the ALTER TABLE command.
regards,
Chandran Honour.
Technical Director, BrowserAngel.
[EMAIL PROTECTED]
+44 (0)20 7
At 9:32 -0500 4/4/02, Rochester, Dean wrote:
>I know that is not valid sql, but it was the jist of what I was inserting.
Generally, when you're reporting problems to the list, it's not worthwhile
to report the gist. Particularly when what you're reporting is erroneous
and doesn't actually have t
Ang,
Thursday, April 04, 2002, 4:21:10 PM, you wrote:
AHK> Is MySQL capable of storing files (*.doc *.zip etc)? If YES,
AHK> - is there a limit to the size?
AHK> - what is the data type to use? BLOB?
Yes, you should use BLOB types (TINYBLOB, BLOB, MEDIUMBLOB, LONGBLOB).
You can read about
Rochester,
Thursday, April 04, 2002, 3:39:41 PM, you wrote:
Reoen> I have a table with a char(2) and when I send it '02' I want it to stay
Reoen> 02,
Reoen> but instead it stores 2
Reoen> How do I make this store as '02'?
If you have char column your data will be stored as a string.
Look:
mysq
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
At Donnerstag, 4. April 2002 15:29 Hathaway, Scott L wrote:
> I have the following query:
>
> select *, max(event_date) as high, min(event_date) as low from schedule
> where event_date between '2002-03-01' and '2003-04-30' group by
> week_ending,meeti
[EMAIL PROTECTED] wrote:
>
> Do MySQL server administrators recommend running a cron script daily
> to isamchk?
>
> Is there any other things that should be run daily to keep MySQL
> running top-notch? If so, does anyone have any pointers to a script
> that has already been developed?
I actuall
At 10:09 AM -0500 4/4/02, John Klein wrote:
>[EMAIL PROTECTED] wrote:
>>
>> Do MySQL server administrators recommend running a cron script daily
>> to isamchk?
>>
>> Is there any other things that should be run daily to keep MySQL
>> running top-notch? If so, does anyone have any pointers to a
Can someone please recommend CASE tools that function well with MySQL
databases?
Need to do some reverse engineering ... create the ERD, data dictionary,
etc
Regards,
Michelle Smith
-
Before posting, please check:
http:
MySQLfront (www.mysqlfront.de) displays all the output from show status in
the host tab when you connect.
-Original Message-
From: Alex Pilson [mailto:[EMAIL PROTECTED]]
Sent: 04 April 2002 07:15
To: John Klein
Cc: [EMAIL PROTECTED]
Subject: Re: Keeping MySQL Databases Heathly
At 10:09
Hi all,
i've got a problem, i need to transfert some data from one database to the
same database but on a différent mysql server.
I think i can't do that easily via command line, so i'll try to make a C
script to do that.
If someone have some fonctions names that can help me ...
Thanks in advan
At 10:19 AM -0500 4/4/02, Smith.Michelle wrote:
>Can someone please recommend CASE tools that function well with MySQL
>databases?
>
>Need to do some reverse engineering ... create the ERD, data dictionary,
>etc
Very cool tool...
http://www.datanamic.com/dezign/index.html
--
<--
[EMAIL PROTECTED] wrote:
> Your message cannot be posted because it appears to be either spam or
> simply off topic to our filter. To bypass the filter you must include
> one of the following words in your message:
>
> sql,query
>
> If you just reply to this message, and include the entire text o
Hi,
I have a newbie question, to which my mysql books didn't have an answer! It
is:
I have two tables with identical structures. I wish to copy the data from
table B into (append) table A. What sql statement will achieve this please?
kind regards, Graham Nichols.
Well, its tough to compare system configurations in a very general way. I've
run any number of different systems. I can tell you that Sun has some very
nice boxes. A 4 way SMP server with a couple gigs of ram and 1-2 internal 36
gig drives can be had in the 25k price range. They're perfectly ni
delete from tableB;
INSERT INTO tableB SELECT * FROM tableeA;
see manual:
6.4.3.1 INSERT ... SELECT Syntax
INSERT [LOW_PRIORITY] [IGNORE] [INTO] tbl_name [(column list)] SELECT ...
-Original Message-
From: Graham Nichols [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 04, 2002 9:44 AM
T
Yes, that should only cause a reordering within the group itself, but in my
case, the group breaks into two groups!
Scott
-Original Message-
From: Michael Zimmermann [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 04, 2002 8:58 AM
To: Hathaway, Scott L; Mysql (E-mail)
Subject: Re: help
At 09:19 AM 4/4/2002, you wrote:
>Can someone please recommend CASE tools that function well with MySQL
>databases?
>
>Need to do some reverse engineering ... create the ERD, data dictionary,
>etc
>
>Regards,
>Michelle Smith
Michelle,
CaseStudio 2 is quite good at around $500 which
David,
Thursday, April 04, 2002, 6:30:39 PM, you wrote:
DB> i've got a problem, i need to transfert some data from one database to the
DB> same database but on a différent mysql server.
DB> I think i can't do that easily via command line, so i'll try to make a C
DB> script to do that.
Look at my
Demirchyan,
Wednesday, April 03, 2002, 10:16:53 PM, you wrote:
DOA> Hello everyone, I have the following line in my create table code:
DOA> SCAN_PARAM_ID MEDIUMINT(20) NOT NULL REFERENCES
DOA> SCAN_PARAMETER(SCAN_PARAM_ID)
DOA> I need to make it so that scan_param_id references to two differe
Madscientist,
Thursday, April 04, 2002, 2:50:40 AM, you wrote:
M> I can't seem to find help for this in the docs or with the search
M> engine.
M> I am installing the new 4.x version an rather than run it over 3.23 I
M> decided to erase the old packages first and start fresh. This is a
M> RedHat
Charitha,
Thursday, April 04, 2002, 1:35:57 PM, you wrote:
C> I am having the mysql log file which is having all the queries which
C> affects the data base.
C> I have to restore those queries in the table in some remote server.
C> Is that possible.
Yes, you can update database from update logs u
Hi Graham,
You can just use "INSERT INTO ... SELECT ..." statement for it . See the
manual:
http://www.mysql.com/doc/I/N/INSERT_SELECT.html
Gurhan
-Original Message-
From: Graham Nichols [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 04, 2002 10:44 AM
To: [EMAIL PROTECTED]
Subject: New
IS it something that you can get the data with mysqldump into an sql file
and then load it into the database you want it to be transferred to? If yes
you can do it all in the command line.
Gurhan
-Original Message-
From: David BORDAS [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 04,
Yes but in fact i forgot to say that i have to change a value of a column,
Ex dump all data from table where category = 2 and
insert all this data into the other mysql with category = 4 and not 2
I think with too connection
i can select all data then insert in new server
ben delete on the old ser
Hi!
We apologize for the delay in releasing 3.23.50. InnoDB-3.23.50 has been
ready for 2 weeks now.
The problem is that Monty wants to compile on Linux the MySQL binaries with
gcc-3.0.4 and a rather new glibc version, and that combination does not seem
to produce stable binaries of MySQL. I aske
Hi.
When I try :
mysql> LOAD DATA LOCAL INFILE "pet.txt" INTO TABLE pet;
I get this error message :
The used command is not allowd with this MySQL version.
I've nevertheless downloaded the latest stable version on mysql.com.
The select version() statement gives me :
3.23.49-nt
MyS
GROUP BY is done on column value.
show us you query
-Original Message-
From: Han de Neeling [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 04, 2002 7:15 AM
To: [EMAIL PROTECTED]
Subject: group by year
I have a MySQL database containing records from several years. I want to
calculate
On Thursday 04 April 2002 09:48 am, you wrote:
> I think you'll find that the RISC systems have fewer processors and run at
> lower clockspeeds for the same total performance. 100k is a HUGE amount of
> money to drop on a system. You could get 2 full racks of high performance
> 1U systems, includi
I am trying to figure out the best way to select
the row of data for a specific id that is the most
recent entry on or before a specific date.
I realize that I could create a temp table and select
where date <= X and group by id, inserting the max
date into the table with the id, then do a
Rajeev,
please upgrade to 3.23.49a.
.37 is a very old version, and the current documents do not accurately
describe it.
Best regards,
Heikki Tuuri
Innobase Oy
---
InnoDB - transactions, row level locking, and foreign key support for MySQL
See http://www.innodb.com, download MySQL-Max from http
On Wednesday 03 April 2002 13:25, Russell E Glaue wrote:
> I am an avid PERL programmer, I also know java. I cannot completely agree
> with either of you.
> However, this debated subject is best discussed in another community.
> The focus here is what has the necessary abilities/functionality to c
Hi. I have two fields, firstname, lastname. I populate a select box with
the firstname lastname. Now when a user selects a name and hits submit, the
program will(should) select * from table where the selected name equal
firstname+lastname. I guess you have to some how put the first and last
na
Everytime I try to setup an odbc connection from a windows 2000 to a sun
unix box which is the sql server host is get the following error:
...Host '%-.64s' is nto allowed to connect to this MYSQL server.
Any ideas???
_
Join the wo
Hi Dean,
> I have a table with a char(2) and when I send it '02' I want it to stay
> 02,
> but instead it stores 2
>
> How do I make this store as '02'?
Works for me:
mysql> create table t ( a char(2) );
Query OK, 0 rows affected (0.08 sec)
mysql> insert into t values ('02');
Query OK, 1 row
Gilles,
Thursday, April 04, 2002, 7:20:35 PM, you wrote:
GM> When I try :
GM> mysql> LOAD DATA LOCAL INFILE "pet.txt" INTO TABLE pet;
GM> I get this error message :
GM> The used command is not allowd with this MySQL version.
GM> I've nevertheless downloaded the latest stable version on
Hi david,
Just create another table in your database with the structure and data of
the table. See "CREATE TABLE ... SELECT ..." syntax at :
http://www.mysql.com/doc/C/R/CREATE_TABLE.html for this task.
Then update all the category values from 2 to 4 in that table. Use
mysqldump to copy it into
On Thursday 04 April 2002 09:48 am, you wrote:
> I think you'll find that the RISC systems have fewer processors and run at
> lower clockspeeds for the same total performance. 100k is a HUGE amount of
> money to drop on a system. You could get 2 full racks of high performance
> 1U systems, includi
Hello
I think the gruop by is behaving strange. Could someone please explain
this or maybe point me to a definition of the group by. (Inspired by
http://www.mysql.org/doc/E/x/Examples.html).
CREATE TABLE shop (
article INT(4) UNSIGNED ZEROFILL DEFAULT '' NOT NULL,
dealer CHAR(20)
> I have a MySQL database containing records from several years. I want to
> calculate counts of records for each year and separate values for a couple
> of other fields. Each record contains a date-field, date. I tried putting
> the function YEAR(date) into a GROUP BY section, but this didnot wor
Hi all,
I hav a problem while dumoing my data into a mysql server provider.
I have some lost connexion during dumping.
So I have to delete by hand the lines inserted and then resrtar wuth the
other.
Do u know a tool that can make this for me.
That meens redo with lines which hadnt been treated a
* Anthony R. J. Ball
> I am trying to figure out the best way to select
> the row of data for a specific id that is the most
> recent entry on or before a specific date.
What about:
SELECT * FROM table
WHERE
id = $specific_id AND
date <= '$specific_date'
ORDER BY date DESC
LIM
SELECT * FROM mytable WHERE date_field mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 04, 2002 10:30 AM
To: [EMAIL PROTECTED]
Subject: Getting the most recent record per id before date X
I am trying to figure out the best way to select
the row of data for a specific id that is the most
rece
SELECT * FROM mytable WHERE first_name=$first && last_name=$last
-Original Message-
From: Chuck Barnett [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 04, 2002 10:28 AM
To: [EMAIL PROTECTED]
Subject: Query help
Hi. I have two fields, firstname, lastname. I populate a select box with
At 12:16 PM 4/4/2002, you wrote:
>Is it possible to access a sql statement to mysql database through
>Internet explorer ? such as :
>
> http://www.abc.com?select * from test
>
>Thanks.
>
>
>--
>
>Best regards,
>
>
>Ridwan
>Goldbase Technology
Ridwan,
Of course, with something lik
At 04:23 PM 4/3/2002, you wrote:
>hello,
>
>i have plans to create a complex SQL database.
>before that i'd like to draw a scheme of it.
>could you please advice which
>program(freeware/shareware)
>would fit for that purpose?
>any links to pages, tutorials about graphical
>databases projecting wou
Read http://www.mysql.com/doc/A/c/Access_denied.html
> Everytime I try to setup an odbc connection from a windows 2000 to a
> sun unix box which is the sql server host is get the following error:
>
> ...Host '%-.64s' is nto allowed to connect to this MYSQL server.
>
> Any ideas???
>
> __
This will not work for my example. I have a select box that was populated
from the db with firstname lastname. The option tag has the value of
firstname+lastname then. Here lies the problem, when I build the query, I
have no way of distinguishing firstname and lastname.
Chuck
- Original Me
Anthony,
Is all the information you need to retrieve in one table? If yes , I don't
think you have to do join to get the row you want..
you should be able to do it by:
SELECT columns FROM table WHERE id=yourid AND DATE => 'date' ORDER BY DATE
LIMIT 1;
Is this what you are asking? And I think it
T'would help had you provided us with your code. Regardless, create your
SELECT box such that the values are comprised of first name and last name
separated by +. The construction would appear liek:
John Smith
John Van Buren
Sam Jones
Chuck Barnett
Zsa Zsa Gabor
Frank Zappa
process.php -
Ack, sorry (to you and Gurhan)... I've done this trick, but
I was actually looking at it with more than one ID, hence
the group by... either select from a whole table for a date
or joining against another table with the desired ids...
On Thu, Apr 04, 2002 at 06:59:30PM +0200, Roger Baklund wro
At 10:28 AM 4/4/2002, you wrote:
>On Thursday 04 April 2002 09:48 am, you wrote:
> > I think you'll find that the RISC systems have fewer processors and run at
> > lower clockspeeds for the same total performance. 100k is a HUGE amount of
> > money to drop on a system. You could get 2 full racks o
At 10:43 AM 4/4/2002, you wrote:
>Hi david,
>Just create another table in your database with the structure and data of
>the table. See "CREATE TABLE ... SELECT ..." syntax at :
>http://www.mysql.com/doc/C/R/CREATE_TABLE.html for this task.
>
> Then update all the category values from 2 to 4 in t
When compiling Mysql on a Dec 3000 OSF1 V4.0 I get the following error:
sql_yacco.yy:719: Parse error before '}'
sql_yacco.yy:1462: Parse error before '}'
sql_yacco.yy:1689: Parse error before '}'
sql_yacco.yy:1723: Parse error before '}'
sql_yacco.yy:1746: Parse error before '}'
sql_yacco.yy:180
My name is Gastón Sancassano and I would like to make some questions about
MySQL because I am a novice.
My question is:
- How does PRYMARY KEY and UNIQUE works?
My problem is that I want to create a table with 3 columns (Nombre, Password
and Permiso) and I don't like to have the name repeated
If this is web based, you could store the id of the record in the VALUE
parameter of the OPTION tag
You could alternately create some kind of object(Vector, array, list
whatever your language is) that would track the id and have that be along
side of the select box, or perhaps your select box can
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
DN >In the last episode (Apr 04), JW said:
DN >Heh. plus the maintenence nightmare of managing 48 servers, 96 mirrored
DN >boot disks, 96 power supplies, etc etc..
DN >
DN >A comparable system to the Dell link you pasted is the Sun Fire v880.
DN >For
Will MYSQL run on Netware?
thanks
Ed
Edward Heiger III, CNE
Manager of I/S
Department of Medicine
Phone: 410-328-1807
Fax: 410-328-3861
http://www.medicine.umaryland.edu/is
-
Before posting, please check:
http://www.mys
[EMAIL PROTECTED] wrote:
>
> This will not work for my example. I have a select box that was populated
> from the db with firstname lastname. The option tag has the value of
> firstname+lastname then. Here lies the problem, when I build the query, I
> have no way of distinguishing firstname an
bear with me-
my host disabled network so I can only connect thru SSH telnet via
localhost. i'd like to use mySQL-FRONT to utilize mySQL.
I am using PuTTY to establish SSH, and what I did was create local port
forwarding. L3306 forwards to localhost:3306 I then run mySQL-FRONT, using
localhost
Hi there,
Lets say i do the following query:
mysql > select something from some_table;
Then i will get the results , how many rows and how much time it took to
perform the query.
My question is how can i get the time it took for perform the query.
I want that cuz i would like to put in a web pag
Maybe you really wanted ORDER BY.
Tobias K. Tobiasen wrote:
> Hello
>
> I think the gruop by is behaving strange. Could someone please explain
> this or maybe point me to a definition of the group by. (Inspired by
> http://www.mysql.org/doc/E/x/Examples.html).
>
>
> CREATE TABLE shop (
> arti
Use CHAR, not TEXT for Nombre and Password
Also, INT will NOT be set to length of 1 in permiso
-Original Message-
From: Gastón Sancassano [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 04, 2002 12:10 PM
To: [EMAIL PROTECTED]
Subject: SQl query in MySQL (1)
My name is Gastón Sancassano
HI,
I am doing a project which looks at internals of a database and I
am trying to understand MySQL source code. I have installed the source
code of version 3.23.47, the most stable version. I am working on Redhat
linux 7.0 version.
I have complied it, made some change
1 - 100 of 159 matches
Mail list logo