I download the mysql++, but I found out
that in the mysql++, there is an include
which I can't find it in the package.
Anyone has ideas of where I can find this undef_short.
I use rpm for redhat and untar src files. No such file exists.
--
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Fri, 28 Feb 2003, ben nevile wrote:
> hi, MySQL community. I am hoping to use the C API in Mac OS X using
> codewarrior, but it looks like the libraries provided in the standard
> MySQL distribution are not compatible. I've done a brief search th
hi everyone,
well this question has been asked before but was long time ago. Since i
could not locate an answer i am posting this question once again.
I want to replicate my database which exists on DB2 to my MySQL machine
across the network
I am using db2 version 7and mysql version 4.0.2
Thanks in
尊敬的mysql，您好!
赛特网页推出若干种韩国商品在线销售及批发业务，
如果你对如下商品中的任何一种感兴趣，
欢迎访问我们的网站。http://www.site-homepage.net
消除脚臭味的袜子脚臭者的福音(批发及在线销售)
生理内裤---抗菌，除味效果(批发及在线销售)
韩式饭桌--体验异国风情，韩式酒家必备(批发及在线销售)
韩国迷你型家用(商贩用)榨油机---稣子、芝麻、红花仔、杏仁、葵花仔皆可榨油。(批发及零售)
韩国邮件地址库(350万个地址)---向韩国地区宣传网站，产品的极好利器
赛特网络营
At 23:08 -0500 3/4/03, Stitchin' wrote:
I've got the following code in my php file:
/* Select all categories from designcatagories table */
$query = "SELECT designcatagories.catcode, designcatagories.catdesc,
count(*) FROM
designs,designcatagories where designs.catcode =
designcatag
尊敬的mysql，您好!
赛特网页推出若干种韩国商品在线销售及批发业务，
如果你对如下商品中的任何一种感兴趣，
欢迎访问我们的网站。http://www.site-homepage.net
消除脚臭味的袜子脚臭者的福音(批发及在线销售)
生理内裤---抗菌，除味效果(批发及在线销售)
韩式饭桌--体验异国风情，韩式酒家必备(批发及在线销售)
韩国迷你型家用(商贩用)榨油机---稣子、芝麻、红花仔、杏仁、葵花仔皆可榨油。(批发及零售)
韩国邮件地址库(350万个地址)---向韩国地区宣传网站，产品的极好利器
赛特网络营
Daniel Kasak wrote:
Hi all.
Hi spam filter. SQL. Query.
I'm trying to append data to a table ( Powertel_CCD_LineList ) if it
doesn't already exist in the table:
insert into Powertel_CCD_LineList
( AccountNo, ServiceNumber, ServiceNumberDescription )
select
Powertel_CCD_CallDetails.AccountNo,
Pow
Allow negative values in the column (but don't use them). When modifying
the values, give them their correct numeric value but make them negative.
Then update the negative values to positive.
HTH,
Tore.
- Original Message -
From: "Amittai Aviram" <[EMAIL PROTECTED]>
To: "Mysql" <[EMAIL P
OK. I solved it.
In a last ditch effort I tried the /usr/bin/mysql_fix_privilege_tables script.
That fixed it up. Replication seems to be working fine.
Cheers.
--
Schedule your world with ScheduleWorld.com
http://www.ScheduleWorld.com/
Java Web Start:
http://www.ScheduleWorld.com/sw/ScheduleWorl
Hi all.
Hi spam filter. SQL. Query.
I'm trying to append data to a table ( Powertel_CCD_LineList ) if it
doesn't already exist in the table:
insert into Powertel_CCD_LineList
( AccountNo, ServiceNumber, ServiceNumberDescription )
select
Powertel_CCD_CallDetails.AccountNo,
Powertel_CCD_CallDetails
I have a database heavy site that utilizes a master mysql server which
processes all updates and replicates to 4 slave servers that handle the
queries. Right now I have a simple perl randomized selection that
determines which of the four database slaves will receive any given
query. This wo
Placed At : MAATDLN
Hi,
I have a database with a table that has 3 columns - name, age and status
and this table has 10 rows.
This table is an Innodb table with dyname table type (incase this is
important) and so I can conduct transactions on
Tore Bostrup wrote:
I'm sure you are aware that this is a non-normalized database design, and
that those tend to make designing queries more difficult and/or inefficient.
The LIKE operator should give you what you want, but you need to be careful:
(PHP string def:)
$sSQL = "SELECT
FROM
WHERE r
I'm using 4.0.9 and I can not grant replication slave.
[EMAIL PROTECTED] root]# rpm -qf /usr/bin/mysql
MySQL-client-4.0.9-0
[EMAIL PROTECTED] root]# rpm -qf /usr/sbin/mysql
mysqld mysqld-max
[EMAIL PROTECTED] root]# rpm -qf /usr/sbin/mysqld-max
MySQL-Max-4.0.9-0
[EMAIL PROTECTED] root]# rpm -
I have a table in which the first column represents the order in which the
data in the rows will appear in an HTML table on a Web page. The column is
called "ordr" (to avoid conflict with the reserved keword "order"). This
column is a primary key, but the values are not auto-incremented, they are
> -Original Message-
> From: Stitchin' [mailto:[EMAIL PROTECTED]
> Subject: Count (*) function results needed in echo statement
>
>
> I've got the following code in my php file:
> >
>
> /* Select all categories from designcatagories table */
> $query = "SELECT
I've got the following code in my php file:
>
/* Select all categories from designcatagories table */
$query = "SELECT designcatagories.catcode, designcatagories.catdesc,
count(*) FROM
designs,designcatagories where designs.catcode =
designcatagories.catc
Thanks to Beau and Tore for insightful feedback. I will most likely
implement the lookup table logic and do things right from the start rather
than using a band-aid solution.
Rich
-Original Message-
From: Beau Hartshorne [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 04, 2003 9:56 PM
To:
I'm sure you are aware that this is a non-normalized database design, and
that those tend to make designing queries more difficult and/or inefficient.
The LIKE operator should give you what you want, but you need to be careful:
(PHP string def:)
$sSQL = "SELECT
FROM
WHERE readBy LIKE '$UserID,
Hi Rich,
I think that instead of a readBY column in your news table, you should
use what's called a lookup table. In this case, the lookup table would
store the primary key from the news table and the primary key from the
user table. Your table structure might look something like this:
user
-
At 12:08 +1100 3/5/03, Daniel Kasak wrote:
Paul DuBois wrote:
That is, you're making an assumption that cannot necessarily be made.
If you can guarantee that the web script will establish a new connection,
and the connection will terminate when the script ends, you can indeed
do what you describe
Greetings,
I've been running a public MySQL server for a couple of years that now
supports several thousand users. I used to run this on a lowly PII-350 and
it ran quite fine with CPU loads usually hanging well under 0.20. The only
hitch was the time necessary to connect seemed to jump up t
Man, this was a tough MySQL question to assign a Subject to. Hopefully the
answer
is easier.
I have a table called news which contains a column called readBy. The read
by column is of type TEXT and it contains a CSV list of IDs of users who
have read a certain news item. For example, if my user ID
Hello,
I`m doing a database in MySQL to catalog cds, and i`m not sure if my table
structure is the best way to do it:
Artist Table
Artist_Id int unsigned not null auto_increment primary key
Name char(120) // Artist or Band Name
Country char(30) // Artist Or Band Country
Members char(255) // Ba
Paul DuBois wrote:
That is, you're making an assumption that cannot necessarily be made.
If you can guarantee that the web script will establish a new connection,
and the connection will terminate when the script ends, you can indeed
do what you describe above.
But you *cannot* do that if you're r
At 15:56 -0800 3/4/03, William R. Mussatto wrote:
> At 23:19 + 3/4/03, Mamatha Balasubramanian wrote:
Thank you once again.
I have a web-interface that does search on a given text and I would
have a script that creates a temporary table. So according to you, in
my script, I just to need
cr
Paul is right. I would like to add a small remark, it should better to drop
the temp. tables before closing your script. This can free up resources. I
had a painful experience that I had created hash temp. tables without
dropping them. This lead to memory leak.
Regards,
--
Yours,
KH Chiu
C&A
> At 23:19 + 3/4/03, Mamatha Balasubramanian wrote:
>>Thank you once again.
>>
>>I have a web-interface that does search on a given text and I would
>> have a script that creates a temporary table. So according to you, in
>> my script, I just to need
>>create a temporary table and not have to
At 23:19 + 3/4/03, Mamatha Balasubramanian wrote:
Thank you once again.
I have a web-interface that does search on a given text and I would
have a script that creates a temporary table. So according to you,
in my script, I just to need
create a temporary table and not have to worry about ano
Thank you once again.
I have a web-interface that does search on a given text and I would have a
script that creates a temporary table. So according to you, in my script, I
just to need
create a temporary table and not have to worry about another client using
the same web interface (and thereby
Mamatha Balasubramanian wrote:
Hi,
I would like to know how MySQL handles multiple temporary tables?
1. Can multiple temporary tables be created at the same time?
Yes
2. If so, how does MySQL differentiate them - do we need to explicitly
give them different names inorder to identify them or doe
At 23:00 + 3/4/03, Mamatha Balasubramanian wrote:
Hi,
I would like to know how MySQL handles multiple temporary tables?
1. Can multiple temporary tables be created at the same time?
2. If so, how does MySQL differentiate them - do we need to
explicitly give them different names inorder to iden
Hi,
I would like to know how MySQL handles multiple temporary tables?
1. Can multiple temporary tables be created at the same time?
2. If so, how does MySQL differentiate them - do we need to explicitly give
them different names inorder to identify them or does MySQL provide a
timestamp (or use s
try thi
FROM lawfac_pub INNER JOIN fac_stud_lunch ON lawfac_pub.hawkid =
fac_stud_lunch_join.instructor_hawkid INNER JOIN fac_stud_lunch_join ON
fac_stud_lunch.instructor_hawkid = fac_stud_lunch_join.instructor_hawkid
-Original Message-
From: Martin Ostlund [mailto:[EMAIL PROTECTED]
Sent:
At 17:11 -0500 3/4/03, Jianping Zhu wrote:
I am writing a simple login system by using perl( this is almost my first
program in perl), After user pick a username i need to check if this
username already exsited in mysql database table. if it is already in
the table, this program will prompt user t
You need quotes around $username in your SQL query, unless you've already run
$username thorough $dbh->quote();
j- k-
On Tuesday 04 March 2003 13:11, Jianping Zhu wrote:
> I am writing a simple login system by using perl( this is almost my first
> program in perl), After user pick a user
Hello
Thanks for a great tool !
and thank you very much in advance for any help
Description:
I am a Programmer working with patient data and for privacy reasons I have
been trying to get des_encrypt() to work on MySQL 3.23.46 with
openssl-0.9.6b on a Linux server.
I followed the steps described o
I am writing a simple login system by using perl( this is almost my first
program in perl), After user pick a username i need to check if this
username already exsited in mysql database table. if it is already in
the table, this program will prompt user to pick another user name.
but something
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:root
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis: make test fails - strack trace included
>Severity:
>Priority:
>Category:
Hi Jakob,
You can not do this in MySQL. MySQL does not support hierarchical joins nor does it
support Transact-SQL. You will need to do this with a combination of SQL and your
favorite host language. Substituting Transact-SQL for Java, Perl, PHP or any other
language and you will get the same r
At 03:57 PM 3/4/2003, Martin Ostlund wrote:
I usually use phpMyAdmin
Thanks for the tip. Unfortunately it isn't my server and they haven't
finished installing phpMyAdmin on it yet. That's why I usually make odbc
connections in access and build the queries graphically. But it just keeps
cho
Hi.
This is not at all an answer to your problem,
and perhaps you're already aware of my tip:
I usually use phpMyAdmin and paste my SQL statements
in there to see what is causing the error, and when it works
you get a pretty good picture of how your "virtual" table
looks like.
Just my 2 cents.
Hi,
I have the following tables:
mysql> describe lawfac_pub;
++--+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
++--+--+-+-+---+
| hawkid | varchar(16) | | PRI | |
I attempted to optimize a table last night, which usually takes about 5
minutes but I expected to take longer as I had done a slew of deletes.
Well, it took over an hour, and from the last modified dates on the table
and temp files, it looked like they hadnt been updated in 10-15 minutes.
Eventua
Hi,
I'm trying to set up a small database server for our students to play
with and ran into problems while creating accounts and granting rights.
I used
insert into user (User, Host, Password,
Insert_priv, Update_priv, Delete_priv,
Create_priv, Drop_priv, Index_priv, Alter_priv)
valu
Hello,
I`m doing a database in MySQL to catalog cds, and i`m not sure if my table
structure is the best way to do it:
Artist Table
Artist_Id int unsigned not null auto_increment primary key
Name char(120) // Artist or Band Name
Country char(30) // Artist Or Band Country
Members char(255) // Ba
Is your database configuration the same on both environments? Usually
this error comes querying for the wrong table/column name. I have also
seen this error when, for example, customer_id = NULL, and in my script
I say WHERE customer_id = $customer_id.
---> Jonathan
-Original Messag
This warning is being generated by PHP not by MySQL. Take a look at
http://www.php.net/manual/en/faq.databases.php#faq.databases.mysqlresource
If you haven't changed anything in your code, you might be using a function
in your query that was made obsolete in the new version of MySQL. Check
your
> this is more a php question then mysql, but if you put a @ before the
> commands that are giving you warnings, it should cause it to not show them
Didn't start happening until the provider upgraded the MySQL engine, and the _show
warnings_ is a MySQL configuration, according to the MySQL docs.
I want to add transaction support to an existing database running
on mysql 3.23.49-3 distributed with Red Hat 7.3.
After browsing through the Mysql and the Innodb documentation, it appears
that
I have the following options:
1) Configure mysql 3.23.49-3 to support innodb tables. Since the
have_inn
Hello.
I have problem to solve in a school homework that I hope someone could
help me with. I have a small community, and the SQL statement below should
set all logged in users that has been inactive for more than 300 seconds
to 0 in the 'inloggad' field. Though the getdate() does not seem to wor
this is more a php question then mysql, but if you put a @ before the
commands that are giving you warnings, it should cause it to not show them
@mysql_connect(...)
and you might also be looking for the php function
error_reporting( [ int level ] )
On Tuesday 04 March 2003 13:55, you wrote:
>
Hi all,
This is quite an involved one...
Using MySQL 4.0.11 on linux
I have two logical db's on the same machine, lets say db1 and db2.
I have perl apps doing the following: "replace into db2.tablename ."
In my.cnf I have the line "binlog-do-db= db1"
The queries are being performed OK
I've devised a solution under Linux, using Heartbeat, DRBD and Perl, but we
have not put it into production yet. We also use LVS to put our database
slaves into HA clusters.
The basic idea is that you have an Active/Standby master, (the standby being a
slave) in a heartbeat cluster. You use DRBD
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
As far as suppressing errors you can suppress them in PHP by putting
an "@" symbol in front of the function call, i.e. $result =
@mysql_fetch_array($sql);
HTH & HAND,
Bryant Hester
- -Original Message-
From: databarn [mailto:[EMAIL PROTECT
Hello,
>Description:
A select returns uncomplete results, when querying an indexed
varchar row with latin1_de character set and strings containing umlauts
or 'ß'.
>How-To-Repeat:
start MySQL 4.0 with character set latin1_de.
create table test (word varchar(255) not null default '', inde
Folk,
I'm not having a lot of success with my provider, so I'll ask here. Is there any way
to turn _show warnings_ off from script? I cant seem to find anything relevant. I'm
getting a warning that, "Supplied argument is not a valid MySQL result resource . .
.". I don't see any way to test
Hi,
I was wondering if anyone knows - is the MySQLcc list down? I signed up
yesterday but never got a confirmation e-mail from them.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://li
At 12:29 -0600 3/4/03, jason wesley upton wrote:
I know that for most purposes you can treat TEXT and BLOB as VARCHAR
under a longer name, but is the same true of LONGTEXT? I have a
field
that needs to be open to a huge amount of text, but I don't want my
database's size to be huge if that maxi
Hello
I'd like to know if they have already implemented that feature of
replication that changes the master server to other serve if the master
fails.
If they have not implemented that yet, how can I do something similar using
the features that mysql have now?
Thank you for any answer.
---
Out
Hi folks,
running mysql-4.0.x since the early versions without any problems, I had
a problem 3 days ago.
I'm not sure if its mysql-4.0.x-related but maybe anyone may shed a light on it.
MySQL is running with the query-cache enabled (16 MB cache for it, 33% cache-hits).
That day mysql got pretty
>Description:
On a windows or linux system where the time is set to local time, the
function from_unixtime incorrectly applies the offset from UTC to Local to
the result. For example when set to EST, "select from_unixtime(0);"
returns "1969-12-31 19:00:00". In fact, section 6.3.4 of the MySql
I know that for most purposes you can treat TEXT and BLOB as VARCHAR under a longer
name, but is the same true of LONGTEXT? I have a field
that needs to be open to a huge amount of text, but I don't want my database's size to
be huge if that maximum allowed amount of text is not used.
Thanks.
Hi
Can anyone please explain why this first query works and returns the
expected data, while the second one only returns a subset (and quite small)
of the expected data.
This one works..
select trans_type,prod_id,sub_prod_id,sum(credits) as credits,
FROM_UNIXTIME(timestamp,'%Y-%m-%d') a
Yes that must be it. Both columns are unsigned. Is
there any way to accomplish this with one query with
unsigned columns?
Otherwise I will have to fetch each column seperately
(two queries) and then do the subtraction outside
MySQL (in my C code).
--- Victoria Reznichenko
<[EMAIL PROTECTED]> wr
On Tuesday 04 March 2003 16:51, Jamie Jennings wrote:
> Hi. I've got two mediumint columns in a mysql table,
> and I'm trying to subtract them like this:
>
> SELECT column1-column2 FROM table WHERE
> name='johndoe';
>
> This works some of the time, however, I get weird
> results for negative numbe
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Mufaddal Khumri wrote:
I am using JDBC and trying to run this query.
Select DISTINCT COURSE.ID, COURSE.NAME,
COURSE.CATEGORYID, COURSE.DESCRIPTION " +
"COURSE.GRADELEVELS, COURSE.OW
I am using JDBC and trying to run this query.
Select DISTINCT COURSE.ID, COURSE.NAME, COURSE.CATEGORYID,
COURSE.DESCRIPTION " +
"COURSE.GRADELEVELS, COURSE.OWNERID from MEETING, COURSE,
INSTRUCTOR " +
"Where INSTURCTOR.ID = 1 And COURSE.INSTRUCTORID =
INSTRUCTOR.ID A
Hi
I am installing MySQL's supper-smack on Linux.
The problem is that it will not 'make'. It errors on two files 'die.cc' and
'gen_data.cc'.
If in add '#include ' to die.cc and '#include ' to
gen_data.cc in will 'make' and 'make install'.
But then will not work. It runs with out any errors but ther
Absolutely brilliant Roger this has sorted the problem out :)
Andrew
>-Original Message-
>From: Roger Baklund [mailto:[EMAIL PROTECTED]
>Sent: 04 March 2003 15:48
>To: MySQL-Lista
>Cc: [EMAIL PROTECTED]
>Subject: Re: Query selected
>
>
>* Andrew
>> Can anyone tell me why this mysql query
* Andrew
> Can anyone tell me why this mysql query and 'selected' isn't
> working? It does keep a fixed id selected but not the one
> that was selected and aslo doesn't return any results?
Try to keep the html part of the problem separate from the mysql part of the
problem... :)
> echo "";
>
> $
Yea, I've done what it says there but had to implement the locking myself,
then just use two subsets of the dB and master slaved them to each other on
the respective parts that weren't being used.
Jerry
Systems Dev
Cable & Wireless
- Original Message
Hi. I've got two mediumint columns in a mysql table,
and I'm trying to subtract them like this:
SELECT column1-column2 FROM table WHERE
name='johndoe';
This works some of the time, however, I get weird
results for negative numbers. For example, when
column1=0 and column2=4995, I get:
18446744073
* Jerry
> I'm fairly sure it won't do master-master at the moment.
>
> I'd like to be wrong though.
>
> http://www.mysql.com/doc/en/Replication_FAQ.html
"master-master" replication is the same as "two-way" replication, and it is
mentioned in the above FAQ, halfway down the page:
"Q: What issues s
Paul,
Thanks for the answers. As a matter of fact, I did think that I was
issuing multiple queries at the same time. Thanks for the
clarification.
---> Jonathan
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Monday, March 03, 2003 9:29 PM
To: [EMAIL PROT
* Gaston Escobar
> I need to sincronice two mysql databases that are in different
> places. It is imposible to centralice everything in one database.
> Then I would need to sincronice the changes made in both of them
> one time per day. Is there any way to do this?
This very much depends on your a
Now, it's working fine !
Thanks a lot
Nivaldo
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, March 04, 2003 12:12 AM
Subject: Re: Error 2013 - Lost connection to MySQL server during query
>
> Suporte schrieb:
> >
I'm fairly sure it won't do master-master at the moment.
I'd like to be wrong though.
http://www.mysql.com/doc/en/Replication_FAQ.html
Jerry
Systems Dev
Cable & Wireless
- Original Message -
From: "Gaston Escobar" <[EMAIL PROTECTED]>
To: <[EMAIL
> I need to sincronice two mysql databases that are in different places. It
is
> imposible to centralice everything in one database. Then I would need to
> sincronice the changes made in both of them one time per day.
> Is there any way to do this?
See the section on replication in the manual at
It must be in a master master way.
-Mensaje original-
De: Jerry [mailto:[EMAIL PROTECTED]
Enviado el: Martes, 04 de Marzo de 2003 10:50 a.m.
Para: Gaston Escobar
Asunto: Re: Data sincronization
Synchronise in a master master way or just to replicate the data for safety
?
---
Have you turned log-bin on the master server? The master will not generate
the log files that the slave reads unless this is turned on.
|-+>
| | Floyd Wellershaus|
| | <[EMAIL PROTECTED]|
| | .com>
I need to sincronice two mysql databases that are in different places. It is
imposible to centralice everything in one database. Then I would need to
sincronice the changes made in both of them one time per day.
Is there any way to do this?
* Ahmed S K Anis
> What is the maximum column width allowed in MySQL.
>
> 255 or 256?
No.
http://www.mysql.com/doc/en/Column_types.html >
http://www.mysql.com/doc/en/String_types.html >
The theoretic maximum column width is 16M on 3.23.x, 2G on 4.x, restricted
by max_allowed_packet, see:
http:/
Can anyone tell me why this mysql query and 'selected' isn't working? It does
keep a fixed id selected but not the one that was selected and aslo doesn't
return any results?
echo "";
$result=mysql_query("SELECT City, CityID FROM city ORDER BY City");
while ($row = mysql_fetch_array($result))
What is the maximum column width allowed in MySQL.
255 or 256?
Anis
>>> Floyd Wellershaus <[EMAIL PROTECTED]> Tuesday, March 04, 2003
6:24:50 PM >>>
Hello,
I am trying to start replication between 2 linux servers mysql version
is
4.0.8.
I am following all instructions, but I keep getting the fo
Hi,
as MySQL doesn't seems to support a direct access to the fulltext index
tables I wonder how or if it's possible to mix a
"soundex-fulltext-mixed-mode" selection.
So my actual selection is like:
"select data,match(data) against ('$query' in boolean mode) as score from
TABLE where match(data)
Hello,
I am trying to start replication between 2 linux servers mysql version is
4.0.8.
I am following all instructions, but I keep getting the following error
message on the slave when I restart.
030303 10:35:28 mysqld started
030303 10:35:29 InnoDB: Started
/usr/mysql/libexec/mysqld: ready for
I am implementing a inheritence in sql database.
I have got a table called Entity with attributes Name,Password and a =
Advertiser table.
Basically, in my java program the Entity is the base class of the =
Advertiser class. ( I like using inheritence a lot ).
Both tables have an autonumber as ke
* John Berman
> I have a single table with 123 columns and currently it holds 49,000
> records
[...]
> 17.72 Secs
>
> I believe I need to insert a soundex field and pre populate it and then
> create an index on the soundex field - If my approach is correct help on
> how to do this would be apprecia
Hi,
I define innodb_buffer_pool_size at 4Go (i have a SUN V880 8Go RAM with
Solaris 8) and i receive a innodb error : cannot allocate memory > 2Go).
What's wrong ? I use mysql_max for solaris 8.
Best regards.
-
Before posting, p
I'm new to mySQL and would like to know how do a SELECT where I get all child records
whose root parent=1
Here's my table (project_group_list):
group_idparent_group_id
1 0
2 0
3 1
4 3
5
Have a relative location that is manageable and store the location and name
of the file in the dB then get the application logic to use it from there.
I've done something similar and have gone well over a 250K objects so I
wouldn't worry about scaling, and that's blobbing not linking.
Load data i
Hi,
I'm quite new to MySql and databases in general (as will
probably be obvious shortly).
I am working on a very large commercial site right now that will
have to database approx. 500 plus pictures, txt files and other various
things (such as client info).
Throughout a f
hi guys i am still haveing the same problem has anyone experienced this
before ?
030305 08:33:36 mysqld started
030305 8:33:37 InnoDB: Started
/usr/local/etc/mysqlslave/libexec/mysqld: ready for connections.
Version: '4.0.11a-gamma' socket: '/usr/local/etc/mysqlslave/tmp/mysql.sock'
port: 3307
On Saturday 01 March 2003 17:30, miniwar at netvigator dot com wrote:
> >Description:
>
> Dear sir,
>When I execute the command "select * from user_info where regdate <
> now()- interval 9 day and phone_confirmed is null and email is null and
> last_online "update user_info set email="1" where
On Tuesday 04 March 2003 09:50, Donna Robinson wrote:
> How can I avoid "Using temporary, "Using filesort"
> when creating indices when my selects MUST be ordered?
Please, check chapter "5 MySQL Optimisation" of the manual. You can find cases
when MySQL uses indexes and when it doesn't use them:
Hi
I have a single table with 123 columns and currently it holds 49,000
records
My ISP is running MySql v: 3.23.38
I use MySql Front to access the table
And I currently have a freetext index on the surname column.
Running a query like
SELECT SURNAME, GIVENNAMES, ageatdeath, gender, dode, moun
>Description:
MySQL doesn't allow me to use a sub-select in an update if
the subselect happens to be from the same table.
>How-To-Repeat:
mysql> use test;
mysql> create table T(lfd int, foo int);
mysql> insert into T (lfd, foo) values ( ( select max( lfd ) +
98 matches
Mail list logo
