Good day
\-=0=-=00-
I have looked in the manual and seem to be missing it or not understanding
correctly,
The curtime() function resturns the current server time. my problem is the
clients are not in the same
country as the server, thus the time of the system is 6 hours behind. We
want to add
In the last episode (Jul 16), Jonathan Villa said:
> I've installed MySQL on Linux more than a few times... so I got the
> process down... however, now I am trying to install on FreeBSD.
>
> This what I am doing...
> 1. tar zxvf mysql...freebsd.tar.gz -C /usr/local/mysql
> 2. cd /usr/local/mysql
>
I've installed MySQL on Linux more than a few times... so I got the
process down... however, now I am trying to install on FreeBSD.
This what I am doing...
1. tar zxvf mysql...freebsd.tar.gz -C /usr/local/mysql
2. cd /usr/local/mysql
3. ./configure (just to get the message)
I get the following...
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 s
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 th
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,
table1.count,
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 someb
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 l
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 Mailin
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 w
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
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 dyna
> 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 wal
> 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
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 cache
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..
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.
UPDAT
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 use
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
-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
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 o
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,
>
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 I
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, l
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 Inn
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
>
> The
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.
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
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
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
--
__ ___ ___ __
/ |/ /_ __
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 Ga
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 for
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, o
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 utili
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 Mes
I have created a BLOB field to store images. Is there any way to embed
them within HTML with something like:
Thanks in advance,
Dan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 fo
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
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" IN
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:http://lists.mysql.co
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:http://lists.mysql.co
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
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 i
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 tha
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 and
I have been getting the following error consistently every few days:
Warning: Too many connections in /path/to/connection.php
I altered the max_connections in my.cnf to allow for 300 connections. I
am not using persistent connections with php. I used to use them but
got this too many connecti
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 t
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:
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
be
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
To
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.
Gre
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
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 Messag
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
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.
Gil
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 PRO
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
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 ar
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 informa
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:
create
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 My
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 my
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 equa
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 start
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 indicat
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 c
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
rat
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]
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
> 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: http://
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: Krasimir_Slave
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: http://l
> 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;
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 comple
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,
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 numbe
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 diskspa
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 command
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??
"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
--
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 en
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 th
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
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 (au
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
"
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 my
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...
-
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
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 2.3
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 |
"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
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 AUTO_
-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 ma
>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
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 ',act.action,
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 wi
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 firs
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 command
"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
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,
1 - 100 of 103 matches
Mail list logo
