Is there any statement in MySql 5.0 to create a
package of my own i,e
create package Pack_name ( ) etc.,
if so please give the syntax of that or
what to do if I want to create a package of my own in
mysql 5.0 . Any help is welcome.
Thanks ,
Sreedhar
Is there any statement named create and complie java
source named .. syntax in the mysql for creation
of a java source file for loading data from java files
or retriving data etc .
Any help is welcome .
__
Do You Yahoo!?
Tired of spam?
Hi list,
This night my slave stopped replicating the master (I am using 4.1.11 to
replicate 4.1.9). Whenever I say start slave, The error log of the
slave says:
050430 10:27:12 [Note] Slave I/O thread: connected to master
'[EMAIL PROTECTED]:3306', replication started in log
'www-bin.03'
after gunzipping and untarring i get to point
in instructions to run script mysql_install_db
i get the following error:
# scripts/mysql_install_db
exec(): 0509-036 Cannot load program ./bin/my_print_defaults because of
the foll
owing errors:
Symbol resolution failed for my_print_defaults
questions!questions!(silly questions! ;)
1. i stored a vector in the dbase as blob, how do i retrieve it as a vector?
2. i'm making a substring search, i.e. ...LIKE '[%, U, D, D, %]'. am i doing it
right?
3.i need to find the exact location of the matching substring in the vector,
i.e. [S, U, U,
Baba,
- Original Message -
From: Baba Buehler [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Friday, April 29, 2005 12:54 AM
Subject: memory error innodb backup
We've got a customer whose system has been experiencing corruption in
their InnoDB tables. They have returned
questions!questions!(silly questions! ;)
1. i stored a vector in the dbase as blob, how do i retrieve it as a vector?
2. i'm making a substring search, i.e. ...LIKE '[%, U, D, D, %]'. am i doing it
right?
3.i need to find the exact location of the matching substring in the vector,
i.e. [S, U, U,
Sam,
- Original Message -
From: Sam Sgro [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Thursday, April 28, 2005 1:35 AM
Subject: Resetting lsn/trx for an .ibd file
It's pretty clear that although you cannot currently move .ibd files
between MySQL installations, it's
Hi,
I am using Mysql built-in defaults for starting the
server. It chokes when the table size grows to 4GB.
===
-rw-rw1 vagarwal dev 4294967284 Apr 29
22:33 crec.MYD
-rw-rw1 vagarwal dev 950261760 Apr 29
23:22 crec.MYI
I created a user and granted
Hello.
Not enough information to make a suggestion. You have a very
old version. Upgrade it.
Jeff Schwartz [EMAIL PROTECTED] wrote:
[-- text/plain, encoding 7bit, charset: us-ascii, 12 lines --]
I'm running MySQL 4.0.14 and it's locking tables for everything including
counting
Hello.
Make the dump using --quote-names option for mysqldump. Does it solve
the problem? You have an old MySQL version. I strongly recommend you to
upgrade.
I backup a db using mysqldump, but when I come to execute the sql file
on an empty db I
get this
Hello.
Question 1: How do I check my syntax against the version and distribution
that I am
running?
In manual it is usually said which features are available as of which
version. Use the special form of comments to adopt your queries to
corresponding version. See:
In article [EMAIL PROTECTED],
Hassan Schroeder [EMAIL PROTECTED] writes:
Paul DuBois wrote:
Before MySQL 5, DECIMAL values are stored as strings, so operations
are less efficient than for integers.
In MySQL 5, the representation of DECIMAL has changed to binary
format,
so it's more
Your questions (this one and the other one that you posted at the same time)
are not very clear so I am really not sure what you want.
However, if you are asking about creating a package for your Java source
code, this has nothing to do with MySQL: there is no special technique for
creating a
Hi,
I am using Mysql built-in defaults for starting the
server. It chokes when the table size grows to 4GB in
data directory.
What parameter needs to be tweaked for allowing larger
size tables ?
===
-rw-rw1 vagarwal dev 4294967284 Apr 29
22:33 crec.MYD
-rw-rw1
I posted a few days ago, but didn't get any responses. I'm hopeful someone
has seen this, and can offer advice.
We recently converted some tables from MyISAM to InnoDB because the need had
arisen for transactional support.
Things have been fine until recently, when the .frm files for
At 16:35 -0700 4/29/05, Hassan Schroeder wrote:
Paul DuBois wrote:
Before MySQL 5, DECIMAL values are stored as strings, so operations
are less efficient than for integers.
In MySQL 5, the representation of DECIMAL has changed to binary format,
so it's more efficient than before. It's probably
Thank you for your help. I really appreciate it.
I created the dump with --quote-names option, but this does not solve the
problem unfortunately. I still get error:
C:\xampp\xampp\mysql\binmysql -uroot db2 test5.txt
ERROR 1005 at line 54: Can't create table '.\db2\shift.frm' (errno: 150)
Hi!
I am struggling with trying to count how many string patterns of a given
kind occur in any given row of a mysql table.
My table looks like this:
Pattern varchar(200)
HowMany varchar(3)
The patterns that appear in the Pattern field can be aphabetic chars only,
but spaces can appear at the
How would I test this fetch to know if there are any rows returned?
$arr = mysql_fetch_array($result, MYSQL_ASSOC)
Hi,
I develop multi-user web tracker system (php+mysql). In these days I have cca
150 users and each of the users has a set of the tables which are all included
in central DB. In DB is on the whole cca 900 tables. Each user has also one
(log) table in which are logged accesses to the web
Hi All!
I am having a heck of a time figuring out how to get a string taken from a
MySql table into an array. I happen to be using PHP but I would appreciate
any pointers whatever in how to do this.
I tried this: $array[] = $pattern; but it put the entire pattern into
$array[1]. I want each
Sorry to all - but I realised that the string in a variable called $pattern
is, in fact, an array, so I don't need to load an array as it is already
there.
My apologies!
-Warren
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
A little more detail about what you are doing would go a long way to
clarifying your question. It *sounds* like you are trying to take a single
string obtained from somewhere in a MySQL table and then split it into
different parts with each part going into a separate element of an array,
but that
From: [EMAIL PROTECTED]
create table a (
b int not null,
c int null
primary_key(b,c)
);
With values:
1 null
1 null
Logically these are unique records under the standard proviso that
null != null. Yet how could I uniquely identify the first row to delete
that row?
First of
Hi,
This is driving me nuts, please tell me is this a bug or a problem wiht my
query:
jappz_guestbook(owner_cno, sent_datetime, is_secret, accepted)
jappz_member_profile(cno, pic_name)
jappz_guestbook's owner_cno and jappz_member_profile's cno are the same
what i need to do is select *
How would I test this fetch to know if there are any rows returned?
$arr = mysql_fetch_array($result, MYSQL_ASSOC)
$rows = mysql_num_rows( $result );
PB
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.11.0 - Release Date: 4/29/2005
--
Hi:
I would like to use the DALP libraries
(http://solutions.mysql.com/software/?item=145) to access a MySQL server
4.1.10 on Linux, from my PocketPC (iPAQ 3100 WM 2003 SE). I would appreciate
it if somebody could provide me with a minimal sample that would just connect
to a database so I can
Geoffrey R. Thompson wrote:
...
Things have been fine until recently, when the .frm files for these tables
mysteriously disappeared from the mysql data directory (even though the
underlying data for the tables was still intact in the separate InnoDB data
file).
...
As far as I'm aware InnoDB
29 matches
Mail list logo