#mysql
04 October 2007
Total 23 pages. You are browsing page 1/23.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last
--- Log opened Thu Oct 04 00:00:35 2007
--- Day changed Thu Oct 04 2007
00:00 <****> I agree, but from what it says above the 'tip' it looks like mysql is only supporting 3-byte characters..
00:01 <****> ok, so that is the problem, mysql currently doesn't support 4-byte characters..
00:01 <****> thanks for your help
00:01 <****> ah, yeah, I skimmed too far
00:02 <****> pastebin?
00:02 <****> !pastebin
00:02 <****> http://pastebin.ca
00:02 <****> oh, there's no chan pastebin?
00:03 <****> is pasting a link too hard? ;)
00:03 <****> # Four bytes are needed for characters in the other planes of Unicode, which are rarely used in practice.
00:04 <****> pastebin
00:04 <****> try http://pastebin.ca or http://pastebin.mysql-es.org
00:04 <****> http://rafb.net/paste
00:15 <****> 0) ORDER BY id desc LIMIT 0, 4\G; this is doing a file sort. i have an index on sent_count, index
00:15 <****> but index in an autoincrement
00:15 <****> how can i order without a filesort
00:16 <****> index = id for my 2nd comment
00:18 <****> Is there any kind of possibility to retrieve data -thats been UUID encrypted in the database- back to normal?
00:18 <****> hello - how i can create a database and a user for the database in mysql console ?
00:33 <****> http://dev.mysql.com/doc/refman/5.0/en/tutorial.html
00:35 <****> if i want to select something but not have it come from a table
00:35 <****> such as select now()
00:35 <****> what do i put in the from clause
00:35 <****> i know there is a specific table you can select from that is generic
00:35 <****> just don't remember the name/keyword
00:36 <****> select 'foo';
00:37 <****> guys is there anything wrong with this line: DECLARE quantidadeTotal INT DEFAULT 0;
00:38 <****> error message?
00:38 <****> ya
00:38 <****> you have an error at line 1
00:38 <****> when importing data using a SQL file, how can I specify that pkey fields can be overwritten? e.g I Have a "name" field (text) as the primary key. If I try to insert a record with the same text in that field it objects since its not unique. How can I tell the database to just replace the old record?
00:38 <****> hmm at line 1 i got this : CREATE FUNCTION calcularQuantidadeComentario(IN id_usuario INT) RETURNS INTEGER
00:42 <****> clue?
00:42 <****> any syntax error there? i can't see
00:49 <****> I am attempting to recreate a database after using mysqldump to create a script with data. But when i run the script i get an error of the form "error while executing query drop table if exists ..... no database selected"
00:50 <****> mysdl dbname < script.sql
00:51 <****> never mind archly stupid error on my part (like who elses right)
00:52 <****> how can I tell a script to tell mysql command line tool to continue even if there is a duplicate key on insert?
00:55 <****> heya all
00:57 <****> brain's fried so probably gloing the wrong way about this...... I have 2 tables containing user info (not duplicated, don't worry!).....if a column in user1 contains a non-zero value, then it should puull info from user2, otherwise pull info from user1
00:58 <****> 0, do this query, otherwise do that query"?
01:01 <****> should show slave hosts return anything if I am using master to master replication?
01:07 <****> is there a mysql command i can do to convert a few dates in my table from Mon 25th June... to the timestamp equivalent
01:10 <****> i want to sanitize all my user-entered data so that it can be safely used in an INSERT string. is there any way to do this easily?
01:11 <****> LJHarb: use placeholders
01:12 <****> what are those
01:12 <****> it depends on what language you are using to write your code
01:12 <****> I can tell you the perl way. not php, :)
01:13 <****> LJHarb, for php mysql_real_escape_string()
01:15 <****> anyone know a query i could run to set the date type to a timestamp rather than a text date, i have to do it for baout 40 records
01:16 <****> that does not make sense as they are different storage types
01:17 <****> !man date and time f
01:17 <****> see http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html
01:17 <****> yes the field has been changed to handle timestamps and there was 40 old records that need to be changed
01:18 <****> alter table would/should have changed the data as well
01:19 <****> hmm, from earlier....
01:19 <****> brain's fried so probably gloing the wrong way about this...... I have 2 tables containing user info (not duplicated, don't worry!).....if a column in user1 contains a non-zero value, then it should puull info from user2, otherwise pull info from user1
01:19 <****> 0, do this query, otherwise do that query"?
01:19 <****> it set all the timestamps to zero
01:19 <****> :(
01:19 <****> thanks archivist, ill try that
01:22 <****> am I correct that UPDATE will only work on a table if there is data in the row? no data, you have to use INSERT?
01:23 <****> insert .. on duplicate key update is probably what you want
01:24 <****> thanks...thought so
01:26 <****> or replace
01:29 <****> does mysql_query ($query) return true if it runs?
01:30 <****> swimrr, this is #mysql, not #php
01:30 <****> sorry
01:31 <****> which is better? innodb or myisam?
01:31 <****> which is better? mercedes or bmw?
01:31 <****> Audi.
01:31 <****> \o\
01:31 <****> lol, you can;t answer a question wirth a question :P
01:31 <****> so innodb and myisam are both german?
01:31 <****> in that case, you can
01:32 <****> aww don't make me go read...
01:32 <****> arthas242, are large dose of depends
01:33 <****> i've heard innodb has transactions.. that sounds good incase of crashes/power problems
01:33 <****> is the defaul myisam?
01:33 <****> lol archivist
01:33 <****> myisam has fulltext
01:33 <****> default is what you make default
01:33 <****> is it default default?
01:33 <****> arthas242: transactions relate to that plus doing multiple inserts/updates that rely upon one another to complete for the database to be valid with respect to it's data integrity
01:34 <****> arthas242: just a power outage doesn't matter if all you're doing is one insert, it either happens or it doesn't.
01:34 <****> aah, so also when doing a backup you'll get a fully consistent snapshot?
01:34 <****> what if it half happens? can it half happen?
01:34 <****> arthas242: no, it can't
01:34 <****> it either runs or it doesn't
01:35 <****> it goes just to INS :)
01:35 <****> ERT wont happen
01:35 <****> Mrdini: Sounds like a possible design mistake. Try describing the tables and the columns of interest.
01:35 <****> can;t it write half the row then have a reset?
01:35 <****> on innodb its acid compliant
01:35 <****> arthas242: if you have multiple inserts that all need to happen then yes it can "half insert" because half of those inserts can run and the other half won't
01:35 <****> arthas242: but if it's just a single insert at a time then you don't need transactions
01:36 <****> ye, but surely at some time it has to write stuff to disk.. and if it crashes halfway through..
01:36 <****> it has a log of whats done so far
Total 23 pages. You are browsing page 1/23.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last