| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
Comments:
<0> Sonny: MySQL Workbench
<1> Xgc, I'm trying to use it, but it seems not to work fine? what version do you have?
<0> Sonny: I believe this is developed by the author of DBDesigner4. I suspect that's available too.
<0> 1.0.1
<2> Xgc: it is
<1> Xgc, dos it work good?
<2> Sonny: decent .. but limited
<1> I create the tables, but cant create the relationships
<0> Sonny: If you have a good budget, you might try Embarcadero. They might have support for 5.0 or have an early release available for customers who offer to help with product feedback.
<1> Xgc, wow thanks man
<0> You're welcome.
<3> hi all
<2> if you have a huge budget try powerbuilder :-)
<3> i think that i have found a bug
<1> I would like something like Erwin... its enough for me... but I cannot generate the scripts dor mysql with it
<2> bugs.mysql.com
<3> when doing this: INSERT DELAYED INTO table SET `from`='1234456' the value is inserted but with an \n
<2> Sonny: i have used visio a fair bit
<1> lsmith, how was it?
<2> quite decent .. you can import via odbc as well
<3> yes
<3> i think it is a bug
<2> http://www.backendmedia.com/LiveUser/liveuser_db_schema.png
<3> because when removig the DELAYED the fild is inserting correctly
<2> nbari: check bugs.mysql.com if someone has filed a bug about this before
<3> ok
<2> and if not file that bug
<1> lsmith, yep I'm tryin to do it with Erwin.. but the syntax fails.. it's mysql doesnt understand some syntax generated
<2> ah ..
<2> i never reimported into mysql
<2> what mysql version?
<3> 5.0.18
<2> i was talking to Sonny :-)
<3> oh ok
<1> lsmith, 5.0.18
<2> ok .. try setting your sql_mode to ANSI
<2> that might help for the import
<1> lsmith, it is because erwin doesnt know the mysql syntax,,, but i.e. with oracle it works perfect..
<1> lsmith, if I do that... mysql will be able to understand an oracle's script?
<2> ! Sonny server sql modes
<2> !m Sonny server sql modes
<4> Sonny: Nothing found
<2> http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html
<2> there is even an ORACLE sql mode
<2> dont expect these to be "perfect"
<1> lsmith, wow that would be great for me!
<1> lsmith, cause I have many scripts in oracle's
<3> well i have allready reported the bug
<3> now any idea on how to remove all the \n from my tables?
<3> any batch proccess?
<3> all my new values start with an \n
<1> lsmith, Ok I've read the document, but I didnt undestand how to change the sql_mode
<2> nbari: RTRIM()?
<3> i used trim but did not work
<3> seems that the \n is been added after processing the input data
<2> SET [SESSION|GLOBAL] sql_mode='mode_value'
<3> ?
<2> nbari: but you could update foo set bar = trim(bar)
<3> oh ok
<3> but how can i doit ? select value from table ---> then update table set value = trim(bar)
<3> how to doint in one single step?
<2> exactly i how told you to :-)
<2> you can include the existing values in an update
<2> "update foo set bar = trim(bar)"
<3> mmmm did not work
<3> if i am not wrong bar is empy i should p*** it
<3> did just has you toll me and the \n is not been removed
<1> lsmith I receive the error that sql_mode cannnot be set in this mode
<2> nbari: maybe \n is not trimmed off by trim() ..
<2> !m nbari string functions
<4> nbari: (String Functions) : http://dev.mysql.com/doc/mysql/en/String_functions.html
<2> maybe you can get some info there
<3> ok
<1> lsmith, nevermind. I figured out my mistake
<2> goody
<3> thanks for the help
<3> bye for now
<5> grant all on london-w_1.* to london-w_1_1@someipaddress identified by "sdfMjzgC";
<5> does not work
<5> i wonder some times y people use those funny characters some times
<6> frisbeboy: quote the username
<5> yep i tried that, but wait ill try again
<6> frisbeboy: - could be interpreted as a subtraction
<6> frisbeboy: the database name too, and _ is a wildcard for the db name, should escape it with \_
<5> i tried escaping other things yeaa thnax
<5> since when is _ a wildcard, thanx for informing me though
<5> no
<5> ERROR:
<5> Unknown command '\_'.
<5> i give up,
<7> frisbeboy: grant all on `london-w_1`.* to 'london-w_1_1'@'someipaddress' identified by "sdfMjzgC";
<7> frisbeboy: not the bacticks (`) for dbname and the single quote (') for the user and ip.
<7> notE
<8> !perror 121
<4> System error: 121 = Remote I/O error
<4> MySQL error: 121 = Duplicate key on write or update
<5> zeitoun: why backtics now all of a sudden? thanx for informing any ways! the mysql development team probly have there reasons for using backticks i take it
<7> bacticks are used to quote fields/table/db names, single quotes for strings
<9> delete * from users limit 221 will delete the first 221 recordsets right?
<9> or will it delete random or from the end?
<7> sym0_: you should use an order by to make sure
<1> do you have any trick to connect to databases from DBDesigner? because it fails here
<1> inalid user/p***
<9> order by asc or dsc?
<7> sym0_: without it, it will probably delete the firs 221 in the order they were inserted....
<7> Sonny: which mysql version ?
<1> 5
<9> delete * from users order asc limit 221?
<7> Sonny: you need an old_p***word account
<1> 5.0.18
<9> delete * from users orderby asc limit 221?
<1> zeitoun, what is it?
<9> ?
<7> Sonny: there was a change in p***word auth protocol starting from 4.1
<1> zeitoun, so is not possible to connect dbdesigner to mysql 5?
<7> Sonny: set p***word for 'dbdesigneruser'@'localhost' = old_p***word('thep***');
<7> sym0_: first.... drop that star.... delete from table.....
<1> zeitoun; thanks I'll try it
<7> sym0_: then order by some column.
<7> !m sym0_ delete syntax
<4> sym0_: (DELETE Syntax) : http://dev.mysql.com/doc/mysql/en/DELETE.html
<1> zeitoun; thank you it worked!!
<7> Sonny: np
<10> Could i have a standard value to be empty on a varchar? cause i keep getting "blabla hasnt got a default value"
<10> on my iserts
<10> inserts
<7> rnnnnnnn: declare the column null or add a default value
<10> ok, null is best?
<7> rnnnnnnn: what is best depends on your requirements
<10> alright
<10> null = if a col can be empty, default = if it cant, right?
<11> yo guys - here's a good one , I want to select from two tables all records where a set of critiera are true - can anyone help me?
<11> I really don't understand joins - but I'm guess I need one
<7> krisp: SELECT t1.bla, t1.blo, t2.bli, t2.ble FROM table1 AS t1 JOIN table2 AS t2 ON t1.somecol = t2.somecol WHERE <somecolumn meets some creteria>
<12> SELECT * FROM Table1 a, Table2 b WHERE a.Something = b.Something AND a.SomethingElse='Foo' AND b.SomeThingElseAsWell='bar'
<11> my god I hate this
<11> How do i get them all to order by the same field
<7> order by somefield
<11> order from both tables by date
<11> but then it orders it by table.date surely?
<7> krisp: what about describing exactly what you want to do instead of being vague.
<11> SELECT *
<11> FROM PO_Adverts CROSS JOIN
<11> SO_Adverts
<11> ORDER BY PO_Adverts.Ad_start DESC
<11> I need to select all the adverts from both tables
<11> and order them by the date they're posted
<11> not by the date in ONE field
<7> is there any relation between the adverts in those 2 tables ?
<11> nope
<7> like one corresponding to the other ?
Return to
#mysql
or
Go to some related
logs:
#javascript
cannot restore segment proc
#centos
#physics
#debian
hba0 megaraid
#lisp
#suse
glxgears fps flag
#debian
|
|
