I used to use Navicat to import CSV files into MySQL.
Now I find that I can use either Navicat or the latest
phpMyAdmin upgrade, and one or the other usually
works, even when I'm battling collation errors.
But I'm stumped on a relatively large but simple
table. I wondered if I might make it work i
--- Andy Bakun <[EMAIL PROTECTED]> wrote:
> On Sat, 2005-02-19 at 23:55, David Blomstrom wrote:
>
> > > Why not set columns to NOT NULL and default to
> space
> > > for character and 0
> > > for numeric?
> >
> > OK, you're suggesting I...
> >
> > 1. Set all the columns to NOT NULL
> > 2. Set
On Sat, 2005-02-19 at 23:55, David Blomstrom wrote:
> > Why not set columns to NOT NULL and default to space
> > for character and 0
> > for numeric?
>
> OK, you're suggesting I...
>
> 1. Set all the columns to NOT NULL
> 2. Set 0 as the default for numeric fields
> 3. Set "space" for the defau
--- Alex S Moore <[EMAIL PROTECTED]> wrote:
> David Blomstrom wrote:
>
> > So I THINK I may have a good idea for a
> workaround. I
> > simply change all my fields to NOT NULL, then fill
> > every cell that would ordinarily be NULL with a
> unique
> > constant, like 606060.
> >
> > Then I find s
I'm having a terrible time with MySQL's new collation
feature. It frequently fills cells that should be NULL
with 0's and pushes data from one column to another. I
can usually import csv files into my tables using
either Navicat or phpMyAdmin, but I have to experiment
with a lot of settings, and so
I had no problem installing mysql as a simple user in my home directory
on a linux x86_64 machine either from source or binary.
I did this:
1.Download binary or source from MySQL mirror
2.Untar into a directory database_dir or make install using ./configure
-âprefix=database_dir
3.Softlink database
I have downloaded both 5.0.0 and latest 5.0.1 binary snapshot but I
found that the stored procedures are very unstable. E.g. when I fetch
empty string into variables, the server crashes.
It seems like 5.x development has been ongoing for more than a year.
Can somebody give me a rough estimate about
I use:
# ps -axH | grep mysql
and now I can see all theads.
I was worry about mysql is not using both CPU, but it is.
I made a test running stress queries:
with 1 coneccion I got 75% idle processor,
2 coneccion I got 50% idle processor,
3 coneccion I got 25% idle processor
Thanks
Paul
Gleb Pahare
Mohsen,
The data structure you seem to be looking for is MYSQL_RES, the C API
resultset, which is an array & which is described in the manual page you
were pointed to. It's pretty straightforward to use, eg
...
MYSQL_RES *rset;
...
if( mysql_real_query( conn, qry, strlen( qry ) == MYSQL_TRUE ) {
Quick definitions (Mite)
a.. noun: any of numerous very small to minute arachnids often infesting
animals or plants or stored foods
a.. noun: a slight but appreciable addition
I think you meant to say "might", not "mite" ;-)
Rhino
- Original Message -
From: "Lisa Mannion" <[EMAIL
Dears,I was attempping with your code.But it could't do my job.
My job:
I have list of my tables in my DB,i did it with mysql_list_tables() func.
It returns MYSQL_RES type.But i don't know how to split it to an array.
Please guide me..
> Hi,
>
> I think you can find all the information you are
> I was wondering if you could tell me of three or four alternative software
> options that can be used for this middle layer. What are the costs involved
> with any of these. Also if you could supply me with a sample script for
> inserting data using these alternative scripting languages, as I hav
Dear Sir/Madam,
I am in third year college in Trinity. I came across your e-mail after much
research on the pipeten.com site and was hoping you mite be able to help me
with a software labs report. If not it would be great if you could indicate a
person who mite.
SCENARIO:
Over the last few weeks
Anyone know what to do when SHOW SLAVE STATUS says:
"Query caused different errors on master and slave."
Master: MySQL 4.1.9-Debian_2-log
Slave: MySQL 4.1.5-gamma-log
Thanks,
Jacob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysq
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
MySQL Connector/J 3.1.7, a new version of the Type-IV all-Java JDBC
driver for MySQL has been released.
Version 3.1.7 is the latest production release of the 3.1 series that is
suitable for use with all versions of MySQL, including MySQL-4.1 or
M
On Sat, 19 Feb 2005 14:01:05 +, Jerry Swanson <[EMAIL PROTECTED]> wrote:
> I have two dates (start_date, end_date). Datediff() function returns
> difference in days.
> I need the difference but not including Satuday and Sunday.
>
> Any ideas?
C:\Program Files\MySQL\MySQL Server 4.1\bin>mysql
I have two dates (start_date, end_date). Datediff() function returns
difference in days.
I need the difference but not including Satuday and Sunday.
Any ideas?
TH
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTE
James,
page number 22357 is corrupt. InnoDB Hot Backup notices these checksum
errors, and refuses to do the backup. Sometimes it happens that an unused
(i.e., freed) page in an ibdata file becomes corrupt. Then it would be nice
to have some tool to reset the checksums on that page, so that mysql
18 matches
Mail list logo
