Shakeel,
this may be a known problem. Another user running on
Solaris reported low CPU and disk i/o in connection
with queries taking a long time. The InnoDB Monitor
output he sent suggests Solaris has problems
scheduling a large number of threads.
I assume the problem is thread thrashing. I hav
I have a query as follows:
SELECT log.entity, log.action,
LEFT(users.username,10) AS username,
LEFT(boards.title,15) AS Board,
LEFT(topics.subject,22) as Subject,
log.postid, log.extraid,
LEFT(from_unixtime(log.logtime),19) AS time, log.ip
FROM log LEFT JOIN users ON log.userid = users.
How about this:
Create a table with two columns. The first is autoincrement, so guarenteed
unique. The second is random (but not neccesarily unique).
Now sort this table by the second column.
The first column, read in order, should now suit your needs, but I don't
think you can do inserts auto
How do I avoid search problems when a user leaves a search box empty on an
Ultradev search page running jserv and attached to a MySQL database?
I have three search boxes: Author, Title, and Keyword
The user enters the search data into one, two, or all three of the fields,
and presses "SUBMIT"
(I
Yes, I think HTML, mySQL and PHP is a marriage made in heaven but...
Online docs is like reading stereo instructions in a foreign language
most of the time. I tried the webmonkey.com tutorial and it was ok..
Funny thing is that the script they used, I couldn't get to work... Go
figure... Just m
I think the worst part about the books is that with things like PHP,
Apache and MySQL, by the time you find (i.e. from browsing at the local
library) and sit down to learn, it's talking about MySQL 3.22, Apache
1.2, and PHP3.
Nothing beats the online documentation.. amen to that. :)
You might
Funny... I find the PHP, HTML and MySQL combo to be a marriage made in
heaven. Also, I have not yet seen a book (and I've bought a few of them)
that beats the PHP and MySQL documentation available <> on the
web. Follow the URLs in the other e-mails and you will find the truth...
OK, maybe I exag
Any books that you buy will probably be derived from:
http://www.mysql.com/documentation/mysql/bychapter/
http://www.php.net/manual/en/
Regards,
Gary "SuperID" Huntress
===
FreeSQL.org offering free database hosting to developers
Visit http://
On 26-Oct-01, Jeff Wiegley, Ph.D. said something totally profound about Build problems
on Solaris 7 and 8. that made me ponder...
JWP> The only useful question in this message is:
JWP>
JWP> How do I pass "-Wl,-R/usr/local/lib" to everything while
JWP> configuring and compiling MySQL?
CXXFLAGS?
> I am a newbie at this and I cannot find the damn answer to it! I want
> to display the table in an html format with PHP but I cannot get it to
> work! With MS SQL Server it was sooo easy! With PHP and mySQL it's a
> pain in the butt! I cannot find any documentation on this and I order 3
> bo
I am a newbie at this and I cannot find the damn answer to it! I want
to display the table in an html format with PHP but I cannot get it to
work! With MS SQL Server it was sooo easy! With PHP and mySQL it's a
pain in the butt! I cannot find any documentation on this and I order 3
books on thi
The only useful question in this message is:
How do I pass "-Wl,-R/usr/local/lib" to everything while
configuring and compiling MySQL?
Please don't tell me about adding LD_LIBRARY_PATH to
my profile. That's just plain dumb when you should be
able to pass "-R" to the linker.
Everything else belo
Is there a query I can run to change the next autoindex to the next highest
integer in the column.
I mean I have my userIDs, and they are autoincrementing. But if I have say
9 users delete 5 of users, and then want to compact the table so that the
ids are all sequential. How can I make it so t
At 15:54 -0600 10/26/01, Brendin wrote:
>Yours is the first and the winner! :) Thanks using is null worked in
>the query... Do you know why = doesn't work?
NULL basically means "unknown value", so saying WHERE x = NULL cannot
work, even if x is NULL. That means "where one unknown value = anothe
Yours is the first and the winner! :) Thanks using is null worked in
the query... Do you know why = doesn't work?
-Original Message-
From: Ravi Raman [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 26, 2001 4:00 PM
To: Mysql; Brendin
Subject: RE: Problem with query
hi.
first of many
hi.
first of many replies, i'm sure:
mysql> select count(compid) from dbLastFaxed where lastFaxedDateTime IS null
;
when you're looking for NULL fields, select where something IS NULL, instead
of '='
-Original Message-
From: Brendin [mailto:[EMAIL PROTECTED]]
Sent: October 26, 2001 5:46
I am having a strange problem with a query... I have a table that
contains 3 columns and 3,315,599 rows. One of the columns is a date
time field. Out of 3,315,599 rows 1,555,157 contain an entry in the
date time field and the other 1,760,442 rows contain null in the date
time field Here is t
looks to me as though the #Password var isn't be used properly?
Jim
- Original Message -
From: "Rachid AIT-MANSOUR" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, October 26, 2001 2:02 PM
Subject: [MySQL - PhpLib]
> I've followed the installation explanations described in the
I've followed the installation explanations described in the documentation
of phplib.
I tried to load index.php3 and the following error message has appeared:
Warning: Access denied for user: 'kris@localhost' (Using password: YES) in
/var/www/php/db_mysql.inc on line 73
Database error: pconnec
On Friday 26 October 2001 11:12, [EMAIL PROTECTED] wrote:
> Hello,
>
> I am experiencing seg faults in seemingly innocent code with MySQL version
4.0.0
> and the embedded library, libmysqld.
> The fault only happens when calling particular functions, specifically
> mysql_ping() and mysql_query()
Install ncurses and ncurses-devel from the rpms on your RedHat CD.
Stan wrote:
> From: stan
> To: [EMAIL PROTECTED]
> Subject: INSTALL BUG (LINUX on i586 with apache and php)
>
>
>> Description:
>
>
> Configure errors and exits after trying to find ncurses lib (also curses
> and termcap are
You just missed the right spot in the manual... try here:
http://www.mysql.com/doc/F/u/Fulltext_Fine-tuning.html
Chris
I didn't make myself really clear in my question. I would like to include
words that are 3 characters in a FULLTEXT index. Th
Hi!
On Oct 26, Oscar Nelson wrote:
> At 09:40 PM 10/26/2001 +0200, Sergei Golubchik wrote:
> >Hi!
> >
> >On Oct 26, Oscar Nelson wrote:
> > > Full text searches in MySQL are limited to 4 characters or more. Is there
> > > any simple
> > > work around to lower this limit to three characters or mor
From: stan
To: [EMAIL PROTECTED]
Subject: INSTALL BUG (LINUX on i586 with apache and php)
>Description:
Configure errors and exits after trying to find ncurses lib (also curses
and termcap aren't in my system). It's a LINUX on a Pentium. Is the
configure not correctly detecting my LINUX O/S?
At 09:40 PM 10/26/2001 +0200, Sergei Golubchik wrote:
>Hi!
>
>On Oct 26, Oscar Nelson wrote:
> > Full text searches in MySQL are limited to 4 characters or more. Is there
> > any simple
> > work around to lower this limit to three characters or more? If there is
> > not, does anyone have any point
> -Original Message-
> From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]]
> Sent: 26 October 2001 13:46
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: Re: Memory allocators / STL
>
>
> [EMAIL PROTECTED] writes:
> > Do you know if this is the case even with the GCC v3.0.1?
>
> what i want is:
>
> UPDATE users SET userinfo_set=1 where (users.userid=userinfo.userid);
>
> aka, i want to set a flag in every row in users if there is a row
> in userinfo with the same userid.
>
> i've been SELECT INTO OUTFILEing (with a join on the two tables)
> and LOAD DATA INFILEi
Hi!
On Oct 26, Oscar Nelson wrote:
> Full text searches in MySQL are limited to 4 characters or more. Is there
> any simple
> work around to lower this limit to three characters or more? If there is
> not, does anyone have any pointers as to where I should start poking around
> in the code?
Yes
Hi!
On Oct 26, [EMAIL PROTECTED] wrote:
> Hello,
>
> I am experiencing seg faults in seemingly innocent code with MySQL version 4.0.0
> and the embedded library, libmysqld.
> The fault only happens when calling particular functions, specifically
> mysql_ping() and mysql_query(). There might be
Greetings all:
I _finally_ got DBI and Msql_Mysql-modules to compile and work under SCO
OpenServer. I thought I would post my results and findings to the list
for future people attempting this daring feet. Thanks to Zdenek Jager
for his tip on using Skunware Perl, 5.005 (see e-mail below).
Here
you could dump the data in an .sql file (mysqldump)
edit the .sql file to make the necessary changes
import the .sql file
- Original Message -
From: "McGrotty, Charles" <[EMAIL PROTECTED]>
To: "'Tore Van Grembergen'" <[EMAIL PROTECTED]>
Sent: Friday, October 26, 2001 8:38 PM
Subject: RE
i feel like i must be missing something simple because i keep wanting to do things
like this, but i can't find a one step way to do
it.
whether or not there is an easy way, can someone tell me the best way to do it?
i want to update a field in one table based on data in another table.
example:
Full text searches in MySQL are limited to 4 characters or more. Is there
any simple
work around to lower this limit to three characters or more? If there is
not, does anyone have any pointers as to where I should start poking around
in the code?
Thanks,
Oscar Nelson
--
To me it seems that at this point the utility 'conf_to_src'
isn't build yet, and therefore ctype_extra_sources.c could not
be created!
ctype_extra_sources.c doesn't exist or is empty.
> -Ursprungliche Nachricht-
> Von: Thomas Spahni [mailto:[EMAIL PROTECTED]]
> Gesendet: Freitag, 26. Ok
Kyle Hayes wrote:
> On Friday 26 October 2001 10:00, Dana Holt wrote:
> > Can I automatically generate a random, unique, integer value in a certain
> > range when inserting data into a column using SQL?
> >
> > If so, how?
>
> Random is easy. Just find a good RNG (random number generator) somewh
You need a mysql client to connect to a mysql server.
First you telnet to your provider, and from the command prompt connect ala:
mysql -uusername -p database_name
or
If your provider is setup to allow mysql connections from outside their
servers (not as likely) then you can install a mysql clie
Bill Adams wrote:
> Demirchyan Oganes-AOD098 wrote:
>
> > Hello everyone,
> >
> > I wanted to ask you 2 questions.
> >
> > 1. I have a table that has 2 columns, user_id,
> user_name.
> > User_id has been setup to a default value 1000
> and to AUTO_INCREMENT.
> >
> > When I insert a record, Inser
I am using Windows 2000 and MS decided to toss the GUI environment for
it. Plus, I tried connecting like this:
Connect host :<3306>
How can I connect to my remote database that is on my hosting provider?
Thank you,
Todd Williamsen, MCSE
home: 847.265.4692
Cell: 847.867.9427
-
The only table type at this moment that supports foreign keys is innodb.
it is distributed with mysql 4.0.
However you need to take the source files or the tar file to instal, the
rpm's have an older version of innodb.
On creation of the table you have to define your constraints (cf manual at
www
With respect to mysql support for the use of "tcp wrappers" I wish to
report a bug in the documentation and two suggestions for improvement
to the source code. All comments pertain to version 3.23.43.
First, the following information in section 2.6.3 (Solaris Notes) of
the MySQL manual is totally
On Friday 26 October 2001 10:00, Dana Holt wrote:
> Can I automatically generate a random, unique, integer value in a certain
> range when inserting data into a column using SQL?
>
> If so, how?
Random is easy. Just find a good RNG (random number generator) somewhere
(there are many available o
Demirchyan Oganes-AOD098 wrote:
> Hello everyone,
>
> I wanted to ask you 2 questions.
>
> 1. I have a table that has 2 columns, user_id, user_name.
> User_id has been setup to a default value 1000 and to AUTO_INCREMENT.
>
> When I insert a record, Insert Into User_Table (user_id,user_name) Value
Dana Holt writes:
> Can I automatically generate a random, unique, integer value
> in a certain range when inserting data into a column using SQL?
"Random"? Like how "random"?
* Math.random() random? And still unique? That's really tough..
* Or just "you don't care, but not sequential" "rando
Hello,
I am experiencing seg faults in seemingly innocent code with MySQL version 4.0.0
and the embedded library, libmysqld.
The fault only happens when calling particular functions, specifically
mysql_ping() and mysql_query(). There might be others, but these are the only
ones I've found so far
Can I automatically generate a random, unique, integer value in a certain
range when inserting data into a column using SQL?
If so, how?
Thanks..
Dana
-
Before posting, please check:
http://www.mysql.com/manual.php (the
> Hi, Roland
>
> Try my JDBC Driver.
>
>http://www.t3-jpn.com/jdbc/jdbcmysql.html
>http://www.t3-jpn.com/jdbc/download/gweMysqlJDBC_extra3.zip
>
> Thanks.
Hello, thanks for the quick answer.
Your page has a link to:
http://www.gwe.co.uk/
which is not working. Is there some information
Hello everyone,
I wanted to ask you 2 questions.
1. I have a table that has 2 columns, user_id, user_name.
User_id has been setup to a default value 1000 and to AUTO_INCREMENT.
When I insert a record, Insert Into User_Table (user_id,user_name) Values (Null,'Jon
Doe');
I get 1 John Doe. But
On Friday 26 October 2001 21:40 pm, Gerd Ruschhaupt wrote:
> Hallo!
> I would like to know, if Mysql works with Chinese or Japanese or
> Arabic languages.
> Thats all!
> Thank you for your Answers.
It seems to work OK with Big5 Chinese, I suspect it will work OK with
GB Chinese as well.
hth
--
Hi,
Thanks for the ones reply this email.
The "SHOW PROCESSLIST" had a state "Repair by sorting" while creating the
index. I assume the
set-variable= myisam_max_sort_file_size=2500M
set-variable= myisam_max_extra_sort_file_size=2500M
is large enough to cache the index.
My question is wh
Use the latest verson of InnoDB, it supports foreign key constraints.
See the documentation for more info on how to declare foreign keys.
Steve Meyers
On Fri, 2001-10-26 at 06:13, McGrotty, Charles wrote:
> Hello,
>
> I have tables in a user administration database and need to link different
Hi, Roland
Try my JDBC Driver.
http://www.t3-jpn.com/jdbc/jdbcmysql.html
http://www.t3-jpn.com/jdbc/download/gweMysqlJDBC_extra3.zip
Thanks.
Roland wrote:
>
> Hello,
> I'm losing precision when I send a double to a mysql database from a Java
> program trough JDBC.
> Code:
> stmt
Basically for each vote you insert a new record, and then to determine the
tally, you have to do a count(*) on the number of records for each vote.
so have ID | NAME | TIMESTAMP columns.
You log each vote by doing an insert (insert into whatever (name, timestamp)
values ('answer', 'timestamp')
> How can i insert image in a database.
<>
(The MySQL Manual, section 7.1.1)
Cheers,
--
,
M A R I O data miner, LIACC, room 221 tel 351+226078830, ext 121
A M A D O Rua Campo Alegre, 823 fax 351+226003654
A L V E S P-4150 PORTO, Portugalmob 351+939354002
---
>>>
Like doesn't distinguish between words, it just matches patterns.
Your first query didn't match because "work" does not match "Why this does
not work" and you didn't use wildcards.
Your second query worked because you used a wildcard so "Why this does not
work" matches /ANYTHING/ + '
Hi, All
I Fixed two bugs.
1. If LoginUser has empty password, Driver can not connect to MySQL.
2. Connection Pool does not work correctly. ;-)
Check this URL out for new Driver. :-)
http://www.t3-jpn.com/jdbc/jdbcmysql.html
"TAKAHASHI, Tomohiro" wrote:
>
> I updated JDBC Driver
Hello,
I'm losing precision when I send a double to a mysql database from a Java
program trough JDBC.
Code:
stmt.setDouble(i+3,((Double)value).doubleValue());
I use a prepared statement.
Now, if I print out the double in java before sending it to the MySql
database this is what it looks
Hello all,
We are doing a lot of data warehousing type work. The catch is we
need to get data back out in seconds rather than minutes. To accomplish this
we generate summary tables in real time. The problem we run into is that
generating the summary tables becomes very costly and our sele
Hello,
sorry that I'm bothering you, but I havent fount answer to question:
Does MySQL take any advantage from SUN SPARC/Solaris 8 64bit
architecture. I think there may be little adavatage when I compile mysql
with 64bit Forthe compiler than 32bit gcc, because Forthe uses then
64bit librarys. But
Hi
> -Original Message-
> From: Matt Sellers [mailto:[EMAIL PROTECTED]]
> Sent: Friday, October 26, 2001 7:37 AM
> To: [EMAIL PROTECTED]
> Subject: MS Access Front end with MySQL Back-end
>
>
> Hi there,
>
> I am new to MySQL, but not to databases. I have several MS Access
> databas
What could be a possible cause for DB connections that do not close? I have
a Apache-PHP-mysql setup and the apache/php thread appears to exit, but
"show processlist" report connections that stay open and "sleep"
Is there a way to determine what was run on that connection that may have
caused it
Hi!
On Oct 26, Kyle Hayes wrote:
> On Friday 26 October 2001 07:18, Wai Lee wrote:
>
> > I dig through the manual and changed any possible settings
> >
> > set-variable= max_heap_table_size=2000M
> > set-variable= key_buffer=2500M
> > set-variable= max_allowed_packet=1M
> > set-varia
When I start mysql 3.23.38 on our Solaris 2.8 machine, with or without
the /etc/my.cnf file read (i.e., I can move it out of the way or not), I
get the following messages:
/etc/rc2.d/S99mysql: @HOSTNAME@: not found
S99mysql is the script that starts up MySQL when I reboot the machine (I
believe
I just installed mysql-3.23.43-apple-darwin1.3.1 on my OS X (10.1) machine.
When I use the "mysqladmin shutdown" command, the command seems to hang.
Running top in a separate terminal window shows both the server and the
mysqladmin process as still running.
Is this a known problem?
=
Hi:
Can anyone twll me how to view warnings in mysql ?
Craig
--
Dr Craig Donlon
European Commission Joint Research Centre, Institute for Environment and
Sustainability,
Inland and Marine Water Unit, TP272, I-21020 Ispra (VA), ITALY.
Tel: +39 0332 786353 Fax:+39 0332 789034 e-mail:[EMAIL PROTE
I am working my way through Paul DuBois' excellent book "MySQL and Perl for
the Web." One of the examples shows how to conduct a poll- vote for your
favorite groundhog: http://www.kitebird.com/cgi-perl/groundhog.pl
Paul then suggests modifying the poll "...to log EACH vote and when it
occurred s
Hi,
Your record_buffer and sort_buffer seem far too high.
Don't forget MySQL could eat up ((sort_buffer + record_buffer) *
max_connections + key_buffer) Mo of memory.
Even with a max_connections set to 1, MySQL could eat in your case up to 7
Go of memory =)
- Original Message -
From: "
I know about the firewall. But i when i disable the firewall i still have
the same problem.
> XP has a built in firewall you might have to allow access to port 3306
>
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: 26 October 2001 13:49
> To: [EMAIL
On Friday 26 October 2001 07:18, Wai Lee wrote:
> I dig through the manual and changed any possible settings
>
> set-variable= max_heap_table_size=2000M
> set-variable= key_buffer=2500M
> set-variable= max_allowed_packet=1M
> set-variable= table_cache=512
> set-variable= sort_
Hi i have a problem with searching TEXT columns for appearance of particilur
words.
Here is the example of what I'm traying to do:
mysql> SELECT "Why this does not work" LIKE "work";
+---+
| "Why this does not work" LIKE "work"
Hello everyone,
I too, am in a simular position, though not a business venture.
I have some private databases that I would like to port to MySQL
from MS Access 2000. If you know of any tools that will export all
the tables and queries to a MySQL equivlent, and convert the forms
to html, php or
Hi!
On Oct 26, Wai Lee wrote:
> Hi all,
>
> Can someone tell me how to speed up the index creation???
>
> I am trying to build an index for a 13,875,354 records(13 million) table
> with 176,322 distinct vendor_id(VARCHAR(40)) in the table.
>
> the existing size of the transaction table:
> tran
Hi there,
I am new to MySQL, but not to databases. I have several MS Access
databases (97 and 2000) that I would like to integrate, storing their data
in a MySQL database. I want to keep the Access 97 and 2000 front ends,
because my users are comfortable with them.
I had "autonumber" fields in
Dear developer,
For some years now, we developed a database application in MicroSoft's
Access '97.
With our user base growing, we're encountering more and more limitations in
the Microsoft development environment, especially in the stability and
number of simultaneous sessions of the database.
How can i insert image in a database.
- Moreno Riccardi
-
Before posting, please check:
http://www.mysql.com/manual.php (the manua
Hi i have got borland 5.5 commandline compiler and i have just downloaded
c++ api for mysql.What must i do with the include files to get it to work
Francois
**
Any review, retransmission, dissemination or other use of, or tak
Forgot to change the "To" address to the list...
FCW
-Original Message-
From: Woolsey, Fred
Sent: Friday, October 26, 2001 10:12 AM
To: 'Barbara Ferrell'
Subject: RE: how to run sql script in NT
Barbara,
You can "redirect" the script to mysql as input on the command line, like
this:
Hi all,
Can someone tell me how to speed up the index creation???
I am trying to build an index for a 13,875,354 records(13 million) table
with 176,322 distinct vendor_id(VARCHAR(40)) in the table.
the existing size of the transaction table:
transaction.MYD = 2,128,954,624 bytes
transaction.MYI
I'm confused.
You say you are at a dos prompt, but you show a mysql prompt.
At the dos prompt do:
mysql < temp.sql
At the mysql prompt:
source temp.sql
Barbara Ferrell wrote:
> i am extremely new at this:
>
> i am on NT4.0
>
> i am in a DOS screen at the mysql prompt (mysql>)
> the path
You don't need to be at the mysql> prompt to run it, just run this from the
DOS prompt:
mysql
To: <[EMAIL PROTECTED]>
Cc: "barbara" <[EMAIL PROTECTED]>
Sent: Friday, October 26, 2001 2:15 PM
Subject: how to run sql script in NT
> i am extremely new at this:
>
> i am on NT4.0
>
> i am in a DOS
Hi,
Try typing:
mysql < Temp.sql
while at the DOS prompt.
Andrew
-Original Message-
From: Barbara Ferrell [mailto:[EMAIL PROTECTED]]
Sent: 26 October 2001 2:15 pm
To: [EMAIL PROTECTED]
Cc: barbara
Subject: how to run sql script in NT
i am extremely new at this:
i am on NT4.0
i
i am extremely new at this:
i am on NT4.0
i am in a DOS screen at the mysql prompt (mysql>)
the path that is described in the top of the window is: =3D
c:\apache\mysql\bin\mysql.exe
i wrote a script to create and load a database exactly as it said in the =
=3D
book.. i saved the file as ..Te
Im not very happy about this :(
Someone is trying to unsubscribe me from the MySQL mailing list!
I havent confirmed the request as I dont want to unsubscribe.
Who is '[EMAIL PROTECTED]' ???
Andrew Murphy
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 25 Oc
latin1_de results in the same problem!
> -Ursprungliche Nachricht-
> Von: Thomas Spahni [mailto:[EMAIL PROTECTED]]
> Gesendet: Freitag, 26. Oktober 2001 11:32
> An: Stephan Skusa
> Cc: [MYSQL]
> Betreff: Re: Problem compiling MySQL-4.0.0-alpha with charset german1
>
>
> On Fri, 26 Oct
Hallo!
I would like to know, if Mysql works with Chinese or Japanese or Arabic
languages.
Thats all!
Thank you for your Answers.
Sincerely
Gerd Ruschhaupt
Datahaus Publishing GmbH
-
Before posting, please check:
http://www.m
Thanks! works a treat!
n
At 09:09 26/10/2001 -0400, Kalok Lo wrote:
>there's a concat(string1, string2) function
>and also a concat_ws(',', string1, string2) newstring
>--concat with separator comma alias "newstring"
>
>http://www.mysql.com/doc/S/t/String_functions.html
>Refer to the above pag
there's a concat(string1, string2) function
and also a concat_ws(',', string1, string2) newstring
--concat with separator comma alias "newstring"
http://www.mysql.com/doc/S/t/String_functions.html
Refer to the above page for more useful string functions
- Original Message -
From: "soni
I realized I made my previous post look like it was a reply and not the
original question, so here I go again...=o)
Original message below
=
Hello,
I have tables in a user administration database and need to
Hi, I'm new here may as well jump right in with a question
Anyone know the equivalent of
's' + convert(varchar,id) as dkey
The result I get in MSSQL 7 is s1, s2, s3 etc
have tried 's'+id as dkey but just get 1,2,3 etc
need to concatenate the two values 's'&id inside a query to populate a
Elm,
>Hello again!
>
>I'm currently inserting all my records into the table and suddenly after
>1909152 records I get the error on an INSERT query :
>
>The table is full
>
>each record is 36 bytes * 1909152 records is 68729472bytes = 68.7mb
>
>I'm using innodb tables and innodb_data_file_path is
Hello,
I tried to get MySql running on an Windows XP OS. But when i try to connect
to the database i get a message like:
This machine is refusing (or blocking) the request of mysql ???
Anybody an idea ?
Thanks,
Nyko
-
Befo
Hello again!
I'm currently inserting all my records into the table and suddenly after
1909152 records I get the error on an INSERT query :
The table is full
each record is 36 bytes * 1909152 records is 68729472bytes = 68.7mb
I'm using innodb tables and innodb_data_file_path is set to
innodb_d
The MySQLFront solution worked like a charm. Thanks, and thanks to all who
replied to my queries on this one.
Brent
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Hello,
I have tables in a user administration database and need to link different
tables with FK's.
How do I do this?
for example:
I have two tables, one called applications, the other called
forum_moderators.
Applications Catches all form submissions.
Forum_Moderators hold the details of act
Sorry about that because there probably will be a stupid question but
I'm from Spain, and i use the "," to represent decimal separator :
123.456,01 ?
well, the function sum in mysql 3.23.42 belive that "." is the decimal
separator and then when he finds a "," separator in a field returns resu
[EMAIL PROTECTED] writes:
> Do you know if this is the case even with the GCC v3.0.1?
> What is the "recommended" combination of compiler / STL implementation in order
> to work properly with MySQL client?
>
> Thanks!
>
> /Stefan
>
Yes, it is as I use the same compiler.
MySQL client can be
Do you know if this is the case even with the GCC v3.0.1?
What is the "recommended" combination of compiler / STL implementation in order
to work properly with MySQL client?
Thanks!
/Stefan
Quoting Sinisa Milivojevic <[EMAIL PROTECTED]>:
> Hi!
>
> It is very well known that most C++ compiler
[EMAIL PROTECTED] writes:
> Hi!
>
> We are currently developing a MT server (pthreads based, the main thread
> does accept() and push_back to a vector that the threads pick up work from,
> the threads share a global hash_map of cached information protected by a
> pthread_rwlock) and we seem to h
On Fri, 26 Oct 2001, Stephan Skusa wrote:
> if I do a
>
> ./configure --prefix=/usr/local/mysql-4.0.0 --with-charset=german1 --with-in
> nodb --with-tcp-port=3307 --with-unix-socket-path=/tmp/mysql4.sock
what about
./configure --with-charset=latin1_de
??
Thomas Spahni
--
hi,
I have two machine, install mysql, create same database.
I want these two database can be the same at any time. in other word, if
one table be inserted a record in one machine, then the same table in
another machine can be inserted same record also.
Who can tell me how to realize this fu
Yes, and yes. They're both documented in the manual.
http://www.mysql.com/doc/A/L/ALTER_TABLE.html
http://www.mysql.com/doc/I/N/INSERT.html
Steve Meyers
> -Original Message-
> From: Tony [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, October 25, 2001 12:57 PM
> To: [EMAIL PROTECTED]
>
1 - 100 of 117 matches
Mail list logo
