Strange BUG? with a working table

Dear Ladies and Sirs, I have a problem to create a tables duplicate with: CREATE TABLE new_1 SELECT * FROM output_1; The table output_1 has this structure: Field TypeNullKey af_1int(11) YES MUL af_3varchar(255)YES

Re: Strange BUG? with a working table

It seems that you have reached the 2G file limit with many Linux system. I am not familiar with SuSe. As I know, you may try to use raid option. You may refer to MySQL doc. on 'create' for details. KH > Dear Ladies and Sirs, > > I have a problem to create a tables duplicate with: > > CREATE

BUG Mysql 3.23.54

When using the client library with php: Earler(earler mysql version) mysqllib: SELECT userfield.*,user.* FROM . [1] =>123 [userid] => 123 Now with MySQL 3.23.54 mysqllib: SELECT userfield.*,user.* FROM . [1] =>123 [userid] => Here you can see that mysql doesn't give the

sql select from question

Hello list, I want to select all the columns in a table except one column. Can I do this without writing all the column names to the query? For example assume that I have table with the name table1 and there are 50 columns in table1 with the names col1, col2, col3.col50. To be able to sele

AW: Strange BUG? with a working table

Hi Chiu, >It seems that you have reached the 2G file limit with many Linux system. I >am not familiar with SuSe. As I know, you may try to use raid option. You >may refer to MySQL doc. on 'create' for details. Yes I know, that I can just manage files to 2 GB. The question was, why is the new ta

Re: Strange BUG? with a working table

Compare tables with : =show create table t1; =show create table t2; Check table type. Or use dump command from shell: shell>mysqldump -pPassword --user=username db_name t1 > t1.sql mysql>rename table t1 to t2; shell>mysql -pPassword --user=username t1.sql > db_name Or try to set MIN_ROWS

Re: Strange BUG? with a working table

Use BIGINT use altertable ...that will take a week Russell Griechen - Original Message - From: "Franz, Fa. PostDirekt MA" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, February 24, 2003 2:35 AM Subject: Strange BUG? with a working table > Dear Ladies and Sirs, > > I have a pro

RE: sql select from question

On 24-Feb-2003 Veysel Harun Sahin wrote: > Hello list, > > I want to select all the columns in a table except one column. Can I do > this without writing all the column names to the query? For example > assume that I have table with the name table1 and there are 50 columns > in table1 with the

hpux Unresolved symbol Abort(coredump)

>Description: Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables /usr/lib/dld.sl: Unresolved symbol: _GLOBAL__FI_libstdc___sl_5_0 (code) from /u sr/local/mysql/libexec/mysqld /usr

hpux Unresolved symbol Abort(coredump)

>Description: Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables /usr/lib/dld.sl: Unresolved symbol: _GLOBAL__FI_libstdc___sl_5_0 (code) from /u sr/local/mysql/libexec/mysqld /usr

hpux Unresolved symbol Abort(coredump)

>Description: Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables /usr/lib/dld.sl: Unresolved symbol: _GLOBAL__FI_libstdc___sl_5_0 (code) from /u sr/local/mysql/libexec/mysqld /usr

hpux Unresolved symbol Abort(coredump)

>Description: Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables /usr/lib/dld.sl: Unresolved symbol: _GLOBAL__FI_libstdc___sl_5_0 (code) from /u sr/local/mysql/libexec/mysqld /usr

Re: sql select from question

Thanks dread. Yes it can be done programmatically. But i try to do only with sql. I don't want to hardcode it. [EMAIL PROTECTED] wrote: On 24-Feb-2003 Veysel Harun Sahin wrote: Hello list, I want to select all the columns in a table except one column. Can I do this without writing all the c

FW: vacancy

INTAS is an independent International Association formed by the European Community, European Union's Member States and like minded countries acting to preserve and promote the valuable scientific potential of the NIS partner countries through East-West Scientific co-operation. We are currently loo

How to query an entire row?

Hello, In a table like this: ID Item1 char(100) Item2 char(100) . . ItemN char(100) What's the cleanest way to do this mysql query: SELECT * FROM MyTable WHERE AnyColumn LIKE '%mysearch%' Only way I can think to do it is: SELECT * FROM MyTable WHERE (Item1 LIKE '%mysearch%' OR Item2 LIKE '%my

Re:Re:Speed improvement with packet proceeding!?

Dear Don, KH Chiu, List, P.S (Chiu): Proceed as is in INSERT VALUES (),()...N? Oops! What about futured stored procedures in Mysql 5.x ? Anyway... Yes, there is a problems with error handling and proceeding but when you use INSERT ... VALUES (),().. (for example 5 rows and after 3th rows mysq

MySQL on windows

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi I am used to using/accessing MySQL on Unix, but I have to write a small client application on Windows, to record and log activity to a remote MySQL database. The options that I have appear to be - - Perl + DBI+DBD-ODBC - - Perl + DBI+DBD-mysql

RE: MySQL on windows

Hi Simon, > The options that I have appear to be > > - - Perl + DBI+DBD-ODBC > - - Perl + DBI+DBD-mysql > - - Visual C++ + ODBC > - - Visual C++ + MySQL++ What about Java + JDBC? Rob :) - Before posting, please check: h

Question mark becomes NULL

Greetings, I have this strange problem. I use a perl script & DBI to insert records into a mySQL database. This database holds 1 text-column. Now when this text-field holds any question marks, they appear in the record as`NULL`. I went thrue the mySQL docs to find out how to avoid this but to

Re: How to query an entire row?

Hello. On Mon 2003-02-24 at 11:28:05 +, [EMAIL PROTECTED] wrote: > Hello, > > In a table like this: > > ID > Item1 char(100) > Item2 char(100) > . > . > ItemN char(100) > > What's the cleanest way to do this mysql query: > > SELECT * FROM MyTable WHERE AnyColumn LIKE '%mysearch%' > > Only

Re: MySQL on windows

Depends on what you are experienced with on win platform I would of thought. Something like vB or Delphi is very quick and easy to use. Jerry - Original Message - From: "Simon Windsor" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, February 24, 2003 12:28 PM Subject: MySQL on

Re: MySQL on windows

In my experience, Perl + DBD-mysql will be the most easy tool for UNIXer (Linuxer). Especially, if you plan to write some non-GUI based system service program. Best regards, KH > Depends on what you are experienced with on win platform I would of thought. > > Something like vB or Delphi is ver

Re: Re: How to query an entire row?

At 13:53 24/02/03 +0100, you wrote: Hello. On Mon 2003-02-24 at 11:28:05 +, [EMAIL PROTECTED] wrote: > Hello, > > In a table like this: > > ID > Item1 char(100) > Item2 char(100) > . > . > ItemN char(100) > > What's the cleanest way to do this mysql query: > > SELECT * FROM MyTable WHERE AnyCo

Heiki, InnoDB crash #2 (update)

The patch got my server up and going again for a bit, but now it has died again after running for about 8 hours or so. InnoDB: Error: trying to access a stray pointer c22fbff8 InnoDB: buf pool start is at 413cc000, number of pages 1024 030223 19:14:31 InnoDB: Assertion failure in thread 66581 in

AUTO_INCREMENT and INDEX feature?

Hi All, I have MyISAM table with auto_increment property. CREATE TABLE rcatdb_categories ( ID bigint(15) NOT NULL auto_increment, ... PRIMARY KEY (ID), ... however I would like to create as smaller as possible index for ID (by default this is automaticaly done with PRIMARY KEY..), but big

Re: MySQL on windows

As I said, all depends on what you are used to , as to which is going to be the least painful path. Jerry - Original Message - From: "KH Chiu" <[EMAIL PROTECTED]> To: "Jerry" <[EMAIL PROTECTED]>; "Simon Windsor" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, February 24, 2003 1

Large table or several tables ?

Hye the list, There is my problem. I have to register about 400 large arrays (~1 lines each) in my MySQL database and I don't know which of the following choices is better. Either create a large tables as a stack, which contains all arrays Either create as many tables as there are arrays and

Re: Question mark becomes NULL

On 24 Feb 2003, at 13:42, Daneman wrote: > I use a perl script & DBI to insert records into a mySQL database. > This database holds 1 text-column. Now when this text-field holds any > question marks, they appear in the record as`NULL`. Post the Perl code you're using for the insert query. It so

Re: Heiki, InnoDB crash #2 (update)

Michael, this is further evidence that the corruption last time was not a bug in the insert buffer, but this is general Linux table corruption. I already suggested that you should upgrade to Linux-2.4.20 or some other recent kernel. Please send me the full .err log. If you can keep the old corrup

Re: Speed improvement with packet proceeding!?

It sounds like you're suggestion something like Oracle does with PL/SQL, which I think is the better way to go. Then it's really up to the user to decide how to optimize multiple steps by creating a batch of commands to be run. On Sunday, February 23, 2003, at 03:57 PM, Julian wrote: I'm not

Re:Re: AUTO_INCREMENT and INDEX feature?

No, you understood me wrong. MEDIUMINT takes only 8 bytes, but BIGINT takes 20, so the whole DB grows, moreover in Mysql documentation I read about indexes and column optimization and thay sad: medium int is always better than int - in context of that article. I would like to do as small as pos

Re: Large table or several tables ?

Depends on in which manner you are going to be using the dB I'd suggest, i.e. just for storage for the arrays or querying the data while it is in the dB. If the data is all related and you are going to be running queries across the whole data set I'd put it all in one table, if the quires that you

Re: mysqld got signal 11; This could be because you hit a bug ....

Hello, I have followed your suggestion. I have installed mysql-debug-4.0.10-gamma-sun-solaris2.9-sparc-64bit on the Solaris 8 (Machine with 8 cpus, 32GB of Memory and 64 of swap) server. I have started the mysqld program as root I have specified the core-file in the /etc/my.cnf file. Other info t

Re: mysqld got signal 11; This could be because you hit a bug ....

Mariella Di Giacomo writes: > Hello, > > I have followed your suggestion. > I have installed mysql-debug-4.0.10-gamma-sun-solaris2.9-sparc-64bit on the > Solaris 8 (Machine with 8 cpus, 32GB of Memory and 64 of swap) server. > I have started the mysqld program as root > I have specified the > cor

Re: mysqld got signal 11; This could be because you hit a bug ....

Hi, I will install the 2.8 debug version. The reason why I set setting sort and record buffers to 1K is because with a few tests I have noticed that I was getting a better response time for queries. The limit for the core file was unlimited. I will look into customer support. Mariella At 06:17

Re: mysqld got signal 11; This could be because you hit a bug ....

Mariella Di Giacomo writes: > Hi, > > I will install the 2.8 debug version. > > The reason why I set > setting sort and record buffers to 1K > is because with a few tests I have noticed that I was getting a better response > time for queries. > > The limit for the core file was unlimited. > > I

Re: Large table or several tables ?

4 million rows is a large table, but not a huge table. 400 is a large number of tables. Does the data in the 400 arrays describe the same type of entity or do they provide *generic* attribute info for different types of entities? If so, they would logically belong in a single table, otherwise no

Re:Re: AUTO_INCREMENT and INDEX feature?

On 24 Feb 2003, at 17:44, Julian wrote: > MEDIUMINT takes only 8 bytes, but BIGINT takes 20, so the whole DB > grows, Where did you get those numbers? According to the documentation (http://www.mysql.com/doc/en/Storage_requirements.html), MEDIUMINT is 3 bytes and BIGINT is 8. And why are you

Re: AUTO_INCREMENT and INDEX feature?

* Julian > MEDIUMINT takes only 8 bytes, but BIGINT takes 20, so the whole DB No, MEDIUMINT occupies 3 bytes, BIGINT 8 bytes. http://www.mysql.com/doc/en/Storage_requirements.html > > grows, moreover in Mysql documentation I read about indexes and column > optimization and thay sad: medium int i

Re: mysqld got signal 11; This could be because you hit a bug ....

Hi, I would prefer the debug version which the latest I believe is the 4.0.10. The same error I get it when I run ALTER TABLES or I try to insert data into tables. I will try and let you know. Thanks, Mariella At 06:31 PM 2/24/03 +0200, you wrote: Mariella Di Giacomo writes: > Hi, > > I will in

Unknown table in field list

Hi again. I've tried searching the list archives for this all morning, but they don't seem to be working (never get any results, page times out). I found one report of this on google but the guy said he figured out the problem but didn't say what he did to fix it! I just added a table to my data

Re: mysqld got signal 11; This could be because you hit a bug ....

Mariella Di Giacomo writes: > Hi, > > I would prefer the debug version which the latest I believe is the 4.0.10. > The same error I get it when I run ALTER TABLES or I try to insert data > into tables. > > > I will try and let you know. > > Thanks, > > Mariella > 4.0.11 will be quite soon, b

INSERT INTO table1 VALUES (DEFAULT): Auto_increment colums do not count up

== INSERT INTO table1 VALUES (DEFAULT): Auto_increment colums do not count up == I am trying to insert values via PHP into a table with an autoincrement f

RE: Unknown table in field list

Change the query to: SELECT parcels.DXF as 'record', building.ADDRESS as 'results1', parcels.relname as 'results2' from parcels INNER JOIN building on parcels.DXF = building.DXF where parcels.relname LIKE '%jones%' order by parcels.relname desc; For tables in the from list, the next word after a

MYSQL 3.23.55 Install Issues

Hi, I've been trying to get the 3.23.55 version of mysqld-nt.exe working with our product (GMS Mail) and I'm running into install\service related issues. I've read through the various threads on this list and nothing seems to solve my problem. The situation is that we include MySQL with our pro

Re: BUG Mysql 3.23.54

On Mon, Feb 24, 2003 at 10:19:01AM +0100, G. Hesen wrote: > When using the client library with php: Have you also changed versions of PHP? > Earler(earler mysql version) mysqllib: > SELECT userfield.*,user.* FROM . > [1] =>123 > [userid] => 123 > > Now with MySQL 3.23.54 mysqllib:

Directory structure

Hi, I am trying to figure out the best method for creating a directory with mySQL (Lasso). Let me first say that I am new-ish to SQL, so might be jumping into the deep-end. I am building this for a site and am looking for a fast method of displaying where users are in the directory, or where a

redirect mysql output to file

Hi, How do i redirect a mysql output to a file from the command line? For example, I want to save DESCRIBE test_table > test_table.file without doing a MYSQLDUMP. thanks, MT - Before posting, please check: http://www.mysql

optimizing large InnoDB table

I have a couple of questions here. This table currently contains about 12 million records. This table is mostly read from, but several times thoughout the day there will be inserts or updates of batches of about 30,000 rows, and there are periodic purges of old rows, which could be up to sever

# of Business Days?

Can anyone out there help me with a SQL query? I need to find the number of business days between date a and b? Obviously finding simply the number of days is easy, but I have no clue how to find the number of business days. TIA! Lucas Cowgar Information Technologies Department Eldorado Services

Re: redirect mysql output to file

At 10:50 AM 2/24/2003 -0700, Mike Doanh Tran wrote: >How do i redirect a mysql output to a file from the command line? >For example, I want to save DESCRIBE test_table > test_table.file >without doing a MYSQLDUMP. >From the command line: $ echo 'describe test_table' | mysql {dbname} > test_ta

RE: redirect mysql output to file

In *NIX you could do this: $ echo "sql commands here" | mysql -uroot -ppassword -hhost database > /path/to/file For extra scripting fun you could backup tables using this: for i in `echo "show databases" | /usr/local/mysql/bin/mysql -uroot | grep -v "Database"` do mysqldump -uroot $i > /path/t

RE: # of Business Days?

I'm not sure of an exact query, but if you can get the total number of days you can mathmatically get the biz days with the following math (in psuedo code): $days = total_days_between_a_and_b; $weeks = ($days / 7); $weekend_days = $weeks * 2; $business_days = ($days - $weekend_days); Hope this he

help starting replication across platforms

I am trying to start replication from a 4.0.9 solaris master to a 4.0.8 linux slave. I am already sucessfully replicating this master to another sun slave. I followed the same procedures on the linux box but no joy. The error log keeps saying : 030221 10:08:56 mysqld started 030221 10:08:56 Inno

Re: Unknown table in field list

Just what it says. Your first query attempts to list a column from a table that is not selected from (building). Your second query attempts to assign the alias "building" to both the parcels table and the building table, and then subsequently does a join on the building table. Use the following

Re: redirect mysql output to file

On Mon, Feb 24, 2003 at 10:50:53AM -0700, Mike Doanh Tran wrote: > Hi, > > How do i redirect a mysql output to a file from the command line? > For example, I want to save DESCRIBE test_table > test_table.file > without doing a MYSQLDUMP. Use the mysql command line client from your command lin

BUG: Format function fails when query ordered

Hello, I am reporting a bug. The format number function fails when a query is sorted. I have included an example page to look at (the error is reproduced here): http://www.meetscoresonline.com/test_format.asp You'll see there are 2 result sets, the first is not ordered and the 2nd is ordered.

Re: Directory structure

Depending on how you plan to use the data, you may be interested in the "Nested Set Model". There are articles listed at searchdatabase.techtarget.com if you search for that string, but you may need to register there (can't supply links as they contain user ID...). Or if you have Joe Celko's SQL

Re: # of Business Days?

Here's a link to a solution that Oracle came up with: http://dco-proxima.dco.pima.edu/oracle/tfts/PRE00136.HTM You should be able to adapt it to MySQL and PHP (or whatever language you are using). Basically, the script gets the start date and end date, then steps through every day counting only b

Re: redirect mysql output to file

Mike, > How do i redirect a mysql output to a file from the command line? > For example, I want to save DESCRIBE test_table > test_table.file > without doing a MYSQLDUMP. To have the mysql client write a protocol, start it, and then do: mysql> tee myoutfile.txt Logging to file 'myoutfile.txt'

Question for the GRANT statement

Hi, I am new to MySQL and SQL in genreal. I just installed mysql 3.23.55 on my Red Hat Linux 7.1. I tried to GRANT user in the following way: CREATE DATABASE izdb; GRANT ALL ON izdb.* TO iz1 IDENTIFIED BY 'iz'; GRANT ALL ON izdb.* TO [EMAIL PROTECTED] IDENTIFIED BY 'iz'; GRANT ALL ON izdb.* TO

Re: Question for the GRANT statement

Try this: GRANT ALL PRIVILEGES ON izdb.* TO iz2@'localhost' IDENTIFIED BY 'iz'; Lucas Cowgar Information Technologies Department Eldorado Services Group Inc. http://www.eldoserv.com [EMAIL PROTECTED] (330) 861-3009 "All your base are belong to us" - Original Message - From: "ianhzhang

Re: Question for the GRANT statement

Thank you Lucas. But why I have to put localhost at the end? The manual says that I can put a wild card "%", like iz3@"%". Or if I did not put anything, it will automatically assume localhost. Thanks again. Ian Zhang [EMAIL PROTECTED] wrote: Try this: GRANT ALL PRIVILEGES ON izdb.* TO iz2

Visual Basic Embedded VC++ DLL

Hi! Has anyone created a DLL in VC++ the uses the embedded mysqlserver.lib library? Is it possible to do this? Is there any special settings that are needed? I have compiled a DLL that does this, but then I run a function wich encapsulates mysql_server_init(), I get a memory error and my VB pro

RE: Question for the GRANT statement

The % wildcard works for granting permission over the network. When you are working on the localhost, you are using mysql.sock to connect to the server. Try this (I believe it should work) /bin/mysql -u iz3 ip'iz' -h'youripaddress' This should allow you to connect using the network and not mysql

Re: Question for the GRANT statement

Ian, Yes, you can put a wildcard but I would advise against it if you are going to be inside any kind of secured environment. If soneone were trying to hack your database, the could do it remotely because MySQL wouldn't care where the connection was coming from, for example, someone could log

RE: # of Business Days?

>>Can anyone out there help me with a SQL query? I need to find the number of business days between date a and b? >>Obviously finding simply the number of days is easy, but I have no clue how to find the number of business days. >>TIA! Here's some ropey perl I wrote a ages back to calculate workin

Re: MYSQL 3.23.55 Install Issues

At 17:43 24/02/2003 +, Simon Tyler wrote: Hi, Hi, I've been trying to get the 3.23.55 version of mysqld-nt.exe working with our product (GMS Mail) and I'm running into install\service related issues. I've read through the various threads on this list and nothing seems to solve my problem.

Problems returning a row count with rows() function

Greetings - I have a simple CGI script written in Perl (using v5.8) that seemed to work well under MySQL 3.23.49. However, after recently upgrading to version 3.23.55 I am running into the following problem. Previously, I used the rows() function to return the number of rows ret

RE: # of Business Days?

use Date::Manip http://www.perldoc.com/perl5.6.1/lib/Date/Manip.html -J -Original Message- From: Andrew Braithwaite [mailto:[EMAIL PROTECTED] Sent: Monday, February 24, 2003 1:33 PM To: 'Lucas Cowgar'; MySQL Mailing List Subject: RE: # of Business Days? >>Can anyone out there help me w

Re: Question mark becomes NULL

At 10:06 24-2-03 -0500, Keith C. Ivey wrote: On 24 Feb 2003, at 13:42, Daneman wrote: > I use a perl script & DBI to insert records into a mySQL database. > This database holds 1 text-column. Now when this text-field holds any > question marks, they appear in the record as`NULL`. Post the Perl co

ÄãÔõÑù²ÅÄÜÉÏÍø׬Ǯ³ÉΪ¸»ÎÌ£¿

小小投资你将迈向百万富翁的行列 小小投资,巨大回报网络时代营销新观念,网络赚钱首选 ★告诉你一个好消息★：一套让中国人迅速富起来的赚钱方案，真的很容易让你赚到钱的网络营销系统，一个月赚万元的创业机会现在就摆在你的面前。据统计，仅在10月份一个月里，全国就有5341人在网络的淘金中，月收入超过3000元。目前月收入最高者为天津的罗国柱147570元/月；上海的林勇139132元/月，而这一切都是在工作之余在家或在网吧中完成。 该系统无风险投资：一次性买断属于你自己的网站行销系统。 操作轻松简易：系统自动生成，您只要会打字即可。 管理安全可靠：拥有属于您自已的个

Re: # of Business Days?

Hello This is not correct, see this at example: From friday to mondey there are 4 days (or 3, depends on how you count ;-). your calcs: $day = 4 $weeks = 4 / 7 = 0 $weekend_day = 0 * 2 = 0 $business_days = 4 - 0 = 4 If you have 100 weeks, then it will be quite correct. here is my solution: $day

Re: Question mark becomes NULL

And you still have not shown us how you are entering the question marks. Daneman wrote: At 10:06 24-2-03 -0500, Keith C. Ivey wrote: On 24 Feb 2003, at 13:42, Daneman wrote: > I use a perl script & DBI to insert records into a mySQL database. > This database holds 1 text-column. Now when this

Cardinality for FULLTEXT-indexes MySQL 4.0.10

Hello! I never got any comment on this one... Have noone else observed this behavior? I'm a bit worried to use this in my production site without knowing if it's and indication of some problem with FULLTEXT indexes... :) Regards, Tobias Lind Hi! I have a question regarding "Cardinality" for FUL

getting NULL in auto_increment column

Can you update an auto_increment with NULL in MySQL? Obviously if you try and put a NULL in directly it will increment to the next integer. Is there some way to actually get a NULL in there instead of the integer? - Before postin

Re: Question mark becomes NULL

At 14:25 24-2-03 -0600, gerald_clark wrote: And you still have not shown us how you are entering the question marks. Like this: $sql = qq{ INSERT INTO main (id, categorie, achternaam, voornaam, aanspreektitel, straat, huisnummer, postcode, plaatsnaam, telefoon, mobiel, email1, email2, tekst) VAL

Re: # of Business Days?

Where I work: 1) We created a table for holidays (projected data for the next few years). 2) Created a function for the day of the week. 3) If M-F and not Holiday, then perform routine. We had to go this route because there are way too many bank and market holidays to keep straight with just code.

Re: getting NULL in auto_increment column

> Can you update an auto_increment with NULL in MySQL? Obviously if you > try and put a NULL in directly it will increment to the next integer. > Is there some way to actually get a NULL in there instead of the > integer? No that's why you declare it NOT NULL when you create it. ---John Holm

Re: Question mark becomes NULL

On 24 Feb 2003, at 21:07, Daneman wrote: > INSERT INTO MyTable (MyFields) VALUES ($val1, $val2, etc); > > Question marks are no longer replaced with NULL values in the text > column this way, still, when I enter question marks into the charvar > fields, the record is not taken into he database. I

Re: getting NULL in auto_increment column

Danny wrote: Can you update an auto_increment with NULL in MySQL? Obviously if you try and put a NULL in directly it will increment to the next integer. Is there some way to actually get a NULL in there instead of the integer? No. Why would you want to? ---

Re: Question mark becomes NULL

If you want to insert question marks into a character field, then you must surround them with quotation marks as you would with any string. I don't see you entering any questionmarks. I see you defining an insert command that uses placeholders for the values entered in the execute statement. You

Re: Question mark becomes NULL

At 15:45 24-2-03 -0500, Keith C. Ivey wrote: On 24 Feb 2003, at 21:07, Daneman wrote: > INSERT INTO MyTable (MyFields) VALUES ($val1, $val2, etc); > > Question marks are no longer replaced with NULL values in the text > column this way, still, when I enter question marks into the charvar > fields,

Re: # of Business Days?

If you truly want only business days - i.e. you don't want to count Holidays - the only solution is to have a tables with all the business days. You'd populate this periodically with future dates as required, and a human may be required to mark off the holidays (unless you can create an algorithm t

SQL question - no CREATE VIEW in mysql

Hi People. SQL problem: given a table where each column is a number, let's say that I wish to create a second table where columns are the sum of specific columns of the first, i.e.: col_1 + col_2 + col_3 + col_4 > col_1 of second table col_5 + col_6 + col_7 + col_8 > col_2 of se

case expression

Hello all ... be gentle, I'm new at this: I've got a simple case query. One works (the top one), but when I try to add additional columns to the query it fails. I reckon it's a pretty simple mistake I'm making, but I don't know what. Any help is appreciated. ---

analyzing mysql general query log

Hello, Can anyone recommend a script to analyze a mysql server general query log. My goal is to determine which users are putting the most load on the server. Any other methods to achieve this same goal would be appreciated as well. Thank you. __

Re: Question mark becomes NULL

sql, query I'm not sure about perl, but I know in JSP you can substitue ? for values to avoid getting SQL syntax errors from variable values that have funky characters, apostrophes and the like. I'm not sure if Perl implements the same SQL statement syntax but with php and stripslashes - it's not

RE: Unknown table in field list

Jon and Tore, thanks so much for your kind help. I greatly appreciate it. I still have one bit of confusion about this whole thing. I'm reading through the manual as I type this so maybe I'll find the answer. If someone can help clarify, I'd appreciate that as well. Running this query: mysql>

RE: case expression

Put the other fields after the CASE statement: SELECT CASE WHEN CHARACTER_LENGTH(system) > 65 THEN CONCAT(LEFT(system, 60), " ...") ELSE system END, wsh_year, id FROM wsh The CASE statement just returns 1 field. -Original Message- From: Richard For

RE: case expression

Thanks, that works fine. If I wanted to create an alias for the column, how would I do that? The first select statement (before the Else) is the current column name. When I add 'AS system' to the end of the string, it fails. Ex. SELECT CASE WHEN CHARACTER_LENGTH(system) > 65 THEN

Re: SQL question - no CREATE VIEW in mysql

Luca, > In Oracle I could create a view from the initial table, what about MySQL? MySQL will support views as of version 5.1. I cannot find it in the todo (http://www.mysql.com/doc/en/TODO.html) but I saw it elsewhere. Regards, -- Stefan Hinz <[EMAIL PROTECTED]> iConnect GmbH

RE: case expression

Consider the CASE statement to be a function, that can only return values. Aliases would go outside the CASE STATEMENT, as follows: SELECT CASE WHEN CHARACTER_LENGTH(system) > 65 THEN CONCAT(LEFT(system, 60), " ...") ELSE system END AS system, wsh_year, id

RE: case expression

Makes sense. Thanks for the help! Rik Forgo JIST3 Army Test, Training and Technology Integration Office (T3I) Diverse Technologies Corp. (c) 443.463.8571 (h) 410.859.8474 > -Original Message- > From: Jon Wagoner [mailto:[EMAIL PROTECTED] > Sent: Monday, February 24, 2003 4:51 PM > To: R

Re: getting NULL in auto_increment column

gerald_clark writes: >Danny wrote: > >>Can you update an auto_increment with NULL in MySQL? Obviously if you >>try and put a NULL in directly it will increment to the next integer. >>Is there some way to actually get a NULL in there instead of the >>integer? >> >> >No. >Why would you want to? B

Re: Cardinality for FULLTEXT-indexes MySQL 4.0.10

Hi! On Feb 24, Tobias Lind wrote: > Hello! > I never got any comment on this one... > Have noone else observed this behavior? > I'm a bit worried to use this in my production site without knowing if it's > and indication of some problem with FULLTEXT indexes... :) > > Regards, > Tobias Lind It's

4.0.10 rpm doesn't include POSTIN script

The 4.0.10 MySQL-server rpm's don't include the POSTIN script. I'm guessing this is because of moving the server to a subpackage and the POSTIN scripts being spec'd for the main package. It's easy to see this by running: rpm -qp --qf "%{POSTIN}\n" MySQL*4.0.9*.i386.rpm rpm -qp --qf "%{POSTIN}\n"

RE: getting NULL in auto_increment column

It does not sound like your data is properly normalized. You might want to take a look at the way you have things set up, this sounds like it cause problems later on. -Original Message- From: Danny [mailto:[EMAIL PROTECTED] Sent: Monday, February 24, 2003 1:54 PM To: [EMAIL PROTECTED] Sub

Re: several newbie problems

At 21:23 19.02.2003 +0100, you wrote: Or you could configure this in your c:\windows\my.ini configuration file: [mysqld] ... skip-innodb (In this case, you have to restart the server for the changes to take effect.) Nice, thanks. mysql>> use nick > Reading table information for completion of table

Re: MySQL Grant issue

I had asked in the past the following: In MySQL I need to create a user that has limited privileges (I figure the GRANT command can handle this), just need to know how to make sure they can only view what they have access to, or does the GRANT command handle that also? Thanks -- Jon Miller <[EMAI

  1   2   >