Mysql query update

[sbell22]

Hello Everyone,

Trying Sugar for the first time and I have some questions:

1. Installed Sugar and imported some users and everything works fine. But when I go to the server I can't use the the command line for mysql. How can I do this?

2. I did something wrong on the import and I would like to run a query to fix it. How can I do that?

I could always export it and change it and then re-import it but I would like to know how to connect to the db and this seems like a simple way to do it.

Thanks...

[Angel]

Why can't you use the mysql command line? Are you getting an error? You don't have access to it? Please elaborate.

[sbell22]

Why can't you use the mysql command line? Are you getting an error? You don't have access to it? Please elaborate.

That was my fault. I didn't have a my.cnf file, added it and I can now log in. But I don't know where to look for a custom field. I added a field to the account detail page called Division. Let me know if you know where this might be.


Thanks again for replying.

[Angel]

Custom fields for the Accounts module would be in the accounts_cstm table.

[lending]

Yep..thanks for the update..i am a frequent user of Mysql.

[sbell22]

Custom fields for the Accounts module would be in the accounts_cstm table.

Thanks for the reply.

I only see 2 schemas (information_schema and test). I don't see accounts_cstm table in either of these 2 schema. What schema should this table be in?

Thanks...

[Angel]

Those are 2 of the default databases that MySQL users.

Have you already selected the database that you are using for your SugarCRM system? i.e. use <your sugar db name>; ?

[freelancer05]

Single-table UPDATE assignments are generally evaluated from left to right. For multiple-table updates, there is no guarantee that assignments are carried out in any particular order.
If you set a column to the value it currently has, MySQL notices this and does not update it.
If you update a column that has been declared NOT NULL by setting to NULL, the column is set to the default value appropriate for the data type and the warning count is incremented. The default value is 0 for numeric types, the empty string ('') for string types, and the “zero” value for date and time types.
UPDATE returns the number of rows that were actually changed. In MySQL 3.22 or later, the mysql_info() C API function returns the number of rows that were matched and updated and the number of warnings that occurred during the UPDATE.
Starting from MySQL 3.23, you can use LIMIT row_count to restrict the scope of the UPDATE. A LIMIT clause works as follows:
• Before MySQL 4.0.13, LIMIT is a rows-affected restriction. The statement stops as soon as it has changed row_count rows that satisfy the WHERE clause.
• From 4.0.13 on, LIMIT is a rows-matched restriction. The statement stops as soon as it has found row_count rows that satisfy the WHERE clause, whether or not they actually were changed.
If an UPDATE statement includes an ORDER BY clause, the rows are updated in the order specified by the clause. ORDER BY can be used from MySQL 4.0.0. This can be useful in certain situations that might otherwise result in an error. Suppose that a table t contains a column id that has a unique index. The following statement could fail with a duplicate-key error, depending on the order in which rows are updated:

[ferozeh786]

Thanks for sharing , it really helped me .

[sbell22]

Those are 2 of the default databases that MySQL users.

Have you already selected the database that you are using for your SugarCRM system? i.e. use <your sugar db name>; ?

Found it. Updated the table and no problems.

Thanks for your help.