At 05:37 PM 11/30/2006, Charles Danko wrote:
Hi,
I am trying to write a new table into main memory, but I am getting an out
of memory error.
Each entry consists of 2 medium_int and 1 tiny_int variables, and the table
contains just over 100,000,000 rows. By my count, this makes just over
700MB
Not sure this is your problem, but do you have the "Allow zero datetime"
option on your connect string? For example,
connectionString="Server=localhost;
User ID=some_user;
Password=some_password;
Database=some_database;
Pooli
Hi,
My initialization for UDF is quite simple:
my_bool do_system_init(UDF_INIT *initid, UDF_ARGS
*args, char *message)
{
initid->max_length = 256;
initid->maybe_null=1;
args->arg_type[0]=STRING_RESULT;
initid->ptr = NULL;
return 0;
}
But I got:
Welcome to t
OK, I'm about to pull my hair out with this one. I know it's simple, but I
can't find a way to do this other than switching it to a string and parsing
it out manually (something I should have to be forced to do).
I've got a simple MySQL Table with a DateTime field in it. I want to
display it
Got it.
Thanks
>>> Chris White <[EMAIL PROTECTED]> 12/1/06 11:34 AM >>>
On Friday 01 December 2006 11:22, Ed Reed wrote:
> I have a problem/question I'd like to find someone else to
verify/answer
> for me.
>
> I'm using MySQL 5.1.09 running on Netware. I've created a stored
> procedure that has
Hi,
Thanks for the responses!
I am creating the table from an existing (MyISAM) table using the command:
CREATE TABLE memRAW (mID SMALLINT NOT NULL, pID MEDIUMINT NOT NULL, mp
TINYINT NOT NULL) ENGINE = MEMORY SELECT * FROM RAW;
The error that I get is in the MySQL client application:
ERROR 11
On Friday 01 December 2006 11:22, Ed Reed wrote:
> I have a problem/question I'd like to find someone else to verify/answer
> for me.
>
> I'm using MySQL 5.1.09 running on Netware. I've created a stored
> procedure that has one parameter,
>
> Create Procedure MyTest(strVal VarChar)
> Begin
> Selec
I have a problem/question I'd like to find someone else to verify/answer
for me.
I'm using MySQL 5.1.09 running on Netware. I've created a stored
procedure that has one parameter,
Create Procedure MyTest(strVal VarChar)
Begin
Select Field1, Field2, Field3 From MyTable
Where Field3=strVal;
En
I've developed several job tracking applications here at my job.
One of them relies heavily on a series of date stamps in the main table.
Each job has about 6 milestones, each with a respective "sibling"
column in the same table. The first sibling reflects the job's
predicted date milestone an
Hi,
It seems that mysql_stmt_execute() sometimes returns 1, and in this case
mysql_stmt_error() says that it "Lost connection to MySQL server during
query"
Can/should I treate this situation as an ordinary CR_SERVER_LOST, or is this
something completely different?
Thx
ImRe
--
MySQL General M
I'm not sure I followed everything you said, but if products.productid is
NULL then I think you will only find those categories that have no matching
products in the products_categories table. Is that what you want?
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmi
The query you suggested with two tables is a great start.
If you make your query into an inline-view (which treats
a query like a table) you could now connect the categories
table to your suggested query:
SELECT
AA.categoryid,
AA.productid
FROM
(
SELECT
A.categoryid,
A.productid
Sounds like you want the SOURCE command
http://dev.mysql.com/doc/refman/5.0/en/batch-commands.html
Dan
On 12/1/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
I want to load a sql file from inside the interactive mysql console, not as a
single command line. How do I do this?
I want to load a sql file from inside the interactive mysql console, not as a
single command line. How do I do this?
Check out the new AOL. Most comprehensive set of free safety and security
tools, free access to millio
Hi,
I am having a bit of trouble with a SQL query that I am hoping
someone here can give me pointers on, or a nudge in the direction of a
place which can give me a better understanding of JOINS.
Running MySQL v4.0.27 Max on a RHEL4 box. I have three tables which
look like this...
Table
> Yes. MySQL was upgraded.
> What's the name of upgrade script and where is it ?
Check the manual on how to upgrade and what script to run.
I cannot remember the name/place :-)
Martijn Tonies
Database Workbench - development tool for MySQL, and more!
Upscene Productions
http://www.upscene.com
Yes. MySQL was upgraded.
What's the name of upgrade script and where is it ?
--- Martijn Tonies <[EMAIL PROTECTED]> wrote:
> Hello Ted,
>
> > I got an error that I don't understand:
> >
> > Enter password:
> > Welcome to the MySQL monitor. Commands end with ;
> or
> > \g.
> > Your MySQL connec
Hi Charles,
Charles Danko wrote:
Each entry consists of 2 medium_int and 1 tiny_int variables, and the
table
contains just over 100,000,000 rows. By my count, this makes just over
700MB of data. The machine I am using has 2GB, but I am still getting an
out of memory error. What am I doing wr
Hi,
I've been thinking a lot on the problem and finally decided to write about
my problem to the list.
Let's say we have a table:
create table friends(
id int(10) unsigned not null auto_increment,
friend1 int(10) unsigned not null,
friend2 int(10) unsigned not null,
primary key(id),
f
Ted Yu wrote:
I got an error that I don't understand:
Enter password:
Welcome to the MySQL monitor. Commands end with ; or
\g.
Your MySQL connection id is 3080 to server version:
5.0.18-log
mysql> create function do_system returns integer
soname 'raptor_udf.so'//
ERROR 1146 (42S02): Table 'mys
Brian Dunning wrote:
I have many sites accessing one MySQL server, all using the same IP,
username, password via a PHP $connection =
mysql_connect($ip,$user,$pass);.
The server is extremely busy, hammered 24x7, but almost all traffic is
coming from one very short script. About once a day we'r
Hello Ted,
> I got an error that I don't understand:
>
> Enter password:
> Welcome to the MySQL monitor. Commands end with ; or
> \g.
> Your MySQL connection id is 3080 to server version:
> 5.0.18-log
>
> mysql> create function do_system returns integer
> soname 'raptor_udf.so'//
> ERROR 1146 (
Hi
The -q argument has already been tried but it did not work so well. I've
told the client to increase the packet_size on their side now but i
haven't received word on if it worked or not.
Med vänliga hälsningar
Stefan Midjich aka nocturnal
[Swehack] http://swehack.se
Visolve DB Team wr
23 matches
Mail list logo
