Quick one... is this program just for Linux?
I think not. As long as you have mysql and apache/php running it can run on
any unix os i think.
Take out the word 'unix' and you'll be right. If you can get a PHP
environment (doesn't necessarily require Apache to be the web server)
and MySQL,
i want to update every row in the mysql table that
matches a part of each row in it.
ie.
for example if a table contains the following rows :
Pid:21577
PPid: 21174
Uid:501
Gid:501
i want to change the first row to
Pid:30209
similarly for any row
plz advice me
Hi
I have a relational db with a couple of tables holding things like
comments and complaints and actions.
In the main table, I have the contact details.
What I'd like to do is to query the db with a php app and to display the
entries in the result set with a last action/comment/contact done
hi listers
i've upgraded my mysql env from 3.23.53 to 4.0.13. also, i changed os from m$ to rh
7.3. what did not change was h/ware.
since the upgrade, i often get the error message table is marked as crashed and
should be repaired. (errno 145). i then run myisamcheck --auto-repair to fix the
In the following statement replace STRING by
concat(group_concat(payment ORDER BY paymentid SEPARATOR '|'),'|')
SELECT
invoiceid,
if ( STRING IS NOT NULL,
substring(STRING, 1,
if( locate('|',STRING) 0,
locate('|',STRING)-1,
Alex82 [EMAIL PROTECTED] wrote:
so what can i do to make a column accetp only certain values...there are any
other solutions?
Check values in your application.
- Original Message -
From: Egor Egorov [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, July 14, 2003 1:58 PM
Best method to start, restart, the server is with the service command:
service mysql start
service mysql stop
service mysql restart
Of course, this assumes that you have it configured in the init.d, which
is something mysql installation normally does itself (at least with the
rpm).
These
Prem Soman [EMAIL PROTECTED] wrote:
i want to update every row in the mysql table that
matches a part of each row in it.
ie.
for example if a table contains the following rows :
Pid:21577
PPid: 21174
Uid:501
Gid:501
i want to change the first row to
Hi!
First of all, if I decide to benchmark MySQL vs. PostgreSQL with my
application, PostgreSQL will probably be faster. That does not mean that
MySQL is generally slower or that I *want* it to look slower. That
just means
1) I have no experience in tuning MySQL
2) My application was built
SELECT c.name, c.surname,
substring(
if ( max(concat(cont.date,'Conctact ',cont.date)
max(concat(compl.date,'Complaint ',compl.date),
if (max(concat(cont.date,'Conctact ',cont.date)
max(concat(act.date,' Action
I've read through the archives and spent hours on Google but I still can't
figure this out. I must extract the data from a SQL Server *.DB file.
Viewing
the raw text, I can see that there views, grants, etc. at the top of the
file,
but this is a process that could not possible be done by hand.
-Original Message-
From: Rudolf Bekker
Sent: Monday, 14 July 2003 14:13
To: MySQL MailList ([EMAIL PROTECTED])
Subject: Pulling large Microsoft SQL files into MySQL
Importance: High
The MySQL manual mentions that one could specify the column and value separators and
the end of file
Ittay,
ALTER TABLE ... AUTO_INCREMENT=...
does not work with InnoDB type tables.
http://www.innodb.com/ibman.html#InnoDB_restrictions
For an AUTO_INCREMENT column one must always define a key to the table, and
that key must contain just the auto-increment column. InnoDB does not
support
Feesch ListMaster [EMAIL PROTECTED] wrote:
I'm not sure if this is a bug report, possibly a security issue. I have
started getting Too many connections error, but not at times when I would
expect the database to be busy. The worrying thing is that the temp drive
gets completely filled (about
Hi guys,
I need some help with this. I have the following 3 tables.
+--+---+
| uid | name |
+--+---+
| 100 | sue |
| 102 | harry |
| 104 | louis |
| 107 | sam |
| 110 | james |
| 111 | mark |
| 112 | rita |
+--+---+
+--+---+
| gid | name
Database mysql running on localhost
Error
The additional Features for working with linked Tables have been
deactivated. To find out why click here.
-
Database mysql running on localhost
PMA Database ... not OK[ Documentation ]
General relation features Disabled
response from phpmyadmin
Hi,
is there an SQL command for making a primary key (auto number key) to start numbering
from beginning after deleting all the records from the table.
thanks
The sales team are down ?
I'm trying to order MySQL-PRO licences and the team not return my
emails...
i trying with [EMAIL PROTECTED] and [EMAIL PROTECTED]
gerardo is out ? this is my contact in MySQL AB :
Tnks in advance,
mysql,innodb,sales,money,help...
I am finally able to enter data and am going through the Tutorial in section 3 of the
mySQL manual. It suggests that I create a .txt file from which to load date into a
table. Where does mySQL look for data to load in the default installation? I thought
it would be in the data folder under
Use InnoDB tables and a foreign key.
Alex82 wrote:
so what can i do to make a column accetp only certain values...there are any
other solutions?
- Original Message -
From: Egor Egorov [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, July 14, 2003 1:58 PM
Subject: Re: check
Alex82
delete all records by this command:
TRUNCATE TABLE `mytable`;
- Original Message -
From: Miroslav I. [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, July 15, 2003 8:10 AM
Subject: auto number primary key - restarting
Hi,
is there an SQL command for making a primary key (auto
I'm actually working on a large Filemaker to MySQL conversion project right
now. I don't need live data at this stage, so I've got a script running
that reads in a FilePro-generated CSV file each night. It works fine,
though early on we had a problem with our old version of Filepro not
exporting
Hello,
i've got a little problem,
we're using mysql with two big tables (one has 90 Mio. Rows (60 Gb on
HD), the other contains nearly 200.000.000 (130 Gb on HD).
Now we want to delete some rows from these tables to free diskspace. It
seems that MySQL frees the harddisk-space which
was used by
George,
Try in the folder with the same name as your database, under the data
folder.
Andy
-Original Message-
From: Degan, George E, JR, MGSVC [mailto:[EMAIL PROTECTED]
Sent: 15 July 2003 13:30
To: [EMAIL PROTECTED]
Subject: Another Newbie Question
I am finally able to enter
Miroslav I. [EMAIL PROTECTED] wrote:
is there an SQL command for making a primary key (auto number key) to start
numbering from beginning after deleting all the records from the table.
For MyISAM tables you can use ALTER TABLE:
http://www.mysql.com/doc/en/ALTER_TABLE.html
--
For
Hi
The only thing I can say is that if you optimise the table often there is
less work for it to do so you table will be left locked for shorter time.
I have not looked in to this but if you use the RAID option. I don't know if
splitting the table up you could just work on one bit at a time??
Please check the history on this list. There are numerous answers to
this problem.
Cheers
/rudy
-Original Message-
From: Miroslav I. [mailto:[EMAIL PROTECTED]
Sent: dinsdag 15 juli 2003 14:10
To: [EMAIL PROTECTED]
Subject: auto number primary key - restarting
Hi,
is there an SQL
http://www.mysql.com/doc/en/Data_size.html
[EMAIL PROTECTED] wrote:
Hello,
i've got a little problem,
we're using mysql with two big tables (one has 90 Mio. Rows (60 Gb on
HD), the other contains nearly 200.000.000 (130 Gb on HD).
Now we want to delete some rows from these tables to free
Hello Miroslav,
Tuesday, July 15, 2003, 3:10:10 PM, you wrote:
Easiest way to do what you want is to make this:
1.SHOW CREATE TABLE TableName
and copy SQL
2. DROP TABLE TableName
3. CREATE TABLE - with SQL copied in 1.
MI Hi,
MI is there an SQL command for making a primary key (auto number
I do not really think that optimizing (in your case compressing, thus
cleaning up free space) is much faster with fixed record length on LARGE
tables. Why? When optimizing the table the DB rebuilds the file record
for record to a temporary file and then moves it back to the original
file (well,
Always take care what you want to achieve! And consider the
circumstances.
Yes, adding a lot of indexes makes queries faster. But makes
inserts/deletes/updates slower.
Alex's problem is NOT that his/her queries takes too long, the problem
is that optimize takes too long. Which is something
Easiest way to do what you want is to make this:
1.SHOW CREATE TABLE TableName
and copy SQL
2. DROP TABLE TableName
3. CREATE TABLE - with SQL copied in 1.
Actually, the easiest way to do this (assuming *all*
records have been deleted) is:
UPDATE table_name SET auto_increment_field = 0;
Has anyone had a table that has lived long enough to wrap the auto
incrementing number...?
i.e. the complete byte span and back to 0x32.
I'm just wondering if mySql will fill in the deleted ID's that don't exist,
or if it just halts...
--
MySQL General Mailing List
For list archives:
truncate table_name
does both in one statement. And even optimizes the table (frees up
unused disk space). However take care that you cannot rollback this DDL.
Cheers
/rudy
-Original Message-
From: Chris Boget [mailto:[EMAIL PROTECTED]
Sent: dinsdag 15 juli 2003 15:29
To:
truncate table_name
does both in one statement. And even optimizes the table (frees up
unused disk space). However take care that you cannot rollback this DDL.
Wow. Learn something new every day! :p
Thanks for the tip, Rudy!
Chris
--
MySQL General Mailing List
For list archives:
Set the autoincrement column to the max value or the given data type
(via alter table), insert a record and see what happens...
Cheers
/rudy
-Original Message-
From: TheMechE [mailto:[EMAIL PROTECTED]
Sent: dinsdag 15 juli 2003 15:40
To: [EMAIL PROTECTED]
Subject: What about auto number
Sorry. I missed this discussion previously. Now I need the answer.
Figures.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL has posted a very interesting comparison on their website. It appears
to be a reasonably fair evaluation. PostgreSQL was faster than MySQL in some
areas and MySQL was faster than PostgreSQL in most areas.
For speed with all of that functionality, I'd be more inclined to look at DB2
Sorry rudy, but I can not understand what you try to say!
I can only say that if you follow the link below and read the
explanations on that page and also follow the related links you can find
answers to Alex's problems.
[EMAIL PROTECTED] wrote:
Always take care what you want to achieve! And
If you have to create that many keys, you may want to consider changing
your data structure. You additions and updates to the database would
get pretty slow if that many indexes have to be updated.
What I usually do is change my columns to rows and add an additional
qualifier column to indicate
I set up a replication with MySQL 4.0.13, it works very fine, but
unfortunately only for several hours (between 10 and 30 hours) Has
someone an idea why the replication stopps?
Thanks,
Moritz
030714 18:02:07 Slave I/O thread: connected to master
'[EMAIL PROTECTED]:3306',
replication
Ok, sorry, I focused too much on the optimization of the table. Because
this is an isolated problem and most what is written on the page does
not apply to this issues. This is like saying When the sun shines,
there is always a shadow which is generally true but not on June,21,
12:00pm on the
Thanks for your efforts, and in rudys last mail he confirms what i have
feared, the io-overhead for reading the
extremely longer rows most probably causes these longer query-times. I
think we will have to redesign our
table-structure, because we're already working on a (hardware-)raid, so
the
on the slave, run show slave status at the mysql prompt. if there is an error, one
of the fileds will tell u what it is
-Original Message-
From: Moritz Steiner [mailto:[EMAIL PROTECTED]
Sent: 15 July 2003 16:41
To: [EMAIL PROTECTED]
Subject: replication
I set up a replication with
I am attempting to create a temporary table to do a complex query and I get an error:
error 1044: Access denied for user: '@localhost' to database 'shopsample'
what can I do to keep this from happening? I am using the production version of mySQL
4.0.13 in windows 2000.
Here is the query:
I have set up a master and slave whose versions are (using 'show =
variables') S: 3.23.47-nt, M: 3.23.47-nt-log. They were both installed =
from the same distribution zip. I can't get replication going even =
though the server and client status seem ok (slave running and file and =
position
I set a lot of variables in the my.cnf file, all variables are set (I
checked it with show variables) except of wait_timeout. If I set the
option in MySQL with option wait_status=xxx it works.
Does anybody know why this could happen?
Thanks,
Moritz
--
MySQL General Mailing List
For list
I want to turn on and off the general query log from time to time. Is
there a possibility to do this without changing the my.cnf file and
restarting the server.
I thought for example set option log=ON
Thanks,
Moritz
Hi All
I've had a quick scoot about and could see anything about cold fusion and mysql
is it possible to use this combination successfully if at all?
Thanks
Andrew
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Hi,
I am new to MySQL. I wonder if someone could tell me if I can run MySQLDump on a
database while a few users are still connected to it. If yes, is it clever enough to
backup the transaction log and use it to restore the database to the nearest state to
the before the dump?
Many thanks.
Thanks Curtis, interesting indeed... presumably MySQL is in a different location
as CF runs off NT4 or is MySQL a win version?
The reason I am asking is because a solution has been presented to me in CF and
MS SQL which I think will restrict future development and wondered whether a
conversion to
The connections will still write to one or two tables. Mainly stock prices from a
price server. Hence, not so bother if any prices arrive after the dump starts are not
captured. I would like to know if mysqldump will fail to run if the tables are not
locked? Cheers. Gilbert
-Original
Hello,
I am creating an on-line course and would like to know if it will make a
difference in the way I set up my database(s).
Option 1 : Create one large Database for the course
Here I would prefix the tables with their functions, ie. reg_ quizzes_
forum_ etc.
Option 2 : Create a
Hi:
I was wondering if there is a date function to get the older date between
two dates?. Or smething that indicates me that one date is older than the
other one.
I know that I have the function YEAR,MONTH,DAY and I can use them, but I
don't know if exists a function that can do the same.
Is it possible to lock single records for all but a certain set of users,
permanently?
The intention is to make old items permanently unchangeable by anyone but
managers.
Thanks,
Dan Ullom
TechCentric
314-991-2594
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
Miguel - You can compare dates directly using and - no need for
a special function. Dates are older when they are less than other
dates.
Cheers.
Jeff
On Tuesday, July 15, 2003, at 09:36 AM, Miguel Perez wrote:
Hi:
I was wondering if there is a date function to get the older date
between
LOAD DATA INFILE data.txt INTO TABLE table_name FIELDS TERMINATED BY
'|' ENCLOSED BY '' LINES TERMINATED BY '\n';
You can find more on this at:
http://www.mysql.com/doc/en/LOAD_DATA.html
-Original Message-
From: Rudolf Bekker [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 15, 2003 2:43
2 methods I can think of:
1) Move the records into a different table, and set permissions
accordingly (allow updates on for managers on that table)
2) Control authentication and access in your program.
-Cameron Wilhelm
On Tuesday, July 15, 2003, at 11:03 AM, Dan Ullom wrote:
Is it possible
Contents are Direct Alliance Corporation CONFIDENTIAL
-
Andrew,
I have setup all the environments you are talking about.
CF with MS SQL is much easier to setup and get going than PHP and mysql.
However I have see twice the speed and stability with my applications that
are written in PHP
Hi everyone,
Since we upgraded to MySQL 4.0.13 from 3.23, we have been getting table
corruption often. It happens about twice per week (with about 500
queries per second average). I have even set up a cron to run
mysqlcheck every hour to try to do some damage control. The biggest
problem is
I¹m developing a calendar, with a view by month and list view, for a client
and I would like to add the option for them to add an event and select if it
is to repeat, i.e. Annually, monthly, weekly. As I see it now I can do one
of two things (possibly more?). Add a predetermined amount of records
This would do it if you are just comparing two dates:
$max_date = ($date1$date2?$date1:$date2);
It's just using the one line form of an if statement. Note that the
function is incorrect if they date are equal.
On Tuesday, July 15, 2003, at 12:36 PM, Miguel Perez wrote:
I was wondering if there
Is there any command that we can use to view the protection on the tables??.
Is there any way that we can convert read only tables to read write?. Please
ehlp
thank u
kamran
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Is there any command that we can use to view the protection on the tables??.
Is there any way that we can convert read only tables to read write?. Please
ehlp
thank u
kamran
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Hi:
Or you can use a DTS to transfer the info to MySQL
Greetings
From: Ralph Guzman [EMAIL PROTECTED]
To: 'Rudolf Bekker' [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: RE: Pulling large Microsoft SQL files into MySQL
Date: Tue, 15 Jul 2003 10:32:03 -0700
LOAD DATA INFILE data.txt INTO TABLE
I'm getting ready to upgrade a server from 4.0.12 and was wondering if
anyone knew the time frame for 4.0.14, or if I should just go with .13
for now.
--
Michael Conlen
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Is there an accepted best practice on whether to store
decimal currency amounts (e.g. dollars and cents) in MySQL
decimal column types?
Certainly, the most straightforward way is to use decimal
columns. But it appears that such values are stored as
ASCII strings, which would be inefficient
I have created a BLOB field to store images. Is there any way to embed
them within HTML with something like:
image start: jpeg
/image
Thanks in advance,
Dan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Richard,
you are running a Red Hat kernel 2.4.18? Kernels 2.4.20 seem to be much more
reliable.
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Transactions, foreign keys, and a hot backup tool for MySQL
Order MySQL technical support from https://order.mysql.com/
- Original
I am currently running ColdFusion MX on my Linux Servers access both MySQL
from different Linux Servers and MS SQL from a MS2000 WS. ColdFusion and
MySQL are both available and run on both Win Linux machines. I also have
PHP installed on Linux, but have never attempted to learn fully
Michael,
- Original Message -
From: Michael Conlen [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Tuesday, July 15, 2003 10:36 PM
Subject: 4.0.13 or 4.0.14
I'm getting ready to upgrade a server from 4.0.12 and was wondering if
anyone knew the time frame for 4.0.14, or if
I have a copy of 3.23.56 running on one of my machines and it does NOT wrap
auto_increment columns when the upper limit is reached. I haven't tested it
with any newer versions, though I doubt they'd be any different. If this is
a concern for you then I would suggest using a bigger column type
Thanks for the tip. I'll see about upgrading, but it won't be a small task.
Any reason why 2.4.18 problems wouldn't have effected MySQL 3.23? I'm
trying to search for a solution that does not involve upgrading kernels on
20 machines that are in production use right now. Thanks again!
Richard
Hi!
On Jul 15, Michael Conlen wrote:
I'm getting ready to upgrade a server from 4.0.12 and was wondering if
anyone knew the time frame for 4.0.14, or if I should just go with .13
for now.
4.0.14 release it a matter of days.
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/
Hi Charla,
Generally if the tables will be related to each other then you want to keep
them in the same database. as an example, you would want to link quiz
scores to the individual students registered in your class. It is a little
easier to do table joins and such when there is only one
Richard,
- Original Message -
From: Richard Gabriel [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, July 15, 2003 10:53 PM
Subject: Re: Frequent Table Corruption - Please Help
Thanks for the tip. I'll see about upgrading, but it won't be a small
Using the C API
I'm getting this on some of my queries, however if I run the query on a different
mysql connection, it seems to run fine:
Errmsg: Malformed packet
Errno: 2027
Any Ideas?
-Ryan.
Alvaro,
- Original Message -
From: Alvaro Avello [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, July 15, 2003 1:13 AM
Subject: Re: innodb file won't shrink
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
There 's any
Walt,
- Original Message -
From: walt [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, July 14, 2003 11:56 PM
Subject: Re: innodb file won't shrink
Heikki Tuuri wrote:
On September 15th, 2003 you will be able to put every InnoDB table into
Hello all,
After changing RAM and the ethernet card of my DB server, the problem of getting
frequent:
Database error (error code 102)
Could not connect to database server (Lost connection to MySQL server during query)
Still occurs ;/
I've tried to eliminate all factors (like multiple servers,
Thank you very much for the help. I will schedule the upgrade and see if
helps. I have 2 other machines running 2.4.18 without problems, but they
also do not run the volume that the problematic machine has and they do not
have RAID. Take care.
Richard Gabriel
Director of Technology,
CoreSense
there is a windows version of mysql. However, I agree with this post as to
have it all run on Linux would be cool. There is also a Linux version of
Cold Fusion.
Curtis
On Tuesday 15 July 2003 14:15, Cory Lamle wrote:
Contents are Direct Alliance Corporation CONFIDENTIAL
-
Andrew,
I
Hi folks,
I¹m wondering what (in general) causes a join to use temporary tables and
filesorts...
More specifically, what can I tune to avoid it? I can give more info about
a specific situation if anyone¹s interested.
All the docs say is that you are likely to get a ³Using temporary² if you
sort
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Sorry HeikkiCan you give me a few steps to obtain that...?
Thanks a lot.
Alvaro Avello.
Heikki Tuuri wrote:
|Alvaro,
|
|- Original Message -
|From: Alvaro Avello [EMAIL PROTECTED]
|To: Heikki Tuuri [EMAIL PROTECTED]
|Cc: [EMAIL
Alvaro,
- Original Message -
From: Alvaro Avello [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, July 15, 2003 11:38 PM
Subject: Re: innodb file won't shrink
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Sorry HeikkiCan you give me a
Still having a problem with this. Still have one last thing that isn't working. This
is MySQL 4.0.13.
UPDATE table_tmp,table2_daily SET table_tmp.period_count = table_tmp.count -
table2.count WHERE table_tmp.id = table2.id AND MAX(table2.timestamp);
This is giving me:
ERROR : Invalid
As far as I know, MAX only returns the greatest row, so what you really
want at the end is
WHERE table_tmp.id=table2.id AND table2.timestamp=MAX(table2.timestamp)
~MJI
Roy Walker wrote:
Still having a problem with this. Still have one last thing that isn't working. This is MySQL 4.0.13.
THis is kinda offtopic.. it depends on what frontend you are using to
access mysql (php,java,perl,etc) ..
You just need to pull the binary data and output it with the correct http
headers and it will show up in a browser.. search the list for more
info. www.php4.com has an example using php..
I think there is a way to insert binary image data in your html, but is
there any particular reason you need to do that?
First you would need to encode it in some ascii equivalent (check w3c.org, I
think) ...and it would increase the size of your html page while rendering
the browser's image
I think there is a way to insert binary image data in your html, but is
there any particular reason you need to do that?
First you would need to encode it in some ascii equivalent (check
w3c.org, I think) ...and it would increase the size of your html page
while rendering the browser's image
I think there is a way to insert binary image data in your html, but is
there any particular reason you need to do that?
Yes, my client's server is running with particularly restrictive PHP
safe mode settings and has informed me that dynamic images are a /must
have/. :: bangs head against
On 15 Jul 2003 at 18:31, Dan Anderson wrote:
I think there is a way to insert binary image data in your html, but
is there any particular reason you need to do that?
Yes, my client's server is running with particularly restrictive PHP
safe mode settings and has informed me that dynamic
The file mysqlqui-win32-static-1.7.5-2.zip with file size of 37k
downloaded from http://www.mysql.com/downloads/gui-mysqlgui.html is
corrupt. Is there a mirror with a compiled windows xp compatible version
somewhere?
Pres. Cliff Murphy
Hyperactive Media Group
Static is for the laundry, Flash is
I have a catalogue built and it passes a variable to the sample page that
shows the larger pic on the page.
But I want to pass a second variable to the page as well, can that be done.
This variable is the simple line of text that talks about the product.
This page does not access the database
I have MySQL version 3.23 on Linux 8.0 . I am trying to do a full text
search IN BOOLEAN MODE and I get an error. If I remove the IN BOOLEAN
MODE option my query runs fine . Does it mean I have to upgrade to 4.0
to use this Search mode? Can somebody please confirm ?
--
MySQL General
I have 2 tables similar to
T1
---
ID | initial |
T2
--
initial | full_name |
I want output based on the T1.ID row which has a given ID=' X '
(If ID = 7 then pretend initial = initial3, as example)
The first or
At 19:28 -0400 7/15/03, Francis Van-Lare wrote:
I have MySQL version 3.23 on Linux 8.0 . I am trying to do a full text
search IN BOOLEAN MODE and I get an error. If I remove the IN BOOLEAN
MODE option my query runs fine . Does it mean I have to upgrade to 4.0
to use this Search mode? Can
Alright, I am almost there, got one problem now. There are multiple
entries for each id in table2. I need only the records with the newest
timestamp for each id. Want to do something like this, but doesn't
work:
INSERT INTO table_tmp (id,count_new,count_old,date) SELECT table1.id,
red fraggle wrote:
The file mysqlqui-win32-static-1.7.5-2.zip with file size of 37k
downloaded from http://www.mysql.com/downloads/gui-mysqlgui.html is
corrupt. Is there a mirror with a compiled windows xp compatible version
somewhere?
Pres. Cliff Murphy
Hyperactive Media Group
Static is for
When I type:
Show keys from [tablename];
I do not see foreign keys listed there and I cannot seem to find any
command that will list foreign keys. Can anyone help?
Also, I notice Innodb tables only store one file unlike MyISAM which
stores 3. Are Innodb tables any slower than MyISAM since they
1 - 100 of 102 matches
Mail list logo