Bonjour,
Bienvenue sur la liste de diffusion Mysql-france. Prenez 2 minutes pour lire ce
message.
Pour vous desinscrire, allez sur le site ONElist,
www.onelist.com, et selectionnez les liens My ONElist situé à gauche.
Vous pouvez aussi demander à recevoir une fois par semaine l'ensemble des
Bonjour,
Nous avons reçu votre demande d'inscription au groupe
mysql-france sur Yahoo! Groupes, le nouveau service de
communautés de Yahoo!. Pour vous inscrire, vous devez confirmer votre
demande en répondant à ce message.
Si vous n'avez pas demandé ou ne souhaitez pas vous inscrire au groupe
Hi.
On Fri, Apr 12, 2002 at 02:49:03PM +0200, [EMAIL PROTECTED] wrote:
[...]
> mysql> explain select * from news where category = 'x' order by category DESC,
>provider_date DESC;
>
>+---+--+++-+---+--+--
Hi.
AFAIK, insert for MERGE tables was introduced in version 4.0.0. Let's
see... yep, http://www.mysql.com/doc/N/e/News-4.0.0.html says so.
Regards,
Benjamin.
PS: The syntax you used should be fine with a version supporting it
On Fri, Apr 19, 2002 at 04:00:02PM -0700, [EMAIL PROTE
* Steve Edberg
> At 1:10 PM +0300 4/19/02, cristian ditoiu wrote:
> >mysql> INSERT INTO ref_data VALUES (186, 139, 'Tess of the
> D\'Urbervilles',
> >'THOMAS HARDY\r\nTESS OF THE D'URBERVILLES\r', 'tess.DOC', '2002-02-06',
>
> ...^
>
> There's an unescaped ' there; if
Hello,
I'm running a relatively busy MySQL server on Mac OS X Server. MySQL runs on
a dedicated dual G4 500, with 1.5 GB of RAM and an 18GB 15k rpm Ultra160
Cheetah drive. No other services besides MySQL run on this machine.
Roughly 3-5 times per day, my MySQL server suddenly "forgets" most or a
I'm trying to use the twz1 jdbc driver with dbvis.
I keep getting a java.lang.VerifyError error. Has anyone been able to get
dbvis to work with
mysql via twz1 driver?
thanks in advance
jennifer moter
-
Before posting, please
On Sat, 20 Apr 2002 [EMAIL PROTECTED] wrote:
> Your message cannot be posted because it appears to be either spam or
> simply off topic to our filter. To bypass the filter you must include
> one of the following words in your message:
>
> sql,query
>
> If you just reply to this message, and inclu
Hi!
I admit I´m a newbie but I´m really trying to get a grip on this... I have
suceeded in creating an administration solution for websites and now one
problem remains:
When the values for a new website is submitted into a mysql table, it
doesn´t work if the amount of text in the values are too
I am trying to normalize a data set based on the minimum values of certain
columns.
I figured out that I can get the minimum value using a query like
SELECT least(min(colOne),min(colTwo)) FROM myTable
Is there a way I can do the normalization in a single query?
Ideally, something like...
SELECT
I think it would be a good idea to be able to specify the error log on
the command line when starting mysqld. Right now mysql users can only
specify the following logs on the command line:
log (access/activity log)
log bin
log bin index
log update
log isam
At 14:10 -0400 4/19/02, Andrew Kuebler wrote:
>Maybe someone can help me here..
>
>I'm inserting data with an AUTO_INCREMENT column and immediately after I
>need to use that new number for a corresponding record in another table.
>How am I able to extract that new number quickly? I could run a SEL
At 14:58 -0400 4/19/02, Barry C. Hawkins wrote:
>Alex,
> Enclose the user string in quotes. This will allow you to use
>the global wildcard option.
>
>Example:
>GRANT ALL ON *.* TO "myuser@%" IDENTIFIED BY "mypassword";
You should quote the user name and host name parts separately.
"myuse
>>>Why is this producing a syntax error at the %? This is supposed to
>>>create a global user, yes?
>>>
>>>GRANT ALL ON *.* TO myuser@% IDENTIFIED BY "mypassword";
>>
>>myuser@"%"
>
>Andrew Hazen emailed me to use single quotes and it worked. So does
>mysql care if it is single or double quotes?
I never saw this message make this list so I'm reposting it.
- Original Message -
From: "Darren Vollmer" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, April 19, 2002 7:33 AM
Subject: problem with load data local infile
> I am having problems with load data local infile.
>
>
Do you have g++ installed? It doesn't look like you do.
On Friday 19 April 2002 1:45 pm, Ricky Sun wrote:
> I am trying to install mysql 3.23.49 source release on RH7.3 Beta 1
> workstation... Encountered the following gcc C++ compiler executable
> creation problem
>
> when ./configure check
I am trying to install mysql 3.23.49 source release on RH7.3 Beta 1 workstation...
Encountered the following gcc C++ compiler executable creation problem
when ./configure checks for C++ compiler it complains :
checking for gcc... gcc
checking whether the C compiler (gcc ) works... y
On Friday, April 19, 2002, at 02:10 PM, Andrew Kuebler wrote:
> I'm inserting data with an AUTO_INCREMENT column and immediately after I
> need to use that new number for a corresponding record in another table.
> How am I able to extract that new number quickly? I could run a SELECT
> query af
Hi, Andrew,
To get the auto_increment value, simply execute
select last_insert_id()
after insert statement
Andrew Kuebler wrote:
>Maybe someone can help me here..
>
>I'm inserting data with an AUTO_INCREMENT column and immediately after I
>need to use that new number for a corresponding record
Alex,
Enclose the user string in quotes. This will allow you to use the global
wildcard option.
Example:
GRANT ALL ON *.* TO "myuser@%" IDENTIFIED BY "mypassword";
For those not using Mac OS X, the default shell is tcsh. I am not sure if this
quirk is a function of string handling
Hi Joseph,
The situation is like this. The daemon was running but any command /
requests were hanging for example any mysqladmin command would sit
there forever, any mysql command would behave the same way.
OS - HP-UX 10.20
Mysql version - 3.23.33
There were lot of activities at the time ser
trying to make a query faster. the list helped out a lot last time, so i
figured i would bring back and get more assistance.
any thoughts?
katen
EXPLAIN SYNTAX:
+-+---+-+---+-+---+--+---+
| table | type | possible_keys | key |
Hi,
I am following up on a thread I started yesterday about building my
tables. (I have included the original email at the end of this one for
reference.) I got some good feedback about it, and so have decided to
change my entire battle plan, and was hoping to get some advice about it.
The
At 12:59 PM -0500 4/19/02, Paul DuBois wrote:
>>Why is this producing a syntax error at the %? This is supposed to
>>create a global user, yes?
>>
>>GRANT ALL ON *.* TO myuser@% IDENTIFIED BY "mypassword";
>
>myuser@"%"
Andrew Hazen emailed me to use single quotes and it worked. So does
mysql c
Maybe someone can help me here..
I'm inserting data with an AUTO_INCREMENT column and immediately after I
need to use that new number for a corresponding record in another table.
How am I able to extract that new number quickly? I could run a SELECT
query after the INSERT using the MAX command, b
Hi Rick,
I've posted a similar question about it, trying to compile MySQLMAX on an
HPUX 11 box. Nobody answered !!
Browsing the web for related sites and information I've found that the only
way to do that is using the aCC compiler, which is sold separatelly from HP
at a cost of more than $1500.
Why is this producing a syntax error at the %? This is supposed to
create a global user, yes?
GRANT ALL ON *.* TO myuser@% IDENTIFIED BY "mypassword";
Is there a quick command to show all GRANTS? or Users?
--
<->
Alex Pilson
FlagShip In
To the members of the list,
This is in regards to my posting regarding mySQL's licencing.
I'm afraid that I forgot to remove the 'request read receipt' on this
installation of Outlook. Do to this oversight many of you have been forced
to either send/not-send the notification. I will endevor to
Greets Folks,
I need help with some too-involved-for-me CGI stuff, and I'd like to work
with a freelance programmer/consultant.
The consulting will be for a mature themed site, and I am running on a
limited budget, so open minds only please. The project is for a paid
membership site using Per
At 9:35 -0700 4/19/02, Soheil Shaghaghi wrote:
>Hi all,
>A few days ego, I asked the group about the meaning of the Overhead in sql.
>Some
>people were nice enough to answer me, and told me I needed to optimize the
>table.
>
>Here is what phpMyAdmin reports on the table:
>Space usage : Type Usage
Is there a way to do a database cross connection from mySQL to a GMACCESS
system?
Should you have any questions, comments or concerns, feel free to call me
at 318-338-2034.
Thank you for your time,
Jay Fitzgerald, Design Director - CSBW-A, CPW-A, CWD-A, CEMS-A
===
My question is this; I have a database that looks like this.
galleries
gallery_id gallery_name
1 3d
2 fractals
3 abstract
4 cats
5 cars
Images
image_id gallery_id
Ignore my previous post..
SELECT ... FROM table WHERE MONTH(datecolumm)=MONTH(NOW()) AND
DAYOFMONTH(datecolumn)=DAYOFMONTH(NOW());
Lessons learned in the last few days = Never post messages right before or
on the project implementation day.
Thanks Keith for pointing that out...
Gurhan
-O
Hi all,
A few days ego, I asked the group about the meaning of the Overhead in sql.
Some
people were nice enough to answer me, and told me I needed to optimize the
table.
Here is what phpMyAdmin reports on the table:
Space usage : Type Usage
Data 1,602 KB
Index 3,729 KB
Overhead 24,718 Bytes
Effe
On Fri, Apr 19, 2002 at 04:12:35AM -0700, Jeremy Zawodny wrote:
> On Wed, Apr 10, 2002 at 08:48:01AM -0700, Nick Pasich wrote:
>
> [snip]
>
> >
> > Any subsequent executions do not. This is because of query caching.
> > I can run --> mysql -e "reset query cache" <-- which will enable
>
At 1:10 PM +0300 4/19/02, cristian ditoiu wrote:
>hi , i have a little mysql problem .
>:
>got 2 servers .. 1 got a dump from server1 via myadmin , but when trying to
>insert the data into server 2 i got a strange errror and i got disconected
>from server2 .
>
>any ideeas ?
>
>--
>
Paras,
Friday, April 19, 2002, 2:55:22 PM, you wrote:
PM> I just now reinstalled MySQL Ver 4.0.1 on Linux Mandrake 7.2 on Intel P III
PM> m/c using the RPM available at MySQL website. The installation got through
PM> w/o any prolem, but it gives "Segmentation Fault" - core dumped when I run
PM> M
Shaun,
I am not sure about everyone else on the list, but as far as I am concerned,
since you are purchasing a service from your provider, all licencing should
be dealt with by them. I would be awefully suspicious of any survice
provider that wouldn't already have this information.
Regards,
SELECT ... FROm table WHERE datecolumn=NOW();
Gurhan
-Original Message-
From: Soheil Shaghaghi [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 19, 2002 11:09 AM
To: [EMAIL PROTECTED]
Subject: Birthday select
Hi everyone.
I have a sql database of users with their birth date (Y/M/D).
Ca
>Hi everyone.
>I have a sql database of users with their birth date (Y/M/D).
>
>Can anyone please tell me how I can check whose birthday each day is, and
>pull them from the database?
WHERE MONTH(birth) = MONTH(CURDATE())
AND DAYOFMONTH(birth) = DAYOFMONTH(CURDATE())
I'm assuming you have birth
Neil Highley writes:
> Let me know about the answer to this one.
>
> [EMAIL PROTECTED]
> ---
> "Life must be lived as play."
> - Plato (427 - 347 BC)
You will be duly informed ...
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ _
Has anyone built mysql 3.23.49a on HP-UX 11.11 using GCC 3.0.x?
If so, what were your CC, CXX, CFLAGS, CXXFLAGS and ./configure set up?
Thanks,
Rick
-
Before posting, please check:
http://www.mysql.com/manual.php (th
Hi everyone.
I have a sql database of users with their birth date (Y/M/D).
Can anyone please tell me how I can check whose birthday each day is, and
pull them from the database?
Thanks,
Soheil
-
Before posting, please check:
Let me know about the answer to this one.
[EMAIL PROTECTED]
---
"Life must be lived as play."
- Plato (427 - 347 BC)
- Original Message -
From: "Sinisa Milivojevic" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[E
Thank you for your report.
Yes, I know about this leak in Windows version. It is due to it's
stack limitations.
Current developrment branch has this leask fixed already ...
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_
Klym writes:
> I hope I'm not out of line by asking a licensing question. I am working on
> a MySQL database for a web-based survey. We will be charging a fee to
> complete the survey and receive reports. Am I required to purchase a MySQL
> licence for this or does my hosting company who sold m
I'm pleased to announce that MySQL and Perl for the Web (New Riders,
by me) is now available in a Dutch translation (MySQL en Perl voor
het web). Not that I can read a word of it ... :-)
Information is available on the translations page at the book's
Web site: http://www.kitebird.com/mysql-perl/
At 15:29 +0200 4/19/02, Toomas Vendelin wrote:
>Hello Paul,
>
>But RLIKE won't use indexes (even if they exist), so why RLIKE '^A' is
>better than LIKE 'A%', if LIKE which starts at the beginning of the
>string **will** use indexes?
I was comparing RLIKE '^A.*' to RLIKE '^A', not RLIKE to LIKE.
Update:
After finding a reference to problems with BSDI and the realpath() system
call in the mailing list archives, I tried rebuilding MySQL with the
HAVE_BROKEN_REALPATH flag defined. That seemed to clear up the problem, at
least with the testing that I performed. YMMV.
DSC
_
Not to beat an apparently dead horse...
My problem was that interactively I could not get the following statement to
execute (on Win NT, myISAM table, mySQL 3.23.49-nt):
insert mytable values (1, 2 ,3, LOAD_FILE('c:\myfile.ext'));
However, I found this would work:
insert mytable (col1, col2, c
It's ok, I do actually fully understand relational database theory and what the
group by statement is used for, but like I say, I personally have no control
over the database or the SQL :-)
I was hoping to get hold of someone who maybe knows the source code quite well
already and could help me o
As a relational database, it doe not matter the order in which data are
stored.
Rather, what matters are the methods by which data are extracted via the
SELECT statement. In order to derive benefits of GROUP BY, you must use it
with SELECTs that use GROUP BY functionality, such as SUM(), COUNT()
I am working with the MySql++ 1.7.9 on windows98 using borland C++ 6.0.
I have found and fixed a memory leak ( applicable on all platforms that need
the __USLC__ conditional defined) , and sucessfully ported the system to
borlanbd C++ 6 with a very minimum of modifications. (mostly resolving
in
am having some trouble with MySQL. Seems I cannot add users. Well, I can
add them (through phpMyAdmin, but they are still not able to get into the
datasbases. I flushed the tables, too.
Current users are not affected.
This started, rather suddenly, the day after I was able to do this.
Anyon
Subject: Re: Select with Order By that don't use my INDEX :(
From: Vic Cekvenich <[EMAIL PROTECTED]>
===
Better yet, remove the order by.
Make it sort by the index, ie, create an index that matches your select.
Vic
Dr. Frank Ullrich wrote:
> David,
>
> it can't because this field is not the fi
I hope I'm not out of line by asking a licensing question. I am working on
a MySQL database for a web-based survey. We will be charging a fee to
complete the survey and receive reports. Am I required to purchase a MySQL
licence for this or does my hosting company who sold me the use of MySQL
co
Is it ok for version 3.22.32 ?
João Alexander Marques
[EMAIL PROTECTED]
Uranet Projetos & Sistemas Ltda.
Tel. : 55 11 3242-1353
- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
To: "Kory Wheatley" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, April 18, 2002
Thank you :-)
I do realise the SQL is not being used as it should be, but as it is not my
database and nor is it my SQL, there's not much I can do to really change
either of these I merely have to work with a database that has been
produced by a third party group, and I must say at this point
I am having problems with load data local infile.
The mysql host server is running 3.23.23
I was able to successfully use load data local infile before to import data
off of a client machine onto the mysql host but now all i get is a
can't stat file errcode2 message.
I know that the pathname I
Are you saying that you want a table with a maximum of 127 records ? Or,
that due to your TINYINT, you are RESTRICTED to 127 records?
If you are restricted to records, change TINYINT to INT.
If you want to have ONLY 128 records, change TINYINT to TINYINT UNSIGNED,
which will permit records 1 thro
Hello Paul,
But RLIKE won't use indexes (even if they exist), so why RLIKE '^A' is
better than LIKE 'A%', if LIKE which starts at the beginning of the
string **will** use indexes?
Regards,
Tom
PD> Regular expression patterns (unlike SQL patterns) don't need to match the
PD> entire string, so R
mysql is acting correctly.
GROUP BY is used to consolidate data for SUMming, COUNTing, etc. Your
SELECT statement makes not such request. You have simply requested the
value of a specific field. Data are stored in mysql databases randomly.
Therefore, when you request a field's data, you are ge
Henning,
Friday, April 19, 2002, 3:38:49 PM, you wrote:
HO> Hey - can anyone help?
HO> I have a MySql-db in which I can only have 127 records.
HO> Using phpmyadmin to insert record number 128 (autoincrement) gets this message:
HO> INSERT INTO `kontakt` (`id`, `navn`, `adresse`, `postnummer`, `by
Gokce,
Friday, April 19, 2002, 12:51:34 PM, you wrote:
GA> I have a table within turkish characters.
GA> I know which set I must use: latin5
GA> But I couldn' t set it.
Run mysqld with --default-character-set=latin5 option or edit my.cnf.
Look at:
http://www.mysql.com/doc/C/h/Character_set
Webmaster33,
Thursday, April 18, 2002, 8:01:30 PM, you wrote:
W> I understand. Bad to hear. :-(
W> I think there would be important to implement features to be able
W> to set different character sets for each table, or to change
W> character sets dynamically without the need to restart MySQL
Chris,
Thursday, April 18, 2002, 8:50:06 PM, you wrote:
CS> Is there any way to grant a user only SELECT permissions on a set of tables
CS> in MySQL, but to also allow them to have CREATE, DROP, and INSERT on the
CS> Database itself??
CS> What I want is a database where the users cannot modify
Sridhar,
Friday, April 19, 2002, 12:54:14 AM, you wrote:
SP> We are currently using Mysql (3.22.32) on a Solaris platform. We are
SP> looking to upgrade/migrate this current version to 3.23.49a, for
SP> utilizing the replication functionality. I would appreciate if anyone
SP> can clarify the foll
Gerald,
Thursday, April 18, 2002, 1:52:25 AM, you wrote:
GRJ> Can the TZ be set in my.cnf (my.ini) when the MySQL server starts up?
GRJ> I have read the manual on this, and tried various combinations, but haven't
GRJ> hit the right syntax.
No, you can't specify timezone in the my.cnf(my.ini) fi
MH,
Thursday, April 18, 2002, 11:50:12 PM, you wrote:
M> Is there a "sanctioned" way to rename a MySQL 3.23.x database, consisting
M> of MyISAM tables?
1. Take down the MySQL server.
2. Rename dir, that contains tables(files) of your database.
3. Start the MySQL server.
4. Don't forget to corr
David,
Friday, April 19, 2002, 8:17:27 AM, you wrote:
DT> Are there any steps I need to take to ensure no corruption of the database if
DT> I downgrade from say
DT> 3.23.49
DT> to
DT> 3.23.48
You can find a short notes about upgrading/downgrading MySQL in the
manual:
http://www.mysql.com
* Henning Olsen
> I have a MySql-db in which I can only have 127 records.
> Using phpmyadmin to insert record number 128 (autoincrement) gets
> this message:
>
> INSERT INTO `kontakt` (`id`, `navn`, `adresse`, `postnummer`,
> `by`, `telefon`, `kommentar`) VALUES ('', 'fsd', 'sfdg', 'sg',
> 'fdsg',
> A closed mouth maintains a happy mind.
It could be that you specified signed TINYINT as type for the PRIMARY
KEY. Signed TINYINT goes from -127 to 127, hence your problem.
HO> INSERT INTO `kontakt` (`id`, `navn`, `adresse`, `postnummer`, `by`,
HO> `telefon`, `kommentar`) VALUES ('', 'fs
Hi Gurus,
I just now reinstalled MySQL Ver 4.0.1 on Linux Mandrake 7.2 on Intel P III
m/c using the RPM available at MySQL website. The installation got through
w/o any prolem, but it gives "Segmentation Fault" - core dumped when I run
MySQLADMIN. I have followed all the post-installation steps gi
WowI think I can finally help somebody on this list.
Ok. I bet that you have your column set up as "tinyint". I presume it
would be the "id" column that you have. "tinyint" is the following:
Signed values: -128 to 127
Unsigned values: 0 to 255
I ran into the problem before too. So if you
Hi,
On Fri, Apr 19, 2002 at 01:38:49PM +0100, Henning Olsen wrote:
> Hey - can anyone help?
> I have a MySql-db in which I can only have 127 records.
> Using phpmyadmin to insert record number 128 (autoincrement) gets this message:
>
> INSERT INTO `kontakt` (`id`, `navn`, `adresse`, `postnummer`,
> Fra: Henning Olsen [mailto:[EMAIL PROTECTED]]
> Sendt: 19. april 2002 14:39
> Hey - can anyone help?
> I have a MySql-db in which I can only have 127 records.
> Using phpmyadmin to insert record number 128 (autoincrement) gets
> this message:
>
> INSERT INTO `kontakt` (`id`, `navn`, `adresse`,
Hey - can anyone help?
I have a MySql-db in which I can only have 127 records.
Using phpmyadmin to insert record number 128 (autoincrement) gets this message:
INSERT INTO `kontakt` (`id`, `navn`, `adresse`, `postnummer`, `by`, `telefon`,
`kommentar`) VALUES ('', 'fsd', 'sfdg', 'sg', 'fdsg', 'sfg
On Wed, Apr 10, 2002 at 08:48:01AM -0700, Nick Pasich wrote:
[snip]
>
> Any subsequent executions do not. This is because of query caching.
> I can run --> mysql -e "reset query cache" <-- which will enable
> the next call to mysqldump to write data.
>
> I believe that
Hi
I am having some trouble figuring out how mySQL interprets the group by
clause in a particular set of data that I have (the ensembl database if
anyone is familar with it!)
Now, I have some data like this:
+-++--+
| gene_id | display_id | db_name |
+-+
> When you write another MySQL-based search engine, you
> obviosly test it issuing queries against big amounts of data which
contains more
> or less sane text. Tell me, where (or how) you usually get the text
> when you need, say, 10GB of it and, I repeat, it should be a REAL
> non-repeating tex
At 9:00 +0200 4/19/02, Jan Peuker wrote:
>There is a method using trim() but I think it's better to use RLIKE "^A.*"
Regular expression patterns (unlike SQL patterns) don't need to match the
entire string, so RLIKE '^A' is sufficient and more efficient because
it doesn't spend time trying to matc
hi , i have a little mysql problem .
:
got 2 servers .. 1 got a dump from server1 via myadmin , but when trying to
insert the data into server 2 i got a strange errror and i got disconected
from server2 .
any ideeas ?
--
Your MySQL connection id is 752533 to server version: 3.23.
Hi the best thing to do is check out Dev.Shed.com - MySql the addressas
follows
http://www.devshed.com./Server_Side/MySQL/Administration
This tells you basically the tasks of correctly administering the MySql
server,including the manipulation of the privilege system.
I could waffle on a bit b
I am doing some automated mysql -u user -ppasswd
database < insertfile.sql
in a loop and have some skip locking presumably because
there are a number of jobs running to do this
(with different files, which however use the same
tables). Should I rather do line by line inserts for
speed?
Th
Hi!
> "Michael" == Michael Stassen <[EMAIL PROTECTED]> writes:
Michael> This has come up before. In fact, I had the exact same problem. You can
Michael> see the the thread "Coredump when running scripts/mysql_install_db " at
Michael> http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:msp:93051
- Original Message -
From: "Joseph Bueno" <[EMAIL PROTECTED]>
To: "David BORDAS" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, April 19, 2002 10:34 AM
Subject: Re: Select with Order By that don't use my INDEX :(
> David BORDAS a écrit :
> >
> > I'm using mysql 3.23.49 on Lin
I have a table within turkish characters.
I know which set I must use: latin5
But I couldn' t set it.
Thanks
SQL,Sql,sql
Edakom Internet Sorumlusu
Gokce Akkaya
-
Before posting, please check:
http://www.mysql.com/
This should work :
$SQL = "INSERT INTO orders (Customer_Id, Order_Date)".
"VALUES($CustID,Now())";
Xavier
-Message d'origine-
De : Alia Mikati [mailto:[EMAIL PROTECTED]]
Envoyé : vendredi 19 avril 2002 11:28
À : [EMAIL PROTECTED]
Objet : Date function
Hello
I
David,
it can't because this field is not the first one in your concat index!
Regards,
Frank.
David BORDAS wrote:
>
> I'm using mysql 3.23.49 on Linux redhat dedicated server.
>
> Here is my query :
>
> mysql> show index from MyTable;
>
> Table
I never saw the function "date()", to insert current date use:
CURRENT_DATE();
regards,
Jan
- Original Message -
From: "Alia Mikati" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, April 19, 2002 11:27 AM
Subject: Date function
> Hello
> I have the following SQL and I wanna
Hello
I have the following SQL and I wanna insert the current date in one of
the table fields but it's not working. Can u tell me whats the problem?
(I'm using mysql and php)
Thx a lot
$SQL = "INSERT INTO orders (Customer_Id, Order_Date)".
"VALUES($CustID,date())";
-
David BORDAS a écrit :
>
> I'm using mysql 3.23.49 on Linux redhat dedicated server.
>
> Here is my query :
>
> mysql> show index from MyTable;
>
> Table: MyTable
> Non_unique : 0
> Key_name: PRIMARY
> Seq_in_index: 1
> Column_name
Hi,
May be this list was unresponsive because your description of the
problem was a bit vague...
I haven't experienced this kind of behaviour myself however some
more details on your problem may help:
- What OS are you using ?
- What version of MySQL are you using ?
- Was mysql server dead ?
(
Michael Williams a écrit :
>
> Okay, this may well be a LINUX issue I am having, so be kind before you
> flame.
>
> When I try to index a large file, it fails with a write error on the /tmp
> directory. Now my /tmp directory is on a smaller partition (as sent to me
> by dell). Can I configure
I'm using mysql 3.23.49 on Linux redhat dedicated server.
Here is my query :
mysql> show index from MyTable;
Table: MyTable
Non_unique : 0
Key_name: PRIMARY
Seq_in_index: 1
Column_name : Field0
Collation : A
Cardinality
Hello Mikael,
Just add LIMIT 10 (which is equivalent to LIMIT 0,10) to show the
first 10 records,
and
LIMIT 10,10 to show 10 records starting from 10.
This issue is covered in online docs.
Regards,
Tom
Friday, April 19, 2002, 9:18:53 AM, you wrote:
MH> This brings up another question to m
This brings up another question to my mind.
What if I only want to show the first 10 records and then the next 10
from that query? How do I do that?
-Original Message-
From: Charles Brisson [mailto:[EMAIL PROTECTED]]
Sent: den 19 april 2002 09:52
To: [EMAIL PROTECTED]
Subject: Re: SELECT
97 matches
Mail list logo
